| Name | Description | Type | Additional information |
|---|---|---|---|
| EmpId | integer |
None. |
|
| OrderID | integer |
None. |
|
| Company | string |
None. |
|
| Segment | string |
None. |
|
| Group | string |
None. |
|
| SLPRSNID | string |
None. |
|
| RepName | string |
None. |
|
| DOCDATE | date |
None. |
|
| ReqShipDate | date |
None. |
|
| SOPNUMBE | string |
None. |
|
| CUSTNMBR | string |
None. |
|
| CUSTNAME | string |
None. |
|
| PRSTADCD | string |
None. |
|
| STAdd1 | string |
None. |
|
| STAdd2 | string |
None. |
|
| STCity | string |
None. |
|
| STState | string |
None. |
|
| STZip | string |
None. |
|
| PRBTADCD | string |
None. |
|
| BTAdd1 | string |
None. |
|
| BTAdd2 | string |
None. |
|
| BTCity | string |
None. |
|
| BTState | string |
None. |
|
| BTZip | string |
None. |
|
| SALSTERR | string |
None. |
|
| UPSZONE | string |
None. |
|
| DOCAMNT | decimal number |
None. |
|
| SUBTOTAL | decimal number |
None. |
|
| TAXAMNT | decimal number |
None. |
|
| LOCNCODE | string |
None. |
|
| LOCNCODEAbbrev | string |
None. |
|
| OrderComments | string |
None. |
|
| OrderNotes | string |
None. |
|
| LNITMSEQ | integer |
None. |
|
| LINELOCNCODE | string |
None. |
|
| ITEMNMBR | string |
None. |
|
| ITEMDESC | string |
None. |
|
| UOFM | string |
None. |
|
| QUANTITY | decimal number |
None. |
|
| UNITCOST | decimal number |
None. |
|
| UNITPRCE | decimal number |
None. |
|
| EXTDCOST | decimal number |
None. |
|
| XTNDPRCE | decimal number |
None. |
|
| MarginDollars | decimal number |
None. |
|
| MarginPerc | decimal number |
None. |
|
| NumOrders | integer |
None. |