TYPE=VIEW
query=select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'\' AS `lfno`,sum(`v1`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank`.`voucher` `v1` USE INDEX (`by_sub_head`) join `co-operativebank`.`sub_head` `sh` USE INDEX (`by_code`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'28201\') and (`v1`.`date` = \'2024-04-29\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no`,`v1`.`vch_no` union all select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'\' AS `lfno`,\'0\' AS `0`,sum(`v1`.`cr`) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank`.`voucher` `v1` USE INDEX (`by_sub_head`) join `co-operativebank`.`sub_head` `sh` USE INDEX (`by_code`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'28201\') and (`v1`.`date` = \'2024-04-29\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no`,`v1`.`vch_no`
md5=776b70606fe8a6e3325497bb2485200a
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2024-05-04 09:45:07
create-version=1
source=select v1.no,v1.acc_no,sh.sub_head as name,\'\' lfno,sum(cr) as CASH,\'0\' as TRAN,date,v1.sub_head from voucher v1 USE INDEX (by_sub_head),sub_head sh USE INDEX (by_code) where v1.sub_head=sh.code and v1.sub_head=\'28201\' and v1.date=\'2024-04-29\' AND DEPOSIT_TYPE=\'CASH\' AND cR<>\'0\' group by v1.acc_no,v1.vch_no  UNION ALL select v1.no,v1.acc_no,sh.sub_head as name,\'\' lfno,\'0\',sum(cr) as TRAN,date,v1.sub_head from voucher v1 USE INDEX (by_sub_head),sub_head sh USE INDEX (by_code) where  v1.sub_head=sh.code and v1.sub_head=\'28201\' and v1.date=\'2024-04-29\' AND DEPOSIT_TYPE=\'TRANSFER\' AND cR<>\'0\' group by v1.acc_no,v1.vch_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'\' AS `lfno`,sum(`v1`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank`.`voucher` `v1` USE INDEX (`by_sub_head`) join `co-operativebank`.`sub_head` `sh` USE INDEX (`by_code`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'28201\') and (`v1`.`date` = \'2024-04-29\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no`,`v1`.`vch_no` union all select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'\' AS `lfno`,\'0\' AS `0`,sum(`v1`.`cr`) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank`.`voucher` `v1` USE INDEX (`by_sub_head`) join `co-operativebank`.`sub_head` `sh` USE INDEX (`by_code`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'28201\') and (`v1`.`date` = \'2024-04-29\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no`,`v1`.`vch_no`
