Component Shop List
In ScopeTechnical: COMP_SHOP_LIST | ID: OR-ITM-COMP_SHOP_LIST-COMPONENT_SHOP_LIST
Stores competitor shopping lists at the item/competitor/competitor store/day level. This table will be downloaded to a PDA.
See how this object fits into Item Management
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_SHOP_LIST
Field Definitions(5)
Rules & Considerations(29)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | SHOPPERRPK | REF_ITEMRPK | SHOP_DATER | REC_DATE | COMP_NAME | ITEM_DESC | COMPETITOR | COMP_STORE | OFFER_TYPE | COMP_RETAIL | MULTI_UNITS | PROM_END_DATE | COMP_STORE_NAME | PROM_START_DATE | COMP_RETAIL_TYPE | MULTI_UNIT_RETAIL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | 1.0000 | 1.0000 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 1.0000 |
| default | Comp Shop List-002-ALT | 3 | Comp Shop List-002-ALT | 2026-01-03 | 2026-01-03 | Comp Shop List Secondary | Comp Shop List-002-ALT | 3 | 1003 | Comp S | 12.5000 | 12.5000 | 2026-01-03 | Comp Shop List Secondary | 2026-01-03 | P | 12.5000 |
| default | Comp Shop List-003-EDGE | 5 | Comp Shop List-003-EDGE | 2026-01-05 | 2026-01-05 | Comp Shop List Core | Comp Shop List-003-EDGE | 5 | 1005 | Comp S | 14.0000 | 14.0000 | 2026-01-05 | Comp Shop List Core | 2026-01-05 | C | 14.0000 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SHOPPERRPK
- 1
- REF_ITEMRPK
- SAMPLE
- SHOP_DATER
- 2026-01-01
- REC_DATE
- 2026-01-01
- COMP_NAME
- SAMPLE
- ITEM_DESC
- SAMPLE
- COMPETITOR
- 1
- COMP_STORE
- 1
- OFFER_TYPE
- SAMPLE
- COMP_RETAIL
- 1.0000
- MULTI_UNITS
- 1.0000
- PROM_END_DATE
- 2026-01-01
- COMP_STORE_NAME
- SAMPLE
- PROM_START_DATE
- 2026-01-01
- COMP_RETAIL_TYPE
- SAMPLE
- MULTI_UNIT_RETAIL
- 1.0000
default
- ITEMRPK
- Comp Shop List-002-ALT
- SHOPPERRPK
- 3
- REF_ITEMRPK
- Comp Shop List-002-ALT
- SHOP_DATER
- 2026-01-03
- REC_DATE
- 2026-01-03
- COMP_NAME
- Comp Shop List Secondary
- ITEM_DESC
- Comp Shop List-002-ALT
- COMPETITOR
- 3
- COMP_STORE
- 1003
- OFFER_TYPE
- Comp S
- COMP_RETAIL
- 12.5000
- MULTI_UNITS
- 12.5000
- PROM_END_DATE
- 2026-01-03
- COMP_STORE_NAME
- Comp Shop List Secondary
- PROM_START_DATE
- 2026-01-03
- COMP_RETAIL_TYPE
- P
- MULTI_UNIT_RETAIL
- 12.5000
default
- ITEMRPK
- Comp Shop List-003-EDGE
- SHOPPERRPK
- 5
- REF_ITEMRPK
- Comp Shop List-003-EDGE
- SHOP_DATER
- 2026-01-05
- REC_DATE
- 2026-01-05
- COMP_NAME
- Comp Shop List Core
- ITEM_DESC
- Comp Shop List-003-EDGE
- COMPETITOR
- 5
- COMP_STORE
- 1005
- OFFER_TYPE
- Comp S
- COMP_RETAIL
- 14.0000
- MULTI_UNITS
- 14.0000
- PROM_END_DATE
- 2026-01-05
- COMP_STORE_NAME
- Comp Shop List Core
- PROM_START_DATE
- 2026-01-05
- COMP_RETAIL_TYPE
- C
- MULTI_UNIT_RETAIL
- 14.0000
Rule Validation Summary
- Source Rule Count
- 39
- Governed Rule Count
- 29