#1.update voucher update voucher set stock_id = 33, status_id = 1, type_id = 0, expiry_date = NULL where voucher_id = 228534 #2.delete voucher_action delete from voucher_action where voucher_id = 228534 and action_id = 30 #3.delete voucher campaign issue delete from voucher_campaign_issue where voucher_id = 228534 delete from voucher_campaign_issue_request where request_id = 30217 #4.delete request delete from voucher_request_approve where request_id = 30217 #5.delete voucher batch delete from voucher_batch where batch_id = 65236 delete from voucher_batch_no_section where batch_id = 65236 #6. check receipt select * from voucher_receipt_numbers where voucher_ids like '"8534%'