RPM Oi Price Below Cost Day
In ScopeTechnical: RPM_OI_PRICE_BELOW_COST_DAY | ID: OR-RPCS-RPM_OI_PRICE_BELOW_COST_DAY
This table hold count of item locations which have retail below cost.
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_DAY
Field Definitions(18)
Rules & Considerations(51)
Sample Load Data(4)
| _scenario | ITEMR | LOCATIONR | LOC_TYPER | CLEAR_INDR | ITEM_DESCR | SESSION_IDRPK | 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 Day-001 | 1 | RPM Oi Price Below Cost Day-001 | RPM Oi Price Below Cost Day-001 | RPM Oi Price Below Cost Day-001 | 1000000001 | 2026-01-01 | 11.0000 | RPM Oi Price Below Cost Day-001 | RPM Oi Price Below Cost Day-001 | 1000000001 | 1 | RPM Oi Price Below Cost Day Primary | RPM Oi Price Below Cost Day-001 | STD-RPM_OI-001 | 11.0000 | 11.0000 | 2026-01-01 |
default
- ITEMR
- RPM Oi Price Below Cost Day-001
- LOCATIONR
- 1
- LOC_TYPER
- RPM Oi Price Below Cost Day-001
- CLEAR_INDR
- RPM Oi Price Below Cost Day-001
- ITEM_DESCR
- RPM Oi Price Below Cost Day-001
- SESSION_IDRPK
- 1000000001
- ACTIVE_DATER
- 2026-01-01
- PRICING_COSTR
- 11.0000
- COST_EVENT_DESCR
- RPM Oi Price Below Cost Day-001
- COST_EVENT_TYPER
- RPM Oi Price Below Cost Day-001
- COST_EVENT_PROCESS_IDR
- 1000000001
- SUPPLIER
- 1
- SUP_NAME
- RPM Oi Price Below Cost Day Primary
- IGNORED_IND
- RPM Oi Price Below Cost Day-001
- ORIGIN_COUNTRY_ID
- STD-RPM_OI-001
- SELLING_UNIT_RETAIL
- 11.0000
- CLEARANCE_UNIT_RETAIL
- 11.0000
- RETAIL_EFFECTIVE_DATE
- 2026-01-01