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`.`heads_voucher` `h` where (`h`.`date` < \'2016-04-01\') group by `h`.`shcode`
md5=c3185897baa234a66eed7b119991d743
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2017-07-31 05:12:42
create-version=1
source=select h.shcode,htcode,if(htcode=\'21000\' or htcode=\'23000\' or  `main_head`=\'60000\',(sum(h.`dr`) - sum(h.`cr`)),(sum(h.`cr`) - sum(h.`dr`))) as bal from heads_voucher h where date<\'2016-04-01\' group by h.shcode
client_cs_name=latin1
connection_cl_name=latin1_swedish_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`.`heads_voucher` `h` where (`h`.`date` < \'2016-04-01\') group by `h`.`shcode`
