SA Voucher

In Scope

Technical: SA_VOUCHER | ID: OR-MFCS-SA_VOUCHER

This is a new table that contains issued/redeemed information about gift certificates and credit vouchers. It is populated when a gift certificate is sold or merchandise is returned for credit,…

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_VOUCHER

Field Definitions(37)

Rules & Considerations(82)

Sample Load Data(4)

_scenario	STATUSR	TENDER_TYPE_IDRPK	VOUCHER_SEQ_NORPK	ISS_AMT	RED_AMT	ASS_DATE	COMMENTS	EXP_DATE	ISS_DATE	RED_DATE	ASS_STORE	ISS_STORE	RED_STORE	VOUCHER_NO	ISS_CASHIER	RED_CASHIER	ESCHEAT_DATE	ISS_REGISTER	RED_REGISTER	ISS_CUST_CITY	ISS_CUST_NAME	ISS_POST_DATE	RED_POST_DATE	ESCH_POST_DATE	ISS_CUST_ADDR1	ISS_CUST_ADDR2	ISS_CUST_STATE	RECIPIENT_NAME	ISS_ITEM_SEQ_NO	ISS_TRAN_SEQ_NO	RECIPIENT_STATE	RED_TRAN_SEQ_NO	ISS_CUST_COUNTRY	ISS_TENDER_SEQ_NO	RECIPIENT_COUNTRY	RED_TENDER_SEQ_NO	ISS_CUST_POSTAL_CODE
default	ACTIVE	100001	2	11.0000	11.0000	2026-01-01	SA Voucher-001	2026-01-01	2026-01-01	2026-01-01	1001	1001	1001	SA Voucher-001	SA Voucher-001	SA Voucher-001	2026-01-01	SA Voucher-001	SA Voucher-001	SA Voucher-001	SA Voucher Primary	2026-01-01	2026-01-01	2026-01-01	SA Voucher-001	SA Voucher-001	SA Voucher-001	SA Voucher Primary	0002	2	SA Voucher-001	2	SA Voucher-001	0002	SA Voucher-001	0002	STD-SA_VOUCHER-001

default

STATUSR: ACTIVE
TENDER_TYPE_IDRPK: 100001
VOUCHER_SEQ_NORPK: 2
ISS_AMT: 11.0000
RED_AMT: 11.0000
ASS_DATE: 2026-01-01
COMMENTS: SA Voucher-001
EXP_DATE: 2026-01-01
ISS_DATE: 2026-01-01
RED_DATE: 2026-01-01
ASS_STORE: 1001
ISS_STORE: 1001
RED_STORE: 1001
VOUCHER_NO: SA Voucher-001
ISS_CASHIER: SA Voucher-001
RED_CASHIER: SA Voucher-001
ESCHEAT_DATE: 2026-01-01
ISS_REGISTER: SA Voucher-001
RED_REGISTER: SA Voucher-001
ISS_CUST_CITY: SA Voucher-001
ISS_CUST_NAME: SA Voucher Primary
ISS_POST_DATE: 2026-01-01
RED_POST_DATE: 2026-01-01
ESCH_POST_DATE: 2026-01-01
ISS_CUST_ADDR1: SA Voucher-001
ISS_CUST_ADDR2: SA Voucher-001
ISS_CUST_STATE: SA Voucher-001
RECIPIENT_NAME: SA Voucher Primary
ISS_ITEM_SEQ_NO: 0002
ISS_TRAN_SEQ_NO: 2
RECIPIENT_STATE: SA Voucher-001
RED_TRAN_SEQ_NO: 2
ISS_CUST_COUNTRY: SA Voucher-001
ISS_TENDER_SEQ_NO: 0002
RECIPIENT_COUNTRY: SA Voucher-001
RED_TENDER_SEQ_NO: 0002
ISS_CUST_POSTAL_CODE: STD-SA_VOUCHER-001

All objects