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
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.
KEYED_LOG	Purging data older than 3 months.
COMMON_LOG	Purging data older than 3 months.
STAGE_APPOINTMENT_ATTR	Purging data older than 3 months.
STAGE_APPOINTMENT	Purging data older than 3 months.
STAGE_ASSET	Purging data older than 3 months.
STAGE_COLUMN_FORMATTING_RULE_DEFN_DTL_LOV	Purging data older than 3 months.
STAGE_COLUMN_FORMATTING_RULE_DEFN	Purging data older than 3 months.
STAGE_CONSOLIDATION_LOCATION	Purging data older than 3 months.
STAGE_CUBISCAN	Purging data older than 3 months.
STAGE_DEST_FACILITY_ATTRIBUTES	Purging data older than 3 months.
STAGE_IB_CONTAINER_LOCK	Purging data older than 3 months.
STAGE_IB_CONTAINER_DTL	Purging data older than 3 months.
STAGE_IB_CONTAINER	Purging data older than 3 months.
STAGE_IB_SHIPMENT_SERIAL_NBR	Purging data older than 3 months.
STAGE_IB_SHIPMENT_ATTR	Purging data older than 3 months.
STAGE_IB_SHIPMENT_DTL	Purging data older than 3 months.
STAGE_IB_SHIPMENT	Purging data older than 3 months.
STAGE_INTF_MESSAGE_ARCHIVE	Purging data older than 3 months.
STAGE_ITEM_ATTR	Purging data older than 3 months.
STAGE_ITEM_BARCODE	Purging data older than 3 months.
STAGE_ITEM_FACILITY	Purging data older than 3 months.
STAGE_ITEM_IMAGE	Purging data older than 3 months.
STAGE_ITEM_MATERIAL_HAZARD_TYPE	Purging data older than 3 months.
STAGE_ITEM_PRE_PACK	Purging data older than 3 months.
STAGE_ITEM	Purging data older than 3 months.
STAGE_LGF_USER	Purging data older than 3 months.
STAGE_LOCATION_CONFIG	Purging data older than 3 months.
STAGE_LPN_LOCATE	Purging data older than 3 months.
STAGE_MOVEMENT_REQUEST_DTL	Purging data older than 3 months.
STAGE_MOVEMENT_REQUEST_HDR	Purging data older than 3 months.
STAGE_OB_LOAD	Purging data older than 3 months.
STAGE_OB_STOP	Purging data older than 3 months.
STAGE_ORDER_DTL	Purging data older than 3 months.
STAGE_ORDER_HDR_ATTR	Purging data older than 3 months.
STAGE_ORDER_HDR	Purging data older than 3 months.
STAGE_ORDER_INSTRUCTIONS	Purging data older than 3 months.
STAGE_PLANNED_OB_LOAD	Purging data older than 3 months.
STAGE_PLANNED_OB_LOAD_ORDER_DTL	Purging data older than 3 months.
STAGE_PLANNED_OB_STOP	Purging data older than 3 months.
STAGE_POINT_OF_SALE	Purging data older than 3 months.
STAGE_PRICE_LABEL	Purging data older than 3 months.
STAGE_PROD_GOAL_LINE_GROUP	Purging data older than 3 months.
STAGE_PROD_GOAL_VAS	Purging data older than 3 months.
STAGE_PURCHASE_ORDER_DTL	Purging data older than 3 months.
STAGE_PURCHASE_ORDER_HDR_ATTR	Purging data older than 3 months.
STAGE_PURCHASE_ORDER_HDR	Purging data older than 3 months.
STAGE_REPACK_SERIAL_NBR	Purging data older than 3 months.
STAGE_REPACK	Purging data older than 3 months.
STAGE_ROUTE_DTL	Purging data older than 3 months.
STAGE_ROUTE_HDR	Purging data older than 3 months.
STAGE_SHIPTO_COMPANY	Purging data older than 3 months.
STAGE_SITE	Purging data older than 3 months.
STAGE_SKU_LINE	Purging data older than 3 months.
STAGE_STORE	Purging data older than 3 months.
STAGE_TRACK_RECORD	Purging data older than 3 months.
STAGE_VENDOR	Purging data older than 3 months.
STAGE_WORK_ORDER_COMPONENT	Purging data older than 3 months.
STAGE_WORK_ORDER_HDR	Purging data older than 3 months.
STAGE_WORK_ORDER_KIT	Purging data older than 3 months.
CC_SUMMARY_ADJUSTMENT_DTL	Purging data older than 5 years.
CC_SUMMARY_ADJUSTMENT_HDR	Purging data older than 5 years.
CC_ADJUSTMENT_HDR (Records with status: Cancelled)	Purging data older than 1 year.
CC_ADJUSTMENT_HDR (Records with statuses: Approved, Rejected, and No Variance)	Purging data older than 5 years.
WMS_ACTIVITY_DTL	Purging data older than 3 months.
FROM_MHE_PICK_CONFIRMATION_SERIAL_NBR	Purging data older than 3 months.
FROM_MHE_PICK_CONFIRMATION	Purging data older than 3 months.
STAGE_DAILY_VAS_TRACK	Purging data older than 3 months.
STAGE_MOVEMENT_REQUEST_SERIAL_NBR	Purging data older than 3 months.
STAGE_ORDER_DTL_SERIAL_NBR	Purging data older than 3 months.
STAGE_ITEM_UOM	Purging data older than 3 months.
LGF_ASYNC_TASK	Purging data older than 3 months.
STAGE_WAA_SCREEN_XREF	Purging data older than 3 months.
STAGE_WORK_AREA_ACTIVITY	Purging data older than 3 months.
STAGE_PLANNED_PARCEL_SHIPMENT_DTL	Purging data older than 3 months.
STAGE_PLANNED_PARCEL_SHIPMENT_HDR	Purging data older than 3 months.
STAGE_EMPLOYEE_LOCATION_TRACK	Purging data older than 3 months.
STAGE_ITEM_SPECIFIC_UOM_CONVERSION	Purging data older than 3 months.
STAGE_ERP_INV_SUMMARY	Purging data older than 3 months.
STAGE_PALLET_TYPE	Purging data older than 3 months.
WAVE_AI_SUMMARY	Purging data older than 3 months.

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.