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