SA Store Day
In ScopeTechnical: SA_STORE_DAY | ID: OR-MFCS-SA_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
Target Structure
- Load Approach
- Table
- Target Objects
- SA_STORE_DAY
Field Definitions(15)
Rules & Considerations(49)
Sample Load Data(4)
| _scenario | DAYR | STORER | DATA_STATUSR | AUDIT_STATUSR | STORE_STATUSR | BUSINESS_DATER | INV_STORE_INDR | INV_BUS_DATE_INDR | STORE_DAY_SEQ_NORPK | AUTO_CLOSED | FILES_LOADED | OMS_FILES_LOADED | TRANSACTIONS_LOADED | STORE_CLOSED_DATETIME | AUDIT_CHANGED_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 001 | 1001 | R | ACTIVE | W | 2026-01-01 | SA Store Day-001 | 2026-01-01 | 2 | Y | 1 | 1 | 1 | 2026-01-01 | 2026-01-01 |
default
- DAYR
- 001
- STORER
- 1001
- DATA_STATUSR
- R
- AUDIT_STATUSR
- ACTIVE
- STORE_STATUSR
- W
- BUSINESS_DATER
- 2026-01-01
- INV_STORE_INDR
- SA Store Day-001
- INV_BUS_DATE_INDR
- 2026-01-01
- STORE_DAY_SEQ_NORPK
- 2
- AUTO_CLOSED
- Y
- FILES_LOADED
- 1
- OMS_FILES_LOADED
- 1
- TRANSACTIONS_LOADED
- 1
- STORE_CLOSED_DATETIME
- 2026-01-01
- AUDIT_CHANGED_DATETIME
- 2026-01-01