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`.`lfnof`,\'\',`v`.`vch_type`,\' \',if((`d`.`cheque_acc_no` = \'\'),`d`.`cheque_no`,`d`.`cheque_acc_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank-henria`.`voucher` `v` join `co-operativebank-henria`.`deposit` `d` where ((`v`.`Acc_no` = \'106101000013\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2023-12-28\') and (`v`.`date` <= \'2024-12-27\')) group by `v`.`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`,\' \',if((`w`.`cheque_no` = \'\'),`w`.`trnsfer_acc`,`w`.`cheque_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank-henria`.`voucher` `v` join `co-operativebank-henria`.`withdrawl` `w` where ((`v`.`Acc_no` = \'106101000013\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2023-12-28\') and (`v`.`date` <= \'2024-12-27\')) group by `v`.`no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
md5=787937236df5ac16137e87dcdf6e5617
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-12-27 08:34:52
create-version=1
source=SELECT v.vch_no,v.no,v.date,v.Acc_no,concat(lfnof,\'\',v.vch_type,\' \',if(d.cheque_acc_no=\'\',d.cheque_no,d.cheque_acc_no)) vch_type,v.Dr,v.Cr,d.Deposited_by as depo_by,v.user_code FROM `voucher` v, deposit d WHERE v.acc_no=\'106101000013\' and v.vch_no=d.shilp and v.date=d.date and v.acc_no=d.acc_no and v.date>=\'2023-12-28\' and v.date<=\'2024-12-27\' group by no,vch_type,date,amt union all select v.vch_no,v.no,v.date,v.Acc_no,concat(v.vch_type,\' \',if(w.cheque_no=\'\', w.trnsfer_acc,w.cheque_no)) as vch_type,v.Dr,v.Cr,w.Withdrawn_by as depo_by,v.user_code FROM `voucher` v,withdrawl w where v.acc_no=\'106101000013\' and v.vch_no=w.slip_no and v.acc_no=w.acc_no and v.date>=\'2023-12-28\' and v.date<=\'2024-12-27\' group by no,vch_type,date,amt
client_cs_name=utf8
connection_cl_name=utf8_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`.`lfnof`,\'\',`v`.`vch_type`,\' \',if((`d`.`cheque_acc_no` = \'\'),`d`.`cheque_no`,`d`.`cheque_acc_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank-henria`.`voucher` `v` join `co-operativebank-henria`.`deposit` `d` where ((`v`.`Acc_no` = \'106101000013\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2023-12-28\') and (`v`.`date` <= \'2024-12-27\')) group by `v`.`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`,\' \',if((`w`.`cheque_no` = \'\'),`w`.`trnsfer_acc`,`w`.`cheque_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank-henria`.`voucher` `v` join `co-operativebank-henria`.`withdrawl` `w` where ((`v`.`Acc_no` = \'106101000013\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2023-12-28\') and (`v`.`date` <= \'2024-12-27\')) group by `v`.`no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
