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` = \'2026-03-18\') 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` = \'2026-03-18\') and (`v`.`dr` <> 0)) group by `v`.`Acc_no`,`v`.`cash_acc`
md5=28351cae134f69b40014f10c5585a617
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-03-18 05:24:50
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=\'2026-03-18\' 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=\'2026-03-18\' and dr<>0 group by v.acc_no,v.cash_acc
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_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` = \'2026-03-18\') 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` = \'2026-03-18\') and (`v`.`dr` <> 0)) group by `v`.`Acc_no`,`v`.`cash_acc`
