One Row For Each Geographic Area
In ScopeTechnical: AREA | ID: OR-FND-AREA-AREA
Stores one row for each geographic area within a chain. An area belongs to a chain within the organizational hierarchy.
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
- AREA
Field Definitions(5)
Rules & Considerations(20)
validation
constraint
Sample Load Data(4)
| _scenario | AREARPK | CHAINR | AREA_NAMER | MGR_NAME | CREATE_ID | CURRENCY_CODE | LAST_UPDATE_ID | CREATE_DATETIME | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | 103 | 13 | Area Secondary | Area Secondary | APP_USER_ID | ALT | APP_USER_ID | 2026-01-03 | 2026-01-03 |
| default | 105 | 15 | Area Core | Area Core | USERENV | EDG | USERENV | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- AREARPK
- 1
- CHAINR
- 1
- AREA_NAMER
- SAMPLE
- MGR_NAME
- SAMPLE
- CREATE_ID
- SAMPLE
- CURRENCY_CODE
- SAM
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- AREARPK
- 103
- CHAINR
- 13
- AREA_NAMER
- Area Secondary
- MGR_NAME
- Area Secondary
- CREATE_ID
- APP_USER_ID
- CURRENCY_CODE
- ALT
- LAST_UPDATE_ID
- APP_USER_ID
- CREATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- AREARPK
- 105
- CHAINR
- 15
- AREA_NAMER
- Area Core
- MGR_NAME
- Area Core
- CREATE_ID
- USERENV
- CURRENCY_CODE
- EDG
- LAST_UPDATE_ID
- USERENV
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 33
- Governed Rule Count
- 20