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 = 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 AND QTYPICKINPROCESS = 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 AND QTYPICKINPROCESS = 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 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

RECUR_RULE is equal to N and EDITDATE 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.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

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_DATEearlier 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.