Division
In ScopeTechnical: DIVISION | ID: OR-MFCS-DIVISION
Stores one row for each division within the company. Whenever a division name is used by Oracle Retail, or a division number is validated, it is always selected from this…
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
- DIVISION
Field Definitions(9)
Rules & Considerations(14)
Sample Load Data(4)
| _scenario | BUYERPK | MERCHPK | DIVISIONRPK | DIV_NAMER | CREATE_IDR | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | TOTAL_MARKET_AMT |
|---|---|---|---|---|---|---|---|---|---|
| default | 0001 | 0001 | 0101 | Division Primary | USERENV | RETAIL_CTX | 2026-01-01 | 2026-01-01 | 11.0000 |
default
- BUYERPK
- 0001
- MERCHPK
- 0001
- DIVISIONRPK
- 0101
- DIV_NAMER
- Division Primary
- CREATE_IDR
- USERENV
- LAST_UPDATE_IDR
- RETAIL_CTX
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- TOTAL_MARKET_AMT
- 11.0000