Build Diff Ratios Based on Sales History (dfrtbld)
Module Name |
dfrtbld.pc |
Description |
Build Diff Ratios Based on Sales History |
Functional Area |
Foundation Data |
Module Type |
Business Processing |
Module Technology |
ProC |
Catalog ID |
RM S214 |
Wrapper Script |
rmswrap_multi_out.ksh |
Design Overview
Diff ratios are used by Merchandising as a way to assign a ratio to a group of diffs or diff combinations based on sales history. The parameters for how these are created are setup online in Merchandising and include specifying a subclass and one or more diff groups for a particular date range. Users also specify how often the ratios should be refreshed and what types of sales should be considered, regular, promotional and/or clearance.
For ratios that are due to be rebuilt, this batch program uses this information and summarizes the total sales for items with the subclass and diff groups selected. It then calculates a percent to each diff combination/store. Diff ratios are used for PO distribution within Merchandising.
I/O Specification
This batch will create a comma delimited output data file for sql loader to upload data to table DIFF_RATIO_DETAIL. The control script for the sql loader is dfrtbld.ctl.