Store Hierarchy

In Scope

Technical: STORE_HIERARCHY | ID: OR-MFCS-STORE_HIERARCHY

Stores one row for each store in the system, along with the organizational hierarhcy information. This table is updated as entities move their positions within the 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

Target Structure

Load Approach
Table
Target Objects
STORE_HIERARCHY

Field Definitions(8)

Rules & Considerations(13)

Sample Load Data(4)

default

AREAR
101
CHAINR
11
STORER
1001
REGIONR
201
COMPANYRPK
0001
DISTRICTR
301
CREATE_IDR
USERENV
CREATE_DATETIMER
2026-01-01
Store Hierarchy | undefined | Oracle Retail