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-bajbajia`.`heads_voucher` `h` where (`h`.`date` < \'2016-01-01\') group by `h`.`shcode`
md5=d61d1718bb8b66cf5697df8f8064069b
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:51:59
create-version=1
source=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 `heads_voucher` `h` where (`h`.`date` < \'2016-01-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-bajbajia`.`heads_voucher` `h` where (`h`.`date` < \'2016-01-01\') group by `h`.`shcode`
