| INVHSEQ |
BCD*10.0 |
Invoice Sequence Key |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| NEXTLSEQ |
BCD*10.0 |
Next Line Sequence |
|
| LINES |
Long |
Lines |
|
| LINESCMPL |
Long |
Lines Complete |
|
| COSTS |
Long |
Costs |
|
| COSTSCMPL |
Long |
Costs Complete |
|
| PAYMENTS |
Long |
Payments |
|
| TAXLINES |
Long |
Lines Tax Calculation Sees |
|
| TAXAUTOCAL |
Boolean |
Auto. tax calculation on save |
List: 2 entries
|
| ISCOMPLETE |
Boolean |
Completed |
List: 2 entries
|
| DTCOMPLETE |
Date |
Date Completed |
|
| POSTDATE |
Date |
Last Posting Date |
|
| PORHSEQ |
BCD*10.0 |
Purchase Order Sequence Key |
|
| PONUMBER |
String*22 |
Purchase Order Number |
Mask: %-22C |
| DATE |
Date |
Invoice Date |
|
| FISCYEAR |
String*4 |
Fiscal Year |
Mask: %4D |
| FISCPERIOD |
Integer |
Fiscal Period |
List: 12 entries
| 1 | = | 1 | | 2 | = | 2 | | 3 | = | 3 | | 4 | = | 4 | | 5 | = | 5 | | 6 | = | 6 | | 7 | = | 7 | | 8 | = | 8 | | 9 | = | 9 | | 10 | = | 10 | | 11 | = | 11 | | 12 | = | 12 |
|
| INVNUMBER |
String*22 |
Invoice Number |
Mask: %-22C |
| VDCODE |
String*12 |
Vendor |
Mask: %-12C |
| VDEXISTS |
Boolean |
Vendor Exists |
List: 2 entries
|
| VDNAME |
String*60 |
Name |
|
| VDADDRESS1 |
String*60 |
Address 1 |
|
| VDADDRESS2 |
String*60 |
Address 2 |
|
| VDADDRESS3 |
String*60 |
Address 3 |
|
| VDADDRESS4 |
String*60 |
Address 4 |
|
| VDCITY |
String*30 |
City |
|
| VDSTATE |
String*30 |
State/Province |
|
| VDZIP |
String*20 |
Zip/Postal Code |
|
| VDCOUNTRY |
String*30 |
Country |
|
| VDPHONE |
String*30 |
Phone Number |
Mask: (%-3C) %-3C-%-24C |
| VDFAX |
String*30 |
Fax Number |
Mask: (%-3C) %-3C-%-24C |
| VDCONTACT |
String*60 |
Contact |
|
| TERMSCODE |
String*6 |
Terms Code |
Mask: %-6N |
| FROMDOC |
Integer |
From Document |
List: 2 entries
|
| FORPRIMARY |
Integer |
Primary Vendor |
List: 3 entries
| 1 | = | Primary Vendor | | 2 | = | Secondary Vendor | | 3 | = | New Vendor |
|
| RCPHSEQ |
BCD*10.0 |
Receipt Sequence Key |
|
| RCPNUMBER |
String*22 |
Receipt Number |
Mask: %-22C |
| RCPDATE |
Date |
Receipt Date |
|
| RETHSEQ |
BCD*10.0 |
Return Sequence Key |
|
| RETNUMBER |
String*22 |
Return Number |
Mask: %-22C |
| RETDATE |
Date |
Return Date |
|
| DESCRIPTIO |
String*60 |
Description |
|
| REFERENCE |
String*60 |
Reference |
|
| COMMENT |
String*250 |
Comment |
|
| CURRENCY |
String*3 |
Currency |
Mask: %-3N |
| RATE |
BCD*8.7 |
Exchange Rate |
|
| SPREAD |
BCD*8.7 |
Rate Spread |
|
| RATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| RATEMATCH |
Integer |
Rate Match Type |
|
| RATEDATE |
Date |
Rate Date |
|
| RATEOPER |
Integer |
Rate Operation |
List: 2 entries
|
| RATEOVER |
Boolean |
Rate Overridden |
List: 2 entries
|
| SCURNDECML |
Integer |
Decimal Places |
|
| DTPYMTASOF |
Date |
Payment As Of Date |
|
| TERMDUEAMT |
BCD*10.3 |
Total Terms Amount Due |
|
| EXTWEIGHT |
BCD*10.4 |
Extended Weight |
|
| EXTENDED |
BCD*10.3 |
Extended Cost |
|
| DOCTOTAL |
BCD*10.3 |
Total |
|
| AMOUNT |
BCD*10.3 |
Additional Costs |
|
| RQRECEIVED |
BCD*10.4 |
Quantity Received |
|
| TAXGROUP |
String*12 |
Tax Group |
Mask: %-12N |
| TAXAUTH1 |
String*12 |
Tax Authority 1 |
Mask: %-12N |
| TAXAUTH2 |
String*12 |
Tax Authority 2 |
Mask: %-12N |
| TAXAUTH3 |
String*12 |
Tax Authority 3 |
Mask: %-12N |
| TAXAUTH4 |
String*12 |
Tax Authority 4 |
Mask: %-12N |
| TAXAUTH5 |
String*12 |
Tax Authority 5 |
Mask: %-12N |
| TAXCLASS1 |
Integer |
Tax Class 1 |
|
| TAXCLASS2 |
Integer |
Tax Class 2 |
|
| TAXCLASS3 |
Integer |
Tax Class 3 |
|
| TAXCLASS4 |
Integer |
Tax Class 4 |
|
| TAXCLASS5 |
Integer |
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 |
|
| TXINCLUDE1 |
BCD*10.3 |
Included Tax Amount 1 |
|
| TXINCLUDE2 |
BCD*10.3 |
Included Tax Amount 2 |
|
| TXINCLUDE3 |
BCD*10.3 |
Included Tax Amount 3 |
|
| TXINCLUDE4 |
BCD*10.3 |
Included Tax Amount 4 |
|
| TXINCLUDE5 |
BCD*10.3 |
Included Tax Amount 5 |
|
| TXEXCLUDE1 |
BCD*10.3 |
Excluded Tax Amount 1 |
|
| TXEXCLUDE2 |
BCD*10.3 |
Excluded Tax Amount 2 |
|
| TXEXCLUDE3 |
BCD*10.3 |
Excluded Tax Amount 3 |
|
| TXEXCLUDE4 |
BCD*10.3 |
Excluded Tax Amount 4 |
|
| TXEXCLUDE5 |
BCD*10.3 |
Excluded Tax Amount 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| F1099CLASS |
String*6 |
1099/CPRS Class |
Mask: %-6N |
| F1099AMT |
BCD*10.3 |
The 1099/CPRS Amount |
|
| MPRORATED |
BCD*10.3 |
Manual Proration Total |
|
| MTOPRORATE |
BCD*10.3 |
Manual To Prorate |
|
| MEXPENSED |
BCD*10.3 |
Manual Proration Expensed |
|
| SCAMOUNT |
BCD*10.3 |
Conversion Source Amount |
|
| FCAMOUNT |
BCD*10.3 |
Conversion Functional Amount |
|
| MULTIRCP |
Boolean |
Multiple Receipts |
List: 2 entries
|
| RCPS |
Long |
Receipts |
|
| VDEMAIL |
String*50 |
E-mail |
|
| VDPHONEC |
String*30 |
Contact Phone |
Mask: (%-3C) %-3C-%-24C |
| VDFAXC |
String*30 |
Contact Fax |
Mask: (%-3C) %-3C-%-24C |
| VDEMAILC |
String*50 |
Contact E-mail |
|
| DISCPCT |
BCD*5.5 |
Discount Percentage |
|
| DISCOUNT |
BCD*10.3 |
Discount Amount |
|
| VALUES |
Long |
Optional Fields |
|
| ONHOLD |
Boolean |
On Hold |
List: 2 entries
|
| TERMDBWT |
BCD*10.3 |
Payment Discount Base With Tax |
|
| TERMDBNT |
BCD*10.3 |
Payment Discount Base Without Tax |
|
| VERPRORATE |
Integer |
Proration Version |
List: 2 entries
|
| HASRTG |
Boolean |
Has Retainage |
List: 2 entries
|
| RTGRATE |
Integer |
Retainage Exchange Rate |
List: 2 entries
| 0 | = | Use Original Document Exchange Rate | | 1 | = | Use Current Exchange Rate |
|
| RTGBASE |
Integer |
Retainage Base |
List: 2 entries
| 0 | = | Total After Taxes | | 1 | = | Total Before Taxes |
|
| RTGTERMS |
String*6 |
Retainage Terms Code |
Mask: %-6N |
| RTGAMOUNT |
BCD*10.3 |
Retainage Amount |
|
| JOBLINES |
Long |
Job Related Lines |
|
| JOBCOSTS |
Long |
Job Related Costs |
|
| TRCURRENCY |
String*3 |
Tax Reporting Currency |
Mask: %-3N |
| RATERC |
BCD*8.7 |
Tax Reporting Exchange Rate |
|
| SPREADRC |
BCD*8.7 |
Tax Reporting Rate Spread |
|
| RATETYPERC |
String*2 |
Tax Reporting Rate Type |
Mask: %-2N |
| RATEMTCHRC |
Integer |
Tax Reporting Rate Match Type |
|
| RATEDATERC |
Date |
Tax Reporting Rate Date |
|
| RATEOPERRC |
Integer |
Tax Reporting Rate Operation |
List: 2 entries
|
| RATERCOVER |
Boolean |
Tax Reporting Rate Overridden |
List: 2 entries
|
| RCURNDECML |
Integer |
Tax Reporting Decimal Places |
|
| 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 |
|
| TRINCLUDE1 |
BCD*10.3 |
Tax Reporting Included Amount 1 |
|
| TRINCLUDE2 |
BCD*10.3 |
Tax Reporting Included Amount 2 |
|
| TRINCLUDE3 |
BCD*10.3 |
Tax Reporting Included Amount 3 |
|
| TRINCLUDE4 |
BCD*10.3 |
Tax Reporting Included Amount 4 |
|
| TRINCLUDE5 |
BCD*10.3 |
Tax Reporting Included Amount 5 |
|
| TREXCLUDE1 |
BCD*10.3 |
Tax Reporting Excluded Amount 1 |
|
| TREXCLUDE2 |
BCD*10.3 |
Tax Reporting Excluded Amount 2 |
|
| TREXCLUDE3 |
BCD*10.3 |
Tax Reporting Excluded Amount 3 |
|
| TREXCLUDE4 |
BCD*10.3 |
Tax Reporting Excluded Amount 4 |
|
| TREXCLUDE5 |
BCD*10.3 |
Tax Reporting Excluded 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 |
|
| 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 |
|
| RTGTAXREP |
Integer |
Report Retainage Tax |
List: 2 entries
| 0 | = | At Time of Original Document | | 1 | = | As Per Tax Authority |
|
| TAXVERSION |
Long |
Tax State Version |
|
| 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 |
|
|