RPM Future Retail Nil History

In Scope

Technical: RPM_FUTURE_RETAIL_NIL_HIST | ID: OR-PRC-RPM_FUTURE_RETAIL_NIL_HIST-RPM_FUTURE_RETAIL_NIL_HISTORY

this table will hold future retail information for items/locations processed via New Item Loc Batch.

See how this object fits into Pricing & Promotions

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: RPM_FUTURE_RETAIL_NIL_HIST

Field Definitions(5)

Rules & Considerations(50)

Sample Load Data(4)

_scenario	DEPT	ITEM	CLASS	DIFF_ID	LOCATION	SUBCLASS	CLEAR_UOM	CREATE_ID	THREAD_NUM	ACTION_DATE	ITEM_PARENT	MULTI_UNITS	SELLING_UOM	CLEARANCE_ID	CLEAR_RETAIL	CUR_HIER_LEVEL	MAX_HIER_LEVEL	NIL_PROCESS_ID	PC_CHANGE_TYPE	PC_MULTI_UNITS	SELLING_RETAIL	ZONE_NODE_TYPE	CLEAR_START_IND	PRICE_CHANGE_ID	STEP_IDENTIFIER	CLEAR_MKDN_INDEX	CREATE_DATE_TIME	FUTURE_RETAIL_ID	PC_CHANGE_AMOUNT	CLEAR_CHANGE_TYPE	MULTI_UNIT_RETAIL	PC_CHANGE_PERCENT	PC_CHANGE_CURRENCY	CLEAR_CHANGE_AMOUNT	PC_ROUNDING_RULE_ID	CLEARANCE_DISPLAY_ID	CLEAR_CHANGE_PERCENT	PC_MULTI_UNIT_IMPACT	PC_MULTI_UNIT_RETAIL	CLEAR_CHANGE_CURRENCY	CLEAR_RETAIL_CURRENCY	PC_CHANGE_SELLING_UOM	CLEAR_ROUNDING_RULE_ID	MULTI_UNIT_SELLING_UOM	PC_EXCEPTION_PARENT_ID	PRICE_CHANGE_DISPLAY_ID	SELLING_RETAIL_CURRENCY	CLEAR_CHANGE_SELLING_UOM	CLEAR_EXCEPTION_PARENT_ID	PC_MULTI_UNIT_SELLING_UOM	MULTI_UNIT_RETAIL_CURRENCY	PC_MULTI_UNIT_RETAIL_CURRENCY
Example values from field definitions	1	SAMPLE	1	SAMPLE	1	1	SAMP	SAMPLE	1	2026-01-01	SAMPLE	1.0000	SAMP	1	1.0000	SA	SA	1	1	1.0000	1.0000	1	1	1	1	1	2026-01-01	1	1.0000	1	1.0000	1.0000	SAM	1.0000	1	SAMPLE	1.0000	SA	1.0000	SAM	SAM	SAMP	1	SAMP	1	SAMPLE	SAM	SAMP	1	SAMP	SAM	SAM
default	1003	RPM Future Retail Nil His	1103	ALT-RPM_FU	3	1113	RPM	MDM_USER	4	2026-01-03	RPM Future Retail Nil His	12.5000	RPM	1000000003	12.5000	RP	RP	1000000003	3	12.5000	12.5000	3	3	1000000003	3	3	2026-01-03	1000000003	12.5000	3	12.5000	12.5000	RPM	12.5000	1000000003	ALT-RPM_FUTURE-	12.5000	R	12.5000	RPM	RPM	RPM	1000000003	RPM	1000000003	ALT-RPM_FUTURE-	RPM	RPM	1000000003	RPM	RPM	RPM
default	1005	RPM Future Retail Nil His	1105	EDGE-RPM_F	5	1115	RPM	BATCH_USER	6	2026-01-05	RPM Future Retail Nil His	14.0000	RPM	1000000005	14.0000	RP	RP	1000000005	5	14.0000	14.0000	5	5	1000000005	5	5	2026-01-05	1000000005	14.0000	5	14.0000	14.0000	RPM	14.0000	1000000005	EDGE-RPM_FUTURE	14.0000	AU	14.0000	RPM	RPM	RPM	1000000005	RPM	1000000005	EDGE-RPM_FUTURE	RPM	RPM	1000000005	RPM	RPM	RPM

