ReSA Transaction Tax History

In Scope

Technical: SA_TRAN_TAX_HIST | ID: OR-RSA-SA_TRAN_TAX_HIST-RESA_TRANSACTION_TAX_HISTORY

Stores historical records for SA tran tax 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_TAX_HIST

Field Definitions(5)

Rules & Considerations(19)

validation

constraint

Sample Load Data(4)

_scenario	DAYR	STORER	TAX_CODER	TAX_SEQ_NOR	TRAN_SEQ_NOR	TAX_AMT	REF_NO17	REF_NO18	REF_NO19	REF_NO20	ERROR_IND	HIST_WRITTEN_DATE
Example values from field definitions	1	1	SAMPLE	1	1	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	2026-01-01
default	3	1003	ALT-SA	4	4	12.5000	SA Tran Tax Hist-002-ALT	SA Tran Tax Hist-002-ALT	SA Tran Tax Hist-002-ALT	SA Tran Tax Hist-002-ALT	S	2026-01-03
default	5	1005	EDGE-S	6	6	14.0000	SA Tran Tax Hist-003-EDGE	SA Tran Tax Hist-003-EDGE	SA Tran Tax Hist-003-EDGE	SA Tran Tax Hist-003-EDGE	S	2026-01-05

Example values from field definitions

DAYR: 1
STORER: 1
TAX_CODER: SAMPLE
TAX_SEQ_NOR: 1
TRAN_SEQ_NOR: 1
TAX_AMT: 1.0000
REF_NO17: SAMPLE
REF_NO18: SAMPLE
REF_NO19: SAMPLE
REF_NO20: SAMPLE
ERROR_IND: S
HIST_WRITTEN_DATE: 2026-01-01

default

DAYR: 3
STORER: 1003
TAX_CODER: ALT-SA
TAX_SEQ_NOR: 4
TRAN_SEQ_NOR: 4
TAX_AMT: 12.5000
REF_NO17: SA Tran Tax Hist-002-ALT
REF_NO18: SA Tran Tax Hist-002-ALT
REF_NO19: SA Tran Tax Hist-002-ALT
REF_NO20: SA Tran Tax Hist-002-ALT
ERROR_IND: S
HIST_WRITTEN_DATE: 2026-01-03