| TRANSTYPE |
Integer |
Transaction Type |
List: 5 entries
| 1 | = | Invoice | | 2 | = | Credit Note | | 3 | = | Shipment | | 4 | = | Debit Note | | 5 | = | Order |
|
| DAYENDNUM |
Long |
Day End Number |
|
| ENTRYNUM |
Long |
Entry Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| PRINTED |
Boolean |
Printed |
|
| TRANSDATE |
Date |
Transaction Date |
|
| FISCYR |
String*4 |
Fiscal Year |
Mask: %-4d |
| FISCPER |
Integer |
Fiscal Period |
|
| DOCNUM |
String*22 |
Document Number |
Mask: %-22C |
| ARINVBATCH |
BCD*5.0 |
A/R Invoice Batch Number |
|
| REFERENCE |
String*60 |
Reference |
|
| DESC |
String*60 |
Description |
|
| CUSTOMER |
String*12 |
Customer Number |
Mask: %-12C |
| CUSTNAME |
String*60 |
Customer Name |
|
| TAXGROUP |
String*12 |
Tax Group |
Mask: %-12N |
| ORDNUMBER |
String*22 |
Order Number |
Mask: %-22C |
| ORDDATE |
Date |
Order Date |
|
| INVNUMBER |
String*22 |
Invoice Number |
Mask: %-22C |
| INVDATE |
Date |
Invoice Date |
|
| PONUMBER |
String*22 |
Purchase Order Number |
Mask: %-22C |
| TERRITORY |
String*6 |
Territory |
Mask: %-6N |
| INVDISCPER |
BCD*5.5 |
Discount Percentage |
|
| INVDISCAMT |
BCD*10.3 |
Discount Amount |
|
| INSOURCURR |
String*3 |
Invoice Currency |
Mask: %-3N |
| INRATE |
BCD*8.7 |
Invoice Exchange Rate |
|
| INRATETYPE |
String*2 |
Invoice Rate Type |
Mask: %-2N |
| INRATEDATE |
Date |
Invoice Rate Date |
|
| TAUTH1 |
String*12 |
Tax Authority 1 |
Mask: %-12N |
| TAUTH2 |
String*12 |
Tax Authority 2 |
Mask: %-12N |
| TAUTH3 |
String*12 |
Tax Authority 3 |
Mask: %-12N |
| TAUTH4 |
String*12 |
Tax Authority 4 |
Mask: %-12N |
| TAUTH5 |
String*12 |
Tax Authority 5 |
Mask: %-12N |
| TCLASS1 |
Integer |
Customer Tax Class 1 |
|
| TCLASS2 |
Integer |
Customer Tax Class 2 |
|
| TCLASS3 |
Integer |
Customer Tax Class 3 |
|
| TCLASS4 |
Integer |
Customer Tax Class 4 |
|
| TCLASS5 |
Integer |
Customer Tax Class 5 |
|
| TBASE1 |
BCD*10.3 |
Tax Base 1 |
|
| TBASE2 |
BCD*10.3 |
Tax Base 2 |
|
| TBASE3 |
BCD*10.3 |
Tax Base 3 |
|
| TBASE4 |
BCD*10.3 |
Tax Base 4 |
|
| TBASE5 |
BCD*10.3 |
Tax Base 5 |
|
| TAMOUNT1H |
BCD*10.3 |
Tax Amount 1 - Functional |
|
| TAMOUNT2H |
BCD*10.3 |
Tax Amount 2 - Functional |
|
| TAMOUNT3H |
BCD*10.3 |
Tax Amount 3 - Functional |
|
| TAMOUNT4H |
BCD*10.3 |
Tax Amount 4 - Functional |
|
| TAMOUNT5H |
BCD*10.3 |
Tax Amount 5 - Functional |
|
| TINAMT1S |
BCD*10.3 |
Tax Included Amount 1 - Source |
|
| TINAMT2S |
BCD*10.3 |
Tax Included Amount 2 - Source |
|
| TINAMT3S |
BCD*10.3 |
Tax Included Amount 3 - Source |
|
| TINAMT4S |
BCD*10.3 |
Tax Included Amount 4 - Source |
|
| TINAMT5S |
BCD*10.3 |
Tax Included Amount 5 - Source |
|
| TEXAMT1S |
BCD*10.3 |
Tax Excluded Amount 1 - Source |
|
| TEXAMT2S |
BCD*10.3 |
Tax Excluded Amount 2 - Source |
|
| TEXAMT3S |
BCD*10.3 |
Tax Excluded Amount 3 - Source |
|
| TEXAMT4S |
BCD*10.3 |
Tax Excluded Amount 4 - Source |
|
| TEXAMT5S |
BCD*10.3 |
Tax Excluded Amount 5 - Source |
|
| TACCT1 |
String*45 |
Tax G/L Account 1 |
Mask: %-45C |
| TACCT2 |
String*45 |
Tax G/L Account 2 |
Mask: %-45C |
| TACCT3 |
String*45 |
Tax G/L Account 3 |
Mask: %-45C |
| TACCT4 |
String*45 |
Tax G/L Account 4 |
Mask: %-45C |
| TACCT5 |
String*45 |
Tax G/L Account 5 |
Mask: %-45C |
| INVNETH |
BCD*10.3 |
Net Invoice Amount (Functional) |
|
| INVNETS |
BCD*10.3 |
Net Invoice Amount (Source) |
|
| SALESPER1 |
String*8 |
Salesperson 1 |
Mask: %-8N |
| SALESPER2 |
String*8 |
Salesperson 2 |
Mask: %-8N |
| SALESPER3 |
String*8 |
Salesperson 3 |
Mask: %-8N |
| SALESPER4 |
String*8 |
Salesperson 4 |
Mask: %-8N |
| SALESPER5 |
String*8 |
Salesperson 5 |
Mask: %-8N |
| SALESPLT1 |
BCD*5.5 |
Sales Percentage 1 |
|
| SALESPLT2 |
BCD*5.5 |
Sales Percentage 2 |
|
| SALESPLT3 |
BCD*5.5 |
Sales Percentage 3 |
|
| SALESPLT4 |
BCD*5.5 |
Sales Percentage 4 |
|
| SALESPLT5 |
BCD*5.5 |
Sales Percentage 5 |
|
| POSTDATE |
Date |
Posting Date |
|
| MULTIDOC |
Boolean |
Multiple Documents |
|
| VALUES |
Long |
Optional Fields |
|
| TRCURRENCY |
String*3 |
Tax Reporting Currency |
Mask: %-3N |
| TRRATE |
BCD*8.7 |
Tax Reporting Currency Rate |
|
| TRRATETYPE |
String*2 |
Tax Reporting Currency Type |
Mask: %-2N |
| TRRATEDATE |
Date |
Tax Reporting Currency Date |
|
| TREAMOUNT1 |
BCD*10.3 |
TRC Excluded Amount 1 |
|
| TREAMOUNT2 |
BCD*10.3 |
TRC Excluded Amount 2 |
|
| TREAMOUNT3 |
BCD*10.3 |
TRC Excluded Amount 3 |
|
| TREAMOUNT4 |
BCD*10.3 |
TRC Excluded Amount 4 |
|
| TREAMOUNT5 |
BCD*10.3 |
TRC Excluded Amount 5 |
|
| TRIAMOUNT1 |
BCD*10.3 |
TRC Included Amount 1 |
|
| TRIAMOUNT2 |
BCD*10.3 |
TRC Included Amount 2 |
|
| TRIAMOUNT3 |
BCD*10.3 |
TRC Included Amount 3 |
|
| TRIAMOUNT4 |
BCD*10.3 |
TRC Included Amount 4 |
|
| TRIAMOUNT5 |
BCD*10.3 |
TRC Included Amount 5 |
|
| CUSACCTSET |
String*6 |
Customer Account Set |
Mask: %-6N |
| JOBLINES |
Long |
Job Related Detail Lines |
|
| LNINVABLE |
Long |
Invoiceable Detail Lines |
|
| HASRTG |
Boolean |
Has Retainage |
List: 2 entries
|
| RTGTERMS |
String*6 |
Retainage Terms |
Mask: %-6N |
| RTGAMOUNT |
BCD*10.3 |
Retainage Amount |
|
| RTGPERCENT |
BCD*5.5 |
Retainage Percent |
|
| RTGRATE |
Integer |
Retainage Exchange Rate |
List: 2 entries
| 0 | = | Use Original Document Exchange Rate | | 1 | = | Use Current Exchange Rate |
|
| RTGTXBASE1 |
BCD*10.3 |
Retainage Tax Base 1 |
|
| RTGTXBASE2 |
BCD*10.3 |
Retainage Tax Base 2 |
|
| RTGTXBASE3 |
BCD*10.3 |
Retainage Tax Base 3 |
|
| RTGTXBASE4 |
BCD*10.3 |
Retainage Tax Base 4 |
|
| RTGTXBASE5 |
BCD*10.3 |
Retainage Tax Base 5 |
|
| RTGTXAMT1 |
BCD*10.3 |
Retainage Tax Amount 1 |
|
| RTGTXAMT2 |
BCD*10.3 |
Retainage Tax Amount 2 |
|
| RTGTXAMT3 |
BCD*10.3 |
Retainage Tax Amount 3 |
|
| RTGTXAMT4 |
BCD*10.3 |
Retainage Tax Amount 4 |
|
| RTGTXAMT5 |
BCD*10.3 |
Retainage Tax Amount 5 |
|
| DATEBUS |
Date |
Posting Date |
|
|