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(31)

Rules & Considerations(38)

Sample Load Data(4)

_scenario	DAYR	STORER	ERROR_INDR	TENDER_AMTR	TRAN_SEQ_NORPK	TENDER_SEQ_NOR	TENDER_TYPE_IDR	TENDER_TYPE_GROUPR	CC_NO	REF_NO9	CC_TOKEN	CHECK_NO	REF_NO10	REF_NO11	REF_NO12	COUPON_NO	IDENTI_ID	CC_AUTH_NO	CC_TERM_ID	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	CC_CARDHOLDER_VERF
Example values from field definitions	1	1	S	1.0000	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPL	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAM	1.0000	SAMPLE

Example values from field definitions

DAYR: 1
STORER: 1
ERROR_INDR: S
TENDER_AMTR: 1.0000
TRAN_SEQ_NORPK: 1
TENDER_SEQ_NOR: 1
TENDER_TYPE_IDR: 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
IDENTI_ID: SAMPLE
CC_AUTH_NO: SAMPLE
CC_TERM_ID: SAMPL
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
CC_CARDHOLDER_VERF: SAMPLE

Rule Validation Summary

Source Rule Count: 44
Governed Rule Count: 38

All objects