Changes related to Customer Allocations

Customer Allocations model has been modified to source the data from these SCV Core tables in addition to the previously used table SC_ITEM_SALES:

• SC_ITEM_NPI
• SC_ITEM_CUSTOMER
• SC_DEMAND_PLAN_AGGR

The SP_V_CUSTOMER_ALLOCATIONS view has been updated to use the above-mentioned tables as source.

The mapping logic in the view has been altered as follows:

• These tables are now used as data source in the specified order:
  1. ITEM_SALES
  2. ITEM_NPI
  3. ITEM_CUSTOMER
  4. DEMAND_PLAN_AGGR
  5. Default value from ITEM_LOCATION
  6. Hard coded default value
• These calculations are now applied to determine column values:
  1. sell_price = AVG
  2. min_service_level = MIN
  3. demand_time_fence = MAX
  4. backlog_allowed_flag = When any of the underlying records = Y, then 1 else 0
• Only the records in ITEM_SALES and ITEM_CUSTOMER are considered where use_in_planning_flag = 'Y'