ReSA Store Day

In Scope

Technical: SA_STORE_DAY | ID: OR-RSA-SA_STORE_DAY-RESA_STORE_DAY

Stores the status and details for each store/day combination. Store_day_ids are generated for each that is expected to be open store/day in the Store/Day creation batch process (sastdycr.pc).

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

Field Definitions(5)

Rules & Considerations(22)

validation

constraint

Sample Load Data(4)

_scenario	DAYR	STORER	BUSINESS_DATER	INV_BUS_DATE_INDR	STORE_DAY_SEQ_NORPK	AUTO_CLOSED	DATA_STATUS	AUDIT_STATUS	FILES_LOADED	STORE_STATUS	INV_STORE_IND	OMS_FILES_LOADED	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	1	2026-01-01	2026-01-01
default	3	1003	2026-01-03	2	4	N	L	PENDIN	3	C	S	3	3	2026-01-03	2026-01-03
default	5	1005	2026-01-05	2	6	Y	P	ACTIVE	5	F	S	5	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_NORPK: 1
AUTO_CLOSED: S
DATA_STATUS: SAMPLE
AUDIT_STATUS: SAMPLE
FILES_LOADED: 1
STORE_STATUS: SAMPLE
INV_STORE_IND: S
OMS_FILES_LOADED: 1
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_NORPK: 4
AUTO_CLOSED: N
DATA_STATUS: L
AUDIT_STATUS: PENDIN
FILES_LOADED: 3
STORE_STATUS: C
INV_STORE_IND: S
OMS_FILES_LOADED: 3
TRANSACTIONS_LOADED: 3
STORE_CLOSED_DATETIME: 2026-01-03
AUDIT_CHANGED_DATETIME: 2026-01-03