Diffgrp Export Stg

In Scope

Technical: DIFFGRP_EXPORT_STG | ID: OR-ITM-DIFFGRP_EXPORT_STG-DIFFGRP_EXPORT_STG

This is table is a staging table for differentiator group 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: DIFFGRP_EXPORT_STG

Field Definitions(5)

Rules & Considerations(16)

validation

constraint

Sample Load Data(4)

_scenario	SEQ_NORPK	ACTION_TYPER	DIFF_GROUP_IDR	BASE_EXTRACTED_INDR	DIFF_ID	PROCESS_ID	TRANSACTION_DATETIME	CUSTOM1_EXTRACTED_IND	CUSTOM2_EXTRACTED_IND	CUSTOM3_EXTRACTED_IND	CUSTOM4_EXTRACTED_IND
Example values from field definitions	1	SAMPLE	SAMPLE	S	SAMPLE	1	2026-01-01	S	S	S	S
default	4	Diffgrp Export	ALT-DIFFGR	D	ALT-DIFFGR	1000000003	2026-01-03	D	D	D	D
default	6	Diffgrp Export	EDGE-DIFFG	D	EDGE-DIFFG	1000000005	2026-01-05	D	D	D	D

Example values from field definitions

SEQ_NORPK: 1
ACTION_TYPER: SAMPLE
DIFF_GROUP_IDR: SAMPLE
BASE_EXTRACTED_INDR: S
DIFF_ID: SAMPLE
PROCESS_ID: 1
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: Diffgrp Export
DIFF_GROUP_IDR: ALT-DIFFGR
BASE_EXTRACTED_INDR: D
DIFF_ID: ALT-DIFFGR
PROCESS_ID: 1000000003
TRANSACTION_DATETIME: 2026-01-03
CUSTOM1_EXTRACTED_IND: D
CUSTOM2_EXTRACTED_IND: D
CUSTOM3_EXTRACTED_IND: D
CUSTOM4_EXTRACTED_IND: D