View: Invoice Additional Costs

RotoID: PO0440
Table: POINVS
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: POINVS

Compositions: 8

RotoID  Tables  Title  DLL 

PO0420  POINVH1POINVH2  Invoices  POINVH
PO0419    Invoice Functions  POINVG
PO0421  POINVI  Invoice Postings  POINVI
PO0441  POINVT  Invoice Posting Cost Lines  POINVT
PO0438  POINVR  Invoice Receipts  POINVR
PO0444  POINVS  Inv. Add. Costs Superview  POINVW
PO0443  POINVSO  Invoice Add. Cost Opt. Fields  POINVSO
PO0415  POINVD  Invoice Cost Distributions  POINVD

Keys: 3

Title  Fields

Master Key  INVHSEQ, INVSREV
Second Key  INVHSEQ, INVSSEQ
Detail Locator Key  INVSSEQ, INVHSEQ

Fields: 214

Field  Index  Type  Title  Attributes  Presentation

INVHSEQ  BCD*10.0  Invoice Sequence Key  E A K R   
INVSREV  BCD*10.0  Line Number  E A K R   
INVSSEQ  BCD*10.0  Invoice Cost Sequence  E A   
RCPHSEQ  BCD*10.0  Receipt Sequence Key  A X   
RCPSSEQ  BCD*10.0  Receipt Cost Sequence  A X   
RETHSEQ  BCD*10.0  Return Sequence Key  A X   
RETSSEQ  BCD*10.0  Return Cost Sequence  A X   
COMPLETION  Integer  Completion Status  A X  List: 3 entries
1=No
2=Yes
3=Yes
DTCOMPLETE  Date  Date Completed  A X   
INDBTABLE  10  Boolean  Stored in Database Table  A C X  List: 2 entries
0=No
1=Yes
ADDCOST  11  String*6  Additional Cost  E A X  Mask: %-6N
GLEXPACCT  12  String*45  Expense Account  A X  Mask: %-45C
GLRETACCT  13  String*45  Return Account  A X  Mask: %-45C
AMOUNT  14  BCD*10.3  Amount  E A X   
PRORMETHOD  15  Integer  Proration Method  E A P X  List: 5 entries
1=No Proration
2=Prorate by Quantity
3=Prorate by Cost
4=Prorate by Weight
5=Prorate Manually
REPRORATE  16  Integer  Reproration Method  A P X  List: 3 entries
1=Leave
2=Prorate
3=Expense
DESCRIPTIO  17  String*60  Description  E A X   
REFERENCE  18  String*60  Reference  E A X   
COMMENT  19  String*250  Comment  E A X   
TAXICLASS1  20  Integer  Cost Tax Class 1  E A X   
TAXICLASS2  21  Integer  Cost Tax Class 2  E A X   
TAXICLASS3  22  Integer  Cost Tax Class 3  E A X   
TAXICLASS4  23  Integer  Cost Tax Class 4  E A X   
TAXICLASS5  24  Integer  Cost Tax Class 5  E A X   
TAXBASE1  25  BCD*10.3  Tax Base 1  A X   
TAXBASE2  26  BCD*10.3  Tax Base 2  A X   
TAXBASE3  27  BCD*10.3  Tax Base 3  A X   
TAXBASE4  28  BCD*10.3  Tax Base 4  A X   
TAXBASE5  29  BCD*10.3  Tax Base 5  A X   
TAXRATE1  30  BCD*8.5  Tax Rate 1  A X   
TAXRATE2  31  BCD*8.5  Tax Rate 2  A X   
TAXRATE3  32  BCD*8.5  Tax Rate 3  A X   
TAXRATE4  33  BCD*8.5  Tax Rate 4  A X   
TAXRATE5  34  BCD*8.5  Tax Rate 5  A X   
TAXAMOUNT1  35  BCD*10.3  Tax Amount 1  A X   
TAXAMOUNT2  36  BCD*10.3  Tax Amount 2  A X   
TAXAMOUNT3  37  BCD*10.3  Tax Amount 3  A X   
TAXAMOUNT4  38  BCD*10.3  Tax Amount 4  A X   
TAXAMOUNT5  39  BCD*10.3  Tax Amount 5  A X   
TAXINCLUD1  40  Boolean  Tax Includable 1  E A X  List: 2 entries
0=No
1=Yes
TAXINCLUD2  41  Boolean  Tax Includable 2  E A X  List: 2 entries
0=No
1=Yes
TAXINCLUD3  42  Boolean  Tax Includable 3  E A X  List: 2 entries
0=No
1=Yes
TAXINCLUD4  43  Boolean  Tax Includable 4  E A X  List: 2 entries
0=No
1=Yes
TAXINCLUD5  44  Boolean  Tax Includable 5  E A X  List: 2 entries
0=No
1=Yes
TXALLOAMT1  45  BCD*10.3  Tax Allocated Amount 1  A X   
TXALLOAMT2  46  BCD*10.3  Tax Allocated Amount 2  A X   
TXALLOAMT3  47  BCD*10.3  Tax Allocated Amount 3  A X   
TXALLOAMT4  48  BCD*10.3  Tax Allocated Amount 4  A X   
TXALLOAMT5  49  BCD*10.3  Tax Allocated Amount 5  A X   
TXRECVAMT1  50  BCD*10.3  Tax Recoverable Amount 1  A X   
TXRECVAMT2  51  BCD*10.3  Tax Recoverable Amount 2  A X   
TXRECVAMT3  52  BCD*10.3  Tax Recoverable Amount 3  A X   
TXRECVAMT4  53  BCD*10.3  Tax Recoverable Amount 4  A X   
TXRECVAMT5  54  BCD*10.3  Tax Recoverable Amount 5  A X   
TXEXPSAMT1  55  BCD*10.3  Tax Expense Amount 1  A X   
TXEXPSAMT2  56  BCD*10.3  Tax Expense Amount 2  A X   
TXEXPSAMT3  57  BCD*10.3  Tax Expense Amount 3  A X   
TXEXPSAMT4  58  BCD*10.3  Tax Expense Amount 4  A X   
TXEXPSAMT5  59  BCD*10.3  Tax Expense Amount 5  A X   
TXBASEALLO  60  BCD*10.3  Net of Tax  A X   
TXINCLUDED  61  BCD*10.3  Tax Included  A C X   
TXEXCLUDED  62  BCD*10.3  Tax Excluded  A C X   
TAXAMOUNT  63  BCD*10.3  Total Tax  A C X   
TXRECVAMT  64  BCD*10.3  Total Tax Recoverable  A X   
TXEXPSAMT  65  BCD*10.3  Total Tax Expensed  A X   
TXALLOAMT  66  BCD*10.3  Total Tax Allocated  A X   
TFBASEALLO  67  BCD*10.3  Func. Net of Tax  A C X   
TFINCLUDE1  68  BCD*10.3  Func. Tax Included Amount 1  A C X   
TFINCLUDE2  69  BCD*10.3  Func. Tax Included Amount 2  A C X   
TFINCLUDE3  70  BCD*10.3  Func. Tax Included Amount 3  A C X   
TFINCLUDE4  71  BCD*10.3  Func. Tax Included Amount 4  A C X   
TFINCLUDE5  72  BCD*10.3  Func. Tax Included Amount 5  A C X   
TFALLOAMT1  73  BCD*10.3  Func. Tax Allocated Amount 1  A C X   
TFALLOAMT2  74  BCD*10.3  Func. Tax Allocated Amount 2  A C X   
TFALLOAMT3  75  BCD*10.3  Func. Tax Allocated Amount 3  A C X   
TFALLOAMT4  76  BCD*10.3  Func. Tax Allocated Amount 4  A C X   
TFALLOAMT5  77  BCD*10.3  Func. Tax Allocated Amount 5  A C X   
TFRECVAMT1  78  BCD*10.3  Func. Tax Recoverable Amount 1  A C X   
TFRECVAMT2  79  BCD*10.3  Func. Tax Recoverable Amount 2  A C X   
TFRECVAMT3  80  BCD*10.3  Func. Tax Recoverable Amount 3  A C X   
TFRECVAMT4  81  BCD*10.3  Func. Tax Recoverable Amount 4  A C X   
TFRECVAMT5  82  BCD*10.3  Func. Tax Recoverable Amount 5  A C X   
TFEXPSAMT1  83  BCD*10.3  Func. Tax Expense Amount 1  A C X   
TFEXPSAMT2  84  BCD*10.3  Func. Tax Expense Amount 2  A C X   
TFEXPSAMT3  85  BCD*10.3  Func. Tax Expense Amount 3  A C X   
TFEXPSAMT4  86  BCD*10.3  Func. Tax Expense Amount 4  A C X   
TFEXPSAMT5  87  BCD*10.3  Func. Tax Expense Amount 5  A C X   
RCPNUMBER  88  String*22  Receipt Number  A X  Mask: %-22C
RCPHSEQA  89  BCD*10.0  Apply To Receipt Sequence Key  A X   
RCPNUMBERA  90  String*22  Apply To Receipt Number  A X  Mask: %-22C
INVSSEQG  91  BCD*10.0  Invoice Cost Group Sequence  A X   
VALUES  92  Long  Optional Fields  E A C X   
TERMDISCBL  93  Integer  Payment Discountable  E A X  List: 2 entries
0=No
1=Yes
CONTRACT  94  String*16  Contract  A X  Mask: %-16C
PROJECT  95  String*16  Project  A X  Mask: %-16N
CCATEGORY  96  String*16  (Cost) Category  A X  Mask: %-16N
COSTCLASS  97  Integer  Cost Class  A C X  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
RESOURCE  98  String*24  Resource  A P X  Mask: %-16N
BILLTYPE  99  Integer  Billing Type  A P X  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
BILLRATE  100  BCD*10.6  Billing Rate  A X   
BILLCURR  101  String*3  Billing Currency  A C X  Mask: %-3N
ARITEMNO  102  String*16  A/R Item Number  A X  Mask: %-16C
ARUNIT  103  String*10  A/R Unit of Measure  A X  Mask: %-10C
CALCOVRHD  104  Boolean  Calculate Overhead  A X  List: 2 entries
0=No
1=Yes
CALCLABOR  105  Boolean  Calculate Labor  A X  List: 2 entries
0=No
1=Yes
RTGPERCENT  106  BCD*5.5  Retainage Percentage  A X   
RTGDAYS  107  Integer  Retention Period  A X   
RTGAMOUNT  108  BCD*10.3  Retainage Amount  A X   
RTGDATEDUE  109  Date  Retainage Due Date  A X   
RTGAMTOVER  110  Boolean  Retainage Amount Overridden  A C X  List: 2 entries
0=No
1=Yes
RTGDDTOVER  111  Boolean  Retainage Due Date Overridden  A C X  List: 2 entries
0=No
1=Yes
COSTDISTS  112  Long  Cost Distributions  E A C X   
MANDISTS  113  Long  Manual Cost Distributions  E A C X   
EXTDISTS  114  Long  Extraneous Cost Distributions  E A C X   
TARAMOUNT1  115  BCD*10.3  Tax Reporting Amount 1  A X   
TARAMOUNT2  116  BCD*10.3  Tax Reporting Amount 2  A X   
TARAMOUNT3  117  BCD*10.3  Tax Reporting Amount 3  A X   
TARAMOUNT4  118  BCD*10.3  Tax Reporting Amount 4  A X   
TARAMOUNT5  119  BCD*10.3  Tax Reporting Amount 5  A X   
TRALLOAMT1  120  BCD*10.3  Tax Reporting Allocated Amount 1  A X   
TRALLOAMT2  121  BCD*10.3  Tax Reporting Allocated Amount 2  A X   
TRALLOAMT3  122  BCD*10.3  Tax Reporting Allocated Amount 3  A X   
TRALLOAMT4  123  BCD*10.3  Tax Reporting Allocated Amount 4  A X   
TRALLOAMT5  124  BCD*10.3  Tax Reporting Allocated Amount 5  A X   
TRRECVAMT1  125  BCD*10.3  Tax Reporting Recoverable Amt. 1  A X   
TRRECVAMT2  126  BCD*10.3  Tax Reporting Recoverable Amt. 2  A X   
TRRECVAMT3  127  BCD*10.3  Tax Reporting Recoverable Amt. 3  A X   
TRRECVAMT4  128  BCD*10.3  Tax Reporting Recoverable Amt. 4  A X   
TRRECVAMT5  129  BCD*10.3  Tax Reporting Recoverable Amt. 5  A X   
TREXPSAMT1  130  BCD*10.3  Tax Reporting Expense Amount 1  A X   
TREXPSAMT2  131  BCD*10.3  Tax Reporting Expense Amount 2  A X   
TREXPSAMT3  132  BCD*10.3  Tax Reporting Expense Amount 3  A X   
TREXPSAMT4  133  BCD*10.3  Tax Reporting Expense Amount 4  A X   
TREXPSAMT5  134  BCD*10.3  Tax Reporting Expense Amount 5  A X   
GLEXPACCTD  141  String*60  Expense Account Description  A C X   
GLRETACCTD  142  String*60  Return Expense Account Desc.  A C X   
TXICLASS1D  143  String*60  Tax Class 1 Description  A C X   
TXICLASS2D  144  String*60  Tax Class 2 Description  A C X   
TXICLASS3D  145  String*60  Tax Class 3 Description  A C X   
TXICLASS4D  146  String*60  Tax Class 4 Description  A C X   
TXICLASS5D  147  String*60  Tax Class 5 Description  A C X   
TXINCLUDE1  148  BCD*10.3  Included Tax Amount 1  A X   
TXINCLUDE2  149  BCD*10.3  Included Tax Amount 2  A X   
TXINCLUDE3  150  BCD*10.3  Included Tax Amount 3  A X   
TXINCLUDE4  151  BCD*10.3  Included Tax Amount 4  A X   
TXINCLUDE5  152  BCD*10.3  Included Tax Amount 5  A X   
TXEXCLUDE1  153  BCD*10.3  Excluded Tax Amount 1  A X   
TXEXCLUDE2  154  BCD*10.3  Excluded Tax Amount 2  A X   
TXEXCLUDE3  155  BCD*10.3  Excluded Tax Amount 3  A X   
TXEXCLUDE4  156  BCD*10.3  Excluded Tax Amount 4  A X   
TXEXCLUDE5  157  BCD*10.3  Excluded Tax Amount 5  A X   
MTOPRORATE  158  BCD*10.3  Manual To Prorate  A C X   
ISCOMPLETE  159  Boolean  Completed  E A X  List: 2 entries
0=No
1=Yes
TAXLINE  160  Long  Lines Tax Calculation Sees  A X   
COSTCMPL  161  Long  Costs Complete  A X   
COST  162  Long  Costs  A X   
RCPSREV  163  BCD*10.0  Line Number  A C X   
PROCESSCMD  164  Integer  Command  E A C X  List: 18 entries
0=Nothing to Process
1=Insert Optional Fields
2=Default and Tranfer Optional Fields
3=Default Opt. Fields During Record Generation
4=Remove Optional Fields
5=Transfer Opt. Fields from Standing Document
6=Insert Item Serial Optional Fields
7=Insert Item Lot Optional Fields
21=Auto-generate Serials
22=Auto-generate Lots
23=Auto-allocate Serials
24=Auto-allocate Lots
25=Clear Serials
26=Clear Lots
27=Auto-assign Serials
28=Auto-assign Lots
29=Create Serials/Lots List
31=Post Serials/Lots to IC Inventory
TERMDBWT  165  BCD*10.3  Payment Discount Base With Tax  A X   
TERMDBNT  166  BCD*10.3  Payment Discount Base Without Tax  A X   
JOBCOST  167  Long  Job Related Cost  A X   
AMOUNTC  168  BCD*10.3  Amount Distribution Sum  E A C X   
BILLRATEC  169  BCD*10.6  Billing Rate Distribution Sum  E A C X   
CONTSTYLE  170  Integer  Project Style  A C X  List: 3 entries
0=
1=Standard
2=Basic
PROJTYPE  171  Integer  Project Type  A C X  List: 4 entries
0=
1=Time and Materials
2=Fixed Price
3=Cost Plus
REVREC  172  Integer  Accounting Method  A C X  List: 9 entries
0=
1=Completed Project
2=Total Cost Percentage Complete
3=Labor Hours Percentage Complete
4=Billings and Costs
5=Project Percentage Complete
6=Category Percentage Complete
7=Completed Contract
8=Accrual-Basis
UFMTCONTNO  173  String*16  Unformatted Contract Code  A C X  Mask: %-16C
TRINCLUDE1  174  BCD*10.3  Tax Reporting Included Amount 1  A X   
TRINCLUDE2  175  BCD*10.3  Tax Reporting Included Amount 2  A X   
TRINCLUDE3  176  BCD*10.3  Tax Reporting Included Amount 3  A X   
TRINCLUDE4  177  BCD*10.3  Tax Reporting Included Amount 4  A X   
TRINCLUDE5  178  BCD*10.3  Tax Reporting Included Amount 5  A X   
TREXCLUDE1  179  BCD*10.3  Tax Reporting Excluded Amount 1  A X   
TREXCLUDE2  180  BCD*10.3  Tax Reporting Excluded Amount 2  A X   
TREXCLUDE3  181  BCD*10.3  Tax Reporting Excluded Amount 3  A X   
TREXCLUDE4  182  BCD*10.3  Tax Reporting Excluded Amount 4  A X   
TREXCLUDE5  183  BCD*10.3  Tax Reporting Excluded Amount 5  A X   
TARAMOUNT  184  BCD*10.3  Tax Reporting Total Amount  A X   
TRINCLUDED  185  BCD*10.3  Tax Reporting Included Amount  A X   
TREXCLUDED  186  BCD*10.3  Tax Reporting Excluded Amount  A X   
TRRECVAMT  187  BCD*10.3  Tax Reporting Recoverable Amount  A X   
TREXPSAMT  188  BCD*10.3  Tax Reporting Expensed Amount  A X   
TRALLOAMT  189  BCD*10.3  Tax Reporting Allocated Amount  A X   
RAXBASE1  190  BCD*10.3  Retainage Tax Base 1  A X   
RAXBASE2  191  BCD*10.3  Retainage Tax Base 2  A X   
RAXBASE3  192  BCD*10.3  Retainage Tax Base 3  A X   
RAXBASE4  193  BCD*10.3  Retainage Tax Base 4  A X   
RAXBASE5  194  BCD*10.3  Retainage Tax Base 5  A X   
RAXAMOUNT1  195  BCD*10.3  Retainage Tax Amount 1  A X   
RAXAMOUNT2  196  BCD*10.3  Retainage Tax Amount 2  A X   
RAXAMOUNT3  197  BCD*10.3  Retainage Tax Amount 3  A X   
RAXAMOUNT4  198  BCD*10.3  Retainage Tax Amount 4  A X   
RAXAMOUNT5  199  BCD*10.3  Retainage Tax Amount 5  A X   
RXRECVAMT1  201  BCD*10.3  Retainage Tax Recoverable Amt. 1  A X   
RXRECVAMT2  202  BCD*10.3  Retainage Tax Recoverable Amt. 2  A X   
RXRECVAMT3  203  BCD*10.3  Retainage Tax Recoverable Amt. 3  A X   
RXRECVAMT4  204  BCD*10.3  Retainage Tax Recoverable Amt. 4  A X   
RXRECVAMT5  205  BCD*10.3  Retainage Tax Recoverable Amt. 5  A X   
RXEXPSAMT1  206  BCD*10.3  Retainage Tax Expense Amount 1  A X   
RXEXPSAMT2  207  BCD*10.3  Retainage Tax Expense Amount 2  A X   
RXEXPSAMT3  208  BCD*10.3  Retainage Tax Expense Amount 3  A X   
RXEXPSAMT4  209  BCD*10.3  Retainage Tax Expense Amount 4  A X   
RXEXPSAMT5  210  BCD*10.3  Retainage Tax Expense Amount 5  A X   
RXALLOAMT1  211  BCD*10.3  Retainage Tax Allocated Amount 1  A X   
RXALLOAMT2  212  BCD*10.3  Retainage Tax Allocated Amount 2  A X   
RXALLOAMT3  213  BCD*10.3  Retainage Tax Allocated Amount 3  A X   
RXALLOAMT4  214  BCD*10.3  Retainage Tax Allocated Amount 4  A X   
RXALLOAMT5  215  BCD*10.3  Retainage Tax Allocated Amount 5  A X   
RAXAMOUNT  216  BCD*10.3  Retainage Tax Total Amount  A X   
TXRXAMT1  217  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 1  A X   
TXRXAMT2  218  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 2  A X   
TXRXAMT3  219  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 3  A X   
TXRXAMT4  220  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 4  A X   
TXRXAMT5  221  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 5  A X   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.