TYPE=VIEW
query=select `hv`.`sub_head` AS `sub_head`,ifnull(`ho`.`bal`,0) AS `opbal`,ifnull(sum(`hv`.`dr`),0) AS `dr`,ifnull(sum(`hv`.`cr`),0) AS `cr`,ifnull(((sum(`hv`.`cr`) - sum(`hv`.`dr`)) + `ho`.`bal`),0) AS `clbal` from `co-operativebank`.`headvoucher` `hv` join `co-operativebank`.`gl_opex1` `ho` where ((`hv`.`hcode` <> \'12300\') and ((`hv`.`shcode` = \'17103\') or (`hv`.`shcode` = \'17109\') or (`hv`.`shcode` = \'17110\') or (`hv`.`shcode` = \'17111\')) and (`hv`.`shcode` = `ho`.`SHCODE`) and (`hv`.`htcode` = \'17000\') and (`hv`.`date` >= \'2025-04-01\') and (`hv`.`date` <= \'2026-03-31\')) group by `hv`.`shcode`
md5=c6eda31f78750fc9c8a943c7a5886ca0
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2026-01-31 05:41:43
create-version=1
source=select hv.sub_head,ifnull(ho.bal,0) opbal,ifnull(sum(hv.dr),0) dr,ifnull(sum(hv.cr),0) cr,ifnull((sum(hv.cr)-SUM(Hv.dR)+HO.BAL),0) clbal from headvoucher hv,GL_OPEX1 ho where hv.hcode<>\'12300\' and (hv.shcode=\'17103\' or hv.shcode=\'17109\' or hv.shcode=\'17110\' or hv.shcode=\'17111\') and HV.shcode=HO.shcode and Hv.htcode=\'17000\' and (HV.date>=\'2025-04-01\' and HV.date<=\'2026-03-31\') group by HV.shcode
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `hv`.`sub_head` AS `sub_head`,ifnull(`ho`.`bal`,0) AS `opbal`,ifnull(sum(`hv`.`dr`),0) AS `dr`,ifnull(sum(`hv`.`cr`),0) AS `cr`,ifnull(((sum(`hv`.`cr`) - sum(`hv`.`dr`)) + `ho`.`bal`),0) AS `clbal` from `co-operativebank`.`headvoucher` `hv` join `co-operativebank`.`gl_opex1` `ho` where ((`hv`.`hcode` <> \'12300\') and ((`hv`.`shcode` = \'17103\') or (`hv`.`shcode` = \'17109\') or (`hv`.`shcode` = \'17110\') or (`hv`.`shcode` = \'17111\')) and (`hv`.`shcode` = `ho`.`SHCODE`) and (`hv`.`htcode` = \'17000\') and (`hv`.`date` >= \'2025-04-01\') and (`hv`.`date` <= \'2026-03-31\')) group by `hv`.`shcode`
