ReSA Transaction Discount History

In Scope

Technical: SA_TRAN_DISC_HIST | ID: OR-RSA-SA_TRAN_DISC_HIST-RESA_TRANSACTION_DISCOUNT_HISTORY

Stores historical records for SA tran disc 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_TRAN_DISC_HIST

Field Definitions(5)

Rules & Considerations(31)

constraint

validation

Sample Load Data(4)

_scenario	DAYR	STORER	ITEM_SEQ_NOR	TRAN_SEQ_NOR	DISCOUNT_SEQ_NOR	QTY	REF_NO13	REF_NO14	REF_NO15	REF_NO16	COUPON_NO	DISC_TYPE	ERROR_IND	PROMOTION	PROMO_COMP	STANDARD_QTY	UOM_QUANTITY	COUPON_REF_NO	RMS_PROMO_TYPE	CATCHWEIGHT_IND	HIST_WRITTEN_DATE	UNIT_DISCOUNT_AMT	STANDARD_UNIT_DISC_AMT
Example values from field definitions	1	1	1	1	1	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	1	1	1.0000	1.0000	SAMPLE	SAMPLE	S	2026-01-01	1.0000	1.0000
default	3	1003	4	4	4	12.5000	SA Tran Disc Hist-002-ALT	SA Tran Disc Hist-002-ALT	SA Tran Disc Hist-002-ALT	SA Tran Disc Hist-002-ALT	SA Tran Disc Hist-002-ALT	SA Tra	S	3	3	12.5000	12.5000	SA Tran Disc His	SA Tra	S	2026-01-03	12.5000	12.5000
default	5	1005	6	6	6	14.0000	SA Tran Disc Hist-003-EDGE	SA Tran Disc Hist-003-EDGE	SA Tran Disc Hist-003-EDGE	SA Tran Disc Hist-003-EDGE	SA Tran Disc Hist-003-EDGE	SA Tra	S	5	5	14.0000	14.0000	SA Tran Disc His	SA Tra	S	2026-01-05	14.0000	14.0000

Example values from field definitions

DAYR: 1
STORER: 1
ITEM_SEQ_NOR: 1
TRAN_SEQ_NOR: 1
DISCOUNT_SEQ_NOR: 1
QTY: 1.0000
REF_NO13: SAMPLE
REF_NO14: SAMPLE
REF_NO15: SAMPLE
REF_NO16: SAMPLE
COUPON_NO: SAMPLE
DISC_TYPE: SAMPLE
ERROR_IND: S
PROMOTION: 1
PROMO_COMP: 1
STANDARD_QTY: 1.0000
UOM_QUANTITY: 1.0000
COUPON_REF_NO: SAMPLE
RMS_PROMO_TYPE: SAMPLE
CATCHWEIGHT_IND: S
HIST_WRITTEN_DATE: 2026-01-01
UNIT_DISCOUNT_AMT: 1.0000
STANDARD_UNIT_DISC_AMT: 1.0000

default

DAYR: 3
STORER: 1003
ITEM_SEQ_NOR: 4
TRAN_SEQ_NOR: 4
DISCOUNT_SEQ_NOR: 4
QTY: 12.5000
REF_NO13: SA Tran Disc Hist-002-ALT
REF_NO14: SA Tran Disc Hist-002-ALT
REF_NO15: SA Tran Disc Hist-002-ALT
REF_NO16: SA Tran Disc Hist-002-ALT
COUPON_NO: SA Tran Disc Hist-002-ALT
DISC_TYPE: SA Tra
ERROR_IND: S
PROMOTION: 3
PROMO_COMP: 3
STANDARD_QTY: 12.5000
UOM_QUANTITY: 12.5000
COUPON_REF_NO: SA Tran Disc His
RMS_PROMO_TYPE: SA Tra
CATCHWEIGHT_IND: S
HIST_WRITTEN_DATE: 2026-01-03
UNIT_DISCOUNT_AMT: 12.5000
STANDARD_UNIT_DISC_AMT: 12.5000