TYPE=VIEW
query=select `co-operativebank`.`svdetails`.`date` AS `date`,`co-operativebank`.`svdetails`.`acc_no` AS `acc_no`,`co-operativebank`.`svdetails`.`name` AS `name`,right(`co-operativebank`.`svdetails`.`lfno`,5) AS `lfno`,(sum(`co-operativebank`.`svdetails`.`amt`) - sum(`co-operativebank`.`svdetails`.`Interest_Amt`)) AS `amt`,`co-operativebank`.`svdetails`.`Interest_Amt` AS `Interest_Amt`,sum(`co-operativebank`.`svdetails`.`amt`) AS `Final_Amt`,sum(`co-operativebank`.`svdetails`.`sub_head`) AS `sub_head` from `co-operativebank`.`svdetails` where ((`co-operativebank`.`svdetails`.`acc_no` <> \'\') and (`co-operativebank`.`svdetails`.`acc_no` <> \'AT\')) group by `co-operativebank`.`svdetails`.`acc_no`
md5=aeae31a9d595c7fc8555da1e26272c04
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2026-01-02 04:01:32
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`.`svdetails`.`date` AS `date`,`co-operativebank`.`svdetails`.`acc_no` AS `acc_no`,`co-operativebank`.`svdetails`.`name` AS `name`,right(`co-operativebank`.`svdetails`.`lfno`,5) AS `lfno`,(sum(`co-operativebank`.`svdetails`.`amt`) - sum(`co-operativebank`.`svdetails`.`Interest_Amt`)) AS `amt`,`co-operativebank`.`svdetails`.`Interest_Amt` AS `Interest_Amt`,sum(`co-operativebank`.`svdetails`.`amt`) AS `Final_Amt`,sum(`co-operativebank`.`svdetails`.`sub_head`) AS `sub_head` from `co-operativebank`.`svdetails` where ((`co-operativebank`.`svdetails`.`acc_no` <> \'\') and (`co-operativebank`.`svdetails`.`acc_no` <> \'AT\')) group by `co-operativebank`.`svdetails`.`acc_no`
