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`,`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-mitrachak`.`deposit_acc` `d` join `co-operativebank-mitrachak`.`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=b78a2b416c30951ec89b1a2b3f375964
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-05-30 04:21:27
create-version=1
source=select  `d`.`id`  AS  `id` ,\n `d`.`no`  AS  `no` ,\n `d`.`member_id`  AS  `member_id` ,\n `d`.`acc_no`  AS  `acc_no` ,\n `d`.`acc_type`  AS  `acc_type` ,\n `d`.`operation_type`  AS  `operation_type` ,\n `d`.`date_open`  AS  `date_open` ,\n `d`.`sub_head`  AS  `sub_head` ,\n `d`.`Deposit_Type`  AS  `Deposit_Type` ,\n `d`.`Chk_Acc_No`  AS  `Chk_Acc_No` ,\n `d`.`Chk_No`  AS  `Chk_No` ,\n `d`.`Draw_Bank`  AS  `Draw_Bank` ,\n `d`.`amt`  AS  `amt` ,\n `d`.`interest`  AS  `interest` ,\n `d`.`Duration`  AS  `Duration` ,\n `d`.`Duration_Type`  AS  `Duration_Type` ,\n `d`.`Instalment_Type`  AS  `Instalment_Type` ,\n `d`.`Age_Type`  AS  `Age_Type` ,\n `d`.`maturity_amt`  AS  `maturity_amt` ,\n `d`.`maturity_date`  AS  `maturity_date` ,\n `d`.`status`  AS  `status` ,\n `d`.`acc_type_code`  AS  `acc_type_code` ,\n `d`.`intro_acc_no`  AS  `intro_acc_no` ,\n `d`.`app_code`  AS  `app_code` ,\n `d`.`fd_sv_acc_no`  AS  `fd_sv_acc_no` ,\n `d`.`rd_dep_per`  AS  `rd_dep_per` ,\n `d`.`scheme`  AS  `scheme` ,\n `d`.`mis_benifit`  AS  `mis_benifit` ,\n `d`.`loan_acc_no`  AS  `loan_acc_no` ,\n `d`.`group_mem`  AS  `group_mem` ,\n `d`.`lf_no`  AS  `lf_no` ,\n `d`.`bankacc`  AS  `bankacc` ,\n `d`.`deperment`  AS  `deperment` ,\n `f`.`CNO`  AS  `CNO` ,\n `f`.`DUR`  AS  `DUR` ,\n `f`.`Durattion_D`  AS  `Durattion_D` ,\n `f`.`INTN`  AS  `INTN` ,\n `f`.`Code`  AS  `Code` ,\nround( ( (  `d`.`maturity_amt`  * pow( ( 1 + (  `f`.`INTN`  /400  )  ) , ( 4 * ( timestampdiff(  DAY ,  `d`.`date_open` ,  `d`.`maturity_date`  )  /365  )  )  )  )  -  `d`.`maturity_amt`  ),\n0 ) AS  `INTAMT` ,\ntimestampdiff(  DAY ,  `d`.`date_open` ,  `d`.`maturity_date`  )  AS  `DAYS`  from (  `co-operativebank-mitrachak`.`deposit_acc`  `d`  join  `co-operativebank-mitrachak`.`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`,`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-mitrachak`.`deposit_acc` `d` join `co-operativebank-mitrachak`.`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\'))
