Stake Product Location

In Scope

Technical: STAKE_PROD_LOC | ID: OR-FND-STAKE_PROD_LOC-STAKE_PRODUCT_LOCATION

Stores a row for each dept/class/subclass location combination in the company for which a Physical Inventory is scheduled. The location can be specified at any level, i.e.

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: STAKE_PROD_LOC

Field Definitions(5)

Rules & Considerations(40)

validation

constraint

Sample Load Data(4)

_scenario	DEPTRPK	CLASSRPK	LOC_TYPERPK	SUBCLASSRPK	CYCLE_COUNTRPK	LOCATION	CREATE_ID	PROCESSED	TOTAL_COST	ADJUST_COST	TOTAL_RETAIL	ADJUST_RETAIL	LAST_UPDATE_ID	CREATE_DATETIME	LAST_UPDATE_DATETIME
Example values from field definitions	1	1	S	1	1	1	SAMPLE	S	1.0000	1.0000	1.0000	1.0000	SAMPLE	2026-01-01	2026-01-01
default	1003	1103	W	1113	3	3	C LIENT_INFO	S	12.5000	12.5000	12.5000	12.5000	C LIENT_INFO	2026-01-03	2026-01-03
default	1005	1105	E	1115	5	5	SESSI ON_USER	S	14.0000	14.0000	14.0000	14.0000	SESSI ON_USER	2026-01-05	2026-01-05

Example values from field definitions

DEPTRPK: 1
CLASSRPK: 1
LOC_TYPERPK: S
SUBCLASSRPK: 1
CYCLE_COUNTRPK: 1
LOCATION: 1
CREATE_ID: SAMPLE
PROCESSED: S
TOTAL_COST: 1.0000
ADJUST_COST: 1.0000
TOTAL_RETAIL: 1.0000
ADJUST_RETAIL: 1.0000
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
LAST_UPDATE_DATETIME: 2026-01-01

default

DEPTRPK: 1003
CLASSRPK: 1103
LOC_TYPERPK: W
SUBCLASSRPK: 1113
CYCLE_COUNTRPK: 3
LOCATION: 3
CREATE_ID: C LIENT_INFO
PROCESSED: S
TOTAL_COST: 12.5000
ADJUST_COST: 12.5000
TOTAL_RETAIL: 12.5000
ADJUST_RETAIL: 12.5000
LAST_UPDATE_ID: C LIENT_INFO
CREATE_DATETIME: 2026-01-03
LAST_UPDATE_DATETIME: 2026-01-03