Back
Sales Order (SO) - SOORDEDA
| Name |
Type |
Length |
Decimal |
Relation |
Description |
| ORDNUM |
String |
8 |
|
|
SO ORDNUM |
| KEYID |
String |
12 |
|
|
SO KEYID |
| LINETYPE |
String |
1 |
|
|
SO LINETYPE |
| WHCODE |
String |
8 |
|
|
SO WHCODE |
| ITEMNUM |
String |
25 |
|
|
SO ITEMNUM |
| DESCRIPT |
String |
40 |
|
|
SO DESCRIPT |
| ACCTNUM |
String |
12 |
|
|
SO ACCTNUM |
| INVACCT |
String |
12 |
|
|
SO INVACCT |
| COSACCT |
String |
12 |
|
|
SO COSACCT |
| TAXABLE |
String |
1 |
|
|
SO TAXABLE |
| COMMABLE |
String |
1 |
|
|
SO COMMABLE |
| BACKORDER |
String |
1 |
|
|
SO BACKORDER |
| DROPSHIP |
String |
1 |
|
|
SO DROPSHIP |
| DISCOUNT |
String |
1 |
|
|
SO DISCOUNT |
| UM |
String |
4 |
|
|
SO UM |
| DISCPERC |
Decimal |
5 |
2 |
|
SO DISCPERC |
| KITNUM |
String |
15 |
|
|
SO KITNUM |
| QTYORD |
Decimal |
12 |
4 |
|
SO QTYORD |
| QTYSHIP |
Decimal |
12 |
4 |
|
SO QTYSHIP |
| QTYBACK |
Decimal |
12 |
4 |
|
SO QTYBACK |
| PERCOST |
Decimal |
10 |
2 |
|
SO PERCOST |
| FPERCOST |
Decimal |
10 |
2 |
|
SO FPERCOST |
| PRICE |
Decimal |
12 |
4 |
|
SO PRICE |
| FPRICE |
Decimal |
12 |
4 |
|
SO FPRICE |
| MESSLINE |
String |
4 |
|
|
SO MESSLINE |
| EXPLODE |
Boolean |
1 |
|
|
SO EXPLODE |
| DISCAMT |
Decimal |
12 |
2 |
|
SO DISCAMT |
| FDISCAMT |
Decimal |
12 |
2 |
|
SO FDISCAMT |
| EXTENSION |
Decimal |
12 |
4 |
|
SO EXTENSION |
| FEXTENSION |
Decimal |
12 |
4 |
|
SO FEXTENSION |
| WEIGHT |
Decimal |
8 |
2 |
|
SO WEIGHT |
| FACTOR |
Decimal |
9 |
4 |
|
SO FACTOR |
| BUILDKIT |
Boolean |
1 |
|
|
SO BUILDKIT |
| PRICECHG |
Boolean |
1 |
|
|
SO PRICECHG |
| ISSPEPRICE |
Boolean |
1 |
|
|
SO ISSPEPRICE |
| REORDERED |
Boolean |
1 |
|
|
SO REORDERED |
| DELDATE |
DateTime |
8 |
|
|
SO DELDATE |
| COMMPCNT |
Decimal |
5 |
2 |
|
SO COMMPCNT |
| COMMPCNTOR |
Decimal |
5 |
2 |
|
SO COMMPCNTOR |
| UPC_NUM |
String |
15 |
|
|
SO UPC_NUM |
| ROYRATE |
Decimal |
9 |
3 |
|
SO ROYRATE |
| ROYPAID |
DateTime |
8 |
|
|
SO ROYPAID |
| ROYAMT |
Decimal |
9 |
2 |
|
SO ROYAMT |
| AUTHCODE |
String |
3 |
|
|
SO AUTHCODE |
| RETURNCODE |
String |
5 |
|
|
SO RETURNCODE |
| TRACKINGNO |
String |
40 |
|
|
SO TRACKINGNO |
| PICKEDUP |
Boolean |
1 |
|
|
SO PICKEDUP |
| BINLOC |
String |
10 |
|
|
SO BINLOC |
| VOLUME |
Decimal |
10 |
3 |
|
SO VOLUME |
| PRICELEVEL |
String |
1 |
|
|
SO PRICELEVEL |
| QTYONWATER |
Decimal |
12 |
4 |
|
SO QTYONWATER |
| FILENUM |
String |
12 |
|
|
SO FILENUM |
| TAXCLASS |
String |
2 |
|
|
SO TAXCLASS |
| ROYMETHOD |
String |
1 |
|
|
SO ROYMETHOD |
| ROYALTYEXP |
String |
12 |
|
|
SO ROYALTYEXP |
| ROYALTYPAY |
String |
12 |
|
|
SO ROYALTYPAY |
| NAMEDROP |
String |
4 |
|
|
SO NAMEDROP |
| CUSTDATE |
String |
18 |
|
|
SO CUSTDATE |
| AUTHCODE2 |
String |
3 |
|
|
SO AUTHCODE2 |
| ROYRATE2 |
Decimal |
9 |
3 |
|
SO ROYRATE2 |
| AUTHCODE3 |
String |
3 |
|
|
SO AUTHCODE3 |
| ROYRATE3 |
Decimal |
9 |
3 |
|
SO ROYRATE3 |
| FINISH |
String |
30 |
|
|
SO FINISH |
| ITEMDIM |
String |
10 |
|
|
SO ITEMDIM |
| PROCSTAT |
String |
2 |
|
|
SO PROCSTAT |
| PROCDATE |
DateTime |
8 |
|
|
SO PROCDATE |
| PROCDESC |
String |
25 |
|
|
SO PROCDESC |