Monthly Sales History Rollup By Diffs (hstbldmth_diff)
Module Name |
hstbldmth_diff.pc |
Description |
Monthly Sales History Rollup by Diffs |
Functional Area |
Sales History |
Module Type |
Business Processing |
Module Technology |
ProC |
Catalog ID |
RMS242 |
Wrapper Script |
rmswrap.ksh |
Design Overview
The sales history rollup routine will extract sales history information for each ITEM_PARENT from the ITEM_LOC_HIST_MTH table and rolls the data to month level. The history information will be rolled up to the item differentiator level to be written to: item_diff_loc_hist_mth and item_parentloc_hist_mth. For each item, data to be retrieved includes sales quantity and stock. This data must be collected from several tables including ITEM_LOC_HIST_MTH, ITEM_LOC, and ITEM_MASTER.