Item Export Stg

In Scope

Technical: ITEM_EXPORT_STG | ID: OR-ITM-ITEM_EXPORT_STG-ITEM_EXPORT_STG

This is table is a staging table for 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: ITEM_EXPORT_STG

Field Definitions(5)

Rules & Considerations(25)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	SEQ_NORPK	LOC	LOC_TYPE	VAT_CODE	VAT_TYPE	ITEM_LEVEL	PROCESS_ID	TRAN_LEVEL	VAT_REGION	ACTION_TYPE	ITEM_PARENT	MERCHANDISE_IND	VAT_ACTIVE_DATE	ITEM_GRANDPARENT	BASE_EXTRACTED_IND	TRANSACTION_DATETIME	CUSTOM1_EXTRACTED_IND	CUSTOM2_EXTRACTED_IND	CUSTOM3_EXTRACTED_IND	CUSTOM4_EXTRACTED_IND
Example values from field definitions	SAMPLE	1	1	S	SAMPLE	S	1	1	1	1	SAMPLE	SAMPLE	S	2026-01-01	SAMPLE	S	2026-01-01	S	S	S	S
default	Item Export Stg-002-ALT	4	3	I	ALT-IT	I	3	1000000003	3	203	Item Export Stg	Item Export Stg-002-ALT	I	2026-01-03	Item Export Stg-002-ALT	I	2026-01-03	I	I	I	I
default	Item Export Stg-003-EDGE	6	5	I	EDGE-I	I	5	1000000005	5	205	Item Export Stg	Item Export Stg-003-EDGE	I	2026-01-05	Item Export Stg-003-EDGE	I	2026-01-05	I	I	I	I

Example values from field definitions

ITEMR: SAMPLE
SEQ_NORPK: 1
LOC: 1
LOC_TYPE: S
VAT_CODE: SAMPLE
VAT_TYPE: S
ITEM_LEVEL: 1
PROCESS_ID: 1
TRAN_LEVEL: 1
VAT_REGION: 1
ACTION_TYPE: SAMPLE
ITEM_PARENT: SAMPLE
MERCHANDISE_IND: S
VAT_ACTIVE_DATE: 2026-01-01
ITEM_GRANDPARENT: 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

ITEMR: Item Export Stg-002-ALT
SEQ_NORPK: 4
LOC: 3
LOC_TYPE: I
VAT_CODE: ALT-IT
VAT_TYPE: I
ITEM_LEVEL: 3
PROCESS_ID: 1000000003
TRAN_LEVEL: 3
VAT_REGION: 203
ACTION_TYPE: Item Export Stg
ITEM_PARENT: Item Export Stg-002-ALT
MERCHANDISE_IND: I
VAT_ACTIVE_DATE: 2026-01-03
ITEM_GRANDPARENT: Item Export Stg-002-ALT
BASE_EXTRACTED_IND: I
TRANSACTION_DATETIME: 2026-01-03
CUSTOM1_EXTRACTED_IND: I
CUSTOM2_EXTRACTED_IND: I
CUSTOM3_EXTRACTED_IND: I
CUSTOM4_EXTRACTED_IND: I