Example values from field definitions

DEPT: 1
ITEM: SAMPLE
CLASS: 1
DIFF_ID: SAMPLE
LOCATION: 1
SUBCLASS: 1
CLEAR_UOM: SAMP
CREATE_ID: SAMPLE
THREAD_NUM: 1
ACTION_DATE: 2026-01-01
ITEM_PARENT: SAMPLE
MULTI_UNITS: 1.0000
SELLING_UOM: SAMP
CLEARANCE_ID: 1
CLEAR_RETAIL: 1.0000
CUR_HIER_LEVEL: SA
MAX_HIER_LEVEL: SA
NIL_PROCESS_ID: 1
PC_CHANGE_TYPE: 1
PC_MULTI_UNITS: 1.0000
SELLING_RETAIL: 1.0000
ZONE_NODE_TYPE: 1
CLEAR_START_IND: 1
PRICE_CHANGE_ID: 1
STEP_IDENTIFIER: 1
CLEAR_MKDN_INDEX: 1
CREATE_DATE_TIME: 2026-01-01
FUTURE_RETAIL_ID: 1
PC_CHANGE_AMOUNT: 1.0000
CLEAR_CHANGE_TYPE: 1
MULTI_UNIT_RETAIL: 1.0000
PC_CHANGE_PERCENT: 1.0000
PC_CHANGE_CURRENCY: SAM
CLEAR_CHANGE_AMOUNT: 1.0000
PC_ROUNDING_RULE_ID: 1
CLEARANCE_DISPLAY_ID: SAMPLE
CLEAR_CHANGE_PERCENT: 1.0000
PC_MULTI_UNIT_IMPACT: SA
PC_MULTI_UNIT_RETAIL: 1.0000
CLEAR_CHANGE_CURRENCY: SAM
CLEAR_RETAIL_CURRENCY: SAM
PC_CHANGE_SELLING_UOM: SAMP
CLEAR_ROUNDING_RULE_ID: 1
MULTI_UNIT_SELLING_UOM: SAMP
PC_EXCEPTION_PARENT_ID: 1
PRICE_CHANGE_DISPLAY_ID: SAMPLE
SELLING_RETAIL_CURRENCY: SAM
CLEAR_CHANGE_SELLING_UOM: SAMP
CLEAR_EXCEPTION_PARENT_ID: 1
PC_MULTI_UNIT_SELLING_UOM: SAMP
MULTI_UNIT_RETAIL_CURRENCY: SAM
PC_MULTI_UNIT_RETAIL_CURRENCY: SAM

default

