TYPE=VIEW
query=select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,sum(`v1`.`dr`) 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` = \'23101B\') and (`v1`.`date` = \'2026-04-13\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by `a`.`acc_no`,`v1`.`vch_no` union all select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,\'0\' AS `0`,(sum(`v1`.`dr`) - sum(`v1`.`interest`)) 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` = \'23101B\') and (`v1`.`date` = \'2026-04-13\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`dr` <> \'0\')) group by `a`.`acc_no`,`v1`.`vch_no`
md5=a84fe23211678727c640864f1f40d96a
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2026-04-13 12:27:25
create-version=1
source=select v1.no,v1.acc_no,name,lfno,(sum(dr)) as CASH,\'0\' as TRAN,date,v1.sub_head from voucher v1 , quick_name a   where v1.acc_no=a.acc_no and v1.sub_head=\'23101B\' and v1.date=\'2026-04-13\' AND DEPOSIT_TYPE=\'CASH\' AND DR<>\'0\' group by a.acc_no,v1.vch_no  UNION ALL select v1.no,v1.acc_no,name,lfno,\'0\',(sum(dr)-sum(v1.interest)) as TRAN,date,v1.sub_head from voucher v1 ,quick_name a  where v1.acc_no=a.acc_no and v1.sub_head=\'23101B\' and v1.date=\'2026-04-13\' AND DEPOSIT_TYPE=\'TRANSFER\' AND DR<>\'0\' group by a.acc_no,v1.vch_no
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,sum(`v1`.`dr`) 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` = \'23101B\') and (`v1`.`date` = \'2026-04-13\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by `a`.`acc_no`,`v1`.`vch_no` union all select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,\'0\' AS `0`,(sum(`v1`.`dr`) - sum(`v1`.`interest`)) 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` = \'23101B\') and (`v1`.`date` = \'2026-04-13\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`dr` <> \'0\')) group by `a`.`acc_no`,`v1`.`vch_no`
