Data purge matrix
This matrix shows the products, modules (data to be purged), tables affected, statuses and dates that will be shown on the purge parameters.
PRODUCT | DATA TO BE PURGED | DB TABLES AFFECTED | STATUS |
---|---|---|---|
RAD | Dock Logging |
DOCKLOG DOCKLOG_LINE DELIVERY_LINE DELIVERY_TICKET DELIVERY_UNIT DISTRIB_LINE DELIVERY_EVENT DELIVERY_EVENT_LINE |
N/A |
Miscellaneous Receiving |
RECEIPT_HEADER RECEIPT_LINE RECEIPT_LINE_DISTRIB DISTRIB_LINE DELIVERY_TICKET DELIVERY_UNIT SIGNATURE DELIVERY_EVENT DELIVERY_EVENT_LINE |
Received Cancelled |
|
PO Receiving |
PO_HEADER PO_LINE PO_LINE_DEL PO_RECEIPT PO_LINE_RECEIPT PO_LINE_RECEIPT_RECORD DISTRIB_LINE DELIVERY_UNIT SIGNATURE DELIVERY_EVENT DELIVERY_EVENT_LINE EVENT_HEADER EVENT_DETAIL |
N/A | |
Picking |
PICKLIST_HEADER PICKLIST_LINE PICKLIST_LOG DISTRIB_LINE DELIVERY_TICKET DELIVERY_UNIT SIGNATURE DELIVERY_EVENT DELIVERY_EVENT_LINE EVENT_HEADER EVENT_DETAIL |
N/A | |
Issues |
EVENT_HEADER (Event Type - ISSUE) EVENT_DETAIL |
N/A | |
Delivery |
MANIFEST MANIFEST_LINE DISTRIB_LINE DELIVERY_TICKET DELIVERY_UNIT SIGNATURE DELIVERY_EVENT DELIVERY_EVENT_LINE ACCOUNT_DIST PO_TRANSDTL |
Delivered Undelivered |
|
MPC | Par Count |
EVENT_HEADER (Event Type - PAR and ADQ) EVENT_DETAIL |
N/A |
Cycle Count |
EVENT_HEADER (Event Type - CYCLE) EVENT_DETAIL |
N/A | |
Pick for Par |
EVENT_HEADER (Event Type - PFP) EVENT_DETAIL |
N/A | |
POU | Cloverleaf Case |
CLOVERLEAF_CASE_HEADER CLOVERLEAF_CASE_PROC CLOVERLEAF_CASE_PROC_ITEM |
Processed Error |
Cloverleaf Billing |
CLOVERLEAF_BILLING_HEADER CLOVERLEAF_BILLING_TRNSCTN |
Processed Error |
|
Cloverleaf Charge |
CLOVERLEAF_CHARGE_HEADER CLOVERLEAF_CHARGE_DETAIL |
Processed Error |
|
POU Unit Cost | ICTRANS | N/A | |
Productivity Data | ACTIVITY_LOG | N/A |