RPM Future Retail
In ScopeTechnical: RPM_FUTURE_RETAIL | ID: OR-PRC-RPM_FUTURE_RETAIL-RPM_FUTURE_RETAIL
this table will hold future retail information for items/locations.
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
Field Definitions(5)
Rules & Considerations(75)
validation
constraint
Sample Load Data(4)
| _scenario | DEPTR | ITEMR | CLASSR | SUBCLASSR | FUTURE_RETAIL_IDRPK | DIFF_ID | ZONE_ID | LOCATION | CLEAR_UOM | ACTION_DATE | ITEM_PARENT | MULTI_UNITS | SELLING_UOM | CLEARANCE_ID | CLEAR_RETAIL | LOCK_VERSION | CUR_HIER_LEVEL | MAX_HIER_LEVEL | PC_CHANGE_TYPE | PC_MULTI_UNITS | SELLING_RETAIL | ZONE_NODE_TYPE | CLEAR_START_IND | PRICE_CHANGE_ID | CLEAR_MKDN_INDEX | LOCATION_MOVE_ID | PC_CHANGE_AMOUNT | SIMPLE_PROMO_UOM | CLEAR_CHANGE_TYPE | MULTI_SELLING_UOM | MULTI_UNIT_RETAIL | PC_CHANGE_PERCENT | PC_NULL_MULTI_IND | PC_PRICE_GUIDE_ID | PC_CHANGE_CURRENCY | CLEAR_CHANGE_AMOUNT | LOC_MOVE_TO_ZONE_ID | ON_SIMPLE_PROMO_IND | PC_ROUNDING_RULE_ID | SIMPLE_PROMO_RETAIL | CLEARANCE_DISPLAY_ID | CLEAR_CHANGE_PERCENT | CLEAR_PRICE_GUIDE_ID | ON_COMPLEX_PROMO_IND | PC_MULTI_SELLING_UOM | PC_MULTI_UNIT_IMPACT | PC_MULTI_UNIT_RETAIL | CLEAR_CHANGE_CURRENCY | CLEAR_RETAIL_CURRENCY | LOC_MOVE_FROM_ZONE_ID | 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 | SIMPLE_PROMO_RETAIL_CURRENCY | PC_MULTI_UNIT_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | 1 | 1 | SAMP | 2026-01-01 | SAMPLE | 1.0000 | SAMP | 1 | 1.0000 | 1 | SA | SA | 1 | 1.0000 | 1.0000 | 1 | 1 | 1 | 1 | 1 | 1.0000 | SAMP | 1 | SAMP | 1.0000 | 1.0000 | 1 | 1 | SAM | 1.0000 | 1 | 1 | 1 | 1.0000 | SAMPLE | 1.0000 | 1 | 1 | SAMP | SA | 1.0000 | SAM | SAM | 1 | SAMP | 1 | SAMP | 1 | SAMPLE | SAM | SAMP | 1 | SAMP | SAM | SAM | SAM |
| default | 1003 | RPM Future Retail-002-ALT | 1103 | 1113 | 1000000003 | ALT-RPM_FU | — | 3 | RPM | 2026-01-03 | RPM Future Retail-002-ALT | 12.5000 | RPM | 1000000003 | 12.5000 | — | RP | RP | 3 | 12.5000 | 12.5000 | 3 | 3 | 1000000003 | 3 | — | 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-003-EDG | 1105 | 1115 | 1000000005 | EDGE-RPM_F | — | 5 | RPM | 2026-01-05 | RPM Future Retail-003-EDG | 14.0000 | RPM | 1000000005 | 14.0000 | — | RP | RP | 5 | 14.0000 | 14.0000 | 5 | 5 | 1000000005 | 5 | — | 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
- DEPTR
- 1
- ITEMR
- SAMPLE
- CLASSR
- 1
- SUBCLASSR
- 1
- FUTURE_RETAIL_IDRPK
- 1
- DIFF_ID
- SAMPLE
- ZONE_ID
- 1
- LOCATION
- 1
- CLEAR_UOM
- SAMP
- ACTION_DATE
- 2026-01-01
- ITEM_PARENT
- SAMPLE
- MULTI_UNITS
- 1.0000
- SELLING_UOM
- SAMP
- CLEARANCE_ID
- 1
- CLEAR_RETAIL
- 1.0000
- LOCK_VERSION
- 1
- CUR_HIER_LEVEL
- SA
- MAX_HIER_LEVEL
- SA
- 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
- CLEAR_MKDN_INDEX
- 1
- LOCATION_MOVE_ID
- 1
- PC_CHANGE_AMOUNT
- 1.0000
- SIMPLE_PROMO_UOM
- SAMP
- CLEAR_CHANGE_TYPE
- 1
- MULTI_SELLING_UOM
- SAMP
- MULTI_UNIT_RETAIL
- 1.0000
- PC_CHANGE_PERCENT
- 1.0000
- PC_NULL_MULTI_IND
- 1
- PC_PRICE_GUIDE_ID
- 1
- PC_CHANGE_CURRENCY
- SAM
- CLEAR_CHANGE_AMOUNT
- 1.0000
- LOC_MOVE_TO_ZONE_ID
- 1
- ON_SIMPLE_PROMO_IND
- 1
- PC_ROUNDING_RULE_ID
- 1
- SIMPLE_PROMO_RETAIL
- 1.0000
- CLEARANCE_DISPLAY_ID
- SAMPLE
- CLEAR_CHANGE_PERCENT
- 1.0000
- CLEAR_PRICE_GUIDE_ID
- 1
- ON_COMPLEX_PROMO_IND
- 1
- PC_MULTI_SELLING_UOM
- SAMP
- PC_MULTI_UNIT_IMPACT
- SA
- PC_MULTI_UNIT_RETAIL
- 1.0000
- CLEAR_CHANGE_CURRENCY
- SAM
- CLEAR_RETAIL_CURRENCY
- SAM
- LOC_MOVE_FROM_ZONE_ID
- 1
- 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
- SIMPLE_PROMO_RETAIL_CURRENCY
- SAM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- SAM
default
- DEPTR
- 1003
- ITEMR
- RPM Future Retail-002-ALT
- CLASSR
- 1103
- SUBCLASSR
- 1113
- FUTURE_RETAIL_IDRPK
- 1000000003
- DIFF_ID
- ALT-RPM_FU
- ZONE_ID
- —
- LOCATION
- 3
- CLEAR_UOM
- RPM
- ACTION_DATE
- 2026-01-03
- ITEM_PARENT
- RPM Future Retail-002-ALT
- MULTI_UNITS
- 12.5000
- SELLING_UOM
- RPM
- CLEARANCE_ID
- 1000000003
- CLEAR_RETAIL
- 12.5000
- LOCK_VERSION
- —
- CUR_HIER_LEVEL
- RP
- MAX_HIER_LEVEL
- RP
- 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
- CLEAR_MKDN_INDEX
- 3
- LOCATION_MOVE_ID
- —
- PC_CHANGE_AMOUNT
- 12.5000
- SIMPLE_PROMO_UOM
- —
- CLEAR_CHANGE_TYPE
- 3
- MULTI_SELLING_UOM
- —
- MULTI_UNIT_RETAIL
- 12.5000
- PC_CHANGE_PERCENT
- 12.5000
- PC_NULL_MULTI_IND
- —
- PC_PRICE_GUIDE_ID
- —
- PC_CHANGE_CURRENCY
- RPM
- CLEAR_CHANGE_AMOUNT
- 12.5000
- LOC_MOVE_TO_ZONE_ID
- —
- ON_SIMPLE_PROMO_IND
- —
- PC_ROUNDING_RULE_ID
- 1000000003
- SIMPLE_PROMO_RETAIL
- —
- CLEARANCE_DISPLAY_ID
- ALT-RPM_FUTURE-
- CLEAR_CHANGE_PERCENT
- 12.5000
- CLEAR_PRICE_GUIDE_ID
- —
- ON_COMPLEX_PROMO_IND
- —
- PC_MULTI_SELLING_UOM
- —
- PC_MULTI_UNIT_IMPACT
- R
- PC_MULTI_UNIT_RETAIL
- 12.5000
- CLEAR_CHANGE_CURRENCY
- RPM
- CLEAR_RETAIL_CURRENCY
- RPM
- LOC_MOVE_FROM_ZONE_ID
- —
- 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
- SIMPLE_PROMO_RETAIL_CURRENCY
- —
- PC_MULTI_UNIT_RETAIL_CURRENCY
- RPM
default
- DEPTR
- 1005
- ITEMR
- RPM Future Retail-003-EDG
- CLASSR
- 1105
- SUBCLASSR
- 1115
- FUTURE_RETAIL_IDRPK
- 1000000005
- DIFF_ID
- EDGE-RPM_F
- ZONE_ID
- —
- LOCATION
- 5
- CLEAR_UOM
- RPM
- ACTION_DATE
- 2026-01-05
- ITEM_PARENT
- RPM Future Retail-003-EDG
- MULTI_UNITS
- 14.0000
- SELLING_UOM
- RPM
- CLEARANCE_ID
- 1000000005
- CLEAR_RETAIL
- 14.0000
- LOCK_VERSION
- —
- CUR_HIER_LEVEL
- RP
- MAX_HIER_LEVEL
- RP
- 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
- CLEAR_MKDN_INDEX
- 5
- LOCATION_MOVE_ID
- —
- PC_CHANGE_AMOUNT
- 14.0000
- SIMPLE_PROMO_UOM
- —
- CLEAR_CHANGE_TYPE
- 5
- MULTI_SELLING_UOM
- —
- MULTI_UNIT_RETAIL
- 14.0000
- PC_CHANGE_PERCENT
- 14.0000
- PC_NULL_MULTI_IND
- —
- PC_PRICE_GUIDE_ID
- —
- PC_CHANGE_CURRENCY
- RPM
- CLEAR_CHANGE_AMOUNT
- 14.0000
- LOC_MOVE_TO_ZONE_ID
- —
- ON_SIMPLE_PROMO_IND
- —
- PC_ROUNDING_RULE_ID
- 1000000005
- SIMPLE_PROMO_RETAIL
- —
- CLEARANCE_DISPLAY_ID
- EDGE-RPM_FUTURE
- CLEAR_CHANGE_PERCENT
- 14.0000
- CLEAR_PRICE_GUIDE_ID
- —
- ON_COMPLEX_PROMO_IND
- —
- PC_MULTI_SELLING_UOM
- —
- PC_MULTI_UNIT_IMPACT
- AU
- PC_MULTI_UNIT_RETAIL
- 14.0000
- CLEAR_CHANGE_CURRENCY
- RPM
- CLEAR_RETAIL_CURRENCY
- RPM
- LOC_MOVE_FROM_ZONE_ID
- —
- 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
- SIMPLE_PROMO_RETAIL_CURRENCY
- —
- PC_MULTI_UNIT_RETAIL_CURRENCY
- RPM
Rule Validation Summary
- Source Rule Count
- 80
- Governed Rule Count
- 75