TYPE=VIEW
query=select `v1`.`cash_acc` AS `acc_no`,`a`.`name` AS `name`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank`.`voucher` `v1` join `co-operativebank`.`j_a` `a` where ((`v1`.`cash_acc` = `a`.`Acc_No`) and (`v1`.`sub_head` = \'62302\') and (`v1`.`date` = \'2018-05-18\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`head` > 60000) and (`v1`.`dr` <> \'0\')) group by `v1`.`cash_acc`
md5=600c4a2b0073dec19100876d9358bb11
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2018-05-19 02:08:13
create-version=1
source=select cash_acc as acc_no,name,sum(dr) as CASH,\'0\' as TRAN,date,v1.sub_head from voucher v1,j_a a where v1.cash_acc=a.acc_no and v1.sub_head=\'62302\' and v1.date=\'2018-05-18\' AND DEPOSIT_TYPE=\'CASH\' and v1.head>60000 AND dR<>\'0\' group by cash_acc
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select `v1`.`cash_acc` AS `acc_no`,`a`.`name` AS `name`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank`.`voucher` `v1` join `co-operativebank`.`j_a` `a` where ((`v1`.`cash_acc` = `a`.`Acc_No`) and (`v1`.`sub_head` = \'62302\') and (`v1`.`date` = \'2018-05-18\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`head` > 60000) and (`v1`.`dr` <> \'0\')) group by `v1`.`cash_acc`
