TYPE=VIEW
query=select `a`.`lf_no` AS `lf_no`,`v`.`date` AS `Open_date`,`v`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal`,`a`.`interest` AS `interest`,max(`v`.`date`) AS `pay_date` from `co-operativebank-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`account` `a` where ((`a`.`Sub_Head` = \'14107\') and (`a`.`Acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2019-06-06\')) group by `v`.`Acc_no`
md5=987e6bb3ce50fe4583d04573572abd9a
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2019-06-06 10:04:30
create-version=1
source=SELECT lf_no,date as Open_date,v.acc_no,a.name,sum(cr)-sum(dr) as bal,a.interest,max(date) as pay_date  FROM `voucher` v,account a WHERE a.sub_head=\'14107\'  and a.acc_no=v.acc_no and date<=\'2019-06-06\' group by acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`lf_no` AS `lf_no`,`v`.`date` AS `Open_date`,`v`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal`,`a`.`interest` AS `interest`,max(`v`.`date`) AS `pay_date` from `co-operativebank-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`account` `a` where ((`a`.`Sub_Head` = \'14107\') and (`a`.`Acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2019-06-06\')) group by `v`.`Acc_no`
