ReSA Transaction Header Attribute History

In Scope

Technical: SA_TRAN_HEAD_ATTRIB_HIST | ID: OR-RSA-SA_TRAN_HEAD_ATTRIB_HIST-RESA_TRANSACTION_HEADER_ATTRIBUTE_HISTORY

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

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_HEAD_ATTRIB_HIST

Field Definitions(5)

Rules & Considerations(14)

validation

constraint

Sample Load Data(4)

_scenario	DAYR	STORER	ATTRIB_TYPER	TRAN_SEQ_NOR	ATTRIB_SEQ_NOR	ERROR_IND	ATTRIB_VALUE	HIST_WRITTEN_DATE
Example values from field definitions	1	1	SAMPLE	1	1	S	SAMPLE	2026-01-01
default	3	1003	SA Tra	4	4	S	SA Tran Head Attrib Hist-002-ALT	2026-01-03
default	5	1005	SA Tra	6	6	S	SA Tran Head Attrib Hist-003-EDGE	2026-01-05

Example values from field definitions

DAYR: 1
STORER: 1
ATTRIB_TYPER: SAMPLE
TRAN_SEQ_NOR: 1
ATTRIB_SEQ_NOR: 1
ERROR_IND: S
ATTRIB_VALUE: SAMPLE
HIST_WRITTEN_DATE: 2026-01-01

default

DAYR: 3
STORER: 1003
ATTRIB_TYPER: SA Tra
TRAN_SEQ_NOR: 4
ATTRIB_SEQ_NOR: 4
ERROR_IND: S
ATTRIB_VALUE: SA Tran Head Attrib Hist-002-ALT
HIST_WRITTEN_DATE: 2026-01-03