| Name |
Type |
Length |
Decimal |
Relation |
Description |
| INVNUM |
String |
12 |
|
|
AR INVNUM |
| NUMBER |
String |
10 |
|
|
AR NUMBER |
| PREPAYNUM |
String |
12 |
|
|
AR 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 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 |
| PRTSTATUS |
String |
1 |
|
|
AR INVOICE HEADER PRTSTATUS - Prtstatus |
| UPDSTATUS |
String |
1 |
|
|
AR INVOICE HEADER UPDSTATUS - Updstatus |
| FRE_TAX |
String |
1 |
|
|
AR FRE_TAX |
| AROVERRIDE |
String |
12 |
|
|
AR INVOICE HEADER AROVERRIDE - Aroverride |
| USERID |
String |
4 |
|
|
AR USERID |
| INVDATE |
DateTime |
8 |
|
|
AR INVDATE |
| DUEDATE |
DateTime |
8 |
|
|
AR DUEDATE |
| DISCDUE |
DateTime |
8 |
|
|
AR DISCDUE |
| COMMENT |
String |
4 |
|
|
AR COMMENT |
| TAX_RATE |
Decimal |
6 |
3 |
|
AR TAX_RATE |
| FTAX_RATE |
Decimal |
6 |
3 |
|
AR FTAX_RATE |
| TAX |
Decimal |
8 |
2 |
|
AR TAX |
| FTAX |
Decimal |
8 |
2 |
|
AR FTAX |
| NTAXTOT |
Decimal |
11 |
2 |
|
AR NTAXTOT |
| FNTAXTOT |
Decimal |
11 |
2 |
|
AR FNTAXTOT |
| TAXTOT |
Decimal |
11 |
2 |
|
AR TAXTOT |
| FTAXTOT |
Decimal |
11 |
2 |
|
AR FTAXTOT |
| INVTOT |
Decimal |
12 |
2 |
|
AR INVTOT |
| FINVTOT |
Decimal |
12 |
2 |
|
AR FINVTOT |
| FREIGHT |
Decimal |
8 |
2 |
|
AR FREIGHT |
| FFREIGHT |
Decimal |
8 |
2 |
|
AR FFREIGHT |
| MISC |
Decimal |
8 |
2 |
|
AR MISC |
| FMISC |
Decimal |
8 |
2 |
|
AR FMISC |
| SLPCOMM |
Decimal |
5 |
2 |
|
AR SLPCOMM |
| FSLPCOMM |
Decimal |
5 |
2 |
|
AR INVOICE HEADER FSLPCOMM - Fslpcomm |
| COMMTOT |
Decimal |
8 |
2 |
|
AR COMMTOT |
| FCOMMTOT |
Decimal |
8 |
2 |
|
AR FCOMMTOT |
| PREPAYAMT |
Decimal |
12 |
2 |
|
AR PREPAYAMT |
| FPREPAYAMT |
Decimal |
12 |
2 |
|
AR FPREPAYAMT |
| CURRENCY |
String |
3 |
|
|
AR INVOICE HEADER CURRENCY - Currency |
| LOCALEXCHA |
Decimal |
8 |
4 |
|
AR LOCALEXCHA |
| FOREIGNEXC |
Decimal |
8 |
4 |
|
AR FOREIGNEXC |
| FILENUMBER |
String |
5 |
|
|
AR FILENUMBER |
| REPEATREF |
String |
8 |
|
|
AR REPEATREF |
| 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 |
| DIVISION |
String |
3 |
|
|
AR DIVISION |
| TAXZONE |
String |
9 |
|
|
AR TAXZONE |