SA Tran Disc Hist

In Scope

Technical: SA_TRAN_DISC_HIST | ID: OR-MFCS-SA_TRAN_DISC_HIST

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

Target Structure

Load Approach: Table
Target Objects: SA_TRAN_DISC_HIST

Field Definitions(23)

Rules & Considerations(58)

Sample Load Data(4)

_scenario	DAYR	STORER	ERROR_INDR	ITEM_SEQ_NOR	TRAN_SEQ_NOR	UOM_QUANTITYR	RMS_PROMO_TYPER	DISCOUNT_SEQ_NOR	HIST_WRITTEN_DATER	QTY	REF_NO13	REF_NO14	REF_NO15	REF_NO16	COUPON_NO	DISC_TYPE	PROMOTION	PROMO_COMP	STANDARD_QTY	COUPON_REF_NO	CATCHWEIGHT_IND	UNIT_DISCOUNT_AMT	STANDARD_UNIT_DISC_AMT
default	001	1001	SA Tran Disc Hist-001	0002	2	11.0000	SA Tran Disc Hist-001	0002	2026-01-01	11.0000	SA Tran Disc Hist-001	SA Tran Disc Hist-001	SA Tran Disc Hist-001	SA Tran Disc Hist-001	SA Tran Disc Hist-001	SA Tran Disc Hist-001	1	1	11.0000	SA Tran Disc Hist-001	SA Tran Disc Hist-001	11.0000	11.0000

default

DAYR: 001
STORER: 1001
ERROR_INDR: SA Tran Disc Hist-001
ITEM_SEQ_NOR: 0002
TRAN_SEQ_NOR: 2
UOM_QUANTITYR: 11.0000
RMS_PROMO_TYPER: SA Tran Disc Hist-001
DISCOUNT_SEQ_NOR: 0002
HIST_WRITTEN_DATER: 2026-01-01
QTY: 11.0000
REF_NO13: SA Tran Disc Hist-001
REF_NO14: SA Tran Disc Hist-001
REF_NO15: SA Tran Disc Hist-001
REF_NO16: SA Tran Disc Hist-001
COUPON_NO: SA Tran Disc Hist-001
DISC_TYPE: SA Tran Disc Hist-001
PROMOTION: 1
PROMO_COMP: 1
STANDARD_QTY: 11.0000
COUPON_REF_NO: SA Tran Disc Hist-001
CATCHWEIGHT_IND: SA Tran Disc Hist-001
UNIT_DISCOUNT_AMT: 11.0000
STANDARD_UNIT_DISC_AMT: 11.0000

All objects