Table: Invoice Additional Costs

Table: POINVS
View: PO0440
Record length: 1850
Flags: A R 

Keys: 3

Title  Flags  Fields

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

Fields: 163

Field  Type  Title  Presentation 

INVHSEQ  BCD*10.0  Invoice Sequence Key   
INVSREV  BCD*10.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
INVSSEQ  BCD*10.0  Invoice Cost Sequence   
RCPHSEQ  BCD*10.0  Receipt Sequence Key   
RCPSSEQ  BCD*10.0  Receipt Cost Sequence   
RETHSEQ  BCD*10.0  Return Sequence Key   
RETSSEQ  BCD*10.0  Return Cost Sequence   
COMPLETION  Integer  Completion Status  List: 3 entries
1=No
2=Yes
3=Yes
DTCOMPLETE  Date  Date Completed   
INDBTABLE  Boolean  Stored in Database Table  List: 2 entries
0=No
1=Yes
ADDCOST  String*6  Additional Cost  Mask: %-6N
GLEXPACCT  String*45  Expense Account  Mask: %-45C
GLRETACCT  String*45  Return Account  Mask: %-45C
AMOUNT  BCD*10.3  Amount   
PRORMETHOD  Integer  Proration Method  List: 5 entries
1=No Proration
2=Prorate by Quantity
3=Prorate by Cost
4=Prorate by Weight
5=Prorate Manually
REPRORATE  Integer  Reproration Method  List: 3 entries
1=Leave
2=Prorate
3=Expense
DESCRIPTIO  String*60  Description   
REFERENCE  String*60  Reference   
COMMENT  String*250  Comment   
TAXICLASS1  Integer  Cost Tax Class 1   
TAXICLASS2  Integer  Cost Tax Class 2   
TAXICLASS3  Integer  Cost Tax Class 3   
TAXICLASS4  Integer  Cost Tax Class 4   
TAXICLASS5  Integer  Cost Tax Class 5   
TAXBASE1  BCD*10.3  Tax Base 1   
TAXBASE2  BCD*10.3  Tax Base 2   
TAXBASE3  BCD*10.3  Tax Base 3   
TAXBASE4  BCD*10.3  Tax Base 4   
TAXBASE5  BCD*10.3  Tax Base 5   
TAXRATE1  BCD*8.5  Tax Rate 1   
TAXRATE2  BCD*8.5  Tax Rate 2   
TAXRATE3  BCD*8.5  Tax Rate 3   
TAXRATE4  BCD*8.5  Tax Rate 4   
TAXRATE5  BCD*8.5  Tax Rate 5   
TAXAMOUNT1  BCD*10.3  Tax Amount 1   
TAXAMOUNT2  BCD*10.3  Tax Amount 2   
TAXAMOUNT3  BCD*10.3  Tax Amount 3   
TAXAMOUNT4  BCD*10.3  Tax Amount 4   
TAXAMOUNT5  BCD*10.3  Tax Amount 5   
TAXINCLUD1  Boolean  Tax Includable 1  List: 2 entries
0=No
1=Yes
TAXINCLUD2  Boolean  Tax Includable 2  List: 2 entries
0=No
1=Yes
TAXINCLUD3  Boolean  Tax Includable 3  List: 2 entries
0=No
1=Yes
TAXINCLUD4  Boolean  Tax Includable 4  List: 2 entries
0=No
1=Yes
TAXINCLUD5  Boolean  Tax Includable 5  List: 2 entries
0=No
1=Yes
TXALLOAMT1  BCD*10.3  Tax Allocated Amount 1   
TXALLOAMT2  BCD*10.3  Tax Allocated Amount 2   
TXALLOAMT3  BCD*10.3  Tax Allocated Amount 3   
TXALLOAMT4  BCD*10.3  Tax Allocated Amount 4   
TXALLOAMT5  BCD*10.3  Tax Allocated Amount 5   
TXRECVAMT1  BCD*10.3  Tax Recoverable Amount 1   
TXRECVAMT2  BCD*10.3  Tax Recoverable Amount 2   
TXRECVAMT3  BCD*10.3  Tax Recoverable Amount 3   
TXRECVAMT4  BCD*10.3  Tax Recoverable Amount 4   
TXRECVAMT5  BCD*10.3  Tax Recoverable Amount 5   
TXEXPSAMT1  BCD*10.3  Tax Expense Amount 1   
TXEXPSAMT2  BCD*10.3  Tax Expense Amount 2   
TXEXPSAMT3  BCD*10.3  Tax Expense Amount 3   
TXEXPSAMT4  BCD*10.3  Tax Expense Amount 4   
TXEXPSAMT5  BCD*10.3  Tax Expense Amount 5   
TXBASEALLO  BCD*10.3  Net of Tax   
TXINCLUDED  BCD*10.3  Tax Included   
TXEXCLUDED  BCD*10.3  Tax Excluded   
TAXAMOUNT  BCD*10.3  Total Tax   
TXRECVAMT  BCD*10.3  Total Tax Recoverable   
TXEXPSAMT  BCD*10.3  Total Tax Expensed   
TXALLOAMT  BCD*10.3  Total Tax Allocated   
TFBASEALLO  BCD*10.3  Func. Net of Tax   
TFINCLUDE1  BCD*10.3  Func. Tax Included Amount 1   
TFINCLUDE2  BCD*10.3  Func. Tax Included Amount 2   
TFINCLUDE3  BCD*10.3  Func. Tax Included Amount 3   
TFINCLUDE4  BCD*10.3  Func. Tax Included Amount 4   
TFINCLUDE5  BCD*10.3  Func. Tax Included Amount 5   
TFALLOAMT1  BCD*10.3  Func. Tax Allocated Amount 1   
TFALLOAMT2  BCD*10.3  Func. Tax Allocated Amount 2   
TFALLOAMT3  BCD*10.3  Func. Tax Allocated Amount 3   
TFALLOAMT4  BCD*10.3  Func. Tax Allocated Amount 4   
TFALLOAMT5  BCD*10.3  Func. Tax Allocated Amount 5   
TFRECVAMT1  BCD*10.3  Func. Tax Recoverable Amount 1   
TFRECVAMT2  BCD*10.3  Func. Tax Recoverable Amount 2   
TFRECVAMT3  BCD*10.3  Func. Tax Recoverable Amount 3   
TFRECVAMT4  BCD*10.3  Func. Tax Recoverable Amount 4   
TFRECVAMT5  BCD*10.3  Func. Tax Recoverable Amount 5   
TFEXPSAMT1  BCD*10.3  Func. Tax Expense Amount 1   
TFEXPSAMT2  BCD*10.3  Func. Tax Expense Amount 2   
TFEXPSAMT3  BCD*10.3  Func. Tax Expense Amount 3   
TFEXPSAMT4  BCD*10.3  Func. Tax Expense Amount 4   
TFEXPSAMT5  BCD*10.3  Func. Tax Expense Amount 5   
RCPNUMBER  String*22  Receipt Number  Mask: %-22C
RCPHSEQA  BCD*10.0  Apply To Receipt Sequence Key   
RCPNUMBERA  String*22  Apply To Receipt Number  Mask: %-22C
INVSSEQG  BCD*10.0  Invoice Cost Group Sequence   
VALUES  Long  Optional Fields   
TERMDISCBL  Integer  Payment Discountable  List: 2 entries
0=No
1=Yes
CONTRACT  String*16  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
CCATEGORY  String*16  (Cost) Category  Mask: %-16N
COSTCLASS  Integer  Cost Class  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
RESOURCE  String*24  Resource  Mask: %-16N
BILLTYPE  Integer  Billing Type  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
BILLRATE  BCD*10.6  Billing Rate   
BILLCURR  String*3  Billing Currency  Mask: %-3N
ARITEMNO  String*16  A/R Item Number  Mask: %-16C
ARUNIT  String*10  A/R Unit of Measure  Mask: %-10C
CALCOVRHD  Boolean  Calculate Overhead  List: 2 entries
0=No
1=Yes
CALCLABOR  Boolean  Calculate Labor  List: 2 entries
0=No
1=Yes
RTGPERCENT  BCD*5.5  Retainage Percentage   
RTGDAYS  Integer  Retention Period   
RTGAMOUNT  BCD*10.3  Retainage Amount   
RTGDATEDUE  Date  Retainage Due Date   
RTGAMTOVER  Boolean  Retainage Amount Overridden  List: 2 entries
0=No
1=Yes
RTGDDTOVER  Boolean  Retainage Due Date Overridden  List: 2 entries
0=No
1=Yes
COSTDISTS  Long  Cost Distributions   
MANDISTS  Long  Manual Cost Distributions   
EXTDISTS  Long  Extraneous Cost Distributions   
TARAMOUNT1  BCD*10.3  Tax Reporting Amount 1   
TARAMOUNT2  BCD*10.3  Tax Reporting Amount 2   
TARAMOUNT3  BCD*10.3  Tax Reporting Amount 3   
TARAMOUNT4  BCD*10.3  Tax Reporting Amount 4   
TARAMOUNT5  BCD*10.3  Tax Reporting Amount 5   
TRALLOAMT1  BCD*10.3  Tax Reporting Allocated Amount 1   
TRALLOAMT2  BCD*10.3  Tax Reporting Allocated Amount 2   
TRALLOAMT3  BCD*10.3  Tax Reporting Allocated Amount 3   
TRALLOAMT4  BCD*10.3  Tax Reporting Allocated Amount 4   
TRALLOAMT5  BCD*10.3  Tax Reporting Allocated Amount 5   
TRRECVAMT1  BCD*10.3  Tax Reporting Recoverable Amt. 1   
TRRECVAMT2  BCD*10.3  Tax Reporting Recoverable Amt. 2   
TRRECVAMT3  BCD*10.3  Tax Reporting Recoverable Amt. 3   
TRRECVAMT4  BCD*10.3  Tax Reporting Recoverable Amt. 4   
TRRECVAMT5  BCD*10.3  Tax Reporting Recoverable Amt. 5   
TREXPSAMT1  BCD*10.3  Tax Reporting Expense Amount 1   
TREXPSAMT2  BCD*10.3  Tax Reporting Expense Amount 2   
TREXPSAMT3  BCD*10.3  Tax Reporting Expense Amount 3   
TREXPSAMT4  BCD*10.3  Tax Reporting Expense Amount 4   
TREXPSAMT5  BCD*10.3  Tax Reporting Expense Amount 5   
RAXBASE1  BCD*10.3  Retainage Tax Base 1   
RAXBASE2  BCD*10.3  Retainage Tax Base 2   
RAXBASE3  BCD*10.3  Retainage Tax Base 3   
RAXBASE4  BCD*10.3  Retainage Tax Base 4   
RAXBASE5  BCD*10.3  Retainage Tax Base 5   
RAXAMOUNT1  BCD*10.3  Retainage Tax Amount 1   
RAXAMOUNT2  BCD*10.3  Retainage Tax Amount 2   
RAXAMOUNT3  BCD*10.3  Retainage Tax Amount 3   
RAXAMOUNT4  BCD*10.3  Retainage Tax Amount 4   
RAXAMOUNT5  BCD*10.3  Retainage Tax Amount 5   
RXRECVAMT1  BCD*10.3  Retainage Tax Recoverable Amt. 1   
RXRECVAMT2  BCD*10.3  Retainage Tax Recoverable Amt. 2   
RXRECVAMT3  BCD*10.3  Retainage Tax Recoverable Amt. 3   
RXRECVAMT4  BCD*10.3  Retainage Tax Recoverable Amt. 4   
RXRECVAMT5  BCD*10.3  Retainage Tax Recoverable Amt. 5   
RXEXPSAMT1  BCD*10.3  Retainage Tax Expense Amount 1   
RXEXPSAMT2  BCD*10.3  Retainage Tax Expense Amount 2   
RXEXPSAMT3  BCD*10.3  Retainage Tax Expense Amount 3   
RXEXPSAMT4  BCD*10.3  Retainage Tax Expense Amount 4   
RXEXPSAMT5  BCD*10.3  Retainage Tax Expense Amount 5   
RXALLOAMT1  BCD*10.3  Retainage Tax Allocated Amount 1   
RXALLOAMT2  BCD*10.3  Retainage Tax Allocated Amount 2   
RXALLOAMT3  BCD*10.3  Retainage Tax Allocated Amount 3   
RXALLOAMT4  BCD*10.3  Retainage Tax Allocated Amount 4   
RXALLOAMT5  BCD*10.3  Retainage Tax Allocated Amount 5   

This page was generated on 2008-May-01

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