Competitor Store Information
In ScopeTechnical: COMP_STORE | ID: OR-FND-COMP_STORE-COMPONENT_STORE
Stores competitor store information.
See how this object fits into Foundation Data
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_STORE
Field Definitions(5)
Rules & Considerations(28)
Sample Load Data(4)
| _scenario | STORERPK | COMPETITORR | STORE_NAMER | FAX | CITY | PHONE | STATE | ADDRESS_1 | ADDRESS_2 | ADDRESS_3 | OPEN_DATE | POST_CODE | CLOSE_DATE | COUNTRY_ID | STORE_FORMAT | CURRENCY_CODE | ESTIMATED_VOLUME | JURISDICTION_CODE | TOTAL_SQUARE_FEET | SELLING_SQUARE_FEET |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAM | 1 | SAM | 1.0000 | SAMPLE | 1 | 1 |
| default | 1003 | 3 | Comp Store Secondary | Comp Store-002-ALT | Comp Store-002-ALT | Comp Store-002-ALT | Com | Comp Store-002-ALT | Comp Store-002-ALT | Comp Store-002-ALT | 2026-01-03 | ALT-COMP_STORE-002 | 2026-01-03 | ALT | 3 | ALT | 12.5000 | ALT-COMP_S | 3 | 3 |
| default | 1005 | 5 | Comp Store Core | Comp Store-003-EDGE | Comp Store-003-EDGE | Comp Store-003-EDGE | Com | Comp Store-003-EDGE | Comp Store-003-EDGE | Comp Store-003-EDGE | 2026-01-05 | EDGE-COMP_STORE-003 | 2026-01-05 | EDG | 5 | EDG | 14.0000 | EDGE-COMP_ | 5 | 5 |
Example values from field definitions
- STORERPK
- 1
- COMPETITORR
- 1
- STORE_NAMER
- SAMPLE
- FAX
- SAMPLE
- CITY
- SAMPLE
- PHONE
- SAMPLE
- STATE
- SAM
- ADDRESS_1
- SAMPLE
- ADDRESS_2
- SAMPLE
- ADDRESS_3
- SAMPLE
- OPEN_DATE
- 2026-01-01
- POST_CODE
- SAMPLE
- CLOSE_DATE
- 2026-01-01
- COUNTRY_ID
- SAM
- STORE_FORMAT
- 1
- CURRENCY_CODE
- SAM
- ESTIMATED_VOLUME
- 1.0000
- JURISDICTION_CODE
- SAMPLE
- TOTAL_SQUARE_FEET
- 1
- SELLING_SQUARE_FEET
- 1
default
- STORERPK
- 1003
- COMPETITORR
- 3
- STORE_NAMER
- Comp Store Secondary
- FAX
- Comp Store-002-ALT
- CITY
- Comp Store-002-ALT
- PHONE
- Comp Store-002-ALT
- STATE
- Com
- ADDRESS_1
- Comp Store-002-ALT
- ADDRESS_2
- Comp Store-002-ALT
- ADDRESS_3
- Comp Store-002-ALT
- OPEN_DATE
- 2026-01-03
- POST_CODE
- ALT-COMP_STORE-002
- CLOSE_DATE
- 2026-01-03
- COUNTRY_ID
- ALT
- STORE_FORMAT
- 3
- CURRENCY_CODE
- ALT
- ESTIMATED_VOLUME
- 12.5000
- JURISDICTION_CODE
- ALT-COMP_S
- TOTAL_SQUARE_FEET
- 3
- SELLING_SQUARE_FEET
- 3
default
- STORERPK
- 1005
- COMPETITORR
- 5
- STORE_NAMER
- Comp Store Core
- FAX
- Comp Store-003-EDGE
- CITY
- Comp Store-003-EDGE
- PHONE
- Comp Store-003-EDGE
- STATE
- Com
- ADDRESS_1
- Comp Store-003-EDGE
- ADDRESS_2
- Comp Store-003-EDGE
- ADDRESS_3
- Comp Store-003-EDGE
- OPEN_DATE
- 2026-01-05
- POST_CODE
- EDGE-COMP_STORE-003
- CLOSE_DATE
- 2026-01-05
- COUNTRY_ID
- EDG
- STORE_FORMAT
- 5
- CURRENCY_CODE
- EDG
- ESTIMATED_VOLUME
- 14.0000
- JURISDICTION_CODE
- EDGE-COMP_
- TOTAL_SQUARE_FEET
- 5
- SELLING_SQUARE_FEET
- 5
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 28