SA Tran Tender

In Scope

Technical: SA_TRAN_TENDER | ID: OR-MFCS-SA_TRAN_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

Target Structure

Load Approach
Table
Target Objects
SA_TRAN_TENDER

Field Definitions(30)

Rules & Considerations(72)

Sample Load Data(4)

default

DAYR
001
STORER
1001
ERROR_INDR
SA Tran Tender-001
TENDER_AMTR
11.0000
TRAN_SEQ_NORPK
2
TENDER_SEQ_NOR
0002
TENDER_TYPE_IDR
100001
TENDER_TYPE_GROUPR
SA Tran Tender-001
CC_NO
SA Tran Tender-001
REF_NO9
SA Tran Tender-001
CC_TOKEN
SA Tran Tender-001
CHECK_NO
2
REF_NO10
SA Tran Tender-001
REF_NO11
SA Tran Tender-001
REF_NO12
SA Tran Tender-001
COUPON_NO
SA Tran Tender-001
IDENTI_ID
STD-SA_TRAN-001
CC_AUTH_NO
SA Tran Tender-001
CC_TERM_ID
STD-SA_TRAN-001
VOUCHER_NO
SA Tran Tender-001
CC_AUTH_SRC
SA Tran Tender-001
CC_EXP_DATE
2026-01-01
CC_SPEC_COND
SA Tran Tender-001
CC_ENTRY_MODE
SA Tran Tender-001
CHECK_ACCT_NO
SA Tran Tender-001
COUPON_REF_NO
SA Tran Tender-001
IDENTI_METHOD
SA Tran Tender-001
ORIG_CURRENCY
SA Tran Tender-001
ORIG_CURR_AMT
11.0000
CC_CARDHOLDER_VERF
SA Tran Tender-001
SA Tran Tender | undefined | Oracle Retail