TYPE=VIEW
query=select `v1`.`Acc_no` AS `acc_no`,concat(`a`.`name`,\' \',if(((`v1`.`transtion_by` = \'SELF\') or (`v1`.`transtion_by` = \'\')),\'\',concat(\'[\',`v1`.`transtion_by`,\']\'))) AS `name`,`a`.`lfno` AS `lfno`,(sum(`v1`.`dr`) - sum(`v1`.`interest`)) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank-dekhaliannapurna`.`voucher` `v1` join `co-operativebank-dekhaliannapurna`.`quick_name` `a` where ((`v1`.`Acc_no` = `a`.`acc_no`) and (`v1`.`sub_head` = \'14101\') and (`v1`.`date` = \'2022-03-31\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by `v1`.`Acc_no`
md5=7f2e77ae8c32a4b273db7558b27a6615
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2022-06-25 11:49:41
create-version=1
source=select v1.acc_no,concat(name,\' \',if(transtion_by=\'SELF\' or transtion_by=\'\',\'\',concat(\'[\',transtion_by,\']\'))) as name,lfno,(sum(dr)-sum(v1.interest)) as CASH,\'0\' as TRAN,v1.date,v1.sub_head from voucher v1,quick_name a where v1.acc_no=a.acc_no and v1.sub_head=\'14101\' and v1.date=\'2022-03-31\' AND DEPOSIT_TYPE=\'CASH\' AND DR<>\'0\' group by v1.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v1`.`Acc_no` AS `acc_no`,concat(`a`.`name`,\' \',if(((`v1`.`transtion_by` = \'SELF\') or (`v1`.`transtion_by` = \'\')),\'\',concat(\'[\',`v1`.`transtion_by`,\']\'))) AS `name`,`a`.`lfno` AS `lfno`,(sum(`v1`.`dr`) - sum(`v1`.`interest`)) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank-dekhaliannapurna`.`voucher` `v1` join `co-operativebank-dekhaliannapurna`.`quick_name` `a` where ((`v1`.`Acc_no` = `a`.`acc_no`) and (`v1`.`sub_head` = \'14101\') and (`v1`.`date` = \'2022-03-31\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by `v1`.`Acc_no`
