TYPE=VIEW
query=select `v`.`shcode` AS `code`,`v`.`sub_head` AS `sub_head`,`q`.`name` AS `NAME`,`mc`.`date_open` AS `Opeing_Date`,`mc`.`acc_no` AS `acc_no`,`mc`.`acc_type` AS `acc_type`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal`,concat(`mc`.`Duration`,\' \',`mc`.`Duration_Type`) AS `Duration`,`mc`.`maturity_date` AS `maturity_date`,timestampdiff(DAY,`mc`.`date_open`,\'2018-03-31\') AS `DAYS`,`mc`.`fd_sv_acc_no` AS `SBACC` from ((`co-operativebank`.`mstr_bnk_acc` `mc` join `co-operativebank`.`headvoucher` `v`) join `co-operativebank`.`quick_name` `q`) where ((`v`.`acc_no` = `q`.`acc_no`) and (`q`.`acc_no` = `mc`.`acc_no`) and (`v`.`acc_no` = `mc`.`acc_no`) and (`v`.`date` <= \'2018-03-31\')) group by `mc`.`acc_no`
md5=8a7f9fb1c57e58b50e25de883b9d77db
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2019-07-14 05:38:50
create-version=1
source=select v.shcode AS code,v.sub_head AS sub_head,q.name AS NAME,mc.date_open AS Opeing_Date,mc.acc_no AS acc_no,mc.acc_type AS acc_type,(sum(v.cr) - sum(v.dr)) AS bal,concat(mc.Duration,\' \',mc.Duration_Type) AS Duration,mc.maturity_date AS maturity_date,timestampdiff(DAY,mc.date_open,\'2018-03-31\') AS DAYS,FD_SV_ACC_NO AS SBACC from (((mstr_bnk_acc mc join headvoucher v) ) join quick_name q) where ((v.Acc_no = q.acc_no) and (q.acc_no = mc.acc_no)  and (v.Acc_no = mc.acc_no) and (v.date <= \'2018-03-31\')) group by mc.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`shcode` AS `code`,`v`.`sub_head` AS `sub_head`,`q`.`name` AS `NAME`,`mc`.`date_open` AS `Opeing_Date`,`mc`.`acc_no` AS `acc_no`,`mc`.`acc_type` AS `acc_type`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal`,concat(`mc`.`Duration`,\' \',`mc`.`Duration_Type`) AS `Duration`,`mc`.`maturity_date` AS `maturity_date`,timestampdiff(DAY,`mc`.`date_open`,\'2018-03-31\') AS `DAYS`,`mc`.`fd_sv_acc_no` AS `SBACC` from ((`co-operativebank`.`mstr_bnk_acc` `mc` join `co-operativebank`.`headvoucher` `v`) join `co-operativebank`.`quick_name` `q`) where ((`v`.`acc_no` = `q`.`acc_no`) and (`q`.`acc_no` = `mc`.`acc_no`) and (`v`.`acc_no` = `mc`.`acc_no`) and (`v`.`date` <= \'2018-03-31\')) group by `mc`.`acc_no`
