TYPE=VIEW
query=select `co-operativebank-henria`.`voucher`.`cash_acc` AS `acc_no`,`co-operativebank-henria`.`voucher`.`cr` AS `cr` from `co-operativebank-henria`.`voucher` where ((`co-operativebank-henria`.`voucher`.`cr` > 0) and (`co-operativebank-henria`.`voucher`.`date` > \'2017-04-01\') and (`co-operativebank-henria`.`voucher`.`date` <= \'2018-03-31\') and ((`co-operativebank-henria`.`voucher`.`head` = \'52100\') or (`co-operativebank-henria`.`voucher`.`head` = \'52200\'))) group by `co-operativebank-henria`.`voucher`.`cash_acc`
md5=4e1fb15e62ea6403fd3e24bdb8809801
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-07-15 17:05:53
create-version=1
source=select  `co-operativebank-henria`.`voucher`.`cash_acc`  AS  `acc_no` ,\n `co-operativebank-henria`.`voucher`.`cr`  AS  `cr`  from  `co-operativebank-henria`.`voucher`  where ( (  `co-operativebank-henria`.`voucher`.`cr`  >0 ) and (  `co-operativebank-henria`.`voucher`.`date`  >  \'2017-04-01\' ) and (  `co-operativebank-henria`.`voucher`.`date`  <=  \'2018-03-31\' ) and ( (  `co-operativebank-henria`.`voucher`.`head`  =  \'52100\' ) or (  `co-operativebank-henria`.`voucher`.`head`  =  \'52200\' ) ) ) group  by  `co-operativebank-henria`.`voucher`.`cash_acc`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-henria`.`voucher`.`cash_acc` AS `acc_no`,`co-operativebank-henria`.`voucher`.`cr` AS `cr` from `co-operativebank-henria`.`voucher` where ((`co-operativebank-henria`.`voucher`.`cr` > 0) and (`co-operativebank-henria`.`voucher`.`date` > \'2017-04-01\') and (`co-operativebank-henria`.`voucher`.`date` <= \'2018-03-31\') and ((`co-operativebank-henria`.`voucher`.`head` = \'52100\') or (`co-operativebank-henria`.`voucher`.`head` = \'52200\'))) group by `co-operativebank-henria`.`voucher`.`cash_acc`
