RPM Future Retail Nil History
In ScopeTechnical: 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(52)
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 |
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
Rule Validation Summary
- Source Rule Count
- 54
- Governed Rule Count
- 50