ReSA Transaction Igtax History

In Scope

Technical: SA_TRAN_IGTAX_HIST | ID: OR-RSA-SA_TRAN_IGTAX_HIST-RESA_TRANSACTION_IGTAX_HISTORY

Stores historical records for SA tran igtax hist in Oracle Retail Merchandising, preserving prior states, events, or transaction outcomes over time. Used for auditability, reporting, reconciliation, and traceability of sales...

See how this object fits into Sales Audit

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

Field Definitions(5)

Rules & Considerations(27)

validation

constraint

Sample Load Data(4)

_scenario	DAYR	STORER	ITEM_SEQ_NOR	TRAN_SEQ_NOR	IGTAX_SEQ_NOR	REF_NO21	REF_NO22	REF_NO23	REF_NO24	ERROR_IND	IGTAX_CODE	IGTAX_RATE	STANDARD_QTY	TAX_AUTHORITY	TAX_CALC_TYPE	TOTAL_IGTAX_AMT	HIST_WRITTEN_DATE	STANDARD_UNIT_IGTAX_AMT
Example values from field definitions	1	1	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	1.0000	1.0000	SAMPLE	SAMPLE	1.0000	2026-01-01	1.0000
default	3	1003	4	4	4	SA Tran Igtax Hist-002-ALT	SA Tran Igtax Hist-002-ALT	SA Tran Igtax Hist-002-ALT	SA Tran Igtax Hist-002-ALT	S	ALT-SA	12.5000	12.5000	SA Tran Ig	SA Tra	12.5000	2026-01-03	12.5000
default	5	1005	6	6	6	SA Tran Igtax Hist-003-EDGE	SA Tran Igtax Hist-003-EDGE	SA Tran Igtax Hist-003-EDGE	SA Tran Igtax Hist-003-EDGE	S	EDGE-S	14.0000	14.0000	SA Tran Ig	SA Tra	14.0000	2026-01-05	14.0000

Example values from field definitions

DAYR: 1
STORER: 1
ITEM_SEQ_NOR: 1
TRAN_SEQ_NOR: 1
IGTAX_SEQ_NOR: 1
REF_NO21: SAMPLE
REF_NO22: SAMPLE
REF_NO23: SAMPLE
REF_NO24: SAMPLE
ERROR_IND: S
IGTAX_CODE: SAMPLE
IGTAX_RATE: 1.0000
STANDARD_QTY: 1.0000
TAX_AUTHORITY: SAMPLE
TAX_CALC_TYPE: SAMPLE
TOTAL_IGTAX_AMT: 1.0000
HIST_WRITTEN_DATE: 2026-01-01
STANDARD_UNIT_IGTAX_AMT: 1.0000

default

DAYR: 3
STORER: 1003
ITEM_SEQ_NOR: 4
TRAN_SEQ_NOR: 4
IGTAX_SEQ_NOR: 4
REF_NO21: SA Tran Igtax Hist-002-ALT
REF_NO22: SA Tran Igtax Hist-002-ALT
REF_NO23: SA Tran Igtax Hist-002-ALT
REF_NO24: SA Tran Igtax Hist-002-ALT
ERROR_IND: S
IGTAX_CODE: ALT-SA
IGTAX_RATE: 12.5000
STANDARD_QTY: 12.5000
TAX_AUTHORITY: SA Tran Ig
TAX_CALC_TYPE: SA Tra
TOTAL_IGTAX_AMT: 12.5000
HIST_WRITTEN_DATE: 2026-01-03
STANDARD_UNIT_IGTAX_AMT: 12.5000