TYPE=VIEW
query=select `co-operativebank-durgapur`.`svdetails`.`date` AS `date`,`co-operativebank-durgapur`.`svdetails`.`acc_no` AS `acc_no`,`co-operativebank-durgapur`.`svdetails`.`name` AS `name`,right(`co-operativebank-durgapur`.`svdetails`.`lfno`,5) AS `lfno`,(sum(`co-operativebank-durgapur`.`svdetails`.`amt`) - sum(`co-operativebank-durgapur`.`svdetails`.`Interest_Amt`)) AS `amt`,`co-operativebank-durgapur`.`svdetails`.`Interest_Amt` AS `Interest_Amt`,sum(`co-operativebank-durgapur`.`svdetails`.`amt`) AS `Final_Amt`,sum(`co-operativebank-durgapur`.`svdetails`.`sub_head`) AS `sub_head` from `co-operativebank-durgapur`.`svdetails` where ((`co-operativebank-durgapur`.`svdetails`.`acc_no` <> \'\') and (`co-operativebank-durgapur`.`svdetails`.`acc_no` <> \'AT\')) group by `co-operativebank-durgapur`.`svdetails`.`acc_no`
md5=9f8f86dfdd500079fe695b1a6843c868
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-07-16 11:21:54
create-version=1
source=SELECT `date`, `acc_no`, `name`, RIGHT(lfno,5) as `lfno`, sum(`amt`)-sum(Interest_Amt) as amt, `Interest_Amt`,sum(`amt`) as `Final_Amt`,sum(sub_head) as sub_head FROM `svdetails` where acc_no<>\'\' and acc_no<>\'AT\'   group by acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-durgapur`.`svdetails`.`date` AS `date`,`co-operativebank-durgapur`.`svdetails`.`acc_no` AS `acc_no`,`co-operativebank-durgapur`.`svdetails`.`name` AS `name`,right(`co-operativebank-durgapur`.`svdetails`.`lfno`,5) AS `lfno`,(sum(`co-operativebank-durgapur`.`svdetails`.`amt`) - sum(`co-operativebank-durgapur`.`svdetails`.`Interest_Amt`)) AS `amt`,`co-operativebank-durgapur`.`svdetails`.`Interest_Amt` AS `Interest_Amt`,sum(`co-operativebank-durgapur`.`svdetails`.`amt`) AS `Final_Amt`,sum(`co-operativebank-durgapur`.`svdetails`.`sub_head`) AS `sub_head` from `co-operativebank-durgapur`.`svdetails` where ((`co-operativebank-durgapur`.`svdetails`.`acc_no` <> \'\') and (`co-operativebank-durgapur`.`svdetails`.`acc_no` <> \'AT\')) group by `co-operativebank-durgapur`.`svdetails`.`acc_no`
