TYPE=VIEW
query=select `heads_voucher`.`shcode` AS `SHCODE`,(sum(`heads_voucher`.`cr`) - sum(`heads_voucher`.`dr`)) AS `BAL` from `co-operativebank`.`heads_voucher` where (`heads_voucher`.`date` < \'2016-04-01\') group by `heads_voucher`.`shcode`
md5=9082fea110db6a9359f1242f8a22d829
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2017-08-17 09:55:25
create-version=1
source=SELECT SHCODE,(sum(cr)-sum(dr)) BAL FROM heads_voucher where date<\'2016-04-01\' group by shcode
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select `heads_voucher`.`shcode` AS `SHCODE`,(sum(`heads_voucher`.`cr`) - sum(`heads_voucher`.`dr`)) AS `BAL` from `co-operativebank`.`heads_voucher` where (`heads_voucher`.`date` < \'2016-04-01\') group by `heads_voucher`.`shcode`
