| Name |
Type |
Length |
Decimal |
Relation |
Description |
| ORDNUM |
String |
8 |
|
|
SO ORDER ENTRY HEADER ORDNUM - Ordnum |
| NUMBER |
String |
10 |
|
|
SO NUMBER |
| ORDDATE |
DateTime |
8 |
|
|
SO ORDER ENTRY HEADER ORDDATE - Orddate |
| TIME |
String |
7 |
|
|
SO ORDER ENTRY HEADER TIME - Time |
| ORDTYPE |
String |
1 |
|
|
SO ORDER ENTRY HEADER ORDTYPE - Ordtype |
| ORIGIN |
String |
1 |
|
|
SO ORDER ENTRY HEADER ORIGIN - Origin |
| REPORDNUM |
String |
8 |
|
|
SO ORDER ENTRY HEADER REPORDNUM - Repordnum |
| ORIGORDNUM |
String |
8 |
|
|
SO ORDER ENTRY HEADER ORIGORDNU - Origordnum |
| INVNUM |
String |
12 |
|
|
SO INVNUM |
| NAME |
String |
30 |
|
|
SO NAME |
| ADDRESS1 |
String |
40 |
|
|
SO ADDRESS1 |
| ADDRESS2 |
String |
40 |
|
|
SO ADDRESS2 |
| CITY |
String |
20 |
|
|
SO CITY |
| STATE |
String |
10 |
|
|
SO STATE |
| ZIP |
String |
10 |
|
|
SO ZIP |
| COUNTRY |
String |
30 |
|
|
SO COUNTRY |
| CONTACT |
String |
30 |
|
|
SO CONTACT |
| CRED1OR2 |
String |
1 |
|
|
SO ORDER ENTRY HEADER CRED1OR2 - Cred1or2 |
| CREDCARD |
String |
4 |
|
|
SO ORDER ENTRY HEADER CREDCARD - Credcard |
| CREDDATE |
String |
10 |
|
|
SO ORDER ENTRY HEADER CREDDATE - Creddate |
| CREDNUM |
String |
22 |
|
|
SO ORDER ENTRY HEADER CREDNUM - Crednum |
| CREDLINE1 |
String |
30 |
|
|
SO ORDER ENTRY HEADER CREDLINE1 - Credline1 |
| CREDLINE2 |
String |
30 |
|
|
SO ORDER ENTRY HEADER CREDLINE2 - Credline2 |
| SHIPCODE |
String |
5 |
|
|
SO SHIPCODE |
| SHIPNAME |
String |
30 |
|
|
SO SHIPNAME |
| SHIPADD1 |
String |
40 |
|
|
SO SHIPADD1 |
| SHIPADD2 |
String |
40 |
|
|
SO SHIPADD2 |
| SHIPCITY |
String |
20 |
|
|
SO SHIPCITY |
| SHIPST |
String |
10 |
|
|
SO SHIPST |
| SHIPZIP |
String |
10 |
|
|
SO SHIPZIP |
| SHIPCTRY |
String |
30 |
|
|
SO SHIPCTRY |
| SHIPPHONE |
String |
10 |
|
|
SO ORDER ENTRY HEADER SHIPPHONE - Shipphone |
| STATUS |
String |
1 |
|
|
SO ORDER ENTRY HEADER STATUS - Status |
| CUSTPONUM |
String |
25 |
|
|
SO ORDER ENTRY HEADER CUSTPONUM - Custponum |
| SHIPVIA |
String |
15 |
|
|
SO ORDER ENTRY HEADER SHIPVIA - Shipvia |
| ZONE |
String |
5 |
|
|
SO ORDER ENTRY HEADER ZONE - Zone |
| FOB |
String |
15 |
|
|
SO ORDER ENTRY HEADER FOB - Fob |
| WHNUM |
String |
8 |
|
|
SO ORDER ENTRY HEADER WHNUM - Whnum |
| TERMCODE |
String |
2 |
|
|
SO TERMCODE |
| INVTYPE |
String |
2 |
|
|
SO INVTYPE |
| SLPCODE |
String |
5 |
|
|
SO SLPCODE |
| SLP1 |
String |
5 |
|
|
SO ORDER ENTRY HEADER SLP1 - Slp1 |
| SLP2 |
String |
5 |
|
|
SO ORDER ENTRY HEADER SLP2 - Slp2 |
| SLP3 |
String |
5 |
|
|
SO ORDER ENTRY HEADER SLP3 - Slp3 |
| SLP4 |
String |
5 |
|
|
SO ORDER ENTRY HEADER SLP4 - Slp4 |
| TCODE_1 |
String |
3 |
|
|
SO TCODE_1 |
| TCODE_2 |
String |
3 |
|
|
SO TCODE_2 |
| TCODE_3 |
String |
3 |
|
|
SO TCODE_3 |
| PRTSTATUS |
String |
1 |
|
|
SO PRTSTATUS |
| SHIPSTATUS |
String |
1 |
|
|
SO ORDER ENTRY HEADER SHIPSTATU - Shipstatus |
| FRE_TAX |
String |
1 |
|
|
SO FRE_TAX |
| CATCODE |
String |
3 |
|
|
SO ORDER ENTRY HEADER CATCODE - Catcode |
| AROVERRIDE |
String |
12 |
|
|
SO AROVERRIDE |
| MISACCT |
String |
12 |
|
|
SO ORDER ENTRY HEADER MISACCT - Misacct |
| TAXACCT |
String |
12 |
|
|
SO ORDER ENTRY HEADER TAXACCT - Taxacct |
| FREACCT |
String |
12 |
|
|
SO ORDER ENTRY HEADER FREACCT - Freacct |
| DISCACCT |
String |
12 |
|
|
SO DISCACCT |
| ARCUST |
String |
10 |
|
|
SO ORDER ENTRY HEADER ARCUST - Arcust |
| USERID |
String |
4 |
|
|
SO USERID |
| OVERFRT |
Boolean |
1 |
|
|
SO ORDER ENTRY HEADER OVERFRT - Overfrt |
| OVERWGT |
Boolean |
1 |
|
|
SO ORDER ENTRY HEADER OVERWGT - Overwgt |
| OVERDISC |
Boolean |
1 |
|
|
SO ORDER ENTRY HEADER OVERDISC - Overdisc |
| OVERTAX |
Boolean |
1 |
|
|
SO ORDER ENTRY HEADER OVERTAX - Overtax |
| INVDATE |
DateTime |
8 |
|
|
SO INVDATE |
| DUEDATE |
DateTime |
8 |
|
|
SO DUEDATE |
| DISCDUE |
DateTime |
8 |
|
|
SO DISCDUE |
| COMMENT |
String |
4 |
|
|
SO COMMENT |
| TAX_RATE |
Decimal |
6 |
3 |
|
SO TAX_RATE |
| DISCPERC |
Decimal |
5 |
3 |
|
SO DISCPERC |
| TAX |
Decimal |
8 |
2 |
|
SO TAX |
| FTAX |
Decimal |
8 |
2 |
|
SO FTAX |
| NTAXTOT |
Decimal |
11 |
2 |
|
SO NTAXTOT |
| FNTAXTOT |
Decimal |
11 |
2 |
|
SO FNTAXTOT |
| TAXTOT |
Decimal |
11 |
2 |
|
SO TAXTOT |
| FTAXTOT |
Decimal |
11 |
2 |
|
SO FTAXTOT |
| SUBTOCOMM |
Decimal |
11 |
2 |
|
SO ORDER ENTRY HEADER SUBTOCOMM - Subtocomm |
| FSUBTOCOMM |
Decimal |
11 |
2 |
|
SO ORDER ENTRY HEADER FSUBTOCOM - Fsubtocomm |
| TOTALCOMM |
Decimal |
11 |
2 |
|
SO ORDER ENTRY HEADER TOTALCOMM - Totalcomm |
| FTOTALCOMM |
Decimal |
11 |
2 |
|
SO ORDER ENTRY HEADER FTOTALCOM - Ftotalcomm |
| INVTOT |
Decimal |
12 |
2 |
|
SO INVTOT |
| FINVTOT |
Decimal |
12 |
2 |
|
SO FINVTOT |
| ORDTOT |
Decimal |
12 |
2 |
|
SO ORDER ENTRY HEADER ORDTOT - Ordtot |
| FORDTOT |
Decimal |
12 |
2 |
|
SO ORDER ENTRY HEADER FORDTOT - Fordtot |
| FREIGHT |
Decimal |
8 |
2 |
|
SO FREIGHT |
| FFREIGHT |
Decimal |
8 |
2 |
|
SO FFREIGHT |
| MISC |
Decimal |
8 |
2 |
|
SO MISC |
| FMISC |
Decimal |
8 |
2 |
|
SO FMISC |
| DEPOSIT |
Decimal |
8 |
2 |
|
SO ORDER ENTRY HEADER DEPOSIT - Deposit |
| FDEPOSIT |
Decimal |
8 |
2 |
|
SO ORDER ENTRY HEADER FDEPOSIT - Fdeposit |
| DISCAMT |
Decimal |
8 |
2 |
|
SO ORDER ENTRY HEADER DISCAMT - Discamt |
| FDISCAMT |
Decimal |
8 |
2 |
|
SO ORDER ENTRY HEADER FDISCAMT - Fdiscamt |
| SUBTODISC |
Decimal |
8 |
2 |
|
SO ORDER ENTRY HEADER SUBTODISC - Subtodisc |
| FSUBTODISC |
Decimal |
8 |
2 |
|
SO ORDER ENTRY HEADER FSUBTODIS - Fsubtodisc |
| COSTCOMM |
Decimal |
8 |
2 |
|
SO ORDER ENTRY HEADER COSTCOMM - Costcomm |
| FCOSTCOMM |
Decimal |
8 |
2 |
|
SO ORDER ENTRY HEADER FCOSTCOMM - Fcostcomm |
| SLPCOMM |
Decimal |
5 |
2 |
|
SO SLPCOMM |
| SLPCOMM1 |
Decimal |
5 |
2 |
|
SO ORDER ENTRY HEADER SLPCOMM1 - Slpcomm1 |
| SLPCOMM2 |
Decimal |
5 |
2 |
|
SO ORDER ENTRY HEADER SLPCOMM2 - Slpcomm2 |
| SLPCOMM3 |
Decimal |
5 |
2 |
|
SO ORDER ENTRY HEADER SLPCOMM3 - Slpcomm3 |
| SLPCOMM4 |
Decimal |
5 |
2 |
|
SO ORDER ENTRY HEADER SLPCOMM4 - Slpcomm4 |
| COMMTOT |
Decimal |
9 |
3 |
|
SO COMMTOT |
| FCOMMTOT |
Decimal |
9 |
3 |
|
SO FCOMMTOT |
| COMMTOT1 |
Decimal |
9 |
3 |
|
SO ORDER ENTRY HEADER COMMTOT1 - Commtot1 |
| FCOMMTOT1 |
Decimal |
9 |
3 |
|
SO ORDER ENTRY HEADER FCOMMTOT1 - Fcommtot1 |
| COMMTOT2 |
Decimal |
9 |
3 |
|
SO ORDER ENTRY HEADER COMMTOT2 - Commtot2 |
| FCOMMTOT2 |
Decimal |
9 |
3 |
|
SO ORDER ENTRY HEADER FCOMMTOT2 - Fcommtot2 |
| COMMTOT3 |
Decimal |
9 |
3 |
|
SO ORDER ENTRY HEADER COMMTOT3 - Commtot3 |
| FCOMMTOT3 |
Decimal |
9 |
3 |
|
SO ORDER ENTRY HEADER FCOMMTOT3 - Fcommtot3 |
| COMMTOT4 |
Decimal |
9 |
3 |
|
SO ORDER ENTRY HEADER COMMTOT4 - Commtot4 |
| FCOMMTOT4 |
Decimal |
9 |
3 |
|
SO ORDER ENTRY HEADER FCOMMTOT4 - Fcommtot4 |
| SLPPERC |
Decimal |
6 |
2 |
|
SO SLPPERC |
| SLPPERC1 |
Decimal |
6 |
2 |
|
SO ORDER ENTRY HEADER SLPPERC1 - Slpperc1 |
| SLPPERC2 |
Decimal |
6 |
2 |
|
SO ORDER ENTRY HEADER SLPPERC2 - Slpperc2 |
| SLPPERC3 |
Decimal |
6 |
2 |
|
SO ORDER ENTRY HEADER SLPPERC3 - Slpperc3 |
| SLPPERC4 |
Decimal |
6 |
2 |
|
SO ORDER ENTRY HEADER SLPPERC4 - Slpperc4 |
| WEIGHT |
Decimal |
8 |
2 |
|
SO ORDER ENTRY HEADER WEIGHT - Weight |
| NUMLABELS |
Int32 |
4 |
|
|
SO ORDER ENTRY HEADER NUMLABELS - Numlabels |
| SHIPAREA |
String |
10 |
|
|
SO ORDER ENTRY HEADER SHIPAREA - Shiparea |
| PAYTYPE |
Int32 |
4 |
|
|
SO ORDER ENTRY HEADER PAYTYPE - Paytype |
| PREPAYNUM |
String |
12 |
|
|
SO PREPAYNUM |
| NOAUTOPO |
Boolean |
1 |
|
|
SO ORDER ENTRY HEADER NOAUTOPO - Noautopo |
| INVOICEPRT |
Boolean |
1 |
|
|
SO INVOICEPRT |
| ORDERPRT |
Boolean |
1 |
|
|
SO ORDERPRT |
| PACKPRT |
Boolean |
1 |
|
|
SO PACKPRT |
| DELDATE |
DateTime |
8 |
|
|
SO DELDATE |
| ISPRINTED |
Boolean |
1 |
|
|
SO ISPRINTED |
| FAXPRT |
Boolean |
1 |
|
|
SO FAXPRT |
| EMAILPRT |
Boolean |
1 |
|
|
SO EMAILPRT |
| EMAIL |
String |
40 |
|
|
SO EMAIL |
| FAX |
String |
15 |
|
|
SO FAX |
| AREAFAX |
String |
10 |
|
|
SO AREAFAX |
| NOTES |
String |
4 |
|
|
SO NOTES |
| CREDITHOLD |
Boolean |
1 |
|
|
SO CREDITHOLD |
| CANCELDATE |
DateTime |
8 |
|
|
SO CANCELDATE |
| REPCODE |
String |
5 |
|
|
SO REPCODE |
| SLPCOMMOR |
Decimal |
5 |
2 |
|
SO SLPCOMMOR |
| PALM_SO |
String |
25 |
|
|
SO PALM_SO |
| TRANS_NUM |
String |
25 |
|
|
SO TRANS_NUM |
| STORE_NO |
String |
30 |
|
|
SO STORE_NO |
| DIST_CTR |
String |
14 |
|
|
SO DIST_CTR |
| CROSS_DOCK |
String |
10 |
|
|
SO CROSS_DOCK |
| DEPT_NUM |
String |
40 |
|
|
SO DEPT_NUM |
| SOURCE |
String |
4 |
|
|
SO SOURCE |
| RESIDENCE |
Boolean |
1 |
|
|
SO RESIDENCE |
| DISCDUE2 |
DateTime |
8 |
|
|
SO DISCDUE2 |
| DISCDUE3 |
DateTime |
8 |
|
|
SO DISCDUE3 |
| DISC1 |
Decimal |
5 |
2 |
|
SO DISC1 |
| DISC2 |
Decimal |
5 |
2 |
|
SO DISC2 |
| DISC3 |
Decimal |
5 |
2 |
|
SO DISC3 |
| AGGINVOICE |
Boolean |
1 |
|
|
SO AGGINVOICE |
| AGGINVNUM |
String |
12 |
|
|
SO AGGINVNUM |
| RELEASED |
DateTime |
8 |
|
|
SO RELEASED |
| CHANGE |
Decimal |
10 |
2 |
|
SO CHANGE |
| EXEMPTTAX |
Boolean |
1 |
|
|
SO EXEMPTTAX |
| CHANNEL |
String |
5 |
|
|
SO CHANNEL |
| DIVISION |
String |
3 |
|
|
SO DIVISION |
| TRACKINGNO |
String |
40 |
|
|
SO TRACKINGNO |
| BOLCOMMENT |
String |
4 |
|
|
SO BOLCOMMENT |
| SHIPREF |
String |
30 |
|
|
SO SHIPREF |
| PRICELEVEL |
String |
1 |
|
|
SO PRICELEVEL |
| REQDATE |
DateTime |
8 |
|
|
SO REQDATE |
| ETADATE |
DateTime |
8 |
|
|
SO ETADATE |
| TAXZONE |
String |
9 |
|
|
SO TAXZONE |
| COMTYPE |
String |
1 |
|
|
SO COMTYPE |
| COMPAID |
Int32 |
4 |
|
|
SO COMPAID |
| COMCHGPCNT |
Decimal |
7 |
3 |
|
SO COMCHGPCNT |
| COMCHGDAYS |
Int32 |
4 |
|
|
SO COMCHGDAYS |
| COMCHGWARN |
Int32 |
4 |
|
|
SO COMCHGWARN |
| POSPRESALE |
Boolean |
1 |
|
|
SO POSPRESALE |
| CONSACCT |
String |
20 |
|
|
SO CONSACCT |
| SHIPAYMETH |
String |
1 |
|
|
SO SHIPAYMETH |
| BILLNAME |
String |
30 |
|
|
SO BILLNAME |
| BILLADD2 |
String |
30 |
|
|
SO BILLADD2 |
| BILLADD1 |
String |
30 |
|
|
SO BILLADD1 |
| BILLCITY |
String |
20 |
|
|
SO BILLCITY |
| BILLZIP |
String |
10 |
|
|
SO BILLZIP |
| BILLST |
String |
2 |
|
|
SO BILLST |
| BILLPHONE |
String |
20 |
|
|
SO BILLPHONE |
| TOTGPCOST |
Decimal |
10 |
2 |
|
SO TOTGPCOST |
| TAGNO |
String |
15 |
|
|
SO TAGNO |
| WORKORDER |
String |
10 |
|
|
SO WORKORDER |
| CONTAINER |
String |
15 |
|
|
SO CONTAINER |
| TRNWHNUM |
String |
8 |
|
|
SO TRNWHNUM |
| XCHGRATE |
Decimal |
12 |
6 |
|
SO XCHGRATE |
| CURCODE |
String |
3 |
|
|
SO CURCODE |
| PROCSTATUS |
String |
2 |
|
|
SO PROCSTATUS |
| PROCDATE |
DateTime |
8 |
|
|
SO PROCDATE |
| PROCTIME |
String |
7 |
|
|
SO PROCTIME |