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-246`.`headvoucher` `hv` join `co-operativebank-246`.`gl_opex1` `ho` where (((`hv`.`shcode` = \'17153\') or (`hv`.`shcode` = \'17154\')) 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=8aa360ea2518d8492676884aa6fbc6ab
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-02-18 10:25:17
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.shcode=\'17153\' or hv.shcode=\'17154\') 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=utf8mb4
connection_cl_name=utf8mb4_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-246`.`headvoucher` `hv` join `co-operativebank-246`.`gl_opex1` `ho` where (((`hv`.`shcode` = \'17153\') or (`hv`.`shcode` = \'17154\')) 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`
