Purge Configuration Options
In ScopeTechnical: PURGE_CONFIG_OPTIONS | ID: OR-CFG-PURGE_CONFIG_OPTIONS-PURGE_CONFIGURATION_OPTIONS
Stores attributes that determine the age of certain transaction records at which point they will be deleted from RMS.
See how this object fits into Configuration
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Information Type
- Configuration
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- PURGE_CONFIG_OPTIONS
Field Definitions(5)
Rules & Considerations(85)
validation
constraint
Sample Load Data(4)
| _scenario | COMP_LIST_DAYSR | COMP_PRICE_MONTHSR | CUST_ORDER_HISTORY_MONTHSR | CREATE_ID | EDI_REV_DAYS | GTS_PURGE_DAYS | INV_ADJ_MONTHS | LAST_UPDATE_ID | CREATE_DATETIME | TSF_HISTORY_MTHS | EDI_DAILY_RPT_LAG | WF_HISTORY_MONTHS | DEAL_HISTORY_MONTHS | ITEM_HISTORY_MONTHS | RETN_SCHED_UPD_DAYS | COST_EVENT_HIST_DAYS | LAST_UPDATE_DATETIME | NWP_RETENTION_PERIOD | ORDER_HISTORY_MONTHS | DAILY_SALES_DISC_MTHS | GL_PUBLISH_PURGE_DAYS | IB_RESULTS_PURGE_DAYS | LOC_CLOSE_HIST_MONTHS | PURGE_HIST_DELAY_DAYS | FDN_STG_RETENTION_DAYS | TSF_MRT_RETENTION_DAYS | ISC_HIST_RETENTION_DAYS | REPL_ORDER_HISTORY_DAYS | REPL_RESULTS_PURGE_DAYS | RETN_EXTRACTED_COST_CHG | SHIP_SCHED_HISTORY_MTHS | STORE_ORDERS_PURGE_DAYS | CONTRACT_INACTIVE_MONTHS | FUTURE_COST_HISTORY_DAYS | IFTD_HIST_RETENTION_DAYS | PROC_DATA_RETENTION_DAYS | RTV_ORDER_HISTORY_MONTHS | INVENTORY_LAYER_HIST_DAYS | MERCHAPI_CACHE_PURGE_DAYS | PRICE_HIST_RETENTION_DAYS | STOCK_LEDGER_PURGE_MONTHS | TRAN_DATA_RETAINED_DAYS_NO | CURRENCY_RATES_PURGE_MONTHS | ILS_EOD_HIST_RETENTION_DAYS | INBOUND_DATA_HISTORY_MONTHS | OWNERSHIP_CHANGE_PURGE_DAYS | PURGE_HIST_RETENTION_MONTHS | WF_NON_STOCK_SALES_HIST_DAYS | REPL_ATTR_HIST_RETENTION_WEEKS | RETENTION_OF_REJECTED_COST_CHG | PURGE_HIST_ROLLUP_RETENTION_MONTHS | INBOUND_DATA_UNPROCESSED_ERROR_DAYS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | 2026-01-01 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2026-01-01 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| default | 3 | 3 | 3 | MDM_USER | 3 | 3 | 3 | MDM_USER | 2026-01-03 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2026-01-03 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | — | 3 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 7 |
| default | 5 | 5 | 5 | BATCH_USER | 5 | 5 | 5 | BATCH_USER | 2026-01-05 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 2026-01-05 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | — | 5 | 5 | 5 | 5 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 5 | 5 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 7 |
Example values from field definitions
- COMP_LIST_DAYSR
- 1
- COMP_PRICE_MONTHSR
- 1
- CUST_ORDER_HISTORY_MONTHSR
- 1
- CREATE_ID
- SAMPLE
- EDI_REV_DAYS
- 1
- GTS_PURGE_DAYS
- 1
- INV_ADJ_MONTHS
- 1
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- TSF_HISTORY_MTHS
- 1
- EDI_DAILY_RPT_LAG
- 1
- WF_HISTORY_MONTHS
- 1
- DEAL_HISTORY_MONTHS
- 1
- ITEM_HISTORY_MONTHS
- 1
- RETN_SCHED_UPD_DAYS
- 1
- COST_EVENT_HIST_DAYS
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
- NWP_RETENTION_PERIOD
- 1
- ORDER_HISTORY_MONTHS
- 1
- DAILY_SALES_DISC_MTHS
- 1
- GL_PUBLISH_PURGE_DAYS
- 1
- IB_RESULTS_PURGE_DAYS
- 1
- LOC_CLOSE_HIST_MONTHS
- 1
- PURGE_HIST_DELAY_DAYS
- 1
- FDN_STG_RETENTION_DAYS
- 1
- TSF_MRT_RETENTION_DAYS
- 1
- ISC_HIST_RETENTION_DAYS
- 1
- REPL_ORDER_HISTORY_DAYS
- 1
- REPL_RESULTS_PURGE_DAYS
- 1
- RETN_EXTRACTED_COST_CHG
- 1
- SHIP_SCHED_HISTORY_MTHS
- 1
- STORE_ORDERS_PURGE_DAYS
- 1
- CONTRACT_INACTIVE_MONTHS
- 1
- FUTURE_COST_HISTORY_DAYS
- 1
- IFTD_HIST_RETENTION_DAYS
- 1
- PROC_DATA_RETENTION_DAYS
- 1
- RTV_ORDER_HISTORY_MONTHS
- 1
- INVENTORY_LAYER_HIST_DAYS
- 1
- MERCHAPI_CACHE_PURGE_DAYS
- 1
- PRICE_HIST_RETENTION_DAYS
- 1
- STOCK_LEDGER_PURGE_MONTHS
- 1
- TRAN_DATA_RETAINED_DAYS_NO
- 1
- CURRENCY_RATES_PURGE_MONTHS
- 1
- ILS_EOD_HIST_RETENTION_DAYS
- 1
- INBOUND_DATA_HISTORY_MONTHS
- 1
- OWNERSHIP_CHANGE_PURGE_DAYS
- 1
- PURGE_HIST_RETENTION_MONTHS
- 1
- WF_NON_STOCK_SALES_HIST_DAYS
- 1
- REPL_ATTR_HIST_RETENTION_WEEKS
- 1
- RETENTION_OF_REJECTED_COST_CHG
- 1
- PURGE_HIST_ROLLUP_RETENTION_MONTHS
- 1
- INBOUND_DATA_UNPROCESSED_ERROR_DAYS
- 1
default
- COMP_LIST_DAYSR
- 3
- COMP_PRICE_MONTHSR
- 3
- CUST_ORDER_HISTORY_MONTHSR
- 3
- CREATE_ID
- MDM_USER
- EDI_REV_DAYS
- 3
- GTS_PURGE_DAYS
- 3
- INV_ADJ_MONTHS
- 3
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- TSF_HISTORY_MTHS
- 3
- EDI_DAILY_RPT_LAG
- 3
- WF_HISTORY_MONTHS
- 3
- DEAL_HISTORY_MONTHS
- 3
- ITEM_HISTORY_MONTHS
- 3
- RETN_SCHED_UPD_DAYS
- 3
- COST_EVENT_HIST_DAYS
- 3
- LAST_UPDATE_DATETIME
- 2026-01-03
- NWP_RETENTION_PERIOD
- 3
- ORDER_HISTORY_MONTHS
- 3
- DAILY_SALES_DISC_MTHS
- 3
- GL_PUBLISH_PURGE_DAYS
- 3
- IB_RESULTS_PURGE_DAYS
- 3
- LOC_CLOSE_HIST_MONTHS
- 3
- PURGE_HIST_DELAY_DAYS
- 3
- FDN_STG_RETENTION_DAYS
- —
- TSF_MRT_RETENTION_DAYS
- 3
- ISC_HIST_RETENTION_DAYS
- 3
- REPL_ORDER_HISTORY_DAYS
- 3
- REPL_RESULTS_PURGE_DAYS
- 3
- RETN_EXTRACTED_COST_CHG
- 0
- SHIP_SCHED_HISTORY_MTHS
- 3
- STORE_ORDERS_PURGE_DAYS
- 3
- CONTRACT_INACTIVE_MONTHS
- 3
- FUTURE_COST_HISTORY_DAYS
- 3
- IFTD_HIST_RETENTION_DAYS
- 3
- PROC_DATA_RETENTION_DAYS
- 3
- RTV_ORDER_HISTORY_MONTHS
- 3
- INVENTORY_LAYER_HIST_DAYS
- 3
- MERCHAPI_CACHE_PURGE_DAYS
- 3
- PRICE_HIST_RETENTION_DAYS
- 3
- STOCK_LEDGER_PURGE_MONTHS
- 3
- TRAN_DATA_RETAINED_DAYS_NO
- 4
- CURRENCY_RATES_PURGE_MONTHS
- 3
- ILS_EOD_HIST_RETENTION_DAYS
- 3
- INBOUND_DATA_HISTORY_MONTHS
- 3
- OWNERSHIP_CHANGE_PURGE_DAYS
- 3
- PURGE_HIST_RETENTION_MONTHS
- 3
- WF_NON_STOCK_SALES_HIST_DAYS
- 3
- REPL_ATTR_HIST_RETENTION_WEEKS
- 3
- RETENTION_OF_REJECTED_COST_CHG
- 3
- PURGE_HIST_ROLLUP_RETENTION_MONTHS
- 3
- INBOUND_DATA_UNPROCESSED_ERROR_DAYS
- 7
default
- COMP_LIST_DAYSR
- 5
- COMP_PRICE_MONTHSR
- 5
- CUST_ORDER_HISTORY_MONTHSR
- 5
- CREATE_ID
- BATCH_USER
- EDI_REV_DAYS
- 5
- GTS_PURGE_DAYS
- 5
- INV_ADJ_MONTHS
- 5
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- TSF_HISTORY_MTHS
- 5
- EDI_DAILY_RPT_LAG
- 5
- WF_HISTORY_MONTHS
- 5
- DEAL_HISTORY_MONTHS
- 5
- ITEM_HISTORY_MONTHS
- 5
- RETN_SCHED_UPD_DAYS
- 5
- COST_EVENT_HIST_DAYS
- 5
- LAST_UPDATE_DATETIME
- 2026-01-05
- NWP_RETENTION_PERIOD
- 5
- ORDER_HISTORY_MONTHS
- 5
- DAILY_SALES_DISC_MTHS
- 5
- GL_PUBLISH_PURGE_DAYS
- 5
- IB_RESULTS_PURGE_DAYS
- 5
- LOC_CLOSE_HIST_MONTHS
- 5
- PURGE_HIST_DELAY_DAYS
- 5
- FDN_STG_RETENTION_DAYS
- —
- TSF_MRT_RETENTION_DAYS
- 5
- ISC_HIST_RETENTION_DAYS
- 5
- REPL_ORDER_HISTORY_DAYS
- 5
- REPL_RESULTS_PURGE_DAYS
- 5
- RETN_EXTRACTED_COST_CHG
- 0
- SHIP_SCHED_HISTORY_MTHS
- 5
- STORE_ORDERS_PURGE_DAYS
- 5
- CONTRACT_INACTIVE_MONTHS
- 5
- FUTURE_COST_HISTORY_DAYS
- 5
- IFTD_HIST_RETENTION_DAYS
- 5
- PROC_DATA_RETENTION_DAYS
- 5
- RTV_ORDER_HISTORY_MONTHS
- 5
- INVENTORY_LAYER_HIST_DAYS
- 5
- MERCHAPI_CACHE_PURGE_DAYS
- 5
- PRICE_HIST_RETENTION_DAYS
- 5
- STOCK_LEDGER_PURGE_MONTHS
- 5
- TRAN_DATA_RETAINED_DAYS_NO
- 6
- CURRENCY_RATES_PURGE_MONTHS
- 5
- ILS_EOD_HIST_RETENTION_DAYS
- 5
- INBOUND_DATA_HISTORY_MONTHS
- 3
- OWNERSHIP_CHANGE_PURGE_DAYS
- 5
- PURGE_HIST_RETENTION_MONTHS
- 5
- WF_NON_STOCK_SALES_HIST_DAYS
- 5
- REPL_ATTR_HIST_RETENTION_WEEKS
- 5
- RETENTION_OF_REJECTED_COST_CHG
- 5
- PURGE_HIST_ROLLUP_RETENTION_MONTHS
- 5
- INBOUND_DATA_UNPROCESSED_ERROR_DAYS
- 7
Rule Validation Summary
- Source Rule Count
- 101
- Governed Rule Count
- 85