Aggregated Customer Demand

Internal Table Name: CustomerDailyDemand

This table shows aggregated demand for customer-product pairs from the Demand table. If the customer-product pair has demand profile override in User-Defined Customer Demand Profile in a specific period, demand during that period will not be written to the Aggregated Customer Demand table.

If you have defined a Start Date and/or End Date in the Products table, this lifetime is not reflected in the Aggregated Customer Demand.

Scenario

Table: CustomerDailyDemand

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

The scenario for which the output data was generated.

Customer Name

Table: CustomerDailyDemand

Internal Name: SITE

The name of the Customer at which the demand occurs.

Product Name

Table: CustomerDailyDemand

Internal Name: PRODUCT

The name of the product demanded at the Customer.

Date

Table: CustomerDailyDemand

Internal Name: TIME

The date on which the demand occurs or the date into which the demand is aggregated. The aggregation level determines this date.

• Daily Demand – Date that demand occurs;
• Weekly Demand – Date for the Sunday of the week in which the demand occurs;
• Monthly Demand – The first day of the month in which the demand occurs.

Aggregated Demand

Table: CustomerDailyDemand

Internal Name: VALUE

The non-zero aggregated demand for the specified aggregation level.

Outlier

Table: CustomerDailyDemand

Internal Name: Outlier

Identifies whether the aggregated demand is an outlier or not. This field displays “True” if the aggregated demand is an outlier.

Adjusted Demand

Table: CustomerDailyDemand

Internal Name: AdjustedDemand

The value that replaces the Outlier if the Replace with Non-Zero Demand Mean option is selected for outlier handling.

Potential Revenue

Table: CustomerDailyDemand

Internal Name: PotentialRevenue

The possible revenue based on Aggregated Demand * Product.Unit Price.

Note: Unit Price Override from Customer Orders and Customer Demand will be supported in future.

Replication

Table: CustomerDailyDemand

Internal Name: REP

The replication number used when the aggregated demand was populated.

Scenario ID

Table: CustomerDailyDemand

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: CustomerDailyDemand

Internal Name: StepNumber

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