Configure Purge in the application
This chapter describes how to configure Purge in the application.
The predefined procedures are available to execute purging of the data in the tables. These procedures can run instantly or on a schedule by creating a scheduled job.
To configure the purge:
The predefined procedures can have multiple tables and are dependent on the master table. For example, if the LOAD table is purged, the tables that are related to the LOAD table are also purged.
This table lists the process details, predefined procedures, and criteria:
Process name | Script ID | Script name | Table name | Default archive days | Script criteria |
---|---|---|---|---|---|
Data Alerts History | Alerts | SPALERTARCHIVE | ALERT | 90 | EDITDATE older than archive days |
Background Jobs Status | BgStatArc | SPBACKGROUNDJOBSTATUSARCHIVE | BACKGROUNDJOBSTATUS | 15 | ENDTIME older than archive days. |
Container Exchange Adjustment | CxAdjArc | SPCXADJUSTMENTARCHIVE | CXADJUSTMENT, CXADJUSTMENTDETAIL | 90 | EDITDATE older than archive days. |
Equipment Check History | EqCkHisArc | SPEQUIPMENTCHECKHISTORYARCHIVE | EQUIPMENTCHECKHISTORY | 90 | EDITDATE older than archive days. |
Import Files | ImpFileArc | SPIMPORTFILEARCHIVE | IMPORTFILE, CONTENT, CONTENT_DATA | 30 | EDITDATE older than archive days and STATUS > 3. |
In Transit | IntransArc | SPINTRANSITARCHIVE | INTRANSIT, INTRANSITDETAIL | 90 | EDITDATE older than archive days. |
Inventory Docs | Invdoc | SPINVENTORYDOCSARCHIVE | CC, CCDETAIL, TRANSFER, TRANSFERDETAIL, ADJUSTMENT, ADJUSTMENTDETAIL, ADJUSTMENTDETAILSERIAL, WEIGHTADJUSTMENT, WEIGHTADJUSTMENTDETAIL, CCLST, CCRELEASEHISTORY, CCDETAILSERIAL, TRANSFERDETAILSERIAL | 90 |
|
Inventory Hold | InvHoldArc | SPINVENTORYHOLDARCHIVE | INVENTORYHOLD, HOLDTRN | 90 |
|
Inventory Transaction History | Itrn | SPITRNARCHIVE | ITRN, ITRNSERIAL | 90 | EDITDATE older than archive days. |
Load Maintenance | Load | SPLOADARCHIVE | LOADHDR, LOADSTOP, LOADSTOPSEAL, LOADUNITDETAIL, LOADORDERDETAIL | 90 | EDITDATE older than archive days and STATUS is set to
9. |
Shipment Orders and associated outbound information | Orders | SPORDERARCHIVE | ORDERS, ORDERDETAIL, PREALLOCATEPICKDETAIL, PICKDETAIL, LABELCONTAINERDETAIL, OPXSHIPORD, ORDERS_UDF, ORDERSTATUSHISTORY, OR- DERDETAILXVAS, DROPID, DROPIDDETAIL, LOTXIDDETAIL, LOTXIDHEADER, APPOINTMENTS, APPOINTMENTDETAIL, TRAILER, TRAILERSTATUS, PACKOUT, PACKOUTDETAIL, ORDERSTATUSHISTORY, ORDERCONTAINEREXCHANGE, XCHGCONTAINERINVENTORY, SPSCASE, LOADPLANNING, APPOINTMENT_SERVICE | 90 |
|
Physical | PhyArc | SPPHYSICALARCHIVE | PHYSICAL | 90 | EDITDATE older than archive days. |
Physical Count | PhyCntArc | SPPHYSICALCOUNTARCHIVE | PHYSICALCOUNT, PHYSICALCOUNTSERIAL | 90 | EDITDATE older than archive days. |
Purchase Orders | POrders | SPPOARCHIVE | PO, PODETAIL, POSTATUSHISTORY, PODETAILSTATUSHISTORY | 90 |
|
Receipts | Receipt | SPRECEIPTARCHIVE | RECEIPT, RECEIPTDETAIL, LPNDETAIL, DROPID, DROPIDDETAIL, LOTXIDDETAIL, LOTXIDHEADER, APPOINTMENTS, APPOINTMENTDETAIL, TRAILER, TRAILERSTATUS, RECEIPTSTATUSHISTORY, RECEIPTDETAILSTATUSHISTORY, RECEIPTCONTAINEREXCHANGE, SEAL_INFO, VENDORCOMPLIANCEHISTORY, APPOINTMENT_SERVICE | 90 |
|
Returned Lots | RtnLotsArc | SPRETURNEDLOTSARCHIVE | RETURNEDLOTS | 365 | EDITDATE older than archive days. |
Transship Crossdock | TRNSHP | SPTRANSSHIPCROSSDOCKARCHIVE | TRANSSHIP, TRANSDETAIL, TRANSASN, TRANSASND | 90 | EDITDATE older than archive days and STATUS is set to
9. |
Task Manager History | TaskDetail | SPTASKHISTORYARCHIVE | TASKDETAIL, USERACTIVITY, USERATTENDANCE, ASSIGNMENT | 90 | EDITDATE older than archive days and STATUS is set to
9. |
Time Sheet Errors | TiShErrArc | SPTIMESHEET_ERRORSARCHIVE | TIMESHEET_ERRORS | 15 | ADDDATE older than archive days. |
Integration Logs | TrLog | SPTRANSMITLOGARCHIVE | TRANSMITLOG | 90 | EDITDATE older than archive days. |
Wave Planning | WavePlan | SPWAVEARCHIVE | WAVE, WAVEDETAIL | 90 |
|
Work Order | WorkOrder | SPWORKORDERARCHIVE | WORKORDER, ROUTEOPS, OPXSHIPORD, OPSSKUDET, WCTASK | 90 |
|
Error Log | ErrLogArc | SPERRLOGARCHIVE | ERRLOG | 90 | EDITDATE older than archive days. |
Delete Aged Inventory Records with Quantity = 0 | InvPurge | SPInventoryPurge | LOTXLOCXID, SKUXLOC, LOT, LOTATTRIBUTE, SKUXLOCPRODUCTION, STATUSHISTORY, STATUSMAINTENANCE | 5 |
Update
Update Update |
Putaway Loc Search Purge | PaSePurArc | SPPALOCSEARCHPURGE | PALOCSEARCH, PUTAWAYTRACELOG, TEMP_PALOCSEARCH | 7 |
|
Datalake deleted rows purge job | PurDelRows | SPIDELETEDROWSPURGE | DELETEDROWS | 30 | EDITDATE older than archive days. |
Report Request purge job | PurRepReq | SPREPORTREQUESTPURGE | REPORTREQUEST | 90 | EDITDATE older than archive days. |
Wave In Process Purge | WaInpPuArc | SPWAVEINPROCESSPURGE | WAVEINPROCESS | 7 | EDITDATE older than archive days. |
User Audit | UserAudPur | SPUSERAUDIT | USER_AUDIT | 30 |
|
State Server | SSPurge | SPSTATE_SERVER | STATE_SERVER | 3 | MAX MODIFIED_DATE older than archive days. |
Mobile Message Archive | MobMessArc | SPMOBILE_MESSAGEARCHIVE | MOBILE_MESSAGE_STATUS, MOBILE_MESSAGE | 90 | EDITDATE older than archive days ago. |
This table lists the tables and scripts that are available on billing archiving:
Script name | Table name | Linked table | Date field | Default purge days |
Archive condition |
---|---|---|---|---|---|
BILLING_INVENTORY_Archive |
BIC_INVENTORY | BIC_INVENTORY_BAL, BIC_INVLOC_BAL, BIC_INVENTORY_UOM | BIC_INVENTORY_BAL.BALANCE_DATE or BIC_INVLOC_BAL.BALANCE_DATE | 366 | If the lot inventory balance is zero on or before the archive date. |
BIC_INVENTORY | EDITDATE | 366 |
|
||
BILLING_INVOICE_Archive |
BIC_INVOICE |
BIC_CHARGE, BIC_CHARGE_DIST, BIC_ORDER_DETAIL, BIC_ORDER_HISTORY, BIC_INVOICE_BATCH |
INVOICE_DATE | 366 |
|
BILLING_RATE_Archive |
BIC_RATE_GROUP | BIC_RATE | EXPIRE_DATE | 366 |
The rate group is in a contract with an effective date earlier than archive days ago. or There are no rates in the rate group. |
BILLING_COST_Archive |
BIC_COST | BIC_COST_DIST | COST_DATE | 366 | BIC_COST.COST_DATE earlier than archive days ago. |
BIC_COST | BIC_COST_BAL- ANCE | BALANCE_DATE | 366 | BIC_COST.BALANCE_DATE earlier than archive days ago. |
|
BILLING_MONTHREPORTING_Archive |
PM_S_CHG1MM, PM_S_CHG1MM_AVG, PM_S_CHG2MM, PM_S_CHG2MM_AVG | CHARGE_DATE | 3660 |
|
|
PM_S_CHARGEALL, PM_S_CHARGECUST, PM_S_CHARGEDEPT |
CHARGE_YEAR | 3660 |
|
||
PM_D_DATE | ACTUAL_DATE | 3660 |
|
||
BILLING_WEEKREPORTING_Archive |
PM_S_CHG1WW, PM_S_CHG1WW_AVG, PM_S_CHG2WW, PM_S_CHG2WW_AVG, PM_S_CHG1DD, PM_S_CHG2DD_AVG, | CHARGE_DATE | 366 |
|
This table lists the tables and scripts that are available on Labor Management Archiving:
Script name | Table name | Linked table | Date field | Default purge days | Archive condition |
---|---|---|---|---|---|
LABOR_HISTORY_Archive | H_LM_CONDITION |
H_LM_CONDITION_CHOOS- ER, H_LM_CHOOSER, H_LM_CONDITION_DETAIL, H_LM_CONDITION_ELE_DETAIL, H_LM_CONDITION_OPER_DETAIL, H_LM_CONDITION_ALLOWANCE, |
ADDDATE | 90 |
|
H_LM_ELEMENT |
H_LM_ELEMENT_DETAIL, H_LM_SUBELEMENT, H_LM_OPERATION, H_LM_OPERATION_DETAIL, H_LM_ALLOWANCE, H_LM_ALLOWANCEDETAIL, H_LM_ALLOWANCE_ELEMENT, H_LM_ALLOWANCE_OPERATION |
ADDDATE | 90 |
|
|
H_LM_TRAVELSECTION |
H_LM_ONEWAYTYPE, H_LM_TRAVELAISLE, H_LM_BOUNDARY, H_LM_RESTRICTOR, H_LM_REST_EQUIPMENT |
ADDDATE | 90 |
|
|
LM_REVISIONCONTROL | ADDDATE | 90 | LM_REVISIONCONTROL.ADDDATE earlier than archive days ago. |
||
LABOR_PLANNING_Archive |
LF_PLANNING_ESTIMATES | PLAN_DATE | 90 |
|
|
LF_PLANNING | PLAN_DATE | 90 | LF_PLANNING.PLAN_DATE earlier than archive days ago. |
||
LF_USERADJ | PLAN_DATE | 90 | LF_USERADJ.PLAN_DATE earlier than archive days ago. |
||
LABOR_PLANSTATS_Archive | LF_STATS_RECALC | ADDDATE | 90 | EDITDATE earlier than archive days ago. |
|
LF_STATS_IBOD | FORECAST_DATE | 90 | |||
LF_STATS_IBOM | FORECAST_DATE | 90 | |||
LF_STATS_OD | FORECAST_DATE | 90 | |||
LF_STATS_OM | FORECAST_DATE | 90 | |||
LABOR_REPORTING_Archive | PM_D_DATE |
pm_s_lm_daily_info, pm_s_lm_user_info, pm_d_user |
ACTUAL_DATE | 3660 |
|
LABOR_SCHEDULING_Archive |
RESSCH_WORKSCHEDULEEXCEPTION | EXCEPTION_DATE | 180 |
|
|
RESSCH_WORKSCHEDULEHEADER | RESSCH_WORKSCHEDULEDETAIL | END_DATE | 180 |
|
|
LABOR_STANDARDAUDIT_Archive |
LM_WORKUNIT |
LM_WORKGROUP, LM_UDF, LM_WORKGROUP, LM_LABORAU- DIT, LM_LABORERROR, LM_TASK |
ADDDATE | 90 |
|