Additional Support for Purge Script Handling

The purge process helps improve performance by optimizing data retention and increasing storage efficiency. It enables you to remove older, no-longer-needed records in a controlled and predictable way.

The tables included in the existing purge script remain supported, with expanded coverage for the following entities as part of this update:

Entity	Status/Identifier	Delete Records Older Than
SERIAL_NUMBER_HISTORY	Action Code: Shipped	3 Years
SERIAL_NUMBER_HISTORY	Action Code: Linked/Delinked	6 Months
PALLET_HISTORY	Pallet Activity: Pallet Moved/LPN Added/LPN Removed/Pallet Weighed and Dimensioned	6 Months
PALLET_HISTORY	Pallet Activity: Pallet Created/Pallet Shipped	3 Years
TO_MHE_DISTRO_HDR/DTL	NA	3 Months
TO_MHE_IBLPN_INFO	NA	3 Months
TO_MHE_LPN_ROUTE_HDR/DTL	NA	3 Months
CONSOLIDATION_PICK_REQUEST/ SERIAL_NUMBER	NA	3 Months (Recently added Table)
AUDIT_HISTORY	NA	1 Year

Steps to enable and configure

You don't need to do anything to enable this feature.