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:
Note: You can
retain the data in the system before purging via Purge Retention Period in the User
UI. This button provides you an option to enter the retention duration (in years)
and can be adjusted to any value between 1 and 5years. This button is authorized
only for ADMIN user provisioned during WMS Cloud service activation (who also
has access to the RF Device Connection Details button) to submit or update
the purge retention period.
| 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. |
|
WMS_ERP_INV_DISCREPANCY |
Purging data older than 3 months. |
|
WMS_ERP_INV_DISCREPANCY_SERIAL_NBR |
Purging data older than 3 months. |
|
WMS_INV_SUMMARY |
Purging data older than 3 months. |
|
WMS_INV_SUMMARY_SERIAL_NBR |
Purging data older than 3 months. |
|
ERP_INV_SUMMARY |
Purging data older than 3 months. |
|
ERP_INV_SUMMARY_SERIAL_NBR |
Purging data older than 3 months. |
| RECON_ERROR_COUNT | 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.