TYPE=VIEW
query=select `v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'\' AS `lfno`,sum(`v1`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-bajbajia`.`voucher` `v1` join `co-operativebank-bajbajia`.`sub_head` `sh`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'22402\') and (`v1`.`date` = \'2018-07-10\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no`
md5=82e15a2c5044201cf0225b9220c8bb7d
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2019-01-10 05:51:50
create-version=1
source=select `v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'\' AS `lfno`,sum(`v1`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`voucher` `v1` join `sub_head` `sh`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'22402\') and (`v1`.`date` = \'2018-07-10\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`cr` <> \'0\')) 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`.`sub_head` AS `name`,\'\' AS `lfno`,sum(`v1`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-bajbajia`.`voucher` `v1` join `co-operativebank-bajbajia`.`sub_head` `sh`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'22402\') and (`v1`.`date` = \'2018-07-10\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no`
