Back
Sales Order (SO) - SOSHPORD
| Name |
Type |
Length |
Decimal |
Relation |
Description |
| ORDNUM |
String |
8 |
|
|
SO ORDNUM |
| NUMBER |
String |
10 |
|
|
SO NUMBER |
| TIME |
String |
7 |
|
|
SO TIME |
| ORDTYPE |
String |
1 |
|
|
SO ORDTYPE |
| INBATCH |
String |
6 |
|
|
SO INBATCH |
| ORIGIN |
String |
1 |
|
|
SO ORIGIN |
| REPORDNUM |
String |
8 |
|
|
SO REPORDNUM |
| ORIGORDNUM |
String |
8 |
|
|
SO 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 |
| CONCODE |
String |
5 |
|
|
SO CONCODE |
| CONTACT |
String |
30 |
|
|
SO CONTACT |
| CRED1OR2 |
String |
1 |
|
|
SO CRED1OR2 |
| CREDCARD |
String |
4 |
|
|
SO CREDCARD |
| CREDDATE |
String |
10 |
|
|
SO CREDDATE |
| CREDNUM |
String |
22 |
|
|
SO CREDNUM |
| CREDLINE1 |
String |
30 |
|
|
SO CREDLINE1 |
| CREDLINE2 |
String |
30 |
|
|
SO 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 SHIPPHONE |
| DIVISION |
String |
3 |
|
|
SO DIVISION |
| STATUS |
String |
1 |
|
|
SO STATUS |
| CUSTPONUM |
String |
25 |
|
|
SO CUSTPONUM |
| SHIPVIA |
String |
15 |
|
|
SO SHIPVIA |
| ZONE |
String |
5 |
|
|
SO ZONE |
| FOB |
String |
15 |
|
|
SO FOB |
| WHNUM |
String |
8 |
|
|
SO WHNUM |
| TERMCODE |
String |
2 |
|
|
SO TERMCODE |
| INVTYPE |
String |
2 |
|
|
SO INVTYPE |
| SLPCODE |
String |
5 |
|
|
SO SLPCODE |
| SLP1 |
String |
5 |
|
|
SO SLP1 |
| SLP2 |
String |
5 |
|
|
SO SLP2 |
| SLP3 |
String |
5 |
|
|
SO SLP3 |
| SLP4 |
String |
5 |
|
|
SO SLP4 |
| TCODE_1 |
String |
3 |
|
|
SO TCODE_1 |
| TCODE_2 |
String |
3 |
|
|
SO TCODE_2 |
| TCODE_3 |
String |
3 |
|
|
SO TCODE_3 |
| FRE_TAX |
String |
1 |
|
|
SO FRE_TAX |
| CATCODE |
String |
3 |
|
|
SO CATCODE |
| AROVERRIDE |
String |
12 |
|
|
SO AROVERRIDE |
| FREACCT |
String |
12 |
|
|
SO FREACCT |
| MISACCT |
String |
12 |
|
|
SO MISACCT |
| TAXACCT |
String |
12 |
|
|
SO TAXACCT |
| DISCACCT |
String |
12 |
|
|
SO DISCACCT |
| ARCUST |
String |
10 |
|
|
SO ARCUST |
| USERID |
String |
4 |
|
|
SO USERID |
| OVERFRT |
Boolean |
1 |
|
|
SO OVERFRT |
| OVERWGT |
Boolean |
1 |
|
|
SO OVERWGT |
| OVERDISC |
Boolean |
1 |
|
|
SO OVERDISC |
| OVERTAX |
Boolean |
1 |
|
|
SO OVERTAX |
| ORDDATE |
DateTime |
8 |
|
|
SO ORDDATE |
| INVDATE |
DateTime |
8 |
|
|
SO INVDATE |
| DUEDATE |
DateTime |
8 |
|
|
SO DUEDATE |
| DISCDUE |
DateTime |
8 |
|
|
SO DISCDUE |
| REVDATE |
DateTime |
8 |
|
|
SO REVDATE |
| ORDDUEDATE |
DateTime |
8 |
|
|
SO ORDDUEDATE |
| 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 |
| FTOTALCOMM |
Decimal |
12 |
2 |
|
SO FTOTALCOMM |
| TOTALCOMM |
Decimal |
12 |
2 |
|
SO TOTALCOMM |
| FSUBTOCOMM |
Decimal |
12 |
2 |
|
SO FSUBTOCOMM |
| SUBTOCOMM |
Decimal |
12 |
2 |
|
SO SUBTOCOMM |
| COSTCOMM |
Decimal |
12 |
2 |
|
SO COSTCOMM |
| FCOSTCOMM |
Decimal |
12 |
2 |
|
SO FCOSTCOMM |
| INVTOT |
Decimal |
12 |
2 |
|
SO INVTOT |
| FINVTOT |
Decimal |
12 |
2 |
|
SO FINVTOT |
| ORDTOT |
Decimal |
12 |
2 |
|
SO ORDTOT |
| FORDTOT |
Decimal |
12 |
2 |
|
SO 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 DEPOSIT |
| FDEPOSIT |
Decimal |
8 |
2 |
|
SO FDEPOSIT |
| SUBTODISC |
Decimal |
12 |
2 |
|
SO SUBTODISC |
| FSUBTODISC |
Decimal |
12 |
2 |
|
SO FSUBTODISC |
| SLPCOMM |
Decimal |
5 |
2 |
|
SO SLPCOMM |
| SLPCOMM1 |
Decimal |
5 |
2 |
|
SO SLPCOMM1 |
| SLPCOMM2 |
Decimal |
5 |
2 |
|
SO SLPCOMM2 |
| SLPCOMM3 |
Decimal |
5 |
2 |
|
SO SLPCOMM3 |
| SLPCOMM4 |
Decimal |
5 |
2 |
|
SO SLPCOMM4 |
| COMMTOT |
Decimal |
9 |
3 |
|
SO COMMTOT |
| FCOMMTOT |
Decimal |
9 |
3 |
|
SO FCOMMTOT |
| COMMTOT1 |
Decimal |
9 |
3 |
|
SO COMMTOT1 |
| FCOMMTOT1 |
Decimal |
9 |
3 |
|
SO FCOMMTOT1 |
| COMMTOT2 |
Decimal |
9 |
3 |
|
SO COMMTOT2 |
| FCOMMTOT2 |
Decimal |
9 |
3 |
|
SO FCOMMTOT2 |
| COMMTOT3 |
Decimal |
9 |
3 |
|
SO COMMTOT3 |
| FCOMMTOT3 |
Decimal |
9 |
3 |
|
SO FCOMMTOT3 |
| COMMTOT4 |
Decimal |
9 |
3 |
|
SO COMMTOT4 |
| FCOMMTOT4 |
Decimal |
9 |
3 |
|
SO FCOMMTOT4 |
| DISCAMT |
Decimal |
8 |
2 |
|
SO DISCAMT |
| FDISCAMT |
Decimal |
8 |
2 |
|
SO FDISCAMT |
| SLPPERC |
Decimal |
6 |
2 |
|
SO SLPPERC |
| SLPPERC1 |
Decimal |
6 |
2 |
|
SO SLPPERC1 |
| SLPPERC2 |
Decimal |
6 |
2 |
|
SO SLPPERC2 |
| SLPPERC3 |
Decimal |
6 |
2 |
|
SO SLPPERC3 |
| SLPPERC4 |
Decimal |
6 |
2 |
|
SO SLPPERC4 |
| WEIGHT |
Decimal |
8 |
2 |
|
SO WEIGHT |
| NUMLABELS |
Int32 |
4 |
|
|
SO NUMLABELS |
| SHIPAREA |
String |
10 |
|
|
SO SHIPAREA |
| PREPAYNUM |
String |
12 |
|
|
SO PREPAYNUM |
| CLIENTREF |
String |
30 |
|
|
SO CLIENTREF |
| DELDATE |
DateTime |
8 |
|
|
SO DELDATE |
| EMAIL |
String |
40 |
|
|
SO EMAIL |
| FAX |
String |
15 |
|
|
SO FAX |
| AREAFAX |
String |
10 |
|
|
SO AREAFAX |
| NOTES |
String |
4 |
|
|
SO NOTES |
| FAXPRT |
Boolean |
1 |
|
|
SO FAXPRT |
| EMAILPRT |
Boolean |
1 |
|
|
SO EMAILPRT |
| CANCELDATE |
DateTime |
8 |
|
|
SO CANCELDATE |
| REPCODE |
String |
5 |
|
|
SO REPCODE |
| PALM_SO |
String |
20 |
|
|
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 |
| SLPCOMMOR |
Decimal |
5 |
2 |
|
SO SLPCOMMOR |
| RELEASED |
DateTime |
8 |
|
|
SO RELEASED |
| CHANGE |
Decimal |
10 |
2 |
|
SO CHANGE |
| EXEMPTTAX |
Boolean |
1 |
|
|
SO EXEMPTTAX |
| CHANNEL |
String |
5 |
|
|
SO CHANNEL |
| TRACKINGNO |
String |
40 |
|
|
SO TRACKINGNO |
| BOLCOMMENT |
String |
4 |
|
|
SO BOLCOMMENT |
| SHIPREF |
String |
30 |
|
|
SO SHIPREF |
| PRICELEVEL |
String |
1 |
|
|
SO PRICELEVEL |
| 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 |
| TAGNO |
String |
15 |
|
|
SO TAGNO |
| WORKORDER |
String |
10 |
|
|
SO WORKORDER |
| CONTAINER |
String |
15 |
|
|
SO CONTAINER |
| 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 |