RPM Oi Price Below Cost Eow
In ScopeTechnical: RPM_OI_PRICE_BELOW_COST_EOW | ID: OR-RPCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_OI_PRICE_BELOW_COST_EOW
Field Definitions(19)
Rules & Considerations(53)
Sample Load Data(4)
| _scenario | ITEMR | EOW_DATER | LOCATIONR | LOC_TYPER | CLEAR_INDR | ITEM_DESCR | SESSION_IDR | ACTIVE_DATER | PRICING_COSTR | COST_EVENT_DESCR | COST_EVENT_TYPER | COST_EVENT_PROCESS_IDR | SUPPLIER | SUP_NAME | IGNORED_IND | ORIGIN_COUNTRY_ID | SELLING_UNIT_RETAIL | CLEARANCE_UNIT_RETAIL | RETAIL_EFFECTIVE_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | RPM Oi Price Below Cost Eow-001 | 2026-01-01 | 1 | RPM Oi Price Below Cost Eow-001 | RPM Oi Price Below Cost Eow-001 | RPM Oi Price Below Cost Eow-001 | 1000000001 | 2026-01-01 | 11.0000 | RPM Oi Price Below Cost Eow-001 | RPM Oi Price Below Cost Eow-001 | 1000000001 | 1 | RPM Oi Price Below Cost Eow Primary | RPM Oi Price Below Cost Eow-001 | STD-RPM_OI-001 | 11.0000 | 11.0000 | 2026-01-01 |
default
- ITEMR
- RPM Oi Price Below Cost Eow-001
- EOW_DATER
- 2026-01-01
- LOCATIONR
- 1
- LOC_TYPER
- RPM Oi Price Below Cost Eow-001
- CLEAR_INDR
- RPM Oi Price Below Cost Eow-001
- ITEM_DESCR
- RPM Oi Price Below Cost Eow-001
- SESSION_IDR
- 1000000001
- ACTIVE_DATER
- 2026-01-01
- PRICING_COSTR
- 11.0000
- COST_EVENT_DESCR
- RPM Oi Price Below Cost Eow-001
- COST_EVENT_TYPER
- RPM Oi Price Below Cost Eow-001
- COST_EVENT_PROCESS_IDR
- 1000000001
- SUPPLIER
- 1
- SUP_NAME
- RPM Oi Price Below Cost Eow Primary
- IGNORED_IND
- RPM Oi Price Below Cost Eow-001
- ORIGIN_COUNTRY_ID
- STD-RPM_OI-001
- SELLING_UNIT_RETAIL
- 11.0000
- CLEARANCE_UNIT_RETAIL
- 11.0000
- RETAIL_EFFECTIVE_DATE
- 2026-01-01