Comp Store
In ScopeTechnical: COMP_STORE | ID: OR-MFCS-COMP_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
Target Structure
- Load Approach
- Table
- Target Objects
- COMP_STORE
Field Definitions(20)
Rules & Considerations(10)
Sample Load Data(4)
| _scenario | STORERPK | COMPETITORRPK | COUNTRY_IDPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 1 | STD-COMP_STORE-001 | Comp Store Primary | STD-COMP_STORE-001 | Comp Store-001 | Comp Store-001 | Comp Store-001 | Comp Store-001 | Comp Store-001 | Comp Store-001 | Comp Store-001 | 2026-01-01 | STD-COMP_STORE-001 | 2026-01-01 | 0001 | 11.0000 | STD-COMP_STORE-001 | 1 | 1 |
default
- STORERPK
- 1001
- COMPETITORRPK
- 1
- COUNTRY_IDPK
- STD-COMP_STORE-001
- STORE_NAMER
- Comp Store Primary
- CURRENCY_CODER
- STD-COMP_STORE-001
- FAX
- Comp Store-001
- CITY
- Comp Store-001
- PHONE
- Comp Store-001
- STATE
- Comp Store-001
- ADDRESS_1
- Comp Store-001
- ADDRESS_2
- Comp Store-001
- ADDRESS_3
- Comp Store-001
- OPEN_DATE
- 2026-01-01
- POST_CODE
- STD-COMP_STORE-001
- CLOSE_DATE
- 2026-01-01
- STORE_FORMAT
- 0001
- ESTIMATED_VOLUME
- 11.0000
- JURISDICTION_CODE
- STD-COMP_STORE-001
- TOTAL_SQUARE_FEET
- 1
- SELLING_SQUARE_FEET
- 1