# 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.