TYPE=VIEW
query=select `co-operativebank-neturia`.`voucher`.`cash_acc` AS `acc_no`,`co-operativebank-neturia`.`voucher`.`cr` AS `cr` from `co-operativebank-neturia`.`voucher` where ((`co-operativebank-neturia`.`voucher`.`cr` > 0) and (`co-operativebank-neturia`.`voucher`.`date` > \'2017-04-01\') and (`co-operativebank-neturia`.`voucher`.`date` <= \'2018-03-31\') and ((`co-operativebank-neturia`.`voucher`.`head` = \'52100\') or (`co-operativebank-neturia`.`voucher`.`head` = \'52200\'))) group by `co-operativebank-neturia`.`voucher`.`cash_acc`
md5=622f88c75c221d91ee562c3bee89b5c8
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-08-30 16:46:55
create-version=1
source=select  `co-operativebank-neturia`.`voucher`.`cash_acc`  AS  `acc_no` ,\n `co-operativebank-neturia`.`voucher`.`cr`  AS  `cr`  from  `co-operativebank-neturia`.`voucher`  where ( (  `co-operativebank-neturia`.`voucher`.`cr`  >0 ) and (  `co-operativebank-neturia`.`voucher`.`date`  >  \'2017-04-01\' ) and (  `co-operativebank-neturia`.`voucher`.`date`  <=  \'2018-03-31\' ) and ( (  `co-operativebank-neturia`.`voucher`.`head`  =  \'52100\' ) or (  `co-operativebank-neturia`.`voucher`.`head`  =  \'52200\' ) ) ) group  by  `co-operativebank-neturia`.`voucher`.`cash_acc`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-neturia`.`voucher`.`cash_acc` AS `acc_no`,`co-operativebank-neturia`.`voucher`.`cr` AS `cr` from `co-operativebank-neturia`.`voucher` where ((`co-operativebank-neturia`.`voucher`.`cr` > 0) and (`co-operativebank-neturia`.`voucher`.`date` > \'2017-04-01\') and (`co-operativebank-neturia`.`voucher`.`date` <= \'2018-03-31\') and ((`co-operativebank-neturia`.`voucher`.`head` = \'52100\') or (`co-operativebank-neturia`.`voucher`.`head` = \'52200\'))) group by `co-operativebank-neturia`.`voucher`.`cash_acc`
