| Name | Description | Type | Additional information |
|---|---|---|---|
| SalesOrderID |
Unique identifier of a Sales Order |
integer |
None. |
| SalesOrder |
The Sales Order number |
string |
None. |
| Reference |
The reference |
string |
None. |
| StatusID | integer |
None. |
|
| FromLocationID |
The ship from location associated with the Sales Order |
integer |
None. |
| ToLocationID |
The ship to location associated with the Sales Order |
integer |
None. |
| CarrierID |
The carrier associated with the Sales Order |
integer |
None. |
| ShipmentTypeID |
The carrier associated with the Sales Order |
integer |
None. |
| CustomerPurchaseOrder |
The customer purchase order associated with the Sales Order |
string |
None. |
| SalesRep1 |
The sales rep 1 associated with the Sales Order |
string |
None. |
| SalesRep2 |
The sales rep 2 associated with the Sales Order |
string |
None. |
| Client |
The client associated with the Sales Order |
string |
None. |
| OrderDate |
The Order date |
date |
None. |
| CustomerOrderDate |
The Customer Order date |
date |
None. |
| PlannedShipDate |
The Planned Ship Date |
date |
None. |
| ExpectedDeliveryDate |
The Expected Delivery Date |
date |
None. |
| ActualDeliveryDate |
The Actual Delivery Date |
date |
None. |
| FreightTerm | string |
None. |
|
| Notes | string |
None. |