Supported Tables in Purge Handling

The purge process enhances performance by optimizing data retention and improving storage efficiency. The purge process is auto-scheduled during your maintenance window from the following tables according to defined 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.
FROM_MANUFACTURING_TRANSACTION_HDR	Purging data older than 5 years.
FROM_MANUFACTURING_TRANSACTION_DTL	Purging data older than 5 years.
FROM_MANUFACTURING_TRANSACTION_DTL_SERIAL_NBR	Purging data older than 5 years.
FROM_MHE_CYCLE_COUNT_INFO_DTL	Purging data older than 5 years.
FROM_MHE_CYCLE_COUNT_INFO_HDR	Purging data older than 5 years.
FROM_MHE_CYCLE_COUNT_INFO_SERIAL_NBR	Purging data older than 5 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.