RPM Oi Price Below Cost Day
In ScopeTechnical: RPM_OI_PRICE_BELOW_COST_DAY | ID: OR-PRC-RPM_OI_PRICE_BELOW_COST_DAY-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_OI_PRICE_BELOW_COST_DAY
Field Definitions(18)
Rules & Considerations(28)
validation
constraint
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | S | S | SAMPLE | 1 | 2026-01-01 | 1.0000 | SAMPLE | SAM | 1 | 1 | SAMPLE | S | SAM | 1.0000 | 1.0000 | 2026-01-01 |
Example values from field definitions
- ITEMR
- SAMPLE
- LOCATIONR
- 1
- LOC_TYPER
- S
- CLEAR_INDR
- S
- ITEM_DESCR
- SAMPLE
- SESSION_IDRPK
- 1
- ACTIVE_DATER
- 2026-01-01
- PRICING_COSTR
- 1.0000
- COST_EVENT_DESCR
- SAMPLE
- COST_EVENT_TYPER
- SAM
- COST_EVENT_PROCESS_IDR
- 1
- SUPPLIER
- 1
- SUP_NAME
- SAMPLE
- IGNORED_IND
- S
- ORIGIN_COUNTRY_ID
- SAM
- SELLING_UNIT_RETAIL
- 1.0000
- CLEARANCE_UNIT_RETAIL
- 1.0000
- RETAIL_EFFECTIVE_DATE
- 2026-01-01
Rule Validation Summary
- Source Rule Count
- 32
- Governed Rule Count
- 28