ReSA Voucher
In ScopeTechnical: SA_VOUCHER | ID: OR-RSA-SA_VOUCHER-RESA_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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- SA_VOUCHER
Field Definitions(37)
Rules & Considerations(34)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1.0000 | 1.0000 | 2026-01-01 | SAMPLE | 2026-01-01 | 2026-01-01 | 2026-01-01 | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPL | SAMPL | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | SAM | SAMPLE | 1 | 1 | SAM | 1 | SAM | 1 | SAM | 1 | SAMPLE |
Example values from field definitions
- STATUSR
- SAMPLE
- TENDER_TYPE_IDRPK
- 1
- VOUCHER_SEQ_NORPK
- 1
- ISS_AMT
- 1.0000
- RED_AMT
- 1.0000
- ASS_DATE
- 2026-01-01
- COMMENTS
- SAMPLE
- EXP_DATE
- 2026-01-01
- ISS_DATE
- 2026-01-01
- RED_DATE
- 2026-01-01
- ASS_STORE
- 1
- ISS_STORE
- 1
- RED_STORE
- 1
- VOUCHER_NO
- SAMPLE
- ISS_CASHIER
- SAMPLE
- RED_CASHIER
- SAMPLE
- ESCHEAT_DATE
- 2026-01-01
- ISS_REGISTER
- SAMPL
- RED_REGISTER
- SAMPL
- ISS_CUST_CITY
- SAMPLE
- ISS_CUST_NAME
- SAMPLE
- ISS_POST_DATE
- 2026-01-01
- RED_POST_DATE
- 2026-01-01
- ESCH_POST_DATE
- 2026-01-01
- ISS_CUST_ADDR1
- SAMPLE
- ISS_CUST_ADDR2
- SAMPLE
- ISS_CUST_STATE
- SAM
- RECIPIENT_NAME
- SAMPLE
- ISS_ITEM_SEQ_NO
- 1
- ISS_TRAN_SEQ_NO
- 1
- RECIPIENT_STATE
- SAM
- RED_TRAN_SEQ_NO
- 1
- ISS_CUST_COUNTRY
- SAM
- ISS_TENDER_SEQ_NO
- 1
- RECIPIENT_COUNTRY
- SAM
- RED_TENDER_SEQ_NO
- 1
- ISS_CUST_POSTAL_CODE
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 34