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-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`account` `a` where ((`a`.`Sub_Head` = \'14107\') and (`a`.`Acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2025-03-31\')) group by `v`.`Acc_no`
md5=b98e03503cbd97c752065f0869728068
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-05-04 04:21:57
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<=\'2025-03-31\' 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-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`account` `a` where ((`a`.`Sub_Head` = \'14107\') and (`a`.`Acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2025-03-31\')) group by `v`.`Acc_no`
