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.