| Name | Description | Type | Additional information |
|---|---|---|---|
| SOPTYPE | integer |
None. |
|
| sopnumbe1 | string |
None. |
|
| sopnumbe2 | string |
None. |
|
| CSTPONBR1 | string |
None. |
|
| CSTPONBR2 | string |
None. |
|
| COMMENT2 | string |
None. |
|
| driver | string |
None. |
|
| order_date | date |
None. |
|
| ship_date | date |
None. |
|
| trailer_num | string |
None. |
|
| order_LOCNCODE | string |
None. |
|
| actual_LOCNCODE | string |
None. |
|
| CUSTNMBR | string |
None. |
|
| CUSTNAME | string |
None. |
|
| SOPNUMBE | string |
None. |
|
| bill_to_add1 | string |
None. |
|
| bill_to_add2 | string |
None. |
|
| bill_to_csz | string |
None. |
|
| ship_to_add1 | string |
None. |
|
| ship_to_add2 | string |
None. |
|
| ship_to_csz | string |
None. |
|
| ship_to_phone | string |
None. |
|
| DEXROWID | integer |
None. |
|
| SHIPMTHD | string |
None. |
|
| ITEMNMBR | string |
None. |
|
| ITEMDESC | string |
None. |
|
| actual_qty_shipped | decimal number |
None. |
|
| UOFM | string |
None. |
|
| stop_num | integer |
None. |
|
| CSTPONBR | string |
None. |
|
| license | string |
None. |
|
| exp_date | date |
None. |
|
| date_desc | string |
None. |
|
| SLPRSNID | string |
None. |
|
| salesman_name | string |
None. |
|
| haz | string |
None. |
|
| haz_comment | string |
None. |
|
| payment_terms | string |
None. |
|
| address_delivery_instructions | string |
None. |
|
| hoppers | string |
None. |