ReSA Flash Sales History

In Scope

Technical: SA_FLASH_SALES_HIST | ID: OR-RSA-SA_FLASH_SALES_HIST-RESA_FLASH_SALES_HISTORY

Stores historical records for SA flash sales 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_FLASH_SALES_HIST

Field Definitions(5)

Rules & Considerations(11)

validation

constraint

Sample Load Data(4)

_scenario	STORER	COMP_INDR	BUSINESS_DATER	WEATHER	NET_SALES	TEMPERATURE	HIST_WRITTEN_DATE	NET_SALES_SUSPENDED
Example values from field definitions	1	S	2026-01-01	SAMPLE	1.0000	1	2026-01-01	1.0000
default	1003	S	2026-01-03	SA Fla	12.5000	3	2026-01-03	12.5000
default	1005	S	2026-01-05	SA Fla	14.0000	5	2026-01-05	14.0000

Example values from field definitions

STORER: 1
COMP_INDR: S
BUSINESS_DATER: 2026-01-01
WEATHER: SAMPLE
NET_SALES: 1.0000
TEMPERATURE: 1
HIST_WRITTEN_DATE: 2026-01-01
NET_SALES_SUSPENDED: 1.0000

default

STORER: 1003
COMP_INDR: S
BUSINESS_DATER: 2026-01-03
WEATHER: SA Fla
NET_SALES: 12.5000
TEMPERATURE: 3
HIST_WRITTEN_DATE: 2026-01-03
NET_SALES_SUSPENDED: 12.5000