Name | Data Type | Required | Description |
BaseScenario* | nvarchar(255) | True | BaseScenario Name |
OrderID* | nvarchar(100) | True | Order ID |
SKU** | nvarchar(255) | True | SKU, which must be found in the SKUS table. |
OrderLineID* | nvarchar(100) | True | A unique identifier for each line within an Order. |
Quantity | decimal(19,4) | True | The quantity requested for the SKU on this OrderLineID |
QuantityUOM | nvarchar(10) | True | Quantity UOM (i.e. PLTS, CASES, etc) |
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