TYPE=VIEW
query=select (sum(`co-operativebank`.`voucher`.`cr`) - sum(`co-operativebank`.`voucher`.`dr`)) AS `amt`,`co-operativebank`.`voucher`.`Acc_no` AS `ledger` from `co-operativebank`.`voucher` where (`co-operativebank`.`voucher`.`status` = \'1\') group by `co-operativebank`.`voucher`.`Acc_no` union all select (sum(`co-operativebank`.`voucher`.`cr`) - sum(`co-operativebank`.`voucher`.`dr`)) AS `amt`,`co-operativebank`.`voucher`.`cash_acc` AS `cash_acc` from `co-operativebank`.`voucher` where (`co-operativebank`.`voucher`.`status` = \'1\') group by `co-operativebank`.`voucher`.`cash_acc`
md5=28d3ca47397ccb7f52f186ab05782cb4
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-12-01 04:25:56
create-version=1
source=select (sum(`voucher`.`cr`) - sum(`voucher`.`dr`)) AS `amt`,`voucher`.`Acc_no` AS `ledger` from `voucher` where (`voucher`.`status` = \'1\') group by `voucher`.`Acc_no` union all select (sum(`voucher`.`cr`) - sum(`voucher`.`dr`)) AS `amt`,`voucher`.`cash_acc` AS `cash_acc` from `voucher` where (`voucher`.`status` = \'1\') group by `voucher`.`cash_acc`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select (sum(`co-operativebank`.`voucher`.`cr`) - sum(`co-operativebank`.`voucher`.`dr`)) AS `amt`,`co-operativebank`.`voucher`.`Acc_no` AS `ledger` from `co-operativebank`.`voucher` where (`co-operativebank`.`voucher`.`status` = \'1\') group by `co-operativebank`.`voucher`.`Acc_no` union all select (sum(`co-operativebank`.`voucher`.`cr`) - sum(`co-operativebank`.`voucher`.`dr`)) AS `amt`,`co-operativebank`.`voucher`.`cash_acc` AS `cash_acc` from `co-operativebank`.`voucher` where (`co-operativebank`.`voucher`.`status` = \'1\') group by `co-operativebank`.`voucher`.`cash_acc`
