RPM Event Itemloc
In ScopeTechnical: RPM_EVENT_ITEMLOC | ID: OR-RPCS-RPM_EVENT_ITEMLOC
this is a working table that is used in the price event execution batch program. this table will contain all item/location that will be affected by a price event execution…
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_EVENT_ITEMLOC
Field Definitions(39)
Rules & Considerations(82)
Sample Load Data(4)
| _scenario | LOC | DEPT | ITEM | CLASS | LOC_TYPE | PACK_IND | SUBCLASS | CLEAR_IND | PACK_TYPE | ACTIVE_DATE | MULTI_UNITS | SELLING_UOM | PRIMARY_SUPP | SELLABLE_IND | STANDARD_UOM | CURRENCY_CODE | ORDERABLE_IND | PRIMARY_CNTRY | PC_REASON_CODE | PRICE_EVENT_ID | IS_ON_CLEARANCE | OLD_SELLING_UOM | ORIG_EVENT_TYPE | PRICE_EVENT_TYPE | CURRENT_CLEAR_UOM | MULTI_UNIT_RETAIL | CLEAR_MARKDOWN_NBR | CURRENT_SELLING_UOM | LAST_EXECUTION_DATE | SELLING_UNIT_RETAIL | CURRENT_CLEAR_RETAIL | LAST_UPDATE_DATETIME | PC_SU_MU_UPDATE_FLAG | CURRENT_SELLING_RETAIL | MULTI_UNIT_SELLING_UOM | PRICE_EVENT_DISPLAY_ID | OLD_SELLING_UNIT_RETAIL | PC_AFFECTED_PROMO_FR_ID | IL_ROWIDNROWID1020CURRENT_UNIT_RETAIL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1001 | RPM Event Itemloc-001 | 1101 | RPM Event Itemloc-001 | RPM Event Itemloc-001 | 1111 | RPM Event Itemloc-001 | RPM Event Itemloc-001 | 2026-01-01 | 11.0000 | RPM Event Itemloc-001 | 1 | RPM Event Itemloc-001 | RPM Event Itemloc-001 | STD-RPM_EVENT-001 | RPM Event Itemloc-001 | RPM Event Itemloc-001 | 000001 | 1000000001 | RPM Event Itemloc-001 | RPM Event Itemloc-001 | RPM Event Itemloc-001 | RPM Event Itemloc-001 | RPM Event Itemloc-001 | 11.0000 | 000001 | RPM Event Itemloc-001 | 2026-01-01 | 11.0000 | 11.0000 | 2026-01-01 | SU | 11.0000 | RPM Event Itemloc-001 | 1000000001 | 11.0000 | 1000000001 | 11.0000 |
default
- LOC
- 1
- DEPT
- 1001
- ITEM
- RPM Event Itemloc-001
- CLASS
- 1101
- LOC_TYPE
- RPM Event Itemloc-001
- PACK_IND
- RPM Event Itemloc-001
- SUBCLASS
- 1111
- CLEAR_IND
- RPM Event Itemloc-001
- PACK_TYPE
- RPM Event Itemloc-001
- ACTIVE_DATE
- 2026-01-01
- MULTI_UNITS
- 11.0000
- SELLING_UOM
- RPM Event Itemloc-001
- PRIMARY_SUPP
- 1
- SELLABLE_IND
- RPM Event Itemloc-001
- STANDARD_UOM
- RPM Event Itemloc-001
- CURRENCY_CODE
- STD-RPM_EVENT-001
- ORDERABLE_IND
- RPM Event Itemloc-001
- PRIMARY_CNTRY
- RPM Event Itemloc-001
- PC_REASON_CODE
- 000001
- PRICE_EVENT_ID
- 1000000001
- IS_ON_CLEARANCE
- RPM Event Itemloc-001
- OLD_SELLING_UOM
- RPM Event Itemloc-001
- ORIG_EVENT_TYPE
- RPM Event Itemloc-001
- PRICE_EVENT_TYPE
- RPM Event Itemloc-001
- CURRENT_CLEAR_UOM
- RPM Event Itemloc-001
- MULTI_UNIT_RETAIL
- 11.0000
- CLEAR_MARKDOWN_NBR
- 000001
- CURRENT_SELLING_UOM
- RPM Event Itemloc-001
- LAST_EXECUTION_DATE
- 2026-01-01
- SELLING_UNIT_RETAIL
- 11.0000
- CURRENT_CLEAR_RETAIL
- 11.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- PC_SU_MU_UPDATE_FLAG
- SU
- CURRENT_SELLING_RETAIL
- 11.0000
- MULTI_UNIT_SELLING_UOM
- RPM Event Itemloc-001
- PRICE_EVENT_DISPLAY_ID
- 1000000001
- OLD_SELLING_UNIT_RETAIL
- 11.0000
- PC_AFFECTED_PROMO_FR_ID
- 1000000001
- IL_ROWIDNROWID1020CURRENT_UNIT_RETAIL
- 11.0000