TYPE=VIEW
query=select `v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'\' AS `lfno`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank-purbadekhali`.`voucher` `v1` join `co-operativebank-purbadekhali`.`sub_head` `sh` where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'61218\') and (`v1`.`date` = \'2025-02-19\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by (`v1`.`Acc_no` or `v1`.`cash_acc`)
md5=f0418482f64171c6267669abe396c849
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-02-19 07:53:48
create-version=1
source=select v1.acc_no,sh.sub_head as name,\'\' lfno,sum(dr) as CASH,\'0\' as TRAN,date,v1.sub_head from voucher v1,sub_head sh where v1.sub_head=sh.code and v1.sub_head=\'61218\' and v1.date=\'2025-02-19\' AND DEPOSIT_TYPE=\'CASH\' AND dR<>\'0\' group by (v1.acc_no or v1.cash_acc)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'\' AS `lfno`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank-purbadekhali`.`voucher` `v1` join `co-operativebank-purbadekhali`.`sub_head` `sh` where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'61218\') and (`v1`.`date` = \'2025-02-19\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by (`v1`.`Acc_no` or `v1`.`cash_acc`)
