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(20)
Rules & Considerations(26)
Sample Load Data(4)
| _scenario | STORERPK | COMPETITORRPK | COUNTRY_IDRPK | STORE_NAMER | CURRENCY_CODER | FAX | CITY | PHONE | STATE | ADDRESS_1 | ADDRESS_2 | ADDRESS_3 | OPEN_DATE | POST_CODE | CLOSE_DATE | STORE_FORMAT | ESTIMATED_VOLUME | JURISDICTION_CODE | TOTAL_SQUARE_FEET | SELLING_SQUARE_FEET |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAM | SAMPLE | SAM | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | 1 | 1.0000 | SAMPLE | 1 | 1 |
Example values from field definitions
- STORERPK
- 1
- COMPETITORRPK
- 1
- COUNTRY_IDRPK
- SAM
- STORE_NAMER
- SAMPLE
- CURRENCY_CODER
- SAM
- 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
- STORE_FORMAT
- 1
- ESTIMATED_VOLUME
- 1.0000
- JURISDICTION_CODE
- SAMPLE
- TOTAL_SQUARE_FEET
- 1
- SELLING_SQUARE_FEET
- 1
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 26