| Name |
Type |
Length |
Decimal |
Relation |
Description |
| ORDNUM |
String |
8 |
|
|
PO ORDNUM |
| VENDNUM |
String |
10 |
|
|
PO VENDNUM |
| TIME |
String |
7 |
|
|
PO TIME |
| ORDTYPE |
String |
1 |
|
|
PO ORDTYPE |
| ORIGIN |
String |
1 |
|
|
PO ORIGIN |
| REPORDNUM |
String |
8 |
|
|
PO REPORDNUM |
| ORIGORDNUM |
String |
8 |
|
|
PO ORIGORDNUM |
| INVNUM |
String |
20 |
|
|
PO INVNUM |
| INBATCH |
String |
6 |
|
|
PO INBATCH |
| NAME |
String |
30 |
|
|
PO NAME |
| ADDRESS1 |
String |
30 |
|
|
PO ADDRESS1 |
| ADDRESS2 |
String |
30 |
|
|
PO ADDRESS2 |
| CITY |
String |
20 |
|
|
PO CITY |
| STATE |
String |
10 |
|
|
PO STATE |
| ZIP |
String |
10 |
|
|
PO ZIP |
| CONTACT |
String |
30 |
|
|
PO CONTACT |
| COUNTRY |
String |
20 |
|
|
PO COUNTRY |
| SHIPCODE |
String |
5 |
|
|
PO SHIPCODE |
| SHIPNAME |
String |
30 |
|
|
PO SHIPNAME |
| SHIPADD1 |
String |
30 |
|
|
PO SHIPADD1 |
| SHIPADD2 |
String |
30 |
|
|
PO SHIPADD2 |
| SHIPCITY |
String |
20 |
|
|
PO SHIPCITY |
| SHIPST |
String |
10 |
|
|
PO SHIPST |
| SHIPZIP |
String |
10 |
|
|
PO SHIPZIP |
| SHIPCTRY |
String |
20 |
|
|
PO SHIPCTRY |
| SHIPPHONE |
String |
20 |
|
|
PO SHIPPHONE |
| STATUS |
String |
1 |
|
|
PO STATUS |
| WHNUM |
String |
8 |
|
|
PO WHNUM |
| SHIPVIA |
String |
15 |
|
|
PO SHIPVIA |
| FOB |
String |
15 |
|
|
PO FOB |
| TERMCODE |
String |
2 |
|
|
PO TERMCODE |
| INVTYPE |
String |
2 |
|
|
PO INVTYPE |
| PRTSTATUS |
String |
1 |
|
|
PO ORD R HEADER PRTSTATUS - Indicates if the purchase order should be printed |
| UPDSTATUS |
String |
1 |
|
|
PO ORD R HEADER UPDSTATUS - Indicates if the receipt or invoice should be updated. |
| USERID |
String |
4 |
|
|
PO USERID |
| FORM1099 |
String |
1 |
|
|
PO FORM1099 |
| BOX1099 |
String |
2 |
|
|
PO BOX1099 |
| UPDATED |
Boolean |
1 |
|
|
PO ORD R HEADER UPDATED - Indicates if the purchase order has been received or invoiced. |
| OVERDISC |
Boolean |
1 |
|
|
PO ORD R HEADER OVERDISC - ** not currently used ** |
| HLDSTATUS |
Boolean |
1 |
|
|
PO ORD R HEADER HLDSTATUS - Set to true to place the invoice on hold. |
| POCLOSED |
Boolean |
1 |
|
|
PO ORD R HEADER POCLOSED - ** not currently used ** |
| RCPTCLOSED |
Boolean |
1 |
|
|
PO ORD R HEADER RCPTCLOSED - ** not currently used ** |
| ORDDATE |
DateTime |
8 |
|
|
PO ORDDATE |
| INVDATE |
DateTime |
8 |
|
|
PO INVDATE |
| DUEDATE |
DateTime |
8 |
|
|
PO DUEDATE |
| REQDATE |
DateTime |
8 |
|
|
PO REQDATE |
| POSTDATE |
DateTime |
8 |
|
|
PO POSTDATE |
| DISCDATE |
DateTime |
8 |
|
|
PO DISCDATE |
| COMMENT |
String |
4 |
|
|
PO COMMENT |
| DISCPERC |
Decimal |
6 |
3 |
|
PO DISCPERC |
| TAX_RATE |
Decimal |
6 |
3 |
|
PO TAX_RATE |
| FTAX_RATE |
Decimal |
6 |
3 |
|
PO FTAX_RATE |
| TAX |
Decimal |
8 |
2 |
|
PO TAX |
| FTAX |
Decimal |
8 |
2 |
|
PO FTAX |
| NTAXTOT |
Decimal |
11 |
2 |
|
PO NTAXTOT |
| FNTAXTOT |
Decimal |
11 |
2 |
|
PO FNTAXTOT |
| TAXTOT |
Decimal |
11 |
2 |
|
PO TAXTOT |
| FTAXTOT |
Decimal |
11 |
2 |
|
PO FTAXTOT |
| INVTOT |
Decimal |
12 |
2 |
|
PO INVTOT |
| FINVTOT |
Decimal |
12 |
2 |
|
PO FINVTOT |
| ORDTOT |
Decimal |
12 |
2 |
|
PO ORDTOT |
| FORDTOT |
Decimal |
12 |
2 |
|
PO FORDTOT |
| FREIGHT |
Decimal |
8 |
2 |
|
PO FREIGHT |
| FFREIGHT |
Decimal |
8 |
2 |
|
PO FFREIGHT |
| MISC |
Decimal |
8 |
2 |
|
PO MISC |
| FMISC |
Decimal |
8 |
2 |
|
PO FMISC |
| FDISCAMT |
Decimal |
8 |
2 |
|
PO FDISCAMT |
| DISCAMT |
Decimal |
8 |
2 |
|
PO DISCAMT |
| FSUBTODISC |
Decimal |
8 |
2 |
|
PO FSUBTODISC |
| SUBTODISC |
Decimal |
8 |
2 |
|
PO SUBTODISC |
| SHPCONTACT |
String |
20 |
|
|
PO SHPCONTACT |
| FAXPRT |
Boolean |
1 |
|
|
POORDEHT FAXPRT - Faxprt |
| EMAILPRT |
Boolean |
1 |
|
|
POORDEHT EMAILPRT - Emailprt |
| EMAIL |
String |
40 |
|
|
PO EMAIL |
| FAX |
String |
15 |
|
|
PO FAX |
| AREAFAX |
String |
10 |
|
|
PO AREAFAX |
| NOTES |
String |
4 |
|
|
PO NOTES |
| TOTWEIGHT |
Decimal |
9 |
4 |
|
POORDEHT TOTWEIGHT - Totweight |
| TOTVOLUME |
Decimal |
9 |
4 |
|
POORDEHT TOTVOLUME - Totvolume |
| CANCELDATE |
DateTime |
8 |
|
|
PO CANCELDATE |
| PACKDATE |
DateTime |
8 |
|
|
PO PACKDATE |
| SHIPDATE |
DateTime |
8 |
|
|
PO SHIPDATE |
| ETADATE |
DateTime |
8 |
|
|
PO ETADATE |
| BROKER |
Decimal |
8 |
2 |
|
PO BROKER |
| FBROKER |
Decimal |
8 |
2 |
|
PO FBROKER |
| TOTVOLORD |
Decimal |
9 |
4 |
|
PO TOTVOLORD |
| TOTPIECES |
Decimal |
12 |
4 |
|
PO TOTPIECES |
| XCHGRATE |
Decimal |
12 |
6 |
|
PO XCHGRATE |
| CURCODE |
String |
3 |
|
|
PO CURCODE |
| TAXABLE |
Int32 |
4 |
|
|
PO TAXABLE |
| TAXAMT |
Decimal |
10 |
2 |
|
PO TAXAMT |
| NETID |
String |
25 |
|
|
PO NETID |
| PONUM |
String |
35 |
|
|
PO PONUM |
| SOURCE |
String |
5 |
|
|
PO SOURCE |
| NUMBER |
String |
10 |
|
|
PO NUMBER |
| CUSTPAYFRT |
Boolean |
1 |
|
|
PO CUSTPAYFRT |
| DEPOSIT |
Decimal |
10 |
2 |
|
PO DEPOSIT |
| FDEPOSIT |
Decimal |
10 |
2 |
|
PO FDEPOSIT |
| BALANCE |
Decimal |
10 |
2 |
|
PO BALANCE |
| BILLTOVEND |
String |
10 |
|
|
PO BILLTOVEND |
| RECEIPTBIN |
String |
10 |
|
|
PO RECEIPTBIN |
| CUSTOMAMT |
Decimal |
8 |
2 |
|
PO CUSTOMAMT |
| FCUSTOMAMT |
Decimal |
8 |
2 |
|
PO FCUSTOMAMT |
| PROCSTATUS |
String |
2 |
|
|
PO PROCSTATUS |
| PROCDATE |
DateTime |
8 |
|
|
PO PROCDATE |
| PROCTIME |
String |
7 |
|
|
PO PROCTIME |