TYPE=VIEW
query=select \'SPL BDF / RISK FUND\' AS `head`,(select sum(`gl_ope`.`bal`) from `co-operativebank-dekhaliannapurna`.`gl_ope` where ((`gl_ope`.`SHCODE` = \'17109\') or (`gl_ope`.`SHCODE` = \'17101\') or (`gl_ope`.`SHCODE` = \'171011\'))) AS `prebal`,((sum(`h`.`cr`) - sum(`h`.`dr`)) + `a`.`amt`) AS `br_up_head`,`a`.`amt` AS `amt` from `co-operativebank-dekhaliannapurna`.`headvoucher` `h` join `co-operativebank-dekhaliannapurna`.`approciation1` `a` join `co-operativebank-dekhaliannapurna`.`gl_ope` `g` where ((`g`.`SHCODE` = `h`.`shcode`) and (`g`.`SHCODE` = `a`.`sub_head`) and (`h`.`shcode` = `a`.`sub_head`) and (`h`.`date` <= \'2026-03-31\') and ((`h`.`shcode` = \'17101\') or (`h`.`shcode` = \'171011\')) and (`h`.`htcode` = \'17000\')) group by `h`.`shcode`
md5=31e7cd9bd6299b10c304f6c220f0210c
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-04-07 06:08:57
create-version=1
source=select \'SPL BDF / RISK FUND\' AS head,(select sum(bal) from gl_ope where ( shcode=\'17109\' or shcode=\'17101\' or shcode=\'171011\' )) as prebal, (sum(cr)-sum(dr)+(amt)) as br_up_head,(amt)  from headvoucher h, approciation1 a,gl_ope g where g.shcode=h.shcode and g.shcode=a.sub_head and h.shcode=a.sub_head  and   h.date<=\'2026-03-31\'  AND (h.shcode=\'17101\' OR h.shcode=\'171011\') and htcode=\'17000\'  GROUP by h.shcode
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select \'SPL BDF / RISK FUND\' AS `head`,(select sum(`gl_ope`.`bal`) from `co-operativebank-dekhaliannapurna`.`gl_ope` where ((`gl_ope`.`SHCODE` = \'17109\') or (`gl_ope`.`SHCODE` = \'17101\') or (`gl_ope`.`SHCODE` = \'171011\'))) AS `prebal`,((sum(`h`.`cr`) - sum(`h`.`dr`)) + `a`.`amt`) AS `br_up_head`,`a`.`amt` AS `amt` from `co-operativebank-dekhaliannapurna`.`headvoucher` `h` join `co-operativebank-dekhaliannapurna`.`approciation1` `a` join `co-operativebank-dekhaliannapurna`.`gl_ope` `g` where ((`g`.`SHCODE` = `h`.`shcode`) and (`g`.`SHCODE` = `a`.`sub_head`) and (`h`.`shcode` = `a`.`sub_head`) and (`h`.`date` <= \'2026-03-31\') and ((`h`.`shcode` = \'17101\') or (`h`.`shcode` = \'171011\')) and (`h`.`htcode` = \'17000\')) group by `h`.`shcode`
