ReSA Transaction Tender

In Scope

Technical: SA_TRAN_TENDER | ID: OR-RSA-SA_TRAN_TENDER-RESA_TRANSACTION_TENDER

This table that contains a record for each type of monetary instrument used by a customer in payment of store purchases (e.g., cash, gift certificate, personal check, Visa, American Express,...

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

Field Definitions(5)

Rules & Considerations(44)

Sample Load Data(4)

_scenario	DAYRPK	STORERPK	TRAN_SEQ_NORPK	TENDER_SEQ_NORPK	TENDER_TYPE_GROUPR	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	CC_CARDHOLDER_VERF
Example values from field definitions	1	1	1	1	SAMPLE	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
default	3	1003	4	4	SA Tra	SA Tran Tender-002-ALT	SA Tran Tender-002-ALT	SA Tran Tender-002-ALT	4	SA Tran Tender-002-ALT	SA Tran Tender-002-ALT	SA Tran Tender-002-ALT	SA Tran Tender-002-ALT	S	ALT-SA_TRAN-002	SA Tran Tender-0	ALT-S	12.5000	SA Tran Tender-002-ALT	SA Tra	2026-01-03	SA Tra	SA Tra	SA Tran Tender-002-ALT	SA Tran Tender-0	SA Tra	SA	12.5000	100003	SA Tra
default	5	1005	6	6	SA Tra	SA Tran Tender-003-EDGE	SA Tran Tender-003-EDGE	SA Tran Tender-003-EDGE	6	SA Tran Tender-003-EDGE	SA Tran Tender-003-EDGE	SA Tran Tender-003-EDGE	SA Tran Tender-003-EDGE	S	EDGE-SA_TRAN-003	SA Tran Tender-0	EDGE-	14.0000	SA Tran Tender-003-EDGE	SA Tra	2026-01-05	SA Tra	SA Tra	SA Tran Tender-003-EDGE	SA Tran Tender-0	SA Tra	SA	14.0000	100005	SA Tra

Example values from field definitions

DAYRPK: 1
STORERPK: 1
TRAN_SEQ_NORPK: 1
TENDER_SEQ_NORPK: 1
TENDER_TYPE_GROUPR: SAMPLE
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
CC_CARDHOLDER_VERF: SAMPLE

default

DAYRPK: 3
STORERPK: 1003
TRAN_SEQ_NORPK: 4
TENDER_SEQ_NORPK: 4
TENDER_TYPE_GROUPR: SA Tra
CC_NO: SA Tran Tender-002-ALT
REF_NO9: SA Tran Tender-002-ALT
CC_TOKEN: SA Tran Tender-002-ALT
CHECK_NO: 4
REF_NO10: SA Tran Tender-002-ALT
REF_NO11: SA Tran Tender-002-ALT
REF_NO12: SA Tran Tender-002-ALT
COUPON_NO: SA Tran Tender-002-ALT
ERROR_IND: S
IDENTI_ID: ALT-SA_TRAN-002
CC_AUTH_NO: SA Tran Tender-0
CC_TERM_ID: ALT-S
TENDER_AMT: 12.5000
VOUCHER_NO: SA Tran Tender-002-ALT
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-002-ALT
COUPON_REF_NO: SA Tran Tender-0
IDENTI_METHOD: SA Tra
ORIG_CURRENCY: SA
ORIG_CURR_AMT: 12.5000
TENDER_TYPE_ID: 100003
CC_CARDHOLDER_VERF: SA Tra

default

DAYRPK: 5
STORERPK: 1005
TRAN_SEQ_NORPK: 6
TENDER_SEQ_NORPK: 6
TENDER_TYPE_GROUPR: SA Tra
CC_NO: SA Tran Tender-003-EDGE
REF_NO9: SA Tran Tender-003-EDGE
CC_TOKEN: SA Tran Tender-003-EDGE
CHECK_NO: 6
REF_NO10: SA Tran Tender-003-EDGE
REF_NO11: SA Tran Tender-003-EDGE
REF_NO12: SA Tran Tender-003-EDGE
COUPON_NO: SA Tran Tender-003-EDGE
ERROR_IND: S
IDENTI_ID: EDGE-SA_TRAN-003
CC_AUTH_NO: SA Tran Tender-0
CC_TERM_ID: EDGE-
TENDER_AMT: 14.0000
VOUCHER_NO: SA Tran Tender-003-EDGE
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-003-EDGE
COUPON_REF_NO: SA Tran Tender-0
IDENTI_METHOD: SA Tra
ORIG_CURRENCY: SA
ORIG_CURR_AMT: 14.0000
TENDER_TYPE_ID: 100005
CC_CARDHOLDER_VERF: SA Tra

Rule Validation Summary

Source Rule Count: 50
Governed Rule Count: 44

All objects