TYPE=VIEW
query=select `dep_return`.`shcode` AS `shcode`,`dep_return`.`sub_head` AS `sub_head`,round((`dep_return`.`Opening` / 100000),2) AS `opening`,round((if(isnull(`dep_return`.`received`),0,`dep_return`.`received`) / 100000),2) AS `received`,round(((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) / 100000),2) AS `Total_amt`,round((if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`) / 100000),2) AS `refund`,round((((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`)) / 100000),2) AS `Balance`,round(((round((((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`)) / 100000),2) / (select round((sum(((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`))) / 100000),2) from `co-operativebank-henria`.`dep_return`)) * 100),2) AS `Of_Depo`,`dep_return`.`total_no_acc` AS `new_acc` from `co-operativebank-henria`.`dep_return` where ((`dep_return`.`shcode` = \'14201\') or (`dep_return`.`shcode` = \'14203\'))
md5=99de67c54fd58fbd24f07f24ad074351
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-04-24 02:10:58
create-version=1
source=SELECT shcode,sub_head,round((opening/100000),2) opening,round((IF(ISNULL(received),0,received)/100000),2) as received,round(((opening)+(IF(ISNULL(received),0,received)))/100000,2) as Total_amt,round((IF(ISNULL(refund),0,refund)/100000),2) as refund,round(((opening)+(IF(ISNULL(received),0,received))-IF(ISNULL(refund),0,refund))/100000,2) as Balance, round((round(((opening)+(IF(ISNULL(received),0,received))-IF(ISNULL(refund),0,refund))/100000,2)/(select round((sum((opening)+(IF(ISNULL(received),0,received))-(IF(ISNULL(refund),0,refund))))/100000,2) FROM dep_return)*100),2) as Of_Depo,total_no_acc as new_acc FROM `dep_return` where shcode=\'14201\' or shcode=\'14203\'
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `dep_return`.`shcode` AS `shcode`,`dep_return`.`sub_head` AS `sub_head`,round((`dep_return`.`Opening` / 100000),2) AS `opening`,round((if(isnull(`dep_return`.`received`),0,`dep_return`.`received`) / 100000),2) AS `received`,round(((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) / 100000),2) AS `Total_amt`,round((if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`) / 100000),2) AS `refund`,round((((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`)) / 100000),2) AS `Balance`,round(((round((((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`)) / 100000),2) / (select round((sum(((`dep_return`.`Opening` + if(isnull(`dep_return`.`received`),0,`dep_return`.`received`)) - if(isnull(`dep_return`.`refund`),0,`dep_return`.`refund`))) / 100000),2) from `co-operativebank-henria`.`dep_return`)) * 100),2) AS `Of_Depo`,`dep_return`.`total_no_acc` AS `new_acc` from `co-operativebank-henria`.`dep_return` where ((`dep_return`.`shcode` = \'14201\') or (`dep_return`.`shcode` = \'14203\'))
