ReSA Store Day History

In Scope

Technical: SA_STORE_DAY_HIST | ID: OR-RSA-SA_STORE_DAY_HIST-RESA_STORE_DAY_HISTORY

Stores historical records for SA store day 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_STORE_DAY_HIST

Field Definitions(5)

Rules & Considerations(22)

validation

constraint

Sample Load Data(4)

_scenario	DAYR	STORER	BUSINESS_DATER	INV_BUS_DATE_INDR	STORE_DAY_SEQ_NOR	AUTO_CLOSED	DATA_STATUS	AUDIT_STATUS	FILES_LOADED	STORE_STATUS	INV_STORE_IND	OMS_FILES_LOADED	HIST_WRITTEN_DATE	TRANSACTIONS_LOADED	STORE_CLOSED_DATETIME	AUDIT_CHANGED_DATETIME
Example values from field definitions	1	1	2026-01-01	S	1	S	SAMPLE	SAMPLE	1	SAMPLE	S	1	2026-01-01	1	2026-01-01	2026-01-01
default	3	1003	2026-01-03	2	4	N	PENDIN	PENDIN	3	PENDIN	S	3	2026-01-03	3	2026-01-03	2026-01-03
default	5	1005	2026-01-05	2	6	Y	ACTIVE	ACTIVE	5	ACTIVE	S	5	2026-01-05	5	2026-01-05	2026-01-05

Example values from field definitions

DAYR: 1
STORER: 1
BUSINESS_DATER: 2026-01-01
INV_BUS_DATE_INDR: S
STORE_DAY_SEQ_NOR: 1
AUTO_CLOSED: S
DATA_STATUS: SAMPLE
AUDIT_STATUS: SAMPLE
FILES_LOADED: 1
STORE_STATUS: SAMPLE
INV_STORE_IND: S
OMS_FILES_LOADED: 1
HIST_WRITTEN_DATE: 2026-01-01
TRANSACTIONS_LOADED: 1
STORE_CLOSED_DATETIME: 2026-01-01
AUDIT_CHANGED_DATETIME: 2026-01-01

default

DAYR: 3
STORER: 1003
BUSINESS_DATER: 2026-01-03
INV_BUS_DATE_INDR: 2
STORE_DAY_SEQ_NOR: 4
AUTO_CLOSED: N
DATA_STATUS: PENDIN
AUDIT_STATUS: PENDIN
FILES_LOADED: 3
STORE_STATUS: PENDIN
INV_STORE_IND: S
OMS_FILES_LOADED: 3
HIST_WRITTEN_DATE: 2026-01-03
TRANSACTIONS_LOADED: 3
STORE_CLOSED_DATETIME: 2026-01-03
AUDIT_CHANGED_DATETIME: 2026-01-03