Vat Export Stg

In Scope

Technical: VAT_EXPORT_STG | ID: OR-ITM-VAT_EXPORT_STG-VAT_EXPORT_STG

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

Field Definitions(5)

Rules & Considerations(18)

validation

constraint

Sample Load Data(4)

_scenario	SEQ_NORPK	VAT_CODER	VAT_REGIONR	ACTION_TYPER	ACTIVE_DATER	PROCESS_ID	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	2026-01-01	1	S	2026-01-01	S	S	S	S
default	4	ALT-VA	203	Vat Export Stg-	2026-01-03	1000000003	V	2026-01-03	V	V	V	V
default	6	EDGE-V	205	Vat Export Stg-	2026-01-05	1000000005	V	2026-01-05	V	V	V	V

Example values from field definitions

SEQ_NORPK: 1
VAT_CODER: SAMPLE
VAT_REGIONR: 1
ACTION_TYPER: SAMPLE
ACTIVE_DATER: 2026-01-01
PROCESS_ID: 1
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
VAT_CODER: ALT-VA
VAT_REGIONR: 203
ACTION_TYPER: Vat Export Stg-
ACTIVE_DATER: 2026-01-03
PROCESS_ID: 1000000003
BASE_EXTRACTED_IND: V
TRANSACTION_DATETIME: 2026-01-03
CUSTOM1_EXTRACTED_IND: V
CUSTOM2_EXTRACTED_IND: V
CUSTOM3_EXTRACTED_IND: V
CUSTOM4_EXTRACTED_IND: V