RPM Zone Future Retail
In ScopeTechnical: RPM_ZONE_FUTURE_RETAIL | ID: OR-PRC-RPM_ZONE_FUTURE_RETAIL-RPM_ZONE_FUTURE_RETAIL
This table will hold zone level future retail changes. it only tracks retails for primary zone groups.
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_ZONE_FUTURE_RETAIL
Field Definitions(5)
Rules & Considerations(33)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | ZONER | ACTION_DATER | ZONE_FUTURE_RETAIL_IDRPK | MULTI_UNITS | SELLING_UOM | LOCK_VERSION | PC_CHANGE_TYPE | PC_MULTI_UNITS | SELLING_RETAIL | PRICE_CHANGE_ID | PC_CHANGE_AMOUNT | MULTI_SELLING_UOM | MULTI_UNIT_RETAIL | PC_CHANGE_PERCENT | PC_NULL_MULTI_IND | PC_PRICE_GUIDE_ID | PC_CHANGE_CURRENCY | PC_ROUNDING_RULE_ID | PC_MULTI_SELLING_UOM | PC_MULTI_UNIT_IMPACT | PC_MULTI_UNIT_RETAIL | PC_CHANGE_SELLING_UOM | MULTI_UNIT_SELLING_UOM | PRICE_CHANGE_DISPLAY_ID | SELLING_RETAIL_CURRENCY | PC_MULTI_UNIT_SELLING_UOM | MULTI_UNIT_RETAIL_CURRENCY | PC_MULTI_UNIT_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 2026-01-01 | 1 | 1.0000 | SAMP | 1 | 1 | 1.0000 | 1.0000 | 1 | 1.0000 | SAMP | 1.0000 | 1.0000 | 1 | 1 | SAM | 1 | SAMP | SA | 1.0000 | SAMP | SAMP | SAMPLE | SAM | SAMP | SAM | SAM |
| default | RPM Zone Future Retail-00 | 3 | 2026-01-03 | 1000000003 | 12.5000 | RPM | — | 3 | 12.5000 | 12.5000 | 1000000003 | 12.5000 | — | 12.5000 | 12.5000 | — | — | RPM | 1000000003 | — | R | 12.5000 | RPM | RPM | ALT-RPM_ZONE-00 | RPM | RPM | RPM | RPM |
| default | RPM Zone Future Retail-00 | 5 | 2026-01-05 | 1000000005 | 14.0000 | RPM | — | 5 | 14.0000 | 14.0000 | 1000000005 | 14.0000 | — | 14.0000 | 14.0000 | — | — | RPM | 1000000005 | — | AU | 14.0000 | RPM | RPM | EDGE-RPM_ZONE-0 | RPM | RPM | RPM | RPM |
Example values from field definitions
- ITEMR
- SAMPLE
- ZONER
- 1
- ACTION_DATER
- 2026-01-01
- ZONE_FUTURE_RETAIL_IDRPK
- 1
- MULTI_UNITS
- 1.0000
- SELLING_UOM
- SAMP
- LOCK_VERSION
- 1
- PC_CHANGE_TYPE
- 1
- PC_MULTI_UNITS
- 1.0000
- SELLING_RETAIL
- 1.0000
- PRICE_CHANGE_ID
- 1
- PC_CHANGE_AMOUNT
- 1.0000
- 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
- PC_ROUNDING_RULE_ID
- 1
- PC_MULTI_SELLING_UOM
- SAMP
- PC_MULTI_UNIT_IMPACT
- SA
- PC_MULTI_UNIT_RETAIL
- 1.0000
- PC_CHANGE_SELLING_UOM
- SAMP
- MULTI_UNIT_SELLING_UOM
- SAMP
- PRICE_CHANGE_DISPLAY_ID
- SAMPLE
- SELLING_RETAIL_CURRENCY
- SAM
- PC_MULTI_UNIT_SELLING_UOM
- SAMP
- MULTI_UNIT_RETAIL_CURRENCY
- SAM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- SAM
default
- ITEMR
- RPM Zone Future Retail-00
- ZONER
- 3
- ACTION_DATER
- 2026-01-03
- ZONE_FUTURE_RETAIL_IDRPK
- 1000000003
- MULTI_UNITS
- 12.5000
- SELLING_UOM
- RPM
- LOCK_VERSION
- —
- PC_CHANGE_TYPE
- 3
- PC_MULTI_UNITS
- 12.5000
- SELLING_RETAIL
- 12.5000
- PRICE_CHANGE_ID
- 1000000003
- PC_CHANGE_AMOUNT
- 12.5000
- 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
- PC_ROUNDING_RULE_ID
- 1000000003
- PC_MULTI_SELLING_UOM
- —
- PC_MULTI_UNIT_IMPACT
- R
- PC_MULTI_UNIT_RETAIL
- 12.5000
- PC_CHANGE_SELLING_UOM
- RPM
- MULTI_UNIT_SELLING_UOM
- RPM
- PRICE_CHANGE_DISPLAY_ID
- ALT-RPM_ZONE-00
- SELLING_RETAIL_CURRENCY
- RPM
- PC_MULTI_UNIT_SELLING_UOM
- RPM
- MULTI_UNIT_RETAIL_CURRENCY
- RPM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- RPM
default
- ITEMR
- RPM Zone Future Retail-00
- ZONER
- 5
- ACTION_DATER
- 2026-01-05
- ZONE_FUTURE_RETAIL_IDRPK
- 1000000005
- MULTI_UNITS
- 14.0000
- SELLING_UOM
- RPM
- LOCK_VERSION
- —
- PC_CHANGE_TYPE
- 5
- PC_MULTI_UNITS
- 14.0000
- SELLING_RETAIL
- 14.0000
- PRICE_CHANGE_ID
- 1000000005
- PC_CHANGE_AMOUNT
- 14.0000
- 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
- PC_ROUNDING_RULE_ID
- 1000000005
- PC_MULTI_SELLING_UOM
- —
- PC_MULTI_UNIT_IMPACT
- AU
- PC_MULTI_UNIT_RETAIL
- 14.0000
- PC_CHANGE_SELLING_UOM
- RPM
- MULTI_UNIT_SELLING_UOM
- RPM
- PRICE_CHANGE_DISPLAY_ID
- EDGE-RPM_ZONE-0
- SELLING_RETAIL_CURRENCY
- RPM
- PC_MULTI_UNIT_SELLING_UOM
- RPM
- MULTI_UNIT_RETAIL_CURRENCY
- RPM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- RPM
Rule Validation Summary
- Source Rule Count
- 41
- Governed Rule Count
- 33
