This is the table that contains all of the customer demand but only contains the OrderID, order date and due date. The details of which SKUs and how many are requested is contained in the CustomerOrderLines Table.
Name | Data Type | Required | Description |
BaseScenario* | nvarchar(255) | True | BaseScenario Name |
OrderID* | nvarchar(100) | True | Order ID |
Customer** | nvarchar(255) | True | Customer Name, which must be found in the Customers table. |
OrderDate | DateTime | True | The date that the order is received and the order fulfillment logic begins. |
DueDate | DateTime | False | The date that the order is due to the customer (including consideration for travel time). If null, it is assumed the DueDate is the EndDate of the simulation run |
Notes | nvarchar(255) | False |
|
SolverInclude | nvarchar(5) | True | Value of "yes" will be included by the Simulation engine. "No" will be ignored |
*Primary Key
**Foreign Key