Purge Stock Ledger History (salprg)
|
Module Name |
salprg.pc |
|
Description |
Purge Stock Ledger History |
|
Functional Area |
Stock Ledger |
|
Module Type |
Admin |
|
Module Technology |
ProC |
|
Catalog ID |
RMS344 |
|
Wrapper Script |
rmswrap.ksh |
Design Overview
This program is used to purge old transaction-level stock ledger records from the Transaction Data History table. The Retain Transaction Data (TRAN_DATA_RETAINED_DAYS_NO) system parameter is used to define how many days the Transaction Data History records should be kept in the system. This program will be run nightly to remove any records older than the current date - the "Retain Transaction Data" days.
This batch also purges data from the MONTH_DATA_ERRORS table in a manner similar to that used for TRAN_DATA_ERRORS. Records that have been posted to GL (posted to GL='Y') can be purged from the table during the subsequent batch run. Records posted to Clearing (Posted to GL='C'learing) during end-of-month processing for any given month will be purged by the batch during the end-of-month processing for the following month.