ReSA System Value History

In Scope

Technical: SA_SYS_VALUE_HIST | ID: OR-RSA-SA_SYS_VALUE_HIST-RESA_SYSTEM_VALUE_HISTORY

Stores historical records for SA sys value 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_SYS_VALUE_HIST

Field Definitions(5)

Rules & Considerations(16)

validation

constraint

Sample Load Data(4)

_scenario	DAYR	STORER	SYS_VALUER	TOTAL_SEQ_NOR	VALUE_REV_NOR	UPDATE_ID	TOTAL_REV_NO	CREATE_DATETIME	UPDATE_DATETIME	HIST_WRITTEN_DATE
Example values from field definitions	1	1	1.0000	1	1	SAMPLE	1	2026-01-01	2026-01-01	2026-01-01
default	3	1003	12.5000	4	4	MDM_USER	4	2026-01-03	2026-01-03	2026-01-03
default	5	1005	14.0000	6	6	BATCH_USER	6	2026-01-05	2026-01-05	2026-01-05

Example values from field definitions

DAYR: 1
STORER: 1
SYS_VALUER: 1.0000
TOTAL_SEQ_NOR: 1
VALUE_REV_NOR: 1
UPDATE_ID: SAMPLE
TOTAL_REV_NO: 1
CREATE_DATETIME: 2026-01-01
UPDATE_DATETIME: 2026-01-01
HIST_WRITTEN_DATE: 2026-01-01

default

DAYR: 3
STORER: 1003
SYS_VALUER: 12.5000
TOTAL_SEQ_NOR: 4
VALUE_REV_NOR: 4
UPDATE_ID: MDM_USER
TOTAL_REV_NO: 4
CREATE_DATETIME: 2026-01-03
UPDATE_DATETIME: 2026-01-03
HIST_WRITTEN_DATE: 2026-01-03