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.