ReSA Customer History

In Scope

Technical: SA_CUSTOMER_HIST | ID: OR-RSA-SA_CUSTOMER_HIST-RESA_CUSTOMER_HISTORY

Stores historical records for SA customer hist in Oracle Retail Merchandising, preserving prior states, events, or transaction outcomes over time. Used for auditability, reporting, reconciliation, and traceability of sales audit...

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_CUSTOMER_HIST

Field Definitions(5)

Rules & Considerations(21)

constraint

validation

Sample Load Data(4)

_scenario	DAYR	STORER	CUST_IDR	TRAN_SEQ_NOR	CUST_ID_TYPER	CITY	NAME	ADDR1	ADDR2	STATE	E_MAIL	COUNTRY	BIRTHDATE	HOME_PHONE	WORK_PHONE	POSTAL_CODE	HIST_WRITTEN_DATE
Example values from field definitions	1	1	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAM	SAMPLE	SAM	2026-01-01	SAMPLE	SAMPLE	SAMPLE	2026-01-01
default	3	1003	ALT-SA_CUSTOME-0	4	SA Cus	SA Customer Hist-002-ALT	SA Customer Hist-002-ALT	SA Customer Hist-002-ALT	SA Customer Hist-002-ALT	SA	SA Customer Hist-002-ALT	SA	2026-01-03	SA Customer Hist-002	SA Customer Hist-002	ALT-SA_CUSTOME-002	2026-01-03
default	5	1005	EDGE-SA_CUSTOME-	6	SA Cus	SA Customer Hist-003-EDGE	SA Customer Hist-003-EDGE	SA Customer Hist-003-EDGE	SA Customer Hist-003-EDGE	SA	SA Customer Hist-003-EDGE	SA	2026-01-05	SA Customer Hist-003	SA Customer Hist-003	EDGE-SA_CUSTOME-003	2026-01-05

Example values from field definitions

DAYR: 1
STORER: 1
CUST_IDR: SAMPLE
TRAN_SEQ_NOR: 1
CUST_ID_TYPER: SAMPLE
CITY: SAMPLE
NAME: SAMPLE
ADDR1: SAMPLE
ADDR2: SAMPLE
STATE: SAM
E_MAIL: SAMPLE
COUNTRY: SAM
BIRTHDATE: 2026-01-01
HOME_PHONE: SAMPLE
WORK_PHONE: SAMPLE
POSTAL_CODE: SAMPLE
HIST_WRITTEN_DATE: 2026-01-01

default

DAYR: 3
STORER: 1003
CUST_IDR: ALT-SA_CUSTOME-0
TRAN_SEQ_NOR: 4
CUST_ID_TYPER: SA Cus
CITY: SA Customer Hist-002-ALT
NAME: SA Customer Hist-002-ALT
ADDR1: SA Customer Hist-002-ALT
ADDR2: SA Customer Hist-002-ALT
STATE: SA
E_MAIL: SA Customer Hist-002-ALT
COUNTRY: SA
BIRTHDATE: 2026-01-03
HOME_PHONE: SA Customer Hist-002
WORK_PHONE: SA Customer Hist-002
POSTAL_CODE: ALT-SA_CUSTOME-002
HIST_WRITTEN_DATE: 2026-01-03