ReSA Transaction Tender Rev

In Scope

Technical: SA_TRAN_TENDER_REV | ID: OR-RSA-SA_TRAN_TENDER_REV-RESA_TRANSACTION_TENDER_REV

Stores a record for each revision to the form of payment records associated with a transaction.

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

Field Definitions(5)

Rules & Considerations(48)

Sample Load Data(4)

_scenario	DAYRPK	STORERPK	REV_NORPK	TRAN_SEQ_NORPK	TENDER_SEQ_NORPK	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	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	SAMPLE	SAMPLE
default	3	1003	4	4	4	SA Tran Tender Rev-002-ALT	SA Tran Tender Rev-002-ALT	SA Tran Tender Rev-002-ALT	4	SA Tran Tender Rev-002-ALT	SA Tran Tender Rev-002-ALT	SA Tran Tender Rev-002-ALT	SA Tran Tender Rev-002-ALT	S	ALT-SA_TRAN-002	SA Tran Tender R	ALT-S	12.5000	SA Tran Tender Rev-002-AL	SA Tra	2026-01-03	SA Tra	SA Tra	SA Tran Tender Rev-002-ALT	SA Tran Tender R	SA Tra	SA	12.5000	100003	SA Tra	SA Tra
default	5	1005	6	6	6	SA Tran Tender Rev-003-EDGE	SA Tran Tender Rev-003-EDGE	SA Tran Tender Rev-003-EDGE	6	SA Tran Tender Rev-003-EDGE	SA Tran Tender Rev-003-EDGE	SA Tran Tender Rev-003-EDGE	SA Tran Tender Rev-003-EDGE	S	EDGE-SA_TRAN-003	SA Tran Tender R	EDGE-	14.0000	SA Tran Tender Rev-003-ED	SA Tra	2026-01-05	SA Tra	SA Tra	SA Tran Tender Rev-003-EDGE	SA Tran Tender R	SA Tra	SA	14.0000	100005	SA Tra	SA Tra

Example values from field definitions

default

DAYRPK: 3
STORERPK: 1003
REV_NORPK: 4
TRAN_SEQ_NORPK: 4
TENDER_SEQ_NORPK: 4
CC_NO: SA Tran Tender Rev-002-ALT
REF_NO9: SA Tran Tender Rev-002-ALT
CC_TOKEN: SA Tran Tender Rev-002-ALT
CHECK_NO: 4
REF_NO10: SA Tran Tender Rev-002-ALT
REF_NO11: SA Tran Tender Rev-002-ALT
REF_NO12: SA Tran Tender Rev-002-ALT
COUPON_NO: SA Tran Tender Rev-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-002-AL
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-002-ALT
COUPON_REF_NO: SA Tran Tender R
IDENTI_METHOD: SA Tra
ORIG_CURRENCY: SA
ORIG_CURR_AMT: 12.5000
TENDER_TYPE_ID: 100003
TENDER_TYPE_GROUP: SA Tra
CC_CARDHOLDER_VERF: SA Tra

default

DAYRPK: 5
STORERPK: 1005
REV_NORPK: 6
TRAN_SEQ_NORPK: 6
TENDER_SEQ_NORPK: 6
CC_NO: SA Tran Tender Rev-003-EDGE
REF_NO9: SA Tran Tender Rev-003-EDGE
CC_TOKEN: SA Tran Tender Rev-003-EDGE
CHECK_NO: 6
REF_NO10: SA Tran Tender Rev-003-EDGE
REF_NO11: SA Tran Tender Rev-003-EDGE
REF_NO12: SA Tran Tender Rev-003-EDGE
COUPON_NO: SA Tran Tender Rev-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-003-ED
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-003-EDGE
COUPON_REF_NO: SA Tran Tender R
IDENTI_METHOD: SA Tra
ORIG_CURRENCY: SA
ORIG_CURR_AMT: 14.0000
TENDER_TYPE_ID: 100005
TENDER_TYPE_GROUP: SA Tra
CC_CARDHOLDER_VERF: SA Tra

Rule Validation Summary

Source Rule Count: 54
Governed Rule Count: 48