RPM Oi Price Below Cost Eow
In ScopeTechnical: RPM_OI_PRICE_BELOW_COST_EOW | ID: OR-PRC-RPM_OI_PRICE_BELOW_COST_EOW-RPM_OI_PRICE_BELOW_COST_EOW
This table hold count of item locations which have retail below cost per week.
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_OI_PRICE_BELOW_COST_EOW
Field Definitions(5)
Rules & Considerations(28)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | LOCATIONR | LOC_TYPER | ITEM_DESCR | SESSION_IDR | EOW_DATE | SUPPLIER | SUP_NAME | CLEAR_IND | ACTIVE_DATE | IGNORED_IND | PRICING_COST | COST_EVENT_DESC | COST_EVENT_TYPE | ORIGIN_COUNTRY_ID | SELLING_UNIT_RETAIL | CLEARANCE_UNIT_RETAIL | COST_EVENT_PROCESS_ID | RETAIL_EFFECTIVE_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | S | SAMPLE | 1 | 2026-01-01 | 1 | SAMPLE | S | 2026-01-01 | S | 1.0000 | SAMPLE | SAM | SAM | 1.0000 | 1.0000 | 1 | 2026-01-01 |
| default | RPM Oi Price Below Cost E | 3 | R | RPM Oi Price Below Cost Eow-002-ALT | 1000000003 | 2026-01-03 | 3 | RPM Oi Price Below Cost Eow Secondary | R | 2026-01-03 | R | 12.5000 | RPM Oi Price Below Cost Eow-002-ALT | RPM | ALT | 12.5000 | 12.5000 | 1000000003 | 2026-01-03 |
| default | RPM Oi Price Below Cost E | 5 | R | RPM Oi Price Below Cost Eow-003-EDGE | 1000000005 | 2026-01-05 | 5 | RPM Oi Price Below Cost Eow Core | R | 2026-01-05 | R | 14.0000 | RPM Oi Price Below Cost Eow-003-EDGE | RPM | EDG | 14.0000 | 14.0000 | 1000000005 | 2026-01-05 |
Example values from field definitions
- ITEMR
- SAMPLE
- LOCATIONR
- 1
- LOC_TYPER
- S
- ITEM_DESCR
- SAMPLE
- SESSION_IDR
- 1
- EOW_DATE
- 2026-01-01
- SUPPLIER
- 1
- SUP_NAME
- SAMPLE
- CLEAR_IND
- S
- ACTIVE_DATE
- 2026-01-01
- IGNORED_IND
- S
- PRICING_COST
- 1.0000
- COST_EVENT_DESC
- SAMPLE
- COST_EVENT_TYPE
- SAM
- ORIGIN_COUNTRY_ID
- SAM
- SELLING_UNIT_RETAIL
- 1.0000
- CLEARANCE_UNIT_RETAIL
- 1.0000
- COST_EVENT_PROCESS_ID
- 1
- RETAIL_EFFECTIVE_DATE
- 2026-01-01
default
- ITEMR
- RPM Oi Price Below Cost E
- LOCATIONR
- 3
- LOC_TYPER
- R
- ITEM_DESCR
- RPM Oi Price Below Cost Eow-002-ALT
- SESSION_IDR
- 1000000003
- EOW_DATE
- 2026-01-03
- SUPPLIER
- 3
- SUP_NAME
- RPM Oi Price Below Cost Eow Secondary
- CLEAR_IND
- R
- ACTIVE_DATE
- 2026-01-03
- IGNORED_IND
- R
- PRICING_COST
- 12.5000
- COST_EVENT_DESC
- RPM Oi Price Below Cost Eow-002-ALT
- COST_EVENT_TYPE
- RPM
- ORIGIN_COUNTRY_ID
- ALT
- SELLING_UNIT_RETAIL
- 12.5000
- CLEARANCE_UNIT_RETAIL
- 12.5000
- COST_EVENT_PROCESS_ID
- 1000000003
- RETAIL_EFFECTIVE_DATE
- 2026-01-03
default
- ITEMR
- RPM Oi Price Below Cost E
- LOCATIONR
- 5
- LOC_TYPER
- R
- ITEM_DESCR
- RPM Oi Price Below Cost Eow-003-EDGE
- SESSION_IDR
- 1000000005
- EOW_DATE
- 2026-01-05
- SUPPLIER
- 5
- SUP_NAME
- RPM Oi Price Below Cost Eow Core
- CLEAR_IND
- R
- ACTIVE_DATE
- 2026-01-05
- IGNORED_IND
- R
- PRICING_COST
- 14.0000
- COST_EVENT_DESC
- RPM Oi Price Below Cost Eow-003-EDGE
- COST_EVENT_TYPE
- RPM
- ORIGIN_COUNTRY_ID
- EDG
- SELLING_UNIT_RETAIL
- 14.0000
- CLEARANCE_UNIT_RETAIL
- 14.0000
- COST_EVENT_PROCESS_ID
- 1000000005
- RETAIL_EFFECTIVE_DATE
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 32
- Governed Rule Count
- 28