Customer Sourcing Table (SIM)

BaseScenario*

nvarchar(255)

True

Base Scenario Name

Customer**

nvarchar(255)

True

Customer Name, which must be found in the Customers table

SKU**

nvarchar(255)

False

If empty, all SKUs are assumed

RevenuePerUnit

decimal(9,4)

False

Optional for revenue calculation in output. If the value is specified both here and in the SKUS table, this value will be used

RevenuePerUnitUOM

nvarchar(10)

False

Required if RevenuePerUnit is specified. Options include EA, CASE, PLT

SourcingLogic

nvarchar(255)

True

The sourcing logic used to select the Site to be used for fulfillment. Possible values: ByRanking

Source

nvarchar(255)

True

Site Name, which must be found in the Sites table

SourcingParameter

int

True

Unique number for each Customer/Source or Customer/Source/SKU combination. Used by the SourcingLogic. Lowest value is highest priority

Notes

nvarchar(255)

False

SolverInclude

nvarchar(5)

True

Value of "yes" will be included by the Simulation engine. "No" will be ignored