TYPE=VIEW
query=select `co-operativebank-dekhaliannapurna`.`headvoucher`.`csl_no` AS `sl_no`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `code`,concat(`co-operativebank-dekhaliannapurna`.`headvoucher`.`head_type`) AS `head`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`dr`) AS `dr`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`cr`) AS `cr`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`hcode` AS `head_n`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `htcode` from `co-operativebank-dekhaliannapurna`.`headvoucher` where ((`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'64000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'38000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'19000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'65000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'24000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'25000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'15000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'16000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'23000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'28000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'22000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'57000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'51000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'52000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'53000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` >= \'2026-03-01\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` <= \'2026-03-31\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`deposit_type` <> \'ATJUST\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`dr` <> 0)) group by `co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` union select `co-operativebank-dekhaliannapurna`.`headvoucher`.`csl_no` AS `sl_no`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `code`,concat(`co-operativebank-dekhaliannapurna`.`headvoucher`.`head_type`) AS `head`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`dr`) AS `dr`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`cr`) AS `cr`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`hcode` AS `head_n`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `htcode` from `co-operativebank-dekhaliannapurna`.`headvoucher` where (((`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` = \'28000\') or (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` = \'22000\')) and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` >= \'2026-03-01\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` <= \'2026-03-31\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`deposit_type` <> \'ATJUST\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`cr` > 0)) group by `co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` union select `co-operativebank-dekhaliannapurna`.`headvoucher`.`csl_no` AS `sl_no`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `code`,concat(`co-operativebank-dekhaliannapurna`.`headvoucher`.`head_type`) AS `head`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`dr`) AS `dr`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`cr`) AS `cr`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`hcode` AS `head_n`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `htcode` from `co-operativebank-dekhaliannapurna`.`headvoucher` where ((`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'28000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'51000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'52000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'53000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` = \'23000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` >= \'2026-03-01\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` <= \'2026-03-31\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`deposit_type` <> \'ATJUST\')) group by `co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` union select 15 AS `sl_no`,\'00000\' AS `code`,\'\' AS `head`,0 AS `dr`,100 AS `cr`,\'00000\' AS `head_n`,\'00000\' AS `htcode`
md5=aef139a75b6a8c83585fe0e1d3eceb33
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-04-13 03:55:18
create-version=1
source=select csl_no as sl_no,htcode AS code,concat(head_type) as head,sum(dr) dr,sum(cr) cr,hcode as head_n, htcode from headvoucher where   htcode<>\'64000\' and (htcode <> \'38000\') and htcode<>\'19000\'  and htcode<>\'65000\' and  htcode<>\'24000\' and htcode<>\'25000\' and htcode<>\'15000\' and htcode<>\'16000\' and htcode<>\'23000\' and htcode<>\'28000\' and htcode<>\'22000\' and htcode<>\'57000\' and htcode<>\'51000\' and htcode<>\'52000\' and htcode<>\'53000\'  and date>=\'2026-03-01\' and date<=\'2026-03-31\' and deposit_type <>  \'ATJUST\' and dr<>0 group by htcode union all select csl_no as sl_no,htcode AS `code`,concat(head_type) AS `head`,sum(`dr`) AS `dr`,sum(`cr`) AS `cr`,hcode AS `head_n`, `htcode` from (headvoucher) where ( (htcode=\'28000\' or htcode=\'22000\') and  (date >= \'2026-03-01\') and (`date` <= \'2026-03-31\') and (`deposit_type` <> \'ATJUST\')) and cr>0 group by `htcode` union ALL select csl_no as sl_no,htcode AS code,concat(head_type) as head,sum(dr) dr,sum(cr) cr,hcode AS `head_n`,htcode from headvoucher where htcode<>\'28000\' and htcode<>\'51000\' and htcode<>\'52000\' and htcode<>\'53000\' and htcode=\'23000\' and date>=\'2026-03-01\' and date<=\'2026-03-31\' and deposit_type <> \'ATJUST\' group by htcode union SELECT 15 as sl_no, \'00000\' as code,\'\' as head,0 as dr,100 as cr,\'00000\' as head_n,\'00000\' as htcode
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `co-operativebank-dekhaliannapurna`.`headvoucher`.`csl_no` AS `sl_no`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `code`,concat(`co-operativebank-dekhaliannapurna`.`headvoucher`.`head_type`) AS `head`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`dr`) AS `dr`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`cr`) AS `cr`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`hcode` AS `head_n`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `htcode` from `co-operativebank-dekhaliannapurna`.`headvoucher` where ((`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'64000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'38000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'19000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'65000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'24000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'25000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'15000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'16000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'23000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'28000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'22000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'57000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'51000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'52000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'53000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` >= \'2026-03-01\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` <= \'2026-03-31\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`deposit_type` <> \'ATJUST\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`dr` <> 0)) group by `co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` union select `co-operativebank-dekhaliannapurna`.`headvoucher`.`csl_no` AS `sl_no`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `code`,concat(`co-operativebank-dekhaliannapurna`.`headvoucher`.`head_type`) AS `head`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`dr`) AS `dr`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`cr`) AS `cr`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`hcode` AS `head_n`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `htcode` from `co-operativebank-dekhaliannapurna`.`headvoucher` where (((`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` = \'28000\') or (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` = \'22000\')) and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` >= \'2026-03-01\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` <= \'2026-03-31\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`deposit_type` <> \'ATJUST\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`cr` > 0)) group by `co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` union select `co-operativebank-dekhaliannapurna`.`headvoucher`.`csl_no` AS `sl_no`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `code`,concat(`co-operativebank-dekhaliannapurna`.`headvoucher`.`head_type`) AS `head`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`dr`) AS `dr`,sum(`co-operativebank-dekhaliannapurna`.`headvoucher`.`cr`) AS `cr`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`hcode` AS `head_n`,`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` AS `htcode` from `co-operativebank-dekhaliannapurna`.`headvoucher` where ((`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'28000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'51000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'52000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` <> \'53000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` = \'23000\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` >= \'2026-03-01\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`date` <= \'2026-03-31\') and (`co-operativebank-dekhaliannapurna`.`headvoucher`.`deposit_type` <> \'ATJUST\')) group by `co-operativebank-dekhaliannapurna`.`headvoucher`.`htcode` union select 15 AS `sl_no`,\'00000\' AS `code`,\'\' AS `head`,0 AS `dr`,100 AS `cr`,\'00000\' AS `head_n`,\'00000\' AS `htcode`
