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.