SA Tran Tender
In ScopeTechnical: 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)
| _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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 001 | 1001 | SA Tran Tender-001 | 11.0000 | 2 | 0002 | 100001 | SA Tran Tender-001 | SA Tran Tender-001 | SA Tran Tender-001 | SA Tran Tender-001 | 2 | SA Tran Tender-001 | SA Tran Tender-001 | SA Tran Tender-001 | SA Tran Tender-001 | STD-SA_TRAN-001 | SA Tran Tender-001 | STD-SA_TRAN-001 | SA Tran Tender-001 | SA Tran Tender-001 | 2026-01-01 | SA Tran Tender-001 | SA Tran Tender-001 | SA Tran Tender-001 | SA Tran Tender-001 | SA Tran Tender-001 | SA Tran Tender-001 | 11.0000 | SA Tran Tender-001 |
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
