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(13)
Rules & Considerations(16)
validation
constraint
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 2026-01-01 | S | 2026-01-01 | 1 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 2026-01-01 | 2026-01-01 | 1.0000 |
Example values from field definitions
- ITEMR
- SAMPLE
- REC_DATER
- 2026-01-01
- RPM_PULLR
- S
- POST_DATER
- 2026-01-01
- COMP_STORER
- 1
- COMP_RETAILR
- 1.0000
- COMP_RETAIL_TYPER
- SAMPLE
- REF_ITEM
- SAMPLE
- OFFER_TYPE
- SAMPLE
- MULTI_UNITS
- 1.0000
- PROM_END_DATE
- 2026-01-01
- PROM_START_DATE
- 2026-01-01
- MULTI_UNIT_RETAIL
- 1.0000
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 16