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` * (`f`.`INTN` / 100)) * (timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) / 365)),0) AS `INTAMT`,timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) AS `DAYS` from (`co-operativebank-bajbajia`.`deposit_acc` `d` join `co-operativebank-bajbajia`.`reschem1` `f`) where ((`f`.`DUR` = `d`.`Duration`) and (`f`.`Durattion_D` = `d`.`Duration_Type`) and (`d`.`maturity_date` <= now()) and ((`d`.`sub_head` = \'14104\') or (`d`.`sub_head` = \'14204\') or (`d`.`sub_head` = \'14304\')) and (`d`.`status` = \'ACTIVE\'))
md5=4b43ef4a5df486fe6c237b6563e77bf6
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:51:47
create-version=1
source=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` * (`f`.`INTN` / 100)) * (timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) / 365)),0) AS `INTAMT`,timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) AS `DAYS` from (`deposit_acc` `d` join `reschem1` `f`) where ((`f`.`DUR` = `d`.`Duration`) and (`f`.`Durattion_D` = `d`.`Duration_Type`) and (`d`.`maturity_date` <= now()) and ((`d`.`sub_head` = \'14104\') or (`d`.`sub_head` = \'14204\') or (`d`.`sub_head` = \'14304\')) 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` * (`f`.`INTN` / 100)) * (timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) / 365)),0) AS `INTAMT`,timestampdiff(DAY,`d`.`date_open`,`d`.`maturity_date`) AS `DAYS` from (`co-operativebank-bajbajia`.`deposit_acc` `d` join `co-operativebank-bajbajia`.`reschem1` `f`) where ((`f`.`DUR` = `d`.`Duration`) and (`f`.`Durattion_D` = `d`.`Duration_Type`) and (`d`.`maturity_date` <= now()) and ((`d`.`sub_head` = \'14104\') or (`d`.`sub_head` = \'14204\') or (`d`.`sub_head` = \'14304\')) and (`d`.`status` = \'ACTIVE\'))
