TYPE=VIEW
query=select (((select sum(`co-operativebank-bajbajia`.`headvoucher`.`cr`) AS `bal` from `co-operativebank-bajbajia`.`headvoucher` where (((`co-operativebank-bajbajia`.`headvoucher`.`type` = \'CASH\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'11000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'13000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'14000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'21000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'23000\') or (`co-operativebank-bajbajia`.`headvoucher`.`main_head` = \'50000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'41000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'42000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'43000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'44000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'46000\') or (`co-operativebank-bajbajia`.`headvoucher`.`main_head` = \'60000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'34000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'35000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'37000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'32000\')) and (`co-operativebank-bajbajia`.`headvoucher`.`htcode` <> \'64000\') and (`co-operativebank-bajbajia`.`headvoucher`.`date` < \'2019-01-05\'))) - (select sum(`co-operativebank-bajbajia`.`headvoucher`.`dr`) AS `bal` from `co-operativebank-bajbajia`.`headvoucher` where (((`co-operativebank-bajbajia`.`headvoucher`.`type` = \'CASH\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'11000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'13000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'14000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'23000\') or (`co-operativebank-bajbajia`.`headvoucher`.`main_head` = \'60000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'34000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'35000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'37000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'32000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'21000\') or (`co-operativebank-bajbajia`.`headvoucher`.`main_head` = \'50000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'41000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'42000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'43000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'44000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'46000\')) and (`co-operativebank-bajbajia`.`headvoucher`.`htcode` <> \'64000\') and (`co-operativebank-bajbajia`.`headvoucher`.`date` < \'2019-01-05\')))) - (select (sum(`co-operativebank-bajbajia`.`headvoucher`.`cr`) - sum(`co-operativebank-bajbajia`.`headvoucher`.`dr`)) AS `bal` from `co-operativebank-bajbajia`.`headvoucher` where (((`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'28000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'22000\')) and (`co-operativebank-bajbajia`.`headvoucher`.`date` < \'2019-01-05\')))) AS `opbal`
md5=29d00b9352a856b79c444b342dee1bea
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:51:55
create-version=1
source=select (((select sum(`headvoucher`.`cr`) AS `bal` from `headvoucher` where (((`headvoucher`.`type` = \'CASH\') or (`headvoucher`.`htcode` = \'11000\') or (`headvoucher`.`htcode` = \'13000\') or (`headvoucher`.`htcode` = \'14000\') or (`headvoucher`.`htcode` = \'21000\') or (`headvoucher`.`htcode` = \'23000\') or (`headvoucher`.`main_head` = \'50000\') or (`headvoucher`.`htcode` = \'41000\') or (`headvoucher`.`htcode` = \'42000\') or (`headvoucher`.`htcode` = \'43000\') or (`headvoucher`.`htcode` = \'44000\') or (`headvoucher`.`htcode` = \'46000\') or (`headvoucher`.`main_head` = \'60000\') or (`headvoucher`.`htcode` = \'34000\') or (`headvoucher`.`htcode` = \'35000\') or (`headvoucher`.`htcode` = \'37000\') or (`headvoucher`.`htcode` = \'32000\')) and (`headvoucher`.`htcode` <> \'64000\') and (`headvoucher`.`date` < \'2019-01-05\'))) - (select sum(`headvoucher`.`dr`) AS `bal` from `headvoucher` where (((`headvoucher`.`type` = \'CASH\') or (`headvoucher`.`htcode` = \'11000\') or (`headvoucher`.`htcode` = \'13000\') or (`headvoucher`.`htcode` = \'14000\') or (`headvoucher`.`htcode` = \'23000\') or (`headvoucher`.`main_head` = \'60000\') or (`headvoucher`.`htcode` = \'34000\') or (`headvoucher`.`htcode` = \'35000\') or (`headvoucher`.`htcode` = \'37000\') or (`headvoucher`.`htcode` = \'32000\') or (`headvoucher`.`htcode` = \'21000\') or (`headvoucher`.`main_head` = \'50000\') or (`headvoucher`.`htcode` = \'41000\') or (`headvoucher`.`htcode` = \'42000\') or (`headvoucher`.`htcode` = \'43000\') or (`headvoucher`.`htcode` = \'44000\') or (`headvoucher`.`htcode` = \'46000\')) and (`headvoucher`.`htcode` <> \'64000\') and (`headvoucher`.`date` < \'2019-01-05\')))) - (select (sum(`headvoucher`.`cr`) - sum(`headvoucher`.`dr`)) AS `bal` from `headvoucher` where (((`headvoucher`.`htcode` = \'28000\') or (`headvoucher`.`htcode` = \'22000\')) and (`headvoucher`.`date` < \'2019-01-05\')))) AS `opbal`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select (((select sum(`co-operativebank-bajbajia`.`headvoucher`.`cr`) AS `bal` from `co-operativebank-bajbajia`.`headvoucher` where (((`co-operativebank-bajbajia`.`headvoucher`.`type` = \'CASH\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'11000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'13000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'14000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'21000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'23000\') or (`co-operativebank-bajbajia`.`headvoucher`.`main_head` = \'50000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'41000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'42000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'43000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'44000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'46000\') or (`co-operativebank-bajbajia`.`headvoucher`.`main_head` = \'60000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'34000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'35000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'37000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'32000\')) and (`co-operativebank-bajbajia`.`headvoucher`.`htcode` <> \'64000\') and (`co-operativebank-bajbajia`.`headvoucher`.`date` < \'2019-01-05\'))) - (select sum(`co-operativebank-bajbajia`.`headvoucher`.`dr`) AS `bal` from `co-operativebank-bajbajia`.`headvoucher` where (((`co-operativebank-bajbajia`.`headvoucher`.`type` = \'CASH\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'11000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'13000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'14000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'23000\') or (`co-operativebank-bajbajia`.`headvoucher`.`main_head` = \'60000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'34000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'35000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'37000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'32000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'21000\') or (`co-operativebank-bajbajia`.`headvoucher`.`main_head` = \'50000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'41000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'42000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'43000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'44000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'46000\')) and (`co-operativebank-bajbajia`.`headvoucher`.`htcode` <> \'64000\') and (`co-operativebank-bajbajia`.`headvoucher`.`date` < \'2019-01-05\')))) - (select (sum(`co-operativebank-bajbajia`.`headvoucher`.`cr`) - sum(`co-operativebank-bajbajia`.`headvoucher`.`dr`)) AS `bal` from `co-operativebank-bajbajia`.`headvoucher` where (((`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'28000\') or (`co-operativebank-bajbajia`.`headvoucher`.`htcode` = \'22000\')) and (`co-operativebank-bajbajia`.`headvoucher`.`date` < \'2019-01-05\')))) AS `opbal`
