TYPE=VIEW
query=select `co-operativebank-mohati`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank-mohati`.`headvoucher`.`shcode` AS `code`,\'BY CASH A/C\' AS `sub_head`,sum(`co-operativebank-mohati`.`headvoucher`.`cr`) AS `dr`,0 AS `cr`,0 AS `interest`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `head`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`deposit_type` = \'CASH\') and (`co-operativebank-mohati`.`headvoucher`.`date` = \'2022-01-10\') and ((`co-operativebank-mohati`.`headvoucher`.`shcode` = \'14201\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = (\'14201\' + 29000)))) union all select `co-operativebank-mohati`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank-mohati`.`headvoucher`.`shcode` AS `code`,\'BY TRANSFER A/C\' AS `sub_head`,sum(`co-operativebank-mohati`.`headvoucher`.`cr`) AS `dr`,0 AS `cr`,0 AS `interest`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `head`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`deposit_type` = \'TRANSFER\') and (`co-operativebank-mohati`.`headvoucher`.`date` = \'2022-01-10\') and ((`co-operativebank-mohati`.`headvoucher`.`shcode` = \'14201\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = (\'14201\' + 29000)))) union all select `co-operativebank-mohati`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank-mohati`.`headvoucher`.`shcode` AS `code`,concat(\'TO \',`co-operativebank-mohati`.`headvoucher`.`sub_head`,\' A/C\') AS `sub_head`,0 AS `dr`,sum(`co-operativebank-mohati`.`headvoucher`.`cr`) AS `cr`,0 AS `interest`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `head`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`date` = \'2022-01-10\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` = \'14201\')) union all select `co-operativebank-mohati`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank-mohati`.`headvoucher`.`shcode` AS `code`,concat(\'TO INTEREST\',\' A/C\') AS `sub_head`,0 AS `dr`,sum(`co-operativebank-mohati`.`headvoucher`.`cr`) AS `cr`,0 AS `interest`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `head`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`date` = \'2022-01-10\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` = (\'14201\' + 29000)))
md5=b6b1c4bf1c28412def1b9fd267a988f4
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2022-01-10 11:30:07
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=\'2022-01-10\'  AND (SHCODE=\'14201\' OR SHCODE=\'14201\'+29000) 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=\'2022-01-10\'  AND (SHCODE=\'14201\' OR SHCODE=\'14201\'+29000) 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=\'2022-01-10\'  AND SHCODE=\'14201\' union all select sub_head as headname,shcode as code,CONCAT(\'TO 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=\'2022-01-10\'  AND SHCODE=\'14201\'+29000
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-mohati`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank-mohati`.`headvoucher`.`shcode` AS `code`,\'BY CASH A/C\' AS `sub_head`,sum(`co-operativebank-mohati`.`headvoucher`.`cr`) AS `dr`,0 AS `cr`,0 AS `interest`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `head`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`deposit_type` = \'CASH\') and (`co-operativebank-mohati`.`headvoucher`.`date` = \'2022-01-10\') and ((`co-operativebank-mohati`.`headvoucher`.`shcode` = \'14201\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = (\'14201\' + 29000)))) union all select `co-operativebank-mohati`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank-mohati`.`headvoucher`.`shcode` AS `code`,\'BY TRANSFER A/C\' AS `sub_head`,sum(`co-operativebank-mohati`.`headvoucher`.`cr`) AS `dr`,0 AS `cr`,0 AS `interest`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `head`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`deposit_type` = \'TRANSFER\') and (`co-operativebank-mohati`.`headvoucher`.`date` = \'2022-01-10\') and ((`co-operativebank-mohati`.`headvoucher`.`shcode` = \'14201\') or (`co-operativebank-mohati`.`headvoucher`.`shcode` = (\'14201\' + 29000)))) union all select `co-operativebank-mohati`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank-mohati`.`headvoucher`.`shcode` AS `code`,concat(\'TO \',`co-operativebank-mohati`.`headvoucher`.`sub_head`,\' A/C\') AS `sub_head`,0 AS `dr`,sum(`co-operativebank-mohati`.`headvoucher`.`cr`) AS `cr`,0 AS `interest`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `head`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`date` = \'2022-01-10\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` = \'14201\')) union all select `co-operativebank-mohati`.`headvoucher`.`sub_head` AS `headname`,`co-operativebank-mohati`.`headvoucher`.`shcode` AS `code`,concat(\'TO INTEREST\',\' A/C\') AS `sub_head`,0 AS `dr`,sum(`co-operativebank-mohati`.`headvoucher`.`cr`) AS `cr`,0 AS `interest`,`co-operativebank-mohati`.`headvoucher`.`hcode` AS `head`,`co-operativebank-mohati`.`headvoucher`.`htcode` AS `htcode`,0 AS `m_count` from `co-operativebank-mohati`.`headvoucher` where ((`co-operativebank-mohati`.`headvoucher`.`date` = \'2022-01-10\') and (`co-operativebank-mohati`.`headvoucher`.`shcode` = (\'14201\' + 29000)))
