RPM Future Retail Nil Hist
In ScopeTechnical: RPM_FUTURE_RETAIL_NIL_HIST | ID: OR-RPCS-RPM_FUTURE_RETAIL_NIL_HIST
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
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_FUTURE_RETAIL_NIL_HIST
Field Definitions(52)
Rules & Considerations(108)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | RPM Future Retail Nil Hist-001 | 1101 | STD-RPM_FUTURE-001 | 1 | 1111 | RPM Future Retail Nil Hist-001 | MIG_USER | 2 | 2026-01-01 | RPM Future Retail Nil Hist-001 | 11.0000 | RPM Future Retail Nil Hist-001 | 1000000001 | 11.0000 | RPM Future Retail Nil Hist-001 | RPM Future Retail Nil Hist-001 | 1000000001 | 1 | 11.0000 | 11.0000 | 000001 | 1 | 1000000001 | 01 | 01 | 2026-01-01 | 1000000001 | 11.0000 | 1 | 11.0000 | 11.0000 | RPM Future Retail Nil Hist-001 | 11.0000 | 1000000001 | STD-RPM_FUTURE-001 | 11.0000 | AU | 11.0000 | RPM Future Retail Nil Hist-001 | RPM Future Retail Nil Hist-001 | RPM Future Retail Nil Hist-001 | 1000000001 | RPM Future Retail Nil Hist-001 | 1000000001 | STD-RPM_FUTURE-001 | RPM Future Retail Nil Hist-001 | RPM Future Retail Nil Hist-001 | 1000000001 | RPM Future Retail Nil Hist-001 | RPM Future Retail Nil Hist-001 | RPM Future Retail Nil Hist-001 |
default
- DEPT
- 1001
- ITEM
- RPM Future Retail Nil Hist-001
- CLASS
- 1101
- DIFF_ID
- STD-RPM_FUTURE-001
- LOCATION
- 1
- SUBCLASS
- 1111
- CLEAR_UOM
- RPM Future Retail Nil Hist-001
- CREATE_ID
- MIG_USER
- THREAD_NUM
- 2
- ACTION_DATE
- 2026-01-01
- ITEM_PARENT
- RPM Future Retail Nil Hist-001
- MULTI_UNITS
- 11.0000
- SELLING_UOM
- RPM Future Retail Nil Hist-001
- CLEARANCE_ID
- 1000000001
- CLEAR_RETAIL
- 11.0000
- CUR_HIER_LEVEL
- RPM Future Retail Nil Hist-001
- MAX_HIER_LEVEL
- RPM Future Retail Nil Hist-001
- NIL_PROCESS_ID
- 1000000001
- PC_CHANGE_TYPE
- 1
- PC_MULTI_UNITS
- 11.0000
- SELLING_RETAIL
- 11.0000
- ZONE_NODE_TYPE
- 000001
- CLEAR_START_IND
- 1
- PRICE_CHANGE_ID
- 1000000001
- STEP_IDENTIFIER
- 01
- CLEAR_MKDN_INDEX
- 01
- CREATE_DATE_TIME
- 2026-01-01
- FUTURE_RETAIL_ID
- 1000000001
- PC_CHANGE_AMOUNT
- 11.0000
- CLEAR_CHANGE_TYPE
- 1
- MULTI_UNIT_RETAIL
- 11.0000
- PC_CHANGE_PERCENT
- 11.0000
- PC_CHANGE_CURRENCY
- RPM Future Retail Nil Hist-001
- CLEAR_CHANGE_AMOUNT
- 11.0000
- PC_ROUNDING_RULE_ID
- 1000000001
- CLEARANCE_DISPLAY_ID
- STD-RPM_FUTURE-001
- CLEAR_CHANGE_PERCENT
- 11.0000
- PC_MULTI_UNIT_IMPACT
- AU
- PC_MULTI_UNIT_RETAIL
- 11.0000
- CLEAR_CHANGE_CURRENCY
- RPM Future Retail Nil Hist-001
- CLEAR_RETAIL_CURRENCY
- RPM Future Retail Nil Hist-001
- PC_CHANGE_SELLING_UOM
- RPM Future Retail Nil Hist-001
- CLEAR_ROUNDING_RULE_ID
- 1000000001
- MULTI_UNIT_SELLING_UOM
- RPM Future Retail Nil Hist-001
- PC_EXCEPTION_PARENT_ID
- 1000000001
- PRICE_CHANGE_DISPLAY_ID
- STD-RPM_FUTURE-001
- SELLING_RETAIL_CURRENCY
- RPM Future Retail Nil Hist-001
- CLEAR_CHANGE_SELLING_UOM
- RPM Future Retail Nil Hist-001
- CLEAR_EXCEPTION_PARENT_ID
- 1000000001
- PC_MULTI_UNIT_SELLING_UOM
- RPM Future Retail Nil Hist-001
- MULTI_UNIT_RETAIL_CURRENCY
- RPM Future Retail Nil Hist-001
- PC_MULTI_UNIT_RETAIL_CURRENCY
- RPM Future Retail Nil Hist-001