RPM Event Itemloc
In ScopeTechnical: RPM_EVENT_ITEMLOC | ID: OR-PRC-RPM_EVENT_ITEMLOC-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_EVENT_ITEMLOC
Field Definitions(39)
Rules & Considerations(36)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | S | S | 1 | S | S | 2026-01-01 | 1.0000 | SAMP | 1 | S | SAMP | SAM | S | SAM | 1 | 1 | S | SAMP | SAM | SAM | SAMP | 1.0000 | 1 | SAMP | 2026-01-01 | 1.0000 | 1.0000 | 2026-01-01 | SA | 1.0000 | SAMP | 1 | 1.0000 | 1 | 1.0000 |
Example values from field definitions
- LOC
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- LOC_TYPE
- S
- PACK_IND
- S
- SUBCLASS
- 1
- CLEAR_IND
- S
- PACK_TYPE
- S
- ACTIVE_DATE
- 2026-01-01
- MULTI_UNITS
- 1.0000
- SELLING_UOM
- SAMP
- PRIMARY_SUPP
- 1
- SELLABLE_IND
- S
- STANDARD_UOM
- SAMP
- CURRENCY_CODE
- SAM
- ORDERABLE_IND
- S
- PRIMARY_CNTRY
- SAM
- PC_REASON_CODE
- 1
- PRICE_EVENT_ID
- 1
- IS_ON_CLEARANCE
- S
- OLD_SELLING_UOM
- SAMP
- ORIG_EVENT_TYPE
- SAM
- PRICE_EVENT_TYPE
- SAM
- CURRENT_CLEAR_UOM
- SAMP
- MULTI_UNIT_RETAIL
- 1.0000
- CLEAR_MARKDOWN_NBR
- 1
- CURRENT_SELLING_UOM
- SAMP
- LAST_EXECUTION_DATE
- 2026-01-01
- SELLING_UNIT_RETAIL
- 1.0000
- CURRENT_CLEAR_RETAIL
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- PC_SU_MU_UPDATE_FLAG
- SA
- CURRENT_SELLING_RETAIL
- 1.0000
- MULTI_UNIT_SELLING_UOM
- SAMP
- PRICE_EVENT_DISPLAY_ID
- 1
- OLD_SELLING_UNIT_RETAIL
- 1.0000
- PC_AFFECTED_PROMO_FR_ID
- 1
- IL_ROWIDNROWID1020CURRENT_UNIT_RETAIL
- 1.0000
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 36