Relitem Export Stg

In Scope

Technical: RELITEM_EXPORT_STG | ID: OR-ITM-RELITEM_EXPORT_STG-RELITEM_EXPORT_STG

This table is a staging table for related item 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 Item Management

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

Field Definitions(5)

Rules & Considerations(17)

validation

constraint

Sample Load Data(4)

_scenario	SEQ_NORPK	ACTION_TYPER	RELATIONSHIP_IDR	ITEM	PROCESS_ID	RELATED_ITEM	BASE_EXTRACTED_IND	TRANSACTION_DATETIME	CUSTOM1_EXTRACTED_IND	CUSTOM2_EXTRACTED_IND	CUSTOM3_EXTRACTED_IND	CUSTOM4_EXTRACTED_IND
Example values from field definitions	1	SAMPLE	1	SAMPLE	1	SAMPLE	S	2026-01-01	S	S	S	S
default	4	Relitem Export	1000000003	Relitem Export Stg-002-AL	1000000003	Relitem Export Stg-002-AL	R	2026-01-03	R	R	R	R
default	6	Relitem Export	1000000005	Relitem Export Stg-003-ED	1000000005	Relitem Export Stg-003-ED	R	2026-01-05	R	R	R	R

Example values from field definitions

SEQ_NORPK: 1
ACTION_TYPER: SAMPLE
RELATIONSHIP_IDR: 1
ITEM: SAMPLE
PROCESS_ID: 1
RELATED_ITEM: 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
ACTION_TYPER: Relitem Export
RELATIONSHIP_IDR: 1000000003
ITEM: Relitem Export Stg-002-AL
PROCESS_ID: 1000000003
RELATED_ITEM: Relitem Export Stg-002-AL
BASE_EXTRACTED_IND: R
TRANSACTION_DATETIME: 2026-01-03
CUSTOM1_EXTRACTED_IND: R
CUSTOM2_EXTRACTED_IND: R
CUSTOM3_EXTRACTED_IND: R
CUSTOM4_EXTRACTED_IND: R