TYPE=VIEW
query=select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`vch_type`,\' \',`d`.`cheque_acc_no`,\' \',`d`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`mstr_bnk_deposit` `d` where ((`v`.`Acc_no` = \'604070000684\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2026-04-18\') and (`v`.`date` <= \'2026-04-18\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`d`.`Amt` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`vch_type`,\' \',`w`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`mstr_bnk_withdrawl` `w` where ((`v`.`Acc_no` = \'604070000684\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2026-04-18\') and (`v`.`date` <= \'2026-04-18\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
md5=590611689796fffcd8160c7bae8f4c48
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-04-18 10:38:12
create-version=1
source=SELECT v.vch_no,v.no,v.date,v.Acc_no,concat(v.vch_type,\' \',d.cheque_acc_no,\' \',d.cheque_no) vch_type,v.Dr,v.Cr FROM `voucher` v, mstr_bnk_deposit d WHERE v.acc_no=\'604070000684\' and v.vch_no=d.shilp and v.date=d.date and v.acc_no=d.acc_no and v.date>=\'2026-04-18\' and v.date<=\'2026-04-18\' group by v.vch_no,vch_type,date,amt union all select v.vch_no,v.no,v.date,v.Acc_no,CONCAT(v.vch_type,\' \', w.cheque_no) AS vch_type,v.Dr,v.Cr FROM `voucher` v,mstr_bnk_withdrawl w where v.acc_no=\'604070000684\' and v.vch_no=w.slip_no and v.acc_no=w.acc_no and v.date>=\'2026-04-18\' and v.date<=\'2026-04-18\' group by v.vch_no,vch_type,date,amt
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`vch_type`,\' \',`d`.`cheque_acc_no`,\' \',`d`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`mstr_bnk_deposit` `d` where ((`v`.`Acc_no` = \'604070000684\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2026-04-18\') and (`v`.`date` <= \'2026-04-18\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`d`.`Amt` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`vch_type`,\' \',`w`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`mstr_bnk_withdrawl` `w` where ((`v`.`Acc_no` = \'604070000684\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2026-04-18\') and (`v`.`date` <= \'2026-04-18\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
