Supported Tables in Purge Handling

The purge process enhances performance by optimizing data retention and improving storage efficiency. You can schedule the records deletion (purge) from the following tables according to predefined timelines:

Table Time frame to be purged
MHE_PICK_CONFIRMATION Purging data older than 3 months.
WMS_ACTIVITY Purging data older than 3 months.
INVENTORY_HISTORY Purging data older than 5 years.
AUDIT_HISTORY Purging data older than 5 years.
LPN_AUDIT_DTL Purging data older than 5 years.
PALLET_AUDIT_DTL Purging data older than 5 years.
OUTPUT_INTERFACE Purging data older than 3 months.
OUTPUT_INTERFACE_MSG_LOG Purging data older than 3 months.
LGFAPI_ARCHIVE Purging data older than 3 months.
STAGE_REPLENISHMENT_PICK Purging data older than 3 months.
SERIAL_NBR_HISTORY Purging data older than 3 years.

Serial Number History handles the history of Serial Number being linked, delinked, and shipped from LPNs.

Note: To avoid accidental loss of essential data during the purge, it's highly recommended to schedule regular API extractions or data exports for all critical information. This ensures a backup of historical data before it's removed by the automated purge processes.