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(5)
Rules & Considerations(35)
Sample Load Data(4)
| _scenario | TENDER_TYPE_IDR | VOUCHER_SEQ_NORPK | STATUS | 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 | 1 | 1 | SAMPLE | 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 |
| default | 100003 | 4 | PENDIN | 12.5000 | 12.5000 | 2026-01-03 | SA Voucher-002-ALT | 2026-01-03 | 2026-01-03 | 2026-01-03 | 1003 | 1003 | 1003 | SA Voucher-002-ALT | SA Voucher | SA Voucher | 2026-01-03 | SA Vo | SA Vo | SA Voucher-002-ALT | SA Voucher Secondary | 2026-01-03 | 2026-01-03 | 2026-01-03 | SA Voucher-002-ALT | SA Voucher-002-ALT | SA | SA Voucher Secondary | 4 | 4 | SA | 4 | SA | 4 | SA | 4 | ALT-SA_VOUCHER-002 |
| default | 100005 | 6 | ACTIVE | 14.0000 | 14.0000 | 2026-01-05 | SA Voucher-003-EDGE | 2026-01-05 | 2026-01-05 | 2026-01-05 | 1005 | 1005 | 1005 | SA Voucher-003-EDGE | SA Voucher | SA Voucher | 2026-01-05 | SA Vo | SA Vo | SA Voucher-003-EDGE | SA Voucher Core | 2026-01-05 | 2026-01-05 | 2026-01-05 | SA Voucher-003-EDGE | SA Voucher-003-EDGE | SA | SA Voucher Core | 6 | 6 | SA | 6 | SA | 6 | SA | 6 | EDGE-SA_VOUCHER-003 |
Example values from field definitions
- TENDER_TYPE_IDR
- 1
- VOUCHER_SEQ_NORPK
- 1
- STATUS
- SAMPLE
- 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
default
- TENDER_TYPE_IDR
- 100003
- VOUCHER_SEQ_NORPK
- 4
- STATUS
- PENDIN
- ISS_AMT
- 12.5000
- RED_AMT
- 12.5000
- ASS_DATE
- 2026-01-03
- COMMENTS
- SA Voucher-002-ALT
- EXP_DATE
- 2026-01-03
- ISS_DATE
- 2026-01-03
- RED_DATE
- 2026-01-03
- ASS_STORE
- 1003
- ISS_STORE
- 1003
- RED_STORE
- 1003
- VOUCHER_NO
- SA Voucher-002-ALT
- ISS_CASHIER
- SA Voucher
- RED_CASHIER
- SA Voucher
- ESCHEAT_DATE
- 2026-01-03
- ISS_REGISTER
- SA Vo
- RED_REGISTER
- SA Vo
- ISS_CUST_CITY
- SA Voucher-002-ALT
- ISS_CUST_NAME
- SA Voucher Secondary
- ISS_POST_DATE
- 2026-01-03
- RED_POST_DATE
- 2026-01-03
- ESCH_POST_DATE
- 2026-01-03
- ISS_CUST_ADDR1
- SA Voucher-002-ALT
- ISS_CUST_ADDR2
- SA Voucher-002-ALT
- ISS_CUST_STATE
- SA
- RECIPIENT_NAME
- SA Voucher Secondary
- ISS_ITEM_SEQ_NO
- 4
- ISS_TRAN_SEQ_NO
- 4
- RECIPIENT_STATE
- SA
- RED_TRAN_SEQ_NO
- 4
- ISS_CUST_COUNTRY
- SA
- ISS_TENDER_SEQ_NO
- 4
- RECIPIENT_COUNTRY
- SA
- RED_TENDER_SEQ_NO
- 4
- ISS_CUST_POSTAL_CODE
- ALT-SA_VOUCHER-002
default
- TENDER_TYPE_IDR
- 100005
- VOUCHER_SEQ_NORPK
- 6
- STATUS
- ACTIVE
- ISS_AMT
- 14.0000
- RED_AMT
- 14.0000
- ASS_DATE
- 2026-01-05
- COMMENTS
- SA Voucher-003-EDGE
- EXP_DATE
- 2026-01-05
- ISS_DATE
- 2026-01-05
- RED_DATE
- 2026-01-05
- ASS_STORE
- 1005
- ISS_STORE
- 1005
- RED_STORE
- 1005
- VOUCHER_NO
- SA Voucher-003-EDGE
- ISS_CASHIER
- SA Voucher
- RED_CASHIER
- SA Voucher
- ESCHEAT_DATE
- 2026-01-05
- ISS_REGISTER
- SA Vo
- RED_REGISTER
- SA Vo
- ISS_CUST_CITY
- SA Voucher-003-EDGE
- ISS_CUST_NAME
- SA Voucher Core
- ISS_POST_DATE
- 2026-01-05
- RED_POST_DATE
- 2026-01-05
- ESCH_POST_DATE
- 2026-01-05
- ISS_CUST_ADDR1
- SA Voucher-003-EDGE
- ISS_CUST_ADDR2
- SA Voucher-003-EDGE
- ISS_CUST_STATE
- SA
- RECIPIENT_NAME
- SA Voucher Core
- ISS_ITEM_SEQ_NO
- 6
- ISS_TRAN_SEQ_NO
- 6
- RECIPIENT_STATE
- SA
- RED_TRAN_SEQ_NO
- 6
- ISS_CUST_COUNTRY
- SA
- ISS_TENDER_SEQ_NO
- 6
- RECIPIENT_COUNTRY
- SA
- RED_TENDER_SEQ_NO
- 6
- ISS_CUST_POSTAL_CODE
- EDGE-SA_VOUCHER-003
Rule Validation Summary
- Source Rule Count
- 41
- Governed Rule Count
- 35