One Row For Each Department
In ScopeTechnical: DEPS | ID: OR-FND-DEPS-DEPS
Stores one row for each department within the company. Whenever a department name etc., is used by Oracle Retail, or a department number is validated, it is always selected from…
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
- DEPS
Field Definitions(20)
Rules & Considerations(46)
Sample Load Data(4)
| _scenario | DEPTRPK | BUYERRPK | MERCHRPK | BUD_INTR | BUD_MKUPR | GROUP_NORPK | CREATE_IDR | DEPT_NAMER | OTB_CALC_TYPER | PURCHASE_TYPER | LAST_UPDATE_IDR | CREATE_DATETIMER | MARKUP_CALC_TYPER | PROFIT_CALC_TYPER | DEPT_VAT_INCL_INDR | LAST_UPDATE_DATETIMER | MAX_AVG_COUNTER | TOTAL_MARKET_AMT | AVG_TOLERANCE_PCT | INVENTORY_LAYER_IDENTIFIER_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | 1 | SAMPLE | SAMPLE | S | 1 | SAMPLE | 2026-01-01 | SA | 1 | S | 2026-01-01 | 1 | 1 | 1 | SAMPLE |
Example values from field definitions
- DEPTRPK
- 1
- BUYERRPK
- 1
- MERCHRPK
- 1
- BUD_INTR
- 1
- BUD_MKUPR
- 1
- GROUP_NORPK
- 1
- CREATE_IDR
- SAMPLE
- DEPT_NAMER
- SAMPLE
- OTB_CALC_TYPER
- S
- PURCHASE_TYPER
- 1
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- MARKUP_CALC_TYPER
- SA
- PROFIT_CALC_TYPER
- 1
- DEPT_VAT_INCL_INDR
- S
- LAST_UPDATE_DATETIMER
- 2026-01-01
- MAX_AVG_COUNTER
- 1
- TOTAL_MARKET_AMT
- 1
- AVG_TOLERANCE_PCT
- 1
- INVENTORY_LAYER_IDENTIFIER_TYPE
- SAMPLE