Component Price History
In ScopeTechnical: COMP_PRICE_HIST | ID: OR-PRC-COMP_PRICE_HIST-COMPONENT_PRICE_HISTORY
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- COMP_PRICE_HIST
Field Definitions(5)
Rules & Considerations(16)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | REC_DATER | COMP_STORER | COMP_RETAILR | REF_ITEM | RPM_PULL | POST_DATE | OFFER_TYPE | MULTI_UNITS | PROM_END_DATE | PROM_START_DATE | COMP_RETAIL_TYPE | MULTI_UNIT_RETAIL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 2026-01-01 | 1 | 1.0000 | SAMPLE | S | 2026-01-01 | SAMPLE | 1.0000 | 2026-01-01 | 2026-01-01 | SAMPLE | 1.0000 |
| default | Comp Price Hist-002-ALT | 2026-01-03 | 1003 | 12.5000 | Comp Price Hist-002-ALT | N | 2026-01-03 | Comp P | 12.5000 | 2026-01-03 | 2026-01-03 | R | 12.5000 |
| default | Comp Price Hist-003-EDGE | 2026-01-05 | 1005 | 14.0000 | Comp Price Hist-003-EDGE | N | 2026-01-05 | Comp P | 14.0000 | 2026-01-05 | 2026-01-05 | R | 14.0000 |
Example values from field definitions
- ITEMR
- SAMPLE
- REC_DATER
- 2026-01-01
- COMP_STORER
- 1
- COMP_RETAILR
- 1.0000
- REF_ITEM
- SAMPLE
- RPM_PULL
- S
- POST_DATE
- 2026-01-01
- OFFER_TYPE
- SAMPLE
- MULTI_UNITS
- 1.0000
- PROM_END_DATE
- 2026-01-01
- PROM_START_DATE
- 2026-01-01
- COMP_RETAIL_TYPE
- SAMPLE
- MULTI_UNIT_RETAIL
- 1.0000
default
- ITEMR
- Comp Price Hist-002-ALT
- REC_DATER
- 2026-01-03
- COMP_STORER
- 1003
- COMP_RETAILR
- 12.5000
- REF_ITEM
- Comp Price Hist-002-ALT
- RPM_PULL
- N
- POST_DATE
- 2026-01-03
- OFFER_TYPE
- Comp P
- MULTI_UNITS
- 12.5000
- PROM_END_DATE
- 2026-01-03
- PROM_START_DATE
- 2026-01-03
- COMP_RETAIL_TYPE
- R
- MULTI_UNIT_RETAIL
- 12.5000
default
- ITEMR
- Comp Price Hist-003-EDGE
- REC_DATER
- 2026-01-05
- COMP_STORER
- 1005
- COMP_RETAILR
- 14.0000
- REF_ITEM
- Comp Price Hist-003-EDGE
- RPM_PULL
- N
- POST_DATE
- 2026-01-05
- OFFER_TYPE
- Comp P
- MULTI_UNITS
- 14.0000
- PROM_END_DATE
- 2026-01-05
- PROM_START_DATE
- 2026-01-05
- COMP_RETAIL_TYPE
- R
- MULTI_UNIT_RETAIL
- 14.0000
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 16