Comp Price Hist
In ScopeTechnical: COMP_PRICE_HIST | ID: OR-MFCS-COMP_PRICE_HIST
Stores competitor price information at the item/competitor/competitor store/day level.
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
- COMP_PRICE_HIST
Field Definitions(13)
Rules & Considerations(38)
Sample Load Data(4)
| _scenario | ITEMR | REC_DATER | RPM_PULLR | POST_DATER | COMP_STORER | COMP_RETAILR | COMP_RETAIL_TYPER | REF_ITEM | OFFER_TYPE | MULTI_UNITS | PROM_END_DATE | PROM_START_DATE | MULTI_UNIT_RETAIL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Comp Price Hist-001 | 2026-01-01 | N | 2026-01-01 | 1001 | 11.0000 | R | Comp Price Hist-001 | Comp Price Hist-001 | 11.0000 | 2026-01-01 | 2026-01-01 | 11.0000 |
default
- ITEMR
- Comp Price Hist-001
- REC_DATER
- 2026-01-01
- RPM_PULLR
- N
- POST_DATER
- 2026-01-01
- COMP_STORER
- 1001
- COMP_RETAILR
- 11.0000
- COMP_RETAIL_TYPER
- R
- REF_ITEM
- Comp Price Hist-001
- OFFER_TYPE
- Comp Price Hist-001
- MULTI_UNITS
- 11.0000
- PROM_END_DATE
- 2026-01-01
- PROM_START_DATE
- 2026-01-01
- MULTI_UNIT_RETAIL
- 11.0000