TYPE=VIEW
query=select `h`.`shcode` AS `shcode`,`h`.`htcode` AS `htcode`,if(((`h`.`htcode` = \'21000\') or (`h`.`htcode` = \'23000\') or (`h`.`htcode` = \'27000\') or (`h`.`main_head` = \'60000\')),(sum(`h`.`dr`) - sum(`h`.`cr`)),(sum(`h`.`cr`) - sum(`h`.`dr`))) AS `bal` from `co-operativebank`.`headvoucher` `h` where (`h`.`date` < \'2017-04-01\') group by `h`.`shcode`
md5=fceff75efa997d6bce7083c0fe55896f
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2018-05-26 10:26:52
create-version=1
source=select h.shcode,htcode,if(htcode=\'21000\' or htcode=\'23000\' or  htcode=\'27000\' or  `main_head`=\'60000\',(sum(h.`dr`) - sum(h.`cr`)),(sum(h.`cr`) - sum(h.`dr`))) as bal from headvoucher h where date<\'2017-04-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`.`htcode` = \'27000\') or (`h`.`main_head` = \'60000\')),(sum(`h`.`dr`) - sum(`h`.`cr`)),(sum(`h`.`cr`) - sum(`h`.`dr`))) AS `bal` from `co-operativebank`.`headvoucher` `h` where (`h`.`date` < \'2017-04-01\') group by `h`.`shcode`
