Merchhier Export Stg

In Scope

Technical: MERCHHIER_EXPORT_STG | ID: OR-FND-MERCHHIER_EXPORT_STG-MERCHHIER_EXPORT_STG

This is table is a staging table for merchandise hierarchy records as they wait to be extracted. This table is automatically inserted into, as records are processed by Oracle Retail.

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

Field Definitions(5)

Rules & Considerations(19)

validation

constraint

Sample Load Data(4)

_scenario	SEQ_NORPK	DEPT	CLASS_ID	DIVISION	GROUP_NO	PROCESS_ID	ACTION_TYPE	SUBCLASS_ID	PARENT_LEVEL	BASE_EXTRACTED_IND	TRANSACTION_DATETIME	CUSTOM1_EXTRACTED_IND	CUSTOM2_EXTRACTED_IND	CUSTOM3_EXTRACTED_IND	CUSTOM4_EXTRACTED_IND
Example values from field definitions	1	1	1	1	1	1	SAMPLE	1	SAMPLE	S	2026-01-01	S	S	S	S
default	4	1003	1000000003	103	4	1000000003	Merchhier Expor	1000000003	Merchhier	M	2026-01-03	M	M	M	M
default	6	1005	1000000005	105	6	1000000005	Merchhier Expor	1000000005	Merchhier	M	2026-01-05	M	M	M	M

Example values from field definitions

SEQ_NORPK: 1
DEPT: 1
CLASS_ID: 1
DIVISION: 1
GROUP_NO: 1
PROCESS_ID: 1
ACTION_TYPE: SAMPLE
SUBCLASS_ID: 1
PARENT_LEVEL: SAMPLE
BASE_EXTRACTED_IND: S
TRANSACTION_DATETIME: 2026-01-01
CUSTOM1_EXTRACTED_IND: S
CUSTOM2_EXTRACTED_IND: S
CUSTOM3_EXTRACTED_IND: S
CUSTOM4_EXTRACTED_IND: S

default

SEQ_NORPK: 4
DEPT: 1003
CLASS_ID: 1000000003
DIVISION: 103
GROUP_NO: 4
PROCESS_ID: 1000000003
ACTION_TYPE: Merchhier Expor
SUBCLASS_ID: 1000000003
PARENT_LEVEL: Merchhier
BASE_EXTRACTED_IND: M
TRANSACTION_DATETIME: 2026-01-03
CUSTOM1_EXTRACTED_IND: M
CUSTOM2_EXTRACTED_IND: M
CUSTOM3_EXTRACTED_IND: M
CUSTOM4_EXTRACTED_IND: M