TYPE=VIEW
query=select `v1`.`Acc_no` AS `acc_no`,`sh`.`name` AS `name`,`sh`.`lfno` AS `lfno`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank-keshabchak`.`voucher` `v1` join `co-operativebank-keshabchak`.`quick_name` `sh` where ((`v1`.`Acc_no` = `sh`.`acc_no`) and (`v1`.`sub_head` = \'63937\') and (`v1`.`date` = \'2024-12-31\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\') and (`v1`.`head` > 60000)) group by `v1`.`Acc_no`
md5=a59e80ca75a8a16b4f085b4deb0f343b
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-01-18 07:15:02
create-version=1
source=select v1.acc_no,sh.name as name,lfno,sum(dr) as CASH,\'0\' as TRAN,date,v1.sub_head from voucher v1,quick_name sh where v1.acc_no=sh.acc_no and v1.sub_head=\'63937\' and v1.date=\'2024-12-31\' AND DEPOSIT_TYPE=\'CASH\' AND dR<>\'0\' and v1.head>60000 group by v1.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v1`.`Acc_no` AS `acc_no`,`sh`.`name` AS `name`,`sh`.`lfno` AS `lfno`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank-keshabchak`.`voucher` `v1` join `co-operativebank-keshabchak`.`quick_name` `sh` where ((`v1`.`Acc_no` = `sh`.`acc_no`) and (`v1`.`sub_head` = \'63937\') and (`v1`.`date` = \'2024-12-31\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\') and (`v1`.`head` > 60000)) group by `v1`.`Acc_no`
