Evo Transfer涉及到的table
Voucher
Voucher_action
Voucher_batch_action
Voucher_campaign_issue
Voucher_info_transfer
Transfer to corporate sales
Voucher ——– Transfer_time(add), Issue_time(add), expiry_time(add), status_id(2-6), transfer_channel(null-6)
Voucher_action ——– insert issue action
Voucher_batch_action ——– insert transfer record, insert issue record
Voucher_info_transfer ——– insert info transfer record
Transfer to Event
Voucher ——– Transfer_time(add), Issue_time(add), expiry_time(add), status_id(2-6), transfer_channel(null-7)
Voucher_action ——–insert issue action
Voucher_batch_action ——– insert transfer record, insert issue record
Voucher_info_transfer ——– insert info transfer record
Transfer for Other Purpose
Voucher ——– Transfer_time(add), Issue_time(add), expiry_time(add), status_id(2-6), transfer_channel(null-50)
Voucher_action ——–insert issue action
Voucher_batch_action ——– insert transfer record, insert issue record
Voucher_info_transfer ——– insert info transfer record
Transfer to Customer Service
Voucher ——– Transfer_time(add), Issue_time(null), expiry_time(null), status_id(2-5), transfer_channel(null)
Voucher_action ——–no insert issue action
Voucher_batch_action ——–insert transfer record, no insert issue record
Voucher_info_transfer ——–insert info transfer record