ReSA Exported History

In Scope

Technical: SA_EXPORTED_HIST | ID: OR-RSA-SA_EXPORTED_HIST-RESA_EXPORTED_HISTORY

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

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_EXPORTED_HIST

Field Definitions(5)

Rules & Considerations(17)

constraint

validation

Sample Load Data(4)

_scenario	DAYR	STORER	EXPORT_SEQ_NOR	STORE_DAY_SEQ_NOR	STATUS	ACCT_PERIOD	SYSTEM_CODE	TRAN_SEQ_NO	EXP_DATETIME	TOTAL_SEQ_NO	HIST_WRITTEN_DATE
Example values from field definitions	1	1	1	1	S	SAMPLE	SAMPLE	1	2026-01-01	1	2026-01-01
default	3	1003	4	4	P	SA Exported Hist-002-ALT	ALT-SA	4	2026-01-03	4	2026-01-03
default	5	1005	6	6	A	SA Exported Hist-003-EDGE	EDGE-S	6	2026-01-05	6	2026-01-05

Example values from field definitions

DAYR: 1
STORER: 1
EXPORT_SEQ_NOR: 1
STORE_DAY_SEQ_NOR: 1
STATUS: S
ACCT_PERIOD: SAMPLE
SYSTEM_CODE: SAMPLE
TRAN_SEQ_NO: 1
EXP_DATETIME: 2026-01-01
TOTAL_SEQ_NO: 1
HIST_WRITTEN_DATE: 2026-01-01

default

DAYR: 3
STORER: 1003
EXPORT_SEQ_NOR: 4
STORE_DAY_SEQ_NOR: 4
STATUS: P
ACCT_PERIOD: SA Exported Hist-002-ALT
SYSTEM_CODE: ALT-SA
TRAN_SEQ_NO: 4
EXP_DATETIME: 2026-01-03
TOTAL_SEQ_NO: 4
HIST_WRITTEN_DATE: 2026-01-03