TYPE=VIEW
query=select `v`.`no` AS `no`,`v`.`cash_acc` AS `acc_no`,`a`.`name` AS `Name`,`a`.`lfno` AS `lfno`,sum(`v`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`quick_name` `a` where (((`v`.`Acc_no` = `a`.`acc_no`) or (`v`.`cash_acc` = `a`.`acc_no`)) and ((`v`.`deposit_type` = \'CASH\') or (`v`.`deposit_type` = \'WITHDRAWL\')) and (`v`.`sub_head` = \'18935\') and (`v`.`date` = \'2025-06-20\') and (`v`.`dr` <> 0)) group by `v`.`Acc_no`,`v`.`cash_acc` union all select `v`.`no` AS `no`,`v`.`cash_acc` AS `acc_no`,`a`.`name` AS `Name`,`a`.`lfno` AS `lfno`,\'0\' AS `CASH`,sum(`v`.`dr`) AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`quick_name` `a` where (((`v`.`Acc_no` = `a`.`acc_no`) or (`v`.`cash_acc` = `a`.`acc_no`)) and (`v`.`deposit_type` = \'TRANSFER\') and (`v`.`sub_head` = \'18935\') and (`v`.`date` = \'2025-06-20\') and (`v`.`dr` <> 0)) group by `v`.`Acc_no`,`v`.`cash_acc`
md5=23cfd88fbee7a6c520b560c1c7a4a126
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-06-20 10:14:29
create-version=1
source=select v.no,v.cash_acc as acc_no,a.Name,lfno,sum(dr) as CASH,\'0\' as TRAN,v.date,v.sub_head from voucher v ,quick_name a  where (v.acc_no=a.acc_no or v.cash_acc=a.acc_no) AND (DEPOSIT_TYPE=\'CASH\' or DEPOSIT_TYPE=\'WITHDRAWL\') and v.sub_head=\'18935\' and v.date=\'2025-06-20\' and dr<>0 group by v.acc_no,v.cash_acc UNION ALL select v.no,v.cash_acc as acc_no,a.Name,lfno,\'0\' as CASH,sum(dr) as TRAN,v.date,v.sub_head from voucher v ,quick_name a  where (v.acc_no=a.acc_no or v.cash_acc=a.acc_no) AND DEPOSIT_TYPE=\'TRANSFER\' and v.sub_head=\'18935\' and v.date=\'2025-06-20\' and dr<>0 group by v.acc_no,v.cash_acc
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`no` AS `no`,`v`.`cash_acc` AS `acc_no`,`a`.`name` AS `Name`,`a`.`lfno` AS `lfno`,sum(`v`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`quick_name` `a` where (((`v`.`Acc_no` = `a`.`acc_no`) or (`v`.`cash_acc` = `a`.`acc_no`)) and ((`v`.`deposit_type` = \'CASH\') or (`v`.`deposit_type` = \'WITHDRAWL\')) and (`v`.`sub_head` = \'18935\') and (`v`.`date` = \'2025-06-20\') and (`v`.`dr` <> 0)) group by `v`.`Acc_no`,`v`.`cash_acc` union all select `v`.`no` AS `no`,`v`.`cash_acc` AS `acc_no`,`a`.`name` AS `Name`,`a`.`lfno` AS `lfno`,\'0\' AS `CASH`,sum(`v`.`dr`) AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`quick_name` `a` where (((`v`.`Acc_no` = `a`.`acc_no`) or (`v`.`cash_acc` = `a`.`acc_no`)) and (`v`.`deposit_type` = \'TRANSFER\') and (`v`.`sub_head` = \'18935\') and (`v`.`date` = \'2025-06-20\') and (`v`.`dr` <> 0)) group by `v`.`Acc_no`,`v`.`cash_acc`
