| 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
|
| DTCOMPLETE |
Date |
Date Completed |
|
| INDBTABLE |
Boolean |
Stored in Database Table |
List: 2 entries
|
| 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
|
| TAXINCLUD2 |
Boolean |
Tax Includable 2 |
List: 2 entries
|
| TAXINCLUD3 |
Boolean |
Tax Includable 3 |
List: 2 entries
|
| TAXINCLUD4 |
Boolean |
Tax Includable 4 |
List: 2 entries
|
| TAXINCLUD5 |
Boolean |
Tax Includable 5 |
List: 2 entries
|
| 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
|
| 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
|
| CALCLABOR |
Boolean |
Calculate Labor |
List: 2 entries
|
| 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
|
| RTGDDTOVER |
Boolean |
Retainage Due Date Overridden |
List: 2 entries
|
| 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 |
|
|