TYPE=VIEW
query=select `co-operativebank-dekhaliannapurna`.`svdetails`.`date` AS `date`,`co-operativebank-dekhaliannapurna`.`svdetails`.`acc_no` AS `acc_no`,`co-operativebank-dekhaliannapurna`.`svdetails`.`name` AS `name`,right(`co-operativebank-dekhaliannapurna`.`svdetails`.`lfno`,5) AS `lfno`,(sum(`co-operativebank-dekhaliannapurna`.`svdetails`.`amt`) - sum(`co-operativebank-dekhaliannapurna`.`svdetails`.`Interest_Amt`)) AS `amt`,`co-operativebank-dekhaliannapurna`.`svdetails`.`Interest_Amt` AS `Interest_Amt`,sum(`co-operativebank-dekhaliannapurna`.`svdetails`.`amt`) AS `Final_Amt`,sum(`co-operativebank-dekhaliannapurna`.`svdetails`.`sub_head`) AS `sub_head` from `co-operativebank-dekhaliannapurna`.`svdetails` where ((`co-operativebank-dekhaliannapurna`.`svdetails`.`acc_no` <> \'\') and (`co-operativebank-dekhaliannapurna`.`svdetails`.`acc_no` <> \'AT\')) group by `co-operativebank-dekhaliannapurna`.`svdetails`.`acc_no`
md5=e383fe547fde03d59ae7a374a898b01d
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-10-15 05:27:36
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-dekhaliannapurna`.`svdetails`.`date` AS `date`,`co-operativebank-dekhaliannapurna`.`svdetails`.`acc_no` AS `acc_no`,`co-operativebank-dekhaliannapurna`.`svdetails`.`name` AS `name`,right(`co-operativebank-dekhaliannapurna`.`svdetails`.`lfno`,5) AS `lfno`,(sum(`co-operativebank-dekhaliannapurna`.`svdetails`.`amt`) - sum(`co-operativebank-dekhaliannapurna`.`svdetails`.`Interest_Amt`)) AS `amt`,`co-operativebank-dekhaliannapurna`.`svdetails`.`Interest_Amt` AS `Interest_Amt`,sum(`co-operativebank-dekhaliannapurna`.`svdetails`.`amt`) AS `Final_Amt`,sum(`co-operativebank-dekhaliannapurna`.`svdetails`.`sub_head`) AS `sub_head` from `co-operativebank-dekhaliannapurna`.`svdetails` where ((`co-operativebank-dekhaliannapurna`.`svdetails`.`acc_no` <> \'\') and (`co-operativebank-dekhaliannapurna`.`svdetails`.`acc_no` <> \'AT\')) group by `co-operativebank-dekhaliannapurna`.`svdetails`.`acc_no`
