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-210`.`headvoucher` `hv` join `co-operativebank-210`.`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-01-15\')) group by `hv`.`shcode`
md5=ae24dbaa3c4646f55990f72d14c125b7
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-01-15 12:16:52
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-01-15\') 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-210`.`headvoucher` `hv` join `co-operativebank-210`.`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-01-15\')) group by `hv`.`shcode`
