TYPE=VIEW
query=select `h`.`shcode` AS `shcode`,`h`.`htcode` AS `htcode`,if(((`h`.`htcode` = \'21000\') or (`h`.`htcode` = \'23000\') or (`h`.`main_head` = \'60000\')),(sum(`h`.`dr`) - sum(`h`.`cr`)),(sum(`h`.`cr`) - sum(`h`.`dr`))) AS `bal` from `co-operativebank-mitrachak`.`heads_voucher` `h` where (`h`.`date` < \'2017-11-01\') group by `h`.`shcode`
md5=bee78c095e861ff1dee65721b7a6b2e4
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-05-30 04:21:30
create-version=1
source=select  `h`.`shcode`  AS  `shcode` ,\n `h`.`htcode`  AS  `htcode` ,\nif( ( (  `h`.`htcode`  =  \'21000\' ) or (  `h`.`htcode`  =  \'23000\' ) or (  `h`.`main_head`  =  \'60000\' ) ) ,\n( sum(  `h`.`dr`  )  - sum(  `h`.`cr`  )  ),\n( sum(  `h`.`cr`  )  - sum(  `h`.`dr`  )  ) ) AS  `bal`  from  `co-operativebank-mitrachak`.`heads_voucher`  `h`  where (  `h`.`date`  <  \'2017-11-01\' ) group  by  `h`.`shcode`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `h`.`shcode` AS `shcode`,`h`.`htcode` AS `htcode`,if(((`h`.`htcode` = \'21000\') or (`h`.`htcode` = \'23000\') or (`h`.`main_head` = \'60000\')),(sum(`h`.`dr`) - sum(`h`.`cr`)),(sum(`h`.`cr`) - sum(`h`.`dr`))) AS `bal` from `co-operativebank-mitrachak`.`heads_voucher` `h` where (`h`.`date` < \'2017-11-01\') group by `h`.`shcode`
