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-keshabchak`.`voucher` `v` join `co-operativebank-keshabchak`.`account` `a` where ((`a`.`Sub_Head` = \'14107\') and (`a`.`Acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2024-12-22\')) group by `v`.`Acc_no`
md5=70d9c8b44733e6fc5742af43f9c0865a
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2024-12-22 09:08:50
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<=\'2024-12-22\' 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-keshabchak`.`voucher` `v` join `co-operativebank-keshabchak`.`account` `a` where ((`a`.`Sub_Head` = \'14107\') and (`a`.`Acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2024-12-22\')) group by `v`.`Acc_no`
