Chain
In ScopeTechnical: CHAIN | ID: OR-FND-CHAIN-CHAIN
Stores one row for each chain and/or format of a store within a company. It is the first level of the organization hierarchy below company.
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
- CHAIN
Field Definitions(5)
Rules & Considerations(17)
validation
constraint
Sample Load Data(4)
| _scenario | CHAINRPK | CREATE_IDR | CHAIN_NAMER | MGR_NAME | IMAGE_URL | CURRENCY_CODE | LAST_UPDATE_ID | CREATE_DATETIME | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | 13 | APP_USER_ID | Chain Secondary | Chain Secondary | Chain-002-ALT | ALT | APP_USER_ID | 2026-01-03 | 2026-01-03 |
| default | 15 | USERENV | Chain Core | Chain Core | Chain-003-EDGE | EDG | USERENV | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- CHAINRPK
- 1
- CREATE_IDR
- SAMPLE
- CHAIN_NAMER
- SAMPLE
- MGR_NAME
- SAMPLE
- IMAGE_URL
- SAMPLE
- CURRENCY_CODE
- SAM
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- CHAINRPK
- 13
- CREATE_IDR
- APP_USER_ID
- CHAIN_NAMER
- Chain Secondary
- MGR_NAME
- Chain Secondary
- IMAGE_URL
- Chain-002-ALT
- CURRENCY_CODE
- ALT
- LAST_UPDATE_ID
- APP_USER_ID
- CREATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- CHAINRPK
- 15
- CREATE_IDR
- USERENV
- CHAIN_NAMER
- Chain Core
- MGR_NAME
- Chain Core
- IMAGE_URL
- Chain-003-EDGE
- CURRENCY_CODE
- EDG
- LAST_UPDATE_ID
- USERENV
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 28
- Governed Rule Count
- 17