Site Demand Series

Internal Table Name: FacilityDemandSeries

If you use historical demand when running Inventory Simulation, Safety Stock Optimization must first be run with the "Populate Site Demand Series" check box selected in Safety Stock Options. When this option is checked, Safety Stock Optimization populates the Facilities Demand Series table for all sites: both customer-facing and non customer-facing.

If you want to populate the Site Demand Series, your Facilities Propagation method must be “Demand Series”. If this option is set to “Formula”, the Site Demand Series table will not be populated.

Scenario

Table: FacilityDemandSeries

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the output data was generated.

Site Name

Table: FacilityDemandSeries

Internal Name: SiteName

The site at which the demand was handled.

Product Name

Table: FacilityDemandSeries

Internal Name: ProductName

The name of the demanded product at the site.

Demand Date

Table: FacilityDemandSeries

Internal Name: DemandDate

The date on which the demand occurred.

Quantity

Table: FacilityDemandSeries

Internal Name: Quantity

The quantity of product at the site on the demand date.

Scenario ID

Table: FacilityDemandSeries

Internal Name: ScenarioID

The identifier of the scenario for which the summary data was generated.

Sub-Scenario ID

Table: FacilityDemandSeries

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the summary data was generated.

Last modified: Wednesday May 15, 2024

Is this useful?