TYPE=VIEW
query=select `co-operativebank`.`voucher`.`Acc_no` AS `Acc_no`,`co-operativebank`.`voucher`.`vch_no` AS `vch_no`,`l`.`name` AS `name`,`co-operativebank`.`voucher`.`vch_type` AS `vch_type`,`co-operativebank`.`voucher`.`dr` AS `dr`,`co-operativebank`.`voucher`.`cr` AS `cr`,`co-operativebank`.`voucher`.`date` AS `date`,`l`.`acc_type` AS `acc_type`,`l`.`sub_head` AS `sub_head` from (`co-operativebank`.`voucher` join `co-operativebank`.`ledgers` `l`) where ((`l`.`acc_no` = `co-operativebank`.`voucher`.`Acc_no`) and (`co-operativebank`.`voucher`.`deposit_type` = \'Cash\') and (`co-operativebank`.`voucher`.`status` = \'1\'))
md5=6e51dd55f5d02a4734ba2d3d540fbefe
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-12-01 04:25:54
create-version=1
source=select `voucher`.`Acc_no` AS `Acc_no`,`voucher`.`vch_no` AS `vch_no`,`l`.`name` AS `name`,`voucher`.`vch_type` AS `vch_type`,`voucher`.`dr` AS `dr`,`voucher`.`cr` AS `cr`,`voucher`.`date` AS `date`,`l`.`acc_type` AS `acc_type`,`l`.`sub_head` AS `sub_head` from (`voucher` join `ledgers` `l`) where ((`l`.`acc_no` = `voucher`.`Acc_no`) and (`voucher`.`deposit_type` = \'Cash\') and (`voucher`.`status` = \'1\'))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank`.`voucher`.`Acc_no` AS `Acc_no`,`co-operativebank`.`voucher`.`vch_no` AS `vch_no`,`l`.`name` AS `name`,`co-operativebank`.`voucher`.`vch_type` AS `vch_type`,`co-operativebank`.`voucher`.`dr` AS `dr`,`co-operativebank`.`voucher`.`cr` AS `cr`,`co-operativebank`.`voucher`.`date` AS `date`,`l`.`acc_type` AS `acc_type`,`l`.`sub_head` AS `sub_head` from (`co-operativebank`.`voucher` join `co-operativebank`.`ledgers` `l`) where ((`l`.`acc_no` = `co-operativebank`.`voucher`.`Acc_no`) and (`co-operativebank`.`voucher`.`deposit_type` = \'Cash\') and (`co-operativebank`.`voucher`.`status` = \'1\'))
