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-144`.`voucher` `v` join `co-operativebank-144`.`mstr_bnk_deposit` `d` where ((`v`.`Acc_no` = \'602111048111\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'1990-04-01\') and (`v`.`date` <= \'2026-03-12\')) 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-144`.`voucher` `v` join `co-operativebank-144`.`mstr_bnk_withdrawl` `w` where ((`v`.`Acc_no` = \'602111048111\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'1990-04-01\') and (`v`.`date` <= \'2026-03-12\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
md5=efa47abd34f0754e72b50af7a8c98f1a
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-03-12 07:07:03
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=\'602111048111\' and v.vch_no=d.shilp and v.date=d.date and v.acc_no=d.acc_no and v.date>=\'1990-04-01\' and v.date<=\'2026-03-12\' 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=\'602111048111\' and v.vch_no=w.slip_no and v.acc_no=w.acc_no and v.date>=\'1990-04-01\' and v.date<=\'2026-03-12\' 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-144`.`voucher` `v` join `co-operativebank-144`.`mstr_bnk_deposit` `d` where ((`v`.`Acc_no` = \'602111048111\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'1990-04-01\') and (`v`.`date` <= \'2026-03-12\')) 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-144`.`voucher` `v` join `co-operativebank-144`.`mstr_bnk_withdrawl` `w` where ((`v`.`Acc_no` = \'602111048111\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'1990-04-01\') and (`v`.`date` <= \'2026-03-12\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
