TYPE=VIEW
query=select `sh`.`sub_head` AS `sub_head`,`b`.`date` AS `open_date`,`b`.`code` AS `acc_no`,`b`.`Amt` AS `amt`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `cler_bal`,`b`.`interest` AS `interest`,round((((sum(`v`.`cr`) - sum(`v`.`dr`)) * (timestampdiff(DAY,max(`v`.`date`),\'2025-04-01\') / 365)) * (`b`.`interest` / 100)),0) AS `Int_pay`,timestampdiff(DAY,max(`v`.`date`),\'2025-04-01\') AS `days` from `co-operativebank-dekhaliannapurna`.`borrowing1` `b` join `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`sub_head` `sh` where ((`v`.`Acc_no` = `b`.`code`) and (`sh`.`code` = `v`.`sub_head`) and (`sh`.`code` = `b`.`sub_head`) and (`v`.`date` <= \'2025-03-31\')) group by `b`.`code`
md5=a451c65885afd8b7be228c7c15a8947c
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-05-04 03:18:04
create-version=1
source=SELECT sh.sub_head,b.date as open_date,b.code as acc_no,b.amt,sum(v.cr)-sum(v.dr) as cler_bal,b.interest,round((sum(v.cr)-sum(dr))*(timestampdiff(day,max(v.date),\'2025-04-01\')/365)*(b.interest/100)) as Int_pay,timestampdiff(day,max(v.date),\'2025-04-01\') as days  FROM `borrowing1` B, VOUCHER V,sub_head sh WHERE V.acc_no=b.code and sh.code=v.sub_head and sh.code=b.sub_head and v.date<=\'2025-03-31\' group by b.code
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `sh`.`sub_head` AS `sub_head`,`b`.`date` AS `open_date`,`b`.`code` AS `acc_no`,`b`.`Amt` AS `amt`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `cler_bal`,`b`.`interest` AS `interest`,round((((sum(`v`.`cr`) - sum(`v`.`dr`)) * (timestampdiff(DAY,max(`v`.`date`),\'2025-04-01\') / 365)) * (`b`.`interest` / 100)),0) AS `Int_pay`,timestampdiff(DAY,max(`v`.`date`),\'2025-04-01\') AS `days` from `co-operativebank-dekhaliannapurna`.`borrowing1` `b` join `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`sub_head` `sh` where ((`v`.`Acc_no` = `b`.`code`) and (`sh`.`code` = `v`.`sub_head`) and (`sh`.`code` = `b`.`sub_head`) and (`v`.`date` <= \'2025-03-31\')) group by `b`.`code`
