TYPE=VIEW
query=select `co-operativebank-115`.`headvoucher`.`hslno` AS `sl_no`,`co-operativebank-115`.`headvoucher`.`htcode` AS `code`,`co-operativebank-115`.`headvoucher`.`head_type` AS `head_type`,(sum(`co-operativebank-115`.`headvoucher`.`cr`) - sum(`co-operativebank-115`.`headvoucher`.`dr`)) AS `cur_bal`,\'0\' AS `bal`,`co-operativebank-115`.`headvoucher`.`shcode` AS `shcode`,`co-operativebank-115`.`headvoucher`.`main_head` AS `main_head` from `co-operativebank-115`.`headvoucher` where ((`co-operativebank-115`.`headvoucher`.`shcode` <> \'12301\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'12302\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'19205\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'19206\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'19207\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'19211\') and ((`co-operativebank-115`.`headvoucher`.`main_head` = 10000) or (`co-operativebank-115`.`headvoucher`.`htcode` = \'46000\')) and (`co-operativebank-115`.`headvoucher`.`date` <= \'2019-03-31\') and ((`co-operativebank-115`.`headvoucher`.`cr` <> 0) or (`co-operativebank-115`.`headvoucher`.`dr` <> 0))) group by `co-operativebank-115`.`headvoucher`.`htcode` union all select \'2\' AS `sl_no`,\'12000\' AS `code`,\'RESERVES & SURPLUS\' AS `head_type`,sum(`co-operativebank-115`.`approciation`.`amt`) AS `cur_bal`,0 AS `bal`,\'\' AS `shcode`,\'10000\' AS `main_hyead` from `co-operativebank-115`.`approciation` where (`co-operativebank-115`.`approciation`.`sub_head` <> \'12301\') group by `co-operativebank-115`.`approciation`.`main_head`
md5=0ef14de107b92fdfa67883319162cf70
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2024-04-23 06:49:54
create-version=1
source=select  `co-operativebank-115`.`headvoucher`.`hslno`  AS  `sl_no` ,\n `co-operativebank-115`.`headvoucher`.`htcode`  AS  `code` ,\n `co-operativebank-115`.`headvoucher`.`head_type`  AS  `head_type` ,\n( sum(  `co-operativebank-115`.`headvoucher`.`cr`  )  - sum(  `co-operativebank-115`.`headvoucher`.`dr`  )  ) AS  `cur_bal` ,\n \'0\' AS  `bal` ,\n `co-operativebank-115`.`headvoucher`.`shcode`  AS  `shcode` ,\n `co-operativebank-115`.`headvoucher`.`main_head`  AS  `main_head`  from  `co-operativebank-115`.`headvoucher`  where ( (  `co-operativebank-115`.`headvoucher`.`shcode`  <>  \'12301\' ) and (  `co-operativebank-115`.`headvoucher`.`shcode`  <>  \'12302\' ) and (  `co-operativebank-115`.`headvoucher`.`shcode`  <>  \'19205\' ) and (  `co-operativebank-115`.`headvoucher`.`shcode`  <>  \'19206\' ) and (  `co-operativebank-115`.`headvoucher`.`shcode`  <>  \'19207\' ) and (  `co-operativebank-115`.`headvoucher`.`shcode`  <>  \'19211\' ) and ( (  `co-operativebank-115`.`headvoucher`.`main_head`  =10000 ) or (  `co-operativebank-115`.`headvoucher`.`htcode`  =  \'46000\' ) ) and (  `co-operativebank-115`.`headvoucher`.`date`  <=  \'2019-03-31\' ) and ( (  `co-operativebank-115`.`headvoucher`.`cr`  <>0 ) or (  `co-operativebank-115`.`headvoucher`.`dr`  <>0 ) ) ) group  by  `co-operativebank-115`.`headvoucher`.`htcode`  union  all  select  \'2\' AS  `sl_no` ,\n \'12000\' AS  `code` ,\n \'RESERVES & SURPLUS\' AS  `head_type` ,\nsum(  `co-operativebank-115`.`approciation`.`amt`  )  AS  `cur_bal` ,\n0 AS  `bal` ,\n \'\' AS  `shcode` ,\n \'10000\' AS  `main_hyead`  from  `co-operativebank-115`.`approciation`  where (  `co-operativebank-115`.`approciation`.`sub_head`  <>  \'12301\' ) group  by  `co-operativebank-115`.`approciation`.`main_head`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-115`.`headvoucher`.`hslno` AS `sl_no`,`co-operativebank-115`.`headvoucher`.`htcode` AS `code`,`co-operativebank-115`.`headvoucher`.`head_type` AS `head_type`,(sum(`co-operativebank-115`.`headvoucher`.`cr`) - sum(`co-operativebank-115`.`headvoucher`.`dr`)) AS `cur_bal`,\'0\' AS `bal`,`co-operativebank-115`.`headvoucher`.`shcode` AS `shcode`,`co-operativebank-115`.`headvoucher`.`main_head` AS `main_head` from `co-operativebank-115`.`headvoucher` where ((`co-operativebank-115`.`headvoucher`.`shcode` <> \'12301\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'12302\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'19205\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'19206\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'19207\') and (`co-operativebank-115`.`headvoucher`.`shcode` <> \'19211\') and ((`co-operativebank-115`.`headvoucher`.`main_head` = 10000) or (`co-operativebank-115`.`headvoucher`.`htcode` = \'46000\')) and (`co-operativebank-115`.`headvoucher`.`date` <= \'2019-03-31\') and ((`co-operativebank-115`.`headvoucher`.`cr` <> 0) or (`co-operativebank-115`.`headvoucher`.`dr` <> 0))) group by `co-operativebank-115`.`headvoucher`.`htcode` union all select \'2\' AS `sl_no`,\'12000\' AS `code`,\'RESERVES & SURPLUS\' AS `head_type`,sum(`co-operativebank-115`.`approciation`.`amt`) AS `cur_bal`,0 AS `bal`,\'\' AS `shcode`,\'10000\' AS `main_hyead` from `co-operativebank-115`.`approciation` where (`co-operativebank-115`.`approciation`.`sub_head` <> \'12301\') group by `co-operativebank-115`.`approciation`.`main_head`
