TYPE=VIEW
query=select `m`.`lf_no` AS `lf_no`,`m`.`Open_date` AS `Open_date`,`m`.`acc_no` AS `acc_no`,`m`.`name` AS `name`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal`,`m`.`interest` AS `interest`,`m`.`pay_date` AS `pay_date`,round((((sum(`v`.`cr`) - sum(`v`.`dr`)) * (timestampdiff(DAY,`m`.`pay_date`,\'2021-05-15\') / 365)) * (`m`.`interest` / 100)),0) AS `Int_amt`,timestampdiff(DAY,`m`.`pay_date`,\'2021-05-15\') AS `Days` from (`co-operativebank-198`.`mis_details` `m` join `co-operativebank-198`.`voucher` `v`) where ((`v`.`sub_head` = \'14107\') and (`m`.`acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2021-05-15\')) group by `m`.`acc_no`
md5=d9c3925cf3bf7e72276879cd139a00f6
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-07-28 05:49:36
create-version=1
source=select  `m`.`lf_no`  AS  `lf_no` ,\n `m`.`Open_date`  AS  `Open_date` ,\n `m`.`acc_no`  AS  `acc_no` ,\n `m`.`name`  AS  `name` ,\n( sum(  `v`.`cr`  )  - sum(  `v`.`dr`  )  ) AS  `bal` ,\n `m`.`interest`  AS  `interest` ,\n `m`.`pay_date`  AS  `pay_date` ,\nround( ( ( ( sum(  `v`.`cr`  )  - sum(  `v`.`dr`  )  )  * ( timestampdiff(  DAY ,  `m`.`pay_date` ,  \'2021-05-15\'  )  /365  )  ) * (  `m`.`interest`  /100  )  ),\n0 ) AS  `Int_amt` ,\ntimestampdiff(  DAY ,  `m`.`pay_date` ,  \'2021-05-15\'  )  AS  `Days`  from (  `co-operativebank-198`.`mis_details`  `m`  join  `co-operativebank-198`.`voucher`  `v`  ) where ( (  `v`.`sub_head`  =  \'14107\' ) and (  `m`.`acc_no`  =  `v`.`Acc_no`  ) and (  `v`.`date`  <=  \'2021-05-15\' ) ) group  by  `m`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `m`.`lf_no` AS `lf_no`,`m`.`Open_date` AS `Open_date`,`m`.`acc_no` AS `acc_no`,`m`.`name` AS `name`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal`,`m`.`interest` AS `interest`,`m`.`pay_date` AS `pay_date`,round((((sum(`v`.`cr`) - sum(`v`.`dr`)) * (timestampdiff(DAY,`m`.`pay_date`,\'2021-05-15\') / 365)) * (`m`.`interest` / 100)),0) AS `Int_amt`,timestampdiff(DAY,`m`.`pay_date`,\'2021-05-15\') AS `Days` from (`co-operativebank-198`.`mis_details` `m` join `co-operativebank-198`.`voucher` `v`) where ((`v`.`sub_head` = \'14107\') and (`m`.`acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2021-05-15\')) group by `m`.`acc_no`
