ReSA Total History

In Scope

Technical: SA_TOTAL_HIST | ID: OR-RSA-SA_TOTAL_HIST-RESA_TOTAL_HISTORY

Stores historical records for SA total 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_TOTAL_HIST

Field Definitions(5)

Rules & Considerations(21)

constraint

validation

Sample Load Data(4)

_scenario	DAYR	STORER	TOTAL_IDR	TOTAL_SEQ_NOR	STORE_DAY_SEQ_NOR	STATUS	REF_NO1	REF_NO2	REF_NO3	ERROR_IND	DISPLAY_ORDER	BAL_GROUP_SEQ_NO	HIST_WRITTEN_DATE
Example values from field definitions	1	1	SAMPLE	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	1	2026-01-01
default	3	1003	ALT-SA_TOT	4	4	PENDIN	SA Total Hist-002-ALT	SA Total Hist-002-ALT	SA Total Hist-002-ALT	S	SA Tot	4	2026-01-03
default	5	1005	EDGE-SA_TO	6	6	ACTIVE	SA Total Hist-003-EDGE	SA Total Hist-003-EDGE	SA Total Hist-003-EDGE	S	SA Tot	6	2026-01-05

Example values from field definitions

DAYR: 1
STORER: 1
TOTAL_IDR: SAMPLE
TOTAL_SEQ_NOR: 1
STORE_DAY_SEQ_NOR: 1
STATUS: SAMPLE
REF_NO1: SAMPLE
REF_NO2: SAMPLE
REF_NO3: SAMPLE
ERROR_IND: S
DISPLAY_ORDER: SAMPLE
BAL_GROUP_SEQ_NO: 1
HIST_WRITTEN_DATE: 2026-01-01

default

DAYR: 3
STORER: 1003
TOTAL_IDR: ALT-SA_TOT
TOTAL_SEQ_NOR: 4
STORE_DAY_SEQ_NOR: 4
STATUS: PENDIN
REF_NO1: SA Total Hist-002-ALT
REF_NO2: SA Total Hist-002-ALT
REF_NO3: SA Total Hist-002-ALT
ERROR_IND: S
DISPLAY_ORDER: SA Tot
BAL_GROUP_SEQ_NO: 4
HIST_WRITTEN_DATE: 2026-01-03