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` from ((`co-operativebank-115`.`mstr_bnk_acc` `mc` join `co-operativebank-115`.`headvoucher` `v`) join `co-operativebank-115`.`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=ba0689b73ea6d8a5448da54109a36562
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2024-04-23 06:49:42
create-version=1
source=select  `v`.`shcode`  AS  `code` ,\n `v`.`sub_head`  AS  `sub_head` ,\n `q`.`name`  AS  `NAME` ,\n `mc`.`date_open`  AS  `Opeing_Date` ,\n `mc`.`acc_no`  AS  `acc_no` ,\n `mc`.`acc_type`  AS  `acc_type` ,\n( sum(  `v`.`cr`  )  - sum(  `v`.`dr`  )  ) AS  `bal` ,\nconcat(  `mc`.`Duration` ,  \' \',  `mc`.`Duration_Type`  )  AS  `Duration` ,\n `mc`.`maturity_date`  AS  `maturity_date` ,\ntimestampdiff(  DAY ,  `mc`.`date_open` ,  \'2018-03-31\'  )  AS  `DAYS`  from ( (  `co-operativebank-115`.`mstr_bnk_acc`  `mc`  join  `co-operativebank-115`.`headvoucher`  `v`  ) join  `co-operativebank-115`.`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` from ((`co-operativebank-115`.`mstr_bnk_acc` `mc` join `co-operativebank-115`.`headvoucher` `v`) join `co-operativebank-115`.`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`
