TYPE=VIEW
query=select `co-operativebank-243`.`svdetails`.`date` AS `date`,`co-operativebank-243`.`svdetails`.`acc_no` AS `acc_no`,`co-operativebank-243`.`svdetails`.`name` AS `name`,`co-operativebank-243`.`svdetails`.`lfno` AS `lfno`,(sum(`co-operativebank-243`.`svdetails`.`amt`) - sum(`co-operativebank-243`.`svdetails`.`Interest_Amt`)) AS `amt`,`co-operativebank-243`.`svdetails`.`Interest_Amt` AS `Interest_Amt`,sum(`co-operativebank-243`.`svdetails`.`amt`) AS `Final_Amt`,sum(`co-operativebank-243`.`svdetails`.`sub_head`) AS `sub_head` from `co-operativebank-243`.`svdetails` where ((`co-operativebank-243`.`svdetails`.`acc_no` <> \'\') and (`co-operativebank-243`.`svdetails`.`acc_no` <> \'AT\')) group by `co-operativebank-243`.`svdetails`.`acc_no`
md5=b26641ea5833ad14802547c9874b7516
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2025-09-15 05:28:21
create-version=1
source=select  `co-operativebank-243`.`svdetails`.`date`  AS  `date` ,\n `co-operativebank-243`.`svdetails`.`acc_no`  AS  `acc_no` ,\n `co-operativebank-243`.`svdetails`.`name`  AS  `name` ,\n `co-operativebank-243`.`svdetails`.`lfno`  AS  `lfno` ,\n( sum(  `co-operativebank-243`.`svdetails`.`amt`  )  - sum(  `co-operativebank-243`.`svdetails`.`Interest_Amt`  )  ) AS  `amt` ,\n `co-operativebank-243`.`svdetails`.`Interest_Amt`  AS  `Interest_Amt` ,\nsum(  `co-operativebank-243`.`svdetails`.`amt`  )  AS  `Final_Amt` ,\nsum(  `co-operativebank-243`.`svdetails`.`sub_head`  )  AS  `sub_head`  from  `co-operativebank-243`.`svdetails`  where ( (  `co-operativebank-243`.`svdetails`.`acc_no`  <>  \'\' ) and (  `co-operativebank-243`.`svdetails`.`acc_no`  <>  \'AT\' ) ) group  by  `co-operativebank-243`.`svdetails`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-243`.`svdetails`.`date` AS `date`,`co-operativebank-243`.`svdetails`.`acc_no` AS `acc_no`,`co-operativebank-243`.`svdetails`.`name` AS `name`,`co-operativebank-243`.`svdetails`.`lfno` AS `lfno`,(sum(`co-operativebank-243`.`svdetails`.`amt`) - sum(`co-operativebank-243`.`svdetails`.`Interest_Amt`)) AS `amt`,`co-operativebank-243`.`svdetails`.`Interest_Amt` AS `Interest_Amt`,sum(`co-operativebank-243`.`svdetails`.`amt`) AS `Final_Amt`,sum(`co-operativebank-243`.`svdetails`.`sub_head`) AS `sub_head` from `co-operativebank-243`.`svdetails` where ((`co-operativebank-243`.`svdetails`.`acc_no` <> \'\') and (`co-operativebank-243`.`svdetails`.`acc_no` <> \'AT\')) group by `co-operativebank-243`.`svdetails`.`acc_no`