DEPT: 1003
ITEM: RPM Future Retail Nil His
CLASS: 1103
DIFF_ID: ALT-RPM_FU
LOCATION: 3
SUBCLASS: 1113
CLEAR_UOM: RPM
CREATE_ID: MDM_USER
THREAD_NUM: 4
ACTION_DATE: 2026-01-03
ITEM_PARENT: RPM Future Retail Nil His
MULTI_UNITS: 12.5000
SELLING_UOM: RPM
CLEARANCE_ID: 1000000003
CLEAR_RETAIL: 12.5000
CUR_HIER_LEVEL: RP
MAX_HIER_LEVEL: RP
NIL_PROCESS_ID: 1000000003
PC_CHANGE_TYPE: 3
PC_MULTI_UNITS: 12.5000
SELLING_RETAIL: 12.5000
ZONE_NODE_TYPE: 3
CLEAR_START_IND: 3
PRICE_CHANGE_ID: 1000000003
STEP_IDENTIFIER: 3
CLEAR_MKDN_INDEX: 3
CREATE_DATE_TIME: 2026-01-03
FUTURE_RETAIL_ID: 1000000003
PC_CHANGE_AMOUNT: 12.5000
CLEAR_CHANGE_TYPE: 3
MULTI_UNIT_RETAIL: 12.5000
PC_CHANGE_PERCENT: 12.5000
PC_CHANGE_CURRENCY: RPM
CLEAR_CHANGE_AMOUNT: 12.5000
PC_ROUNDING_RULE_ID: 1000000003
CLEARANCE_DISPLAY_ID: ALT-RPM_FUTURE-
CLEAR_CHANGE_PERCENT: 12.5000
PC_MULTI_UNIT_IMPACT: R
PC_MULTI_UNIT_RETAIL: 12.5000
CLEAR_CHANGE_CURRENCY: RPM
CLEAR_RETAIL_CURRENCY: RPM
PC_CHANGE_SELLING_UOM: RPM
CLEAR_ROUNDING_RULE_ID: 1000000003
MULTI_UNIT_SELLING_UOM: RPM
PC_EXCEPTION_PARENT_ID: 1000000003
PRICE_CHANGE_DISPLAY_ID: ALT-RPM_FUTURE-
SELLING_RETAIL_CURRENCY: RPM
CLEAR_CHANGE_SELLING_UOM: RPM
CLEAR_EXCEPTION_PARENT_ID: 1000000003
PC_MULTI_UNIT_SELLING_UOM: RPM
MULTI_UNIT_RETAIL_CURRENCY: RPM
PC_MULTI_UNIT_RETAIL_CURRENCY: RPM

default

DEPT: 1005
ITEM: RPM Future Retail Nil His
CLASS: 1105
DIFF_ID: EDGE-RPM_F
LOCATION: 5
SUBCLASS: 1115
CLEAR_UOM: RPM
CREATE_ID: BATCH_USER
THREAD_NUM: 6
ACTION_DATE: 2026-01-05
ITEM_PARENT: RPM Future Retail Nil His
MULTI_UNITS: 14.0000
SELLING_UOM: RPM
CLEARANCE_ID: 1000000005
CLEAR_RETAIL: 14.0000
CUR_HIER_LEVEL: RP
MAX_HIER_LEVEL: RP
NIL_PROCESS_ID: 1000000005
PC_CHANGE_TYPE: 5
PC_MULTI_UNITS: 14.0000
SELLING_RETAIL: 14.0000
ZONE_NODE_TYPE: 5
CLEAR_START_IND: 5
PRICE_CHANGE_ID: 1000000005
STEP_IDENTIFIER: 5
CLEAR_MKDN_INDEX: 5
CREATE_DATE_TIME: 2026-01-05
FUTURE_RETAIL_ID: 1000000005
PC_CHANGE_AMOUNT: 14.0000
CLEAR_CHANGE_TYPE: 5
MULTI_UNIT_RETAIL: 14.0000
PC_CHANGE_PERCENT: 14.0000
PC_CHANGE_CURRENCY: RPM
CLEAR_CHANGE_AMOUNT: 14.0000
PC_ROUNDING_RULE_ID: 1000000005
CLEARANCE_DISPLAY_ID: EDGE-RPM_FUTURE
CLEAR_CHANGE_PERCENT: 14.0000
PC_MULTI_UNIT_IMPACT: AU
PC_MULTI_UNIT_RETAIL: 14.0000
CLEAR_CHANGE_CURRENCY: RPM
CLEAR_RETAIL_CURRENCY: RPM
PC_CHANGE_SELLING_UOM: RPM
CLEAR_ROUNDING_RULE_ID: 1000000005
MULTI_UNIT_SELLING_UOM: RPM
PC_EXCEPTION_PARENT_ID: 1000000005
PRICE_CHANGE_DISPLAY_ID: EDGE-RPM_FUTURE
SELLING_RETAIL_CURRENCY: RPM
CLEAR_CHANGE_SELLING_UOM: RPM
CLEAR_EXCEPTION_PARENT_ID: 1000000005
PC_MULTI_UNIT_SELLING_UOM: RPM
MULTI_UNIT_RETAIL_CURRENCY: RPM
PC_MULTI_UNIT_RETAIL_CURRENCY: RPM

Rule Validation Summary

Source Rule Count: 54
Governed Rule Count: 50

All objects