Purge Aged Sales History (hstprg)
|
Module Name |
hstprg.pc |
|
Description |
Purge Aged Sales History |
|
Functional Area |
Sales Posting |
|
Module Type |
Admin |
|
Module Technology |
ProC |
|
Catalog ID |
RMS244 |
|
Wrapper Script |
rmswrap.ksh |
Design Overview
Deletes records from ITEM_LOC_HIST, SUBCLASS_SALES_HIST, CLASS_SALES_HIST, DEPT_SALES_HIST and DAILY_SALES_DISCOUNT tables, where data is older than the specified number of months. Number of months for retention of fashion style history is specified by system_options.ITEM_HISTORY_MONTHS.