ReSA Transaction Header

In Scope

Technical: SA_TRAN_HEAD | ID: OR-RSA-SA_TRAN_HEAD-RESA_TRANSACTION_HEADER

This table will hold base level information about each transaction processed in the Oracle Retail sales audit system.

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_TRAN_HEAD

Field Definitions(5)

Rules & Considerations(61)

constraint

validation

Sample Load Data(4)

_scenario	DAYRPK	STORERPK	REV_NOR	TRAN_SEQ_NORPK	STORE_DAY_SEQ_NOR	VALUE	STATUS	CASHIER	REF_NO1	REF_NO2	REF_NO3	REF_NO4	TRAN_NO	REF_NO25	REF_NO26	REF_NO27	REF_NO28	REF_NO29	REF_NO30	REF_NO31	REGISTER	BANNER_NO	ERROR_IND	TRAN_DATE	TRAN_TYPE	UPDATE_ID	VENDOR_NO	ORIG_REG_NO	REASON_CODE	ROUNDED_AMT	SALESPERSON	DUP_TRAN_IND	ORIG_TRAN_NO	POS_TRAN_IND	SUB_TRAN_TYPE	TRAN_DATETIME	ORIG_TRAN_TYPE	PAYMENT_REF_NO	RTLOG_ORIG_SYS	VENDOR_INVC_NO	ROUNDED_OFF_AMT	UPDATE_DATETIME	TRAN_PROCESS_SYS	CREDIT_PROMOTION_ID	PROOF_OF_DELIVERY_NO
Example values from field definitions	1	1	1	1	1	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPL	1	S	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPL	SAMPLE	1.0000	SAMPLE	S	1	S	SAMPLE	2026-01-01	SAMPLE	SAMPLE	SAM	SAMPLE	1.0000	2026-01-01	SAM	1	SAMPLE
default	3	1003	4	4	4	12.5000	PENDIN	SA Tran He	SA Tran Head-002-ALT	SA Tran Head-002-ALT	SA Tran Head-002-ALT	SA Tran Head-002-ALT	4	SA Tran Head-002-ALT	SA Tran Head-002-ALT	SA Tran Head-002-ALT	SA Tran Head-002-ALT	SA Tran Head-002-ALT	SA Tran Head-002-ALT	SA Tran Head-002-ALT	SA Tr	4	S	2026-01-03	SA Tra	MDM_USER	SA Tran He	SA Tr	ALT-SA	12.5000	SA Tran He	N	4	S	SA Tra	2026-01-03	SA Tra	SA Tran Head-002	POS	SA Tran Head-002-ALT	12.5000	2026-01-03	SA	1000000003	SA Tran Head-002-ALT
default	5	1005	6	6	6	14.0000	ACTIVE	SA Tran He	SA Tran Head-003-EDGE	SA Tran Head-003-EDGE	SA Tran Head-003-EDGE	SA Tran Head-003-EDGE	6	SA Tran Head-003-EDGE	SA Tran Head-003-EDGE	SA Tran Head-003-EDGE	SA Tran Head-003-EDGE	SA Tran Head-003-EDGE	SA Tran Head-003-EDGE	SA Tran Head-003-EDGE	SA Tr	6	S	2026-01-05	SA Tra	BATCH_USER	SA Tran He	SA Tr	EDGE-S	14.0000	SA Tran He	Y	6	S	SA Tra	2026-01-05	SA Tra	SA Tran Head-003	POS	SA Tran Head-003-EDGE	14.0000	2026-01-05	SA	1000000005	SA Tran Head-003-EDGE

Example values from field definitions

DAYRPK: 1
STORERPK: 1
REV_NOR: 1
TRAN_SEQ_NORPK: 1
STORE_DAY_SEQ_NOR: 1
VALUE: 1.0000
STATUS: SAMPLE
CASHIER: SAMPLE
REF_NO1: SAMPLE
REF_NO2: SAMPLE
REF_NO3: SAMPLE
REF_NO4: SAMPLE
TRAN_NO: 1
REF_NO25: SAMPLE
REF_NO26: SAMPLE
REF_NO27: SAMPLE
REF_NO28: SAMPLE
REF_NO29: SAMPLE
REF_NO30: SAMPLE
REF_NO31: SAMPLE
REGISTER: SAMPL
BANNER_NO: 1
ERROR_IND: S
TRAN_DATE: 2026-01-01
TRAN_TYPE: SAMPLE
UPDATE_ID: SAMPLE
VENDOR_NO: SAMPLE
ORIG_REG_NO: SAMPL
REASON_CODE: SAMPLE
ROUNDED_AMT: 1.0000
SALESPERSON: SAMPLE
DUP_TRAN_IND: S
ORIG_TRAN_NO: 1
POS_TRAN_IND: S
SUB_TRAN_TYPE: SAMPLE
TRAN_DATETIME: 2026-01-01
ORIG_TRAN_TYPE: SAMPLE
PAYMENT_REF_NO: SAMPLE
RTLOG_ORIG_SYS: SAM
VENDOR_INVC_NO: SAMPLE
ROUNDED_OFF_AMT: 1.0000
UPDATE_DATETIME: 2026-01-01
TRAN_PROCESS_SYS: SAM
CREDIT_PROMOTION_ID: 1
PROOF_OF_DELIVERY_NO: SAMPLE

default

DAYRPK: 3
STORERPK: 1003
REV_NOR: 4
TRAN_SEQ_NORPK: 4
STORE_DAY_SEQ_NOR: 4
VALUE: 12.5000
STATUS: PENDIN
CASHIER: SA Tran He
REF_NO1: SA Tran Head-002-ALT
REF_NO2: SA Tran Head-002-ALT
REF_NO3: SA Tran Head-002-ALT
REF_NO4: SA Tran Head-002-ALT
TRAN_NO: 4
REF_NO25: SA Tran Head-002-ALT
REF_NO26: SA Tran Head-002-ALT
REF_NO27: SA Tran Head-002-ALT
REF_NO28: SA Tran Head-002-ALT
REF_NO29: SA Tran Head-002-ALT
REF_NO30: SA Tran Head-002-ALT
REF_NO31: SA Tran Head-002-ALT
REGISTER: SA Tr
BANNER_NO: 4
ERROR_IND: S
TRAN_DATE: 2026-01-03
TRAN_TYPE: SA Tra
UPDATE_ID: MDM_USER
VENDOR_NO: SA Tran He
ORIG_REG_NO: SA Tr
REASON_CODE: ALT-SA
ROUNDED_AMT: 12.5000
SALESPERSON: SA Tran He
DUP_TRAN_IND: N
ORIG_TRAN_NO: 4
POS_TRAN_IND: S
SUB_TRAN_TYPE: SA Tra
TRAN_DATETIME: 2026-01-03
ORIG_TRAN_TYPE: SA Tra
PAYMENT_REF_NO: SA Tran Head-002
RTLOG_ORIG_SYS: POS
VENDOR_INVC_NO: SA Tran Head-002-ALT
ROUNDED_OFF_AMT: 12.5000
UPDATE_DATETIME: 2026-01-03
TRAN_PROCESS_SYS: SA
CREDIT_PROMOTION_ID: 1000000003
PROOF_OF_DELIVERY_NO: SA Tran Head-002-ALT