TYPE=VIEW
query=select `d`.`id` AS `id`,`d`.`no` AS `no`,`d`.`member_id` AS `member_id`,`d`.`acc_no` AS `acc_no`,`d`.`acc_type` AS `acc_type`,`d`.`operation_type` AS `operation_type`,`d`.`date_open` AS `date_open`,`d`.`sub_head` AS `sub_head`,`d`.`Deposit_Type` AS `Deposit_Type`,`d`.`Chk_Acc_No` AS `Chk_Acc_No`,`d`.`Chk_No` AS `Chk_No`,`d`.`Draw_Bank` AS `Draw_Bank`,`d`.`amt` AS `amt`,`d`.`interest` AS `interest`,`d`.`Duration` AS `Duration`,`d`.`Duration_Type` AS `Duration_Type`,`d`.`Instalment_Type` AS `Instalment_Type`,`d`.`Age_Type` AS `Age_Type`,`d`.`maturity_amt` AS `maturity_amt`,`d`.`maturity_date` AS `maturity_date`,`d`.`status` AS `status`,`d`.`acc_type_code` AS `acc_type_code`,`d`.`intro_acc_no` AS `intro_acc_no`,`d`.`app_code` AS `app_code`,`d`.`fd_sv_acc_no` AS `fd_sv_acc_no`,`d`.`rd_dep_per` AS `rd_dep_per`,`d`.`scheme` AS `scheme`,`d`.`mis_benifit` AS `mis_benifit`,`d`.`loan_acc_no` AS `loan_acc_no`,`d`.`group_mem` AS `group_mem`,`d`.`lf_no` AS `lf_no`,`d`.`bankacc` AS `bankacc`,`d`.`deperment` AS `deperment`,`d`.`groupno` AS `groupno`,`d`.`block` AS `block`,`f`.`CNO` AS `CNO`,`f`.`DUR` AS `DUR`,`f`.`Durattion_D` AS `Durattion_D`,`f`.`INTN` AS `INTN`,`f`.`Code` AS `Code`,round(((`d`.`maturity_amt` * pow((1 + (`f`.`INTN` / 400)),(4 * (timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) / 365)))) - `d`.`maturity_amt`),0) AS `INTAMT`,timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) AS `DAYS` from (`co-operativebank`.`deposit_acc` `d` join `co-operativebank`.`fdschem1` `f`) where ((`f`.`DUR` = `d`.`Duration`) and (`f`.`Durattion_D` = `d`.`Duration_Type`) and (`d`.`maturity_date` <= now()) and ((`d`.`sub_head` = \'14103\') or (`d`.`sub_head` = \'14203\') or (`d`.`sub_head` = \'14303\')) and (`d`.`status` = \'ACTIVE\'))
md5=4c36a859b074d556379f428a0506561e
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2019-07-10 16:23:10
create-version=1
source=select D.*,F.*,ROUND(maturity_amt * power((1 + (INTN / 400)) , (4 * (TIMESTAMPDIFF(DAY,date_open,maturity_date) / 365)))-maturity_amt) AS INTAMT,TIMESTAMPDIFF(DAY,date_open,maturity_date) AS DAYS from (`deposit_acc` `d` join `fdschem1` `f`) where ((`f`.`DUR` = `d`.`Duration`) and (`f`.`Durattion_D` = `d`.`Duration_Type`) and (`d`.`maturity_date` <= now()) and (`d`.`sub_head` = \'14103\' OR `d`.`sub_head` = \'14203\' OR `d`.`sub_head` = \'14303\') and (`d`.`status` = \'ACTIVE\'))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `d`.`id` AS `id`,`d`.`no` AS `no`,`d`.`member_id` AS `member_id`,`d`.`acc_no` AS `acc_no`,`d`.`acc_type` AS `acc_type`,`d`.`operation_type` AS `operation_type`,`d`.`date_open` AS `date_open`,`d`.`sub_head` AS `sub_head`,`d`.`Deposit_Type` AS `Deposit_Type`,`d`.`Chk_Acc_No` AS `Chk_Acc_No`,`d`.`Chk_No` AS `Chk_No`,`d`.`Draw_Bank` AS `Draw_Bank`,`d`.`amt` AS `amt`,`d`.`interest` AS `interest`,`d`.`Duration` AS `Duration`,`d`.`Duration_Type` AS `Duration_Type`,`d`.`Instalment_Type` AS `Instalment_Type`,`d`.`Age_Type` AS `Age_Type`,`d`.`maturity_amt` AS `maturity_amt`,`d`.`maturity_date` AS `maturity_date`,`d`.`status` AS `status`,`d`.`acc_type_code` AS `acc_type_code`,`d`.`intro_acc_no` AS `intro_acc_no`,`d`.`app_code` AS `app_code`,`d`.`fd_sv_acc_no` AS `fd_sv_acc_no`,`d`.`rd_dep_per` AS `rd_dep_per`,`d`.`scheme` AS `scheme`,`d`.`mis_benifit` AS `mis_benifit`,`d`.`loan_acc_no` AS `loan_acc_no`,`d`.`group_mem` AS `group_mem`,`d`.`lf_no` AS `lf_no`,`d`.`bankacc` AS `bankacc`,`d`.`deperment` AS `deperment`,`d`.`groupno` AS `groupno`,`d`.`block` AS `block`,`f`.`CNO` AS `CNO`,`f`.`DUR` AS `DUR`,`f`.`Durattion_D` AS `Durattion_D`,`f`.`INTN` AS `INTN`,`f`.`Code` AS `Code`,round(((`d`.`maturity_amt` * pow((1 + (`f`.`INTN` / 400)),(4 * (timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) / 365)))) - `d`.`maturity_amt`),0) AS `INTAMT`,timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) AS `DAYS` from (`co-operativebank`.`deposit_acc` `d` join `co-operativebank`.`fdschem1` `f`) where ((`f`.`DUR` = `d`.`Duration`) and (`f`.`Durattion_D` = `d`.`Duration_Type`) and (`d`.`maturity_date` <= now()) and ((`d`.`sub_head` = \'14103\') or (`d`.`sub_head` = \'14203\') or (`d`.`sub_head` = \'14303\')) and (`d`.`status` = \'ACTIVE\'))
