| Name |
Type |
Length |
Decimal |
Relation |
Description |
| INVNUM |
String |
12 |
|
|
AR INVNUM |
| NUMBER |
String |
10 |
|
|
AR NUMBER |
| PREPAYNUM |
String |
12 |
|
|
AR INVOICE HIS HEADER PREPAYNUM - Prepaynum |
| NAME |
String |
30 |
|
|
AR NAME |
| ADDRESS1 |
String |
40 |
|
|
AR ADDRESS1 |
| ADDRESS2 |
String |
40 |
|
|
AR ADDRESS2 |
| CITY |
String |
20 |
|
|
AR CITY |
| STATE |
String |
10 |
|
|
AR STATE |
| ZIP |
String |
10 |
|
|
AR ZIP |
| COUNTRY |
String |
30 |
|
|
AR COUNTRY |
| TERMCODE |
String |
2 |
|
|
AR TERMCODE |
| INVTYPE |
String |
2 |
|
|
AR INVOICE HIS HEADER INVTYPE - Invtype |
| SLPCODE |
String |
5 |
|
|
AR SLPCODE |
| TCODE_1 |
String |
3 |
|
|
AR TCODE_1 |
| TCODE_2 |
String |
3 |
|
|
AR TCODE_2 |
| TCODE_3 |
String |
3 |
|
|
AR TCODE_3 |
| INBATCH |
String |
6 |
|
|
AR INVOICE HIS HEADER INBATCH - Inbatch |
| DEFAR |
String |
12 |
|
|
AR DEFAR |
| DEFFREIGHT |
String |
12 |
|
|
AR DEFFREIGHT |
| DEFMISC |
String |
12 |
|
|
AR DEFMISC |
| DEFSTAXPAY |
String |
12 |
|
|
AR DEFSTAXPAY |
| DEFFINANCE |
String |
12 |
|
|
AR DEFFINANCE |
| DEFDISC |
String |
12 |
|
|
AR DEFDISC |
| FRE_TAX |
String |
1 |
|
|
AR INVOICE HIS HEADER FRE_TAX - Fre_tax |
| USERID |
String |
4 |
|
|
AR USERID |
| USERCOMP |
String |
3 |
|
|
AR USERCOMP |
| INVDATE |
DateTime |
8 |
|
|
AR INVDATE |
| DUEDATE |
DateTime |
8 |
|
|
AR INVOICE HIS HEADER DUEDATE - Duedate |
| DISCDUE |
DateTime |
8 |
|
|
AR INVOICE HIS HEADER DISCDUE - Discdue |
| COMMENT |
String |
4 |
|
|
AR COMMENT |
| TAX_RATE |
Decimal |
6 |
3 |
|
AR INVOICE HIS HEADER TAX_RATE - Tax_rate |
| FTAX_RATE |
Decimal |
6 |
3 |
|
AR INVOICE HIS HEADER FTAX_RATE - Ftax_rate |
| TAX |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER TAX - Tax |
| FTAX |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER FTAX - Ftax |
| NTAXTOT |
Decimal |
11 |
2 |
|
AR INVOICE HIS HEADER NTAXTOT - Ntaxtot |
| FNTAXTOT |
Decimal |
11 |
2 |
|
AR INVOICE HIS HEADER FNTAXTOT - Fntaxtot |
| TAXTOT |
Decimal |
11 |
2 |
|
AR INVOICE HIS HEADER TAXTOT - Taxtot |
| FTAXTOT |
Decimal |
11 |
2 |
|
AR INVOICE HIS HEADER FTAXTOT - Ftaxtot |
| INVTOT |
Decimal |
12 |
2 |
|
AR INVOICE HIS HEADER INVTOT - Invtot |
| FINVTOT |
Decimal |
12 |
2 |
|
AR INVOICE HIS HEADER FINVTOT - Finvtot |
| FREIGHT |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER FREIGHT - Freight |
| FFREIGHT |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER FFREIGHT - Ffreight |
| MISC |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER MISC - Misc |
| FMISC |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER FMISC - Fmisc |
| AMTOPEN |
Decimal |
12 |
2 |
|
AR INVOICE HIS HEADER AMTOPEN - Amtopen |
| FAMTOPEN |
Decimal |
12 |
2 |
|
AR INVOICE HIS HEADER FAMTOPEN - Famtopen |
| DISCOUNT |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER DISCOUNT - Discount |
| FDISCOUNT |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER FDISCOUNT - Fdiscount |
| SLPCOMM |
Decimal |
5 |
2 |
|
AR INVOICE HIS HEADER SLPCOMM - Slpcomm |
| COMMTOT |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER COMMTOT - Commtot |
| FCOMMTOT |
Decimal |
8 |
2 |
|
AR INVOICE HIS HEADER FCOMMTOT - Fcommtot |
| PREPAYAMT |
Decimal |
12 |
2 |
|
AR INVOICE HIS HEADER PREPAYAMT - Prepayamt |
| FPREPAYAMT |
Decimal |
12 |
2 |
|
AR INVOICE HIS HEADER FPREPAYAM - Fprepayamt |
| FILENUMBER |
String |
5 |
|
|
AR INVOICE HIS HEADER FILENUMBE - Filenumber |
| CUSTPONUM |
String |
25 |
|
|
AR CUSTPONUM |
| FAXPRT |
Boolean |
1 |
|
|
AR FAXPRT |
| EMAILPRT |
Boolean |
1 |
|
|
AR EMAILPRT |
| FAX |
String |
15 |
|
|
AR FAX |
| AREAFAX |
String |
10 |
|
|
AR AREAFAX |
| NOTES |
String |
4 |
|
|
AR NOTES |
| CONTACT |
String |
20 |
|
|
AR CONTACT |
| EMAIL |
String |
40 |
|
|
AR EMAIL |
| REPCODE |
String |
5 |
|
|
AR REPCODE |
| LASTPYMNT |
DateTime |
8 |
|
|
AR LASTPYMNT |
| DIVISION |
String |
3 |
|
|
AR DIVISION |