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:

  1. Select WMS > Administration > Facility Management > Archive setup. The Archive Configuration screen is displayed.
  2. Verify this information:
    Source Database Name
    The database from which the data to be purged.
    Note: If the application instance is SCPRD, the source database is SCPRD.
    Source Warehouse Name
    The warehouse from which the data to be purged.
    Source Server Name
    The server from which the data to be purged.
    Script ID
    The identification number for the predefined procedure.
    Note: This ID is used as a parameter for scheduling jobs and running predefined procedures.
    Script Name
    The name of the predefined procedure.
    Process Name
    The name of the process.
    Note: This name is used to identify the tables that are in the application.
    Archive Days
    The number of days to store the data in the application. If the value is 90, the system stores data for the last 90 days only and purges the remaining data.
    Note: You can only modify this field value.
    Tables Archived
    The list of tables from which the data is purged when you perform the predefined procedure.
  3. Click Save.

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

EFFECTIVEDATE older than archive days
Inventory Hold InvHoldArc SPINVENTORYHOLDARCHIVE INVENTORYHOLD, HOLDTRN 90

EDITDATE older than archive days and HOLD is set to 0.
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

EDITDATE older than archive days and STATUS >= '95' or EDITDATE older than 90 days
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

EDITDATE older than archive days and STATUS >= '9' or EDITDATE older than 180 days
Receipts Receipt SPRECEIPTARCHIVE RECEIPT, RECEIPTDETAIL, LPNDETAIL, DROPID, DROPIDDETAIL, LOTXIDDETAIL, LOTXIDHEADER, APPOINTMENTS, APPOINTMENTDETAIL, TRAILER, TRAILERSTATUS, RECEIPTSTATUSHISTORY, RECEIPTDETAILSTATUSHISTORY, RECEIPTCONTAINEREXCHANGE, SEAL_INFO, VENDORCOMPLIANCEHISTORY, APPOINTMENT_SERVICE 90

EDITDATE older than archive days and STATUS IN ('9', '11',

'15', '20') or EDITDATE older than 180 days
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

EDITDATE older than archive days and STATUS >= '9' or

EDITDATE older than 180 days
Work Order WorkOrder SPWORKORDERARCHIVE WORKORDER, ROUTEOPS, OPXSHIPORD, OPSSKUDET, WCTASK 90

CLOSEDATE older than archive days and STATUS is set to 50
Error Log ErrLogArc SPERRLOGARCHIVE ERRLOG 90 EDITDATE older than archive days
Delete Aged Inventory Records with Quantity set to 0 InvPurge SPInventoryPurge LOTXLOCXID, SKUXLOC, LOT, LOTATTRIBUTE, SKUXLOCPRODUCTION, STATUSHISTORY, STATUSMAINTENANCE 5

SKUxLOC:

LocationType NOT IN ('PICK', 'CASE', 'LAYER') AND QTY = 0 AND QTYALLOCATED = 0 AND QTYPICKED = 0 AND QTYEXPECTED = 0 ANDQTYPICKINPROCESS = 0 AND EDITDATE older than archive days

Update qtypickinprocess to 0 when qtypickinprocess<>0 and qty =0

LOTXLOCXID:

QTY = 0 AND QTYALLOCATED = 0 AND QTYPICKED = 0 AND QTYEXPECTED = 0 ANDQTYPICKINPROCESS = 0 AND PENDINGMOVEIN = 0 AND EDITDATE older than archive days

Update qtypickinprocess to 0 when qtypickinprocess<>0 and qty =0

Update pendingmovein to 0 when pendingmovein <>0 and editdate older than archive days
Putaway Loc Search Purge PaSePurArc SPPALOCSEARCHPURGE PALOCSEARCH, PUTAWAYTRACELOG, TEMP_PALOCSEARCH 7

PALOCSEARCH, TEMP_PALOC- SEARCH:

ADDDATE older than archive days
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

LOGIN_DATE_TIME older than archive days
State Server SSPurge SPSTATE_SERVER STATE_SERVER 3 Session ID with 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 SKU_QTY less than or equal to zero on the maximum inventory balance date record by lot code OR
BIC_INVENTORY EDITDATE 366

RECUR_RULE is equal to N and edit date earlier than the archive days ago

BILLING_INVOICE_Archive

 BIC_INVOICE

BIC_CHARGE,

BIC_CHARGE_DIST,

BIC_ORDER_DETAIL,

BIC_ORDER_HISTORY,

BIC_INVOICE_BATCH

 INVOICE_DATE 366

INVOICE_STATUS is X or C and INVOICE_DATE earlier than archive days ago and if the billing order history information is on the archived invoice

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.bal- ance_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

CHARGE_DATE

earlier than archive days ago

PM_S_CHARGEALL,

PM_S_CHARGECUST,

PM_S_CHARGEDEPT

 CHARGE_YEAR 3660

CHARGE_YEAR earlier than the year taken from CHARGE_DATE
PM_D_DATE ACTUAL_DATE 3660

ACTUAL_DATE

earlier than archive days ago

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

CHARGE_DATE

earlier than archive days ago

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_CONDITION.adddate earlier than archive days ago
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_ELEMENT.adddate earlier than archive days ago
H_LM_TRAVELSECTION

H_LM_ONEWAYTYPE,

H_LM_TRAVELAISLE,

H_LM_BOUNDARY,

H_LM_RESTRICTOR, H_LM_REST_EQUIPMENT

 ADDDATE 90

H_LM_TRAVELSECTION.adddate earlier than archive days ago
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 earlier than archive days ago
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

PM_D_DATE.ACTUAL date, earlier than archive days ago

pm_s_lm_daily_in- fo.date_key, earlier than archive days ago

pm_s_lm_user_info.date_key, earlier than archive days ago

pm_d_user.edit_date, earlier than archive days ago

LABOR_SCHEDULING_Archive

 RESSCH_WORKSCHEDULEEXCEPTION EXCEPTION_DATE 180

RESSCH_WORKSCHEDULEEXCEPTION.EXCEPTION_DATE earlier than archive days ago
RESSCH_WORKSCHEDULEHEADER RESSCH_WORKSCHEDULEDETAIL END_DATE 180

RESSCH_WORKSCHEDULEHEADER.end_date earlier than archive days ago

LABOR_STANDARDAUDIT_Archive

 LM_WORKUNIT

LM_WORKGROUP, LM_UDF, LM_WORKGROUP, LM_LABORAU- DIT, LM_LABORERROR, LM_TASK

 ADDDATE 90

LM_WORKUNIT.ADDDATE earlier than archive days ago