One Row For Each Department

In Scope

Technical: 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(5)

Rules & Considerations(41)

constraint

validation

Sample Load Data(4)

_scenario	DEPTRPK	DEPT_NAMER	PROFIT_CALC_TYPER	BUYER	MERCH	BUD_INT	BUD_MKUP	GROUP_NO	CREATE_ID	OTB_CALC_TYPE	PURCHASE_TYPE	LAST_UPDATE_ID	CREATE_DATETIME	MAX_AVG_COUNTER	MARKUP_CALC_TYPE	TOTAL_MARKET_AMT	AVG_TOLERANCE_PCT	DEPT_VAT_INCL_IND	LAST_UPDATE_DATETIME	INVENTORY_LAYER_IDENTIFIER_TYPE
Example values from field definitions	1	SAMPLE	1	1	1	1.0000	1.0000	1	SAMPLE	S	1	SAMPLE	2026-01-01	1	SA	1.0000	1.0000	S	2026-01-01	SAMPLE
default	1003	Footwear	2	3	3	12.5000	12.5000	4	C LIENT_INFO	R	1	APP_USER_ID	2026-01-03	3	R	12.5000	12.5000	D	2026-01-03	E
default	1005	Beauty	1	5	5	14.0000	14.0000	6	USE RENV	C	2	USERENV	2026-01-05	5	C	14.0000	14.0000	D	2026-01-05	S

Example values from field definitions

DEPTRPK: 1
DEPT_NAMER: SAMPLE
PROFIT_CALC_TYPER: 1
BUYER: 1
MERCH: 1
BUD_INT: 1.0000
BUD_MKUP: 1.0000
GROUP_NO: 1
CREATE_ID: SAMPLE
OTB_CALC_TYPE: S
PURCHASE_TYPE: 1
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
MAX_AVG_COUNTER: 1
MARKUP_CALC_TYPE: SA
TOTAL_MARKET_AMT: 1.0000
AVG_TOLERANCE_PCT: 1.0000
DEPT_VAT_INCL_IND: S
LAST_UPDATE_DATETIME: 2026-01-01
INVENTORY_LAYER_IDENTIFIER_TYPE: SAMPLE

default

DEPTRPK: 1003
DEPT_NAMER: Footwear
PROFIT_CALC_TYPER: 2
BUYER: 3
MERCH: 3
BUD_INT: 12.5000
BUD_MKUP: 12.5000
GROUP_NO: 4
CREATE_ID: C LIENT_INFO
OTB_CALC_TYPE: R
PURCHASE_TYPE: 1
LAST_UPDATE_ID: APP_USER_ID
CREATE_DATETIME: 2026-01-03
MAX_AVG_COUNTER: 3
MARKUP_CALC_TYPE: R
TOTAL_MARKET_AMT: 12.5000
AVG_TOLERANCE_PCT: 12.5000
DEPT_VAT_INCL_IND: D
LAST_UPDATE_DATETIME: 2026-01-03
INVENTORY_LAYER_IDENTIFIER_TYPE: E