ReSA Transaction Tender Rev History

In Scope

Technical: SA_TRAN_TENDER_REV_HIST | ID: OR-RSA-SA_TRAN_TENDER_REV_HIST-RESA_TRANSACTION_TENDER_REV_HISTORY

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

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_TENDER_REV_HIST

Field Definitions(5)

Rules & Considerations(40)

Sample Load Data(4)

_scenario	DAYR	STORER	REV_NOR	TRAN_SEQ_NOR	TENDER_SEQ_NOR	CC_NO	REF_NO9	CC_TOKEN	CHECK_NO	REF_NO10	REF_NO11	REF_NO12	COUPON_NO	ERROR_IND	IDENTI_ID	CC_AUTH_NO	CC_TERM_ID	TENDER_AMT	VOUCHER_NO	CC_AUTH_SRC	CC_EXP_DATE	CC_SPEC_COND	CC_ENTRY_MODE	CHECK_ACCT_NO	COUPON_REF_NO	IDENTI_METHOD	ORIG_CURRENCY	ORIG_CURR_AMT	TENDER_TYPE_ID	HIST_WRITTEN_DATE	TENDER_TYPE_GROUP	CC_CARDHOLDER_VERF
Example values from field definitions	1	1	1	1	1	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	SAMPL	1.0000	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAM	1.0000	1	2026-01-01	SAMPLE	SAMPLE
default	3	1003	4	4	4	SA Tran Tender Rev Hist-002-ALT	SA Tran Tender Rev Hist-002-AL	SA Tran Tender Rev Hist-002-ALT	4	SA Tran Tender Rev Hist-002-AL	SA Tran Tender Rev Hist-002-AL	SA Tran Tender Rev Hist-002-AL	SA Tran Tender Rev Hist-002-ALT	S	ALT-SA_TRAN-002	SA Tran Tender R	ALT-S	12.5000	SA Tran Tender Rev Hist-0	SA Tra	2026-01-03	SA Tra	SA Tra	SA Tran Tender Rev Hist-002-AL	SA Tran Tender R	SA Tra	SA	12.5000	100003	2026-01-03	SA Tra	SA Tra
default	5	1005	6	6	6	SA Tran Tender Rev Hist-003-EDGE	SA Tran Tender Rev Hist-003-ED	SA Tran Tender Rev Hist-003-EDGE	6	SA Tran Tender Rev Hist-003-ED	SA Tran Tender Rev Hist-003-ED	SA Tran Tender Rev Hist-003-ED	SA Tran Tender Rev Hist-003-EDGE	S	EDGE-SA_TRAN-003	SA Tran Tender R	EDGE-	14.0000	SA Tran Tender Rev Hist-0	SA Tra	2026-01-05	SA Tra	SA Tra	SA Tran Tender Rev Hist-003-ED	SA Tran Tender R	SA Tra	SA	14.0000	100005	2026-01-05	SA Tra	SA Tra

Example values from field definitions

DAYR: 1
STORER: 1
REV_NOR: 1
TRAN_SEQ_NOR: 1
TENDER_SEQ_NOR: 1
CC_NO: SAMPLE
REF_NO9: SAMPLE
CC_TOKEN: SAMPLE
CHECK_NO: 1
REF_NO10: SAMPLE
REF_NO11: SAMPLE
REF_NO12: SAMPLE
COUPON_NO: SAMPLE
ERROR_IND: S
IDENTI_ID: SAMPLE
CC_AUTH_NO: SAMPLE
CC_TERM_ID: SAMPL
TENDER_AMT: 1.0000
VOUCHER_NO: SAMPLE
CC_AUTH_SRC: SAMPLE
CC_EXP_DATE: 2026-01-01
CC_SPEC_COND: SAMPLE
CC_ENTRY_MODE: SAMPLE
CHECK_ACCT_NO: SAMPLE
COUPON_REF_NO: SAMPLE
IDENTI_METHOD: SAMPLE
ORIG_CURRENCY: SAM
ORIG_CURR_AMT: 1.0000
TENDER_TYPE_ID: 1
HIST_WRITTEN_DATE: 2026-01-01
TENDER_TYPE_GROUP: SAMPLE
CC_CARDHOLDER_VERF: SAMPLE

default

DAYR: 3
STORER: 1003
REV_NOR: 4
TRAN_SEQ_NOR: 4
TENDER_SEQ_NOR: 4
CC_NO: SA Tran Tender Rev Hist-002-ALT
REF_NO9: SA Tran Tender Rev Hist-002-AL
CC_TOKEN: SA Tran Tender Rev Hist-002-ALT
CHECK_NO: 4
REF_NO10: SA Tran Tender Rev Hist-002-AL
REF_NO11: SA Tran Tender Rev Hist-002-AL
REF_NO12: SA Tran Tender Rev Hist-002-AL
COUPON_NO: SA Tran Tender Rev Hist-002-ALT
ERROR_IND: S
IDENTI_ID: ALT-SA_TRAN-002
CC_AUTH_NO: SA Tran Tender R
CC_TERM_ID: ALT-S
TENDER_AMT: 12.5000
VOUCHER_NO: SA Tran Tender Rev Hist-0
CC_AUTH_SRC: SA Tra
CC_EXP_DATE: 2026-01-03
CC_SPEC_COND: SA Tra
CC_ENTRY_MODE: SA Tra
CHECK_ACCT_NO: SA Tran Tender Rev Hist-002-AL
COUPON_REF_NO: SA Tran Tender R
IDENTI_METHOD: SA Tra
ORIG_CURRENCY: SA
ORIG_CURR_AMT: 12.5000
TENDER_TYPE_ID: 100003
HIST_WRITTEN_DATE: 2026-01-03
TENDER_TYPE_GROUP: SA Tra
CC_CARDHOLDER_VERF: SA Tra

default

DAYR: 5
STORER: 1005
REV_NOR: 6
TRAN_SEQ_NOR: 6
TENDER_SEQ_NOR: 6
CC_NO: SA Tran Tender Rev Hist-003-EDGE
REF_NO9: SA Tran Tender Rev Hist-003-ED
CC_TOKEN: SA Tran Tender Rev Hist-003-EDGE
CHECK_NO: 6
REF_NO10: SA Tran Tender Rev Hist-003-ED
REF_NO11: SA Tran Tender Rev Hist-003-ED
REF_NO12: SA Tran Tender Rev Hist-003-ED
COUPON_NO: SA Tran Tender Rev Hist-003-EDGE
ERROR_IND: S
IDENTI_ID: EDGE-SA_TRAN-003
CC_AUTH_NO: SA Tran Tender R
CC_TERM_ID: EDGE-
TENDER_AMT: 14.0000
VOUCHER_NO: SA Tran Tender Rev Hist-0
CC_AUTH_SRC: SA Tra
CC_EXP_DATE: 2026-01-05
CC_SPEC_COND: SA Tra
CC_ENTRY_MODE: SA Tra
CHECK_ACCT_NO: SA Tran Tender Rev Hist-003-ED
COUPON_REF_NO: SA Tran Tender R
IDENTI_METHOD: SA Tra
ORIG_CURRENCY: SA
ORIG_CURR_AMT: 14.0000
TENDER_TYPE_ID: 100005
HIST_WRITTEN_DATE: 2026-01-05
TENDER_TYPE_GROUP: SA Tra
CC_CARDHOLDER_VERF: SA Tra

Rule Validation Summary

Source Rule Count: 46
Governed Rule Count: 40

All objects