TYPE=VIEW
query=select `co-operativebank`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank`.`headvoucher`.`shcode` AS `code`,\'BY CASH A/C\' AS `sub_head`,sum(`co-operativebank`.`headvoucher`.`cr`) AS `dr`,0 AS `cr`,0 AS `interest`,`co-operativebank`.`headvoucher`.`hcode` AS `head`,`co-operativebank`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank`.`headvoucher` where ((`co-operativebank`.`headvoucher`.`deposit_type` = \'CASH\') and (`co-operativebank`.`headvoucher`.`date` = \'2021-12-14\') and ((`co-operativebank`.`headvoucher`.`shcode` = \'14102\') or (`co-operativebank`.`headvoucher`.`shcode` = \'57915\'))) union all select `co-operativebank`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank`.`headvoucher`.`shcode` AS `code`,\'BY TRANSFER A/C\' AS `sub_head`,sum(`co-operativebank`.`headvoucher`.`cr`) AS `dr`,0 AS `cr`,0 AS `interest`,`co-operativebank`.`headvoucher`.`hcode` AS `head`,`co-operativebank`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank`.`headvoucher` where ((`co-operativebank`.`headvoucher`.`deposit_type` = \'TRANSFER\') and (`co-operativebank`.`headvoucher`.`date` = \'2021-12-14\') and ((`co-operativebank`.`headvoucher`.`shcode` = \'14102\') or (`co-operativebank`.`headvoucher`.`shcode` = \'57915\'))) union all select `co-operativebank`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank`.`headvoucher`.`shcode` AS `code`,concat(\'TO \',`co-operativebank`.`headvoucher`.`sub_head`,\' A/C\') AS `sub_head`,0 AS `dr`,sum(`co-operativebank`.`headvoucher`.`cr`) AS `cr`,0 AS `interest`,`co-operativebank`.`headvoucher`.`hcode` AS `head`,`co-operativebank`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank`.`headvoucher` where ((`co-operativebank`.`headvoucher`.`date` = \'2021-12-14\') and (`co-operativebank`.`headvoucher`.`shcode` = \'14102\')) union all select `co-operativebank`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank`.`headvoucher`.`shcode` AS `code`,concat(\'TO PENALTY INTEREST\',\' A/C\') AS `sub_head`,0 AS `dr`,sum(`co-operativebank`.`headvoucher`.`cr`) AS `cr`,0 AS `interest`,`co-operativebank`.`headvoucher`.`hcode` AS `head`,`co-operativebank`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank`.`headvoucher` where ((`co-operativebank`.`headvoucher`.`date` = \'2021-12-14\') and (`co-operativebank`.`headvoucher`.`shcode` = \'57915\'))
md5=e6535a7f2378ef4324a17e8a98cc29c2
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2021-12-14 03:42:00
create-version=1
source=select sub_head as headname,shcode as code,\'BY CASH A/C\' AS sub_head,sum(cr) dr,0 cr,0 as interest, hcode as head,htcode htcode,0 as m_count from headvoucher where  deposit_type=\'CASH\' and date=\'2021-12-14\'  AND (SHCODE=\'14102\' OR SHCODE=\'57915\') union all select sub_head as headname,shcode as code,\'BY TRANSFER A/C\' AS sub_head,sum(cr) dr,0 cr,0 as interest, hcode as head,htcode htcode,0 as m_count from headvoucher where  deposit_type=\'TRANSFER\' and date=\'2021-12-14\'  AND (SHCODE=\'14102\'  OR SHCODE=\'57915\') union all select sub_head as headname,shcode as code,CONCAT(\'TO \',sub_head,\' A/C\') AS sub_head,0 dr,sum(cr) cr,0 as interest, hcode as head,htcode htcode,0 as m_count from headvoucher where   date=\'2021-12-14\'  AND SHCODE=\'14102\' union all select sub_head as headname,shcode as code,CONCAT(\'TO PENALTY INTEREST\',\' A/C\') AS sub_head,0 dr,sum(cr) cr,0 as interest, hcode as head,htcode htcode,0 as m_count from headvoucher where   date=\'2021-12-14\'  AND SHCODE=\'57915\'
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank`.`headvoucher`.`shcode` AS `code`,\'BY CASH A/C\' AS `sub_head`,sum(`co-operativebank`.`headvoucher`.`cr`) AS `dr`,0 AS `cr`,0 AS `interest`,`co-operativebank`.`headvoucher`.`hcode` AS `head`,`co-operativebank`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank`.`headvoucher` where ((`co-operativebank`.`headvoucher`.`deposit_type` = \'CASH\') and (`co-operativebank`.`headvoucher`.`date` = \'2021-12-14\') and ((`co-operativebank`.`headvoucher`.`shcode` = \'14102\') or (`co-operativebank`.`headvoucher`.`shcode` = \'57915\'))) union all select `co-operativebank`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank`.`headvoucher`.`shcode` AS `code`,\'BY TRANSFER A/C\' AS `sub_head`,sum(`co-operativebank`.`headvoucher`.`cr`) AS `dr`,0 AS `cr`,0 AS `interest`,`co-operativebank`.`headvoucher`.`hcode` AS `head`,`co-operativebank`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank`.`headvoucher` where ((`co-operativebank`.`headvoucher`.`deposit_type` = \'TRANSFER\') and (`co-operativebank`.`headvoucher`.`date` = \'2021-12-14\') and ((`co-operativebank`.`headvoucher`.`shcode` = \'14102\') or (`co-operativebank`.`headvoucher`.`shcode` = \'57915\'))) union all select `co-operativebank`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank`.`headvoucher`.`shcode` AS `code`,concat(\'TO \',`co-operativebank`.`headvoucher`.`sub_head`,\' A/C\') AS `sub_head`,0 AS `dr`,sum(`co-operativebank`.`headvoucher`.`cr`) AS `cr`,0 AS `interest`,`co-operativebank`.`headvoucher`.`hcode` AS `head`,`co-operativebank`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank`.`headvoucher` where ((`co-operativebank`.`headvoucher`.`date` = \'2021-12-14\') and (`co-operativebank`.`headvoucher`.`shcode` = \'14102\')) union all select `co-operativebank`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank`.`headvoucher`.`shcode` AS `code`,concat(\'TO PENALTY INTEREST\',\' A/C\') AS `sub_head`,0 AS `dr`,sum(`co-operativebank`.`headvoucher`.`cr`) AS `cr`,0 AS `interest`,`co-operativebank`.`headvoucher`.`hcode` AS `head`,`co-operativebank`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank`.`headvoucher` where ((`co-operativebank`.`headvoucher`.`date` = \'2021-12-14\') and (`co-operativebank`.`headvoucher`.`shcode` = \'57915\'))
