TYPE=VIEW
query=select `co-operativebank-kutubpur`.`loan_collection1120001000134`.`last_day` AS `last_day`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`nsc` AS `nsc`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`acc_no` AS `acc_no`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`fianl_date` AS `fianl_date`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`duration` AS `duration`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`duration_type` AS `duration_type`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`loan_inst` AS `loan_inst`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`ins_type` AS `ins_type`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`cc_int` AS `cc_int`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`od_int` AS `od_int`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`cc_int_due` AS `cc_int_due`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`od_int_due` AS `od_int_due`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`cur_due_amt` AS `cur_due_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`jer_amt` AS `jer_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`no_inst` AS `no_inst`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`loan_amt` AS `loan_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`Inst_amt` AS `Inst_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`clear_amt` AS `clear_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`total_pay` AS `total_pay`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`sum(prin_amt)` AS `sum(prin_amt)`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`pay_date` AS `pay_date`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`days` AS `days`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`cc_days` AS `cc_days`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`od_days` AS `od_days`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`inst_day` AS `inst_day`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`dur_day` AS `dur_day`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`issue_date` AS `issue_date`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`imst_date` AS `imst_date`,(to_days(\'2021-04-21\') - to_days(if((`co-operativebank-kutubpur`.`loan_collection1120001000134`.`imst_date` >= `co-operativebank-kutubpur`.`loan_collection1120001000134`.`pay_date`),`co-operativebank-kutubpur`.`loan_collection1120001000134`.`imst_date`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`pay_date`))) AS `oddays` from `co-operativebank-kutubpur`.`loan_collection1120001000134`
md5=8e8f1acd7fa2505cbdab5a0fac7da1dd
updatable=1
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-08-20 14:29:38
create-version=1
source=select  `co-operativebank-kutubpur`.`loan_collection1120001000134`.`last_day`  AS  `last_day` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`nsc`  AS  `nsc` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`acc_no`  AS  `acc_no` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`fianl_date`  AS  `fianl_date` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`duration`  AS  `duration` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`duration_type`  AS  `duration_type` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`loan_inst`  AS  `loan_inst` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`ins_type`  AS  `ins_type` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`cc_int`  AS  `cc_int` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`od_int`  AS  `od_int` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`cc_int_due`  AS  `cc_int_due` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`od_int_due`  AS  `od_int_due` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`cur_due_amt`  AS  `cur_due_amt` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`jer_amt`  AS  `jer_amt` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`no_inst`  AS  `no_inst` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`loan_amt`  AS  `loan_amt` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`Inst_amt`  AS  `Inst_amt` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`clear_amt`  AS  `clear_amt` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`total_pay`  AS  `total_pay` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`sum(prin_amt)`  AS  `sum(prin_amt)` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`pay_date`  AS  `pay_date` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`days`  AS  `days` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`cc_days`  AS  `cc_days` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`od_days`  AS  `od_days` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`inst_day`  AS  `inst_day` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`dur_day`  AS  `dur_day` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`issue_date`  AS  `issue_date` ,\n `co-operativebank-kutubpur`.`loan_collection1120001000134`.`imst_date`  AS  `imst_date` ,\n( to_days(  \'2021-04-21\'  )  - to_days( if( (  `co-operativebank-kutubpur`.`loan_collection1120001000134`.`imst_date`  >=  `co-operativebank-kutubpur`.`loan_collection1120001000134`.`pay_date`  ),  `co-operativebank-kutubpur`.`loan_collection1120001000134`.`imst_date` ,  `co-operativebank-kutubpur`.`loan_collection1120001000134`.`pay_date`  )  )  ) AS  `oddays`  from  `co-operativebank-kutubpur`.`loan_collection1120001000134`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-kutubpur`.`loan_collection1120001000134`.`last_day` AS `last_day`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`nsc` AS `nsc`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`acc_no` AS `acc_no`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`fianl_date` AS `fianl_date`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`duration` AS `duration`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`duration_type` AS `duration_type`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`loan_inst` AS `loan_inst`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`ins_type` AS `ins_type`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`cc_int` AS `cc_int`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`od_int` AS `od_int`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`cc_int_due` AS `cc_int_due`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`od_int_due` AS `od_int_due`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`cur_due_amt` AS `cur_due_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`jer_amt` AS `jer_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`no_inst` AS `no_inst`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`loan_amt` AS `loan_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`Inst_amt` AS `Inst_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`clear_amt` AS `clear_amt`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`total_pay` AS `total_pay`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`sum(prin_amt)` AS `sum(prin_amt)`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`pay_date` AS `pay_date`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`days` AS `days`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`cc_days` AS `cc_days`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`od_days` AS `od_days`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`inst_day` AS `inst_day`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`dur_day` AS `dur_day`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`issue_date` AS `issue_date`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`imst_date` AS `imst_date`,(to_days(\'2021-04-21\') - to_days(if((`co-operativebank-kutubpur`.`loan_collection1120001000134`.`imst_date` >= `co-operativebank-kutubpur`.`loan_collection1120001000134`.`pay_date`),`co-operativebank-kutubpur`.`loan_collection1120001000134`.`imst_date`,`co-operativebank-kutubpur`.`loan_collection1120001000134`.`pay_date`))) AS `oddays` from `co-operativebank-kutubpur`.`loan_collection1120001000134`
