TYPE=VIEW
query=select `co-operativebank-neturia`.`loan_collection1120001000260`.`last_day` AS `last_day`,`co-operativebank-neturia`.`loan_collection1120001000260`.`nsc` AS `nsc`,`co-operativebank-neturia`.`loan_collection1120001000260`.`acc_no` AS `acc_no`,`co-operativebank-neturia`.`loan_collection1120001000260`.`fianl_date` AS `fianl_date`,`co-operativebank-neturia`.`loan_collection1120001000260`.`duration` AS `duration`,`co-operativebank-neturia`.`loan_collection1120001000260`.`duration_type` AS `duration_type`,`co-operativebank-neturia`.`loan_collection1120001000260`.`loan_inst` AS `loan_inst`,`co-operativebank-neturia`.`loan_collection1120001000260`.`ins_type` AS `ins_type`,`co-operativebank-neturia`.`loan_collection1120001000260`.`cc_int` AS `cc_int`,`co-operativebank-neturia`.`loan_collection1120001000260`.`od_int` AS `od_int`,`co-operativebank-neturia`.`loan_collection1120001000260`.`cc_int_due` AS `cc_int_due`,`co-operativebank-neturia`.`loan_collection1120001000260`.`od_int_due` AS `od_int_due`,`co-operativebank-neturia`.`loan_collection1120001000260`.`cur_due_amt` AS `cur_due_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`jer_amt` AS `jer_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`no_inst` AS `no_inst`,`co-operativebank-neturia`.`loan_collection1120001000260`.`loan_amt` AS `loan_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`Inst_amt` AS `Inst_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`clear_amt` AS `clear_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`total_pay` AS `total_pay`,`co-operativebank-neturia`.`loan_collection1120001000260`.`sum(prin_amt)` AS `sum(prin_amt)`,`co-operativebank-neturia`.`loan_collection1120001000260`.`pay_date` AS `pay_date`,`co-operativebank-neturia`.`loan_collection1120001000260`.`days` AS `days`,`co-operativebank-neturia`.`loan_collection1120001000260`.`cc_days` AS `cc_days`,`co-operativebank-neturia`.`loan_collection1120001000260`.`od_days` AS `od_days`,`co-operativebank-neturia`.`loan_collection1120001000260`.`inst_day` AS `inst_day`,`co-operativebank-neturia`.`loan_collection1120001000260`.`dur_day` AS `dur_day`,`co-operativebank-neturia`.`loan_collection1120001000260`.`issue_date` AS `issue_date`,`co-operativebank-neturia`.`loan_collection1120001000260`.`imst_date` AS `imst_date`,(to_days(\'2020-09-30\') - to_days(if((`co-operativebank-neturia`.`loan_collection1120001000260`.`imst_date` >= `co-operativebank-neturia`.`loan_collection1120001000260`.`pay_date`),`co-operativebank-neturia`.`loan_collection1120001000260`.`imst_date`,`co-operativebank-neturia`.`loan_collection1120001000260`.`pay_date`))) AS `oddays` from `co-operativebank-neturia`.`loan_collection1120001000260`
md5=7a36c894b17ff13c815ddab48a8e3a5b
updatable=1
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-08-30 16:47:16
create-version=1
source=select  `co-operativebank-neturia`.`loan_collection1120001000260`.`last_day`  AS  `last_day` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`nsc`  AS  `nsc` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`acc_no`  AS  `acc_no` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`fianl_date`  AS  `fianl_date` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`duration`  AS  `duration` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`duration_type`  AS  `duration_type` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`loan_inst`  AS  `loan_inst` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`ins_type`  AS  `ins_type` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`cc_int`  AS  `cc_int` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`od_int`  AS  `od_int` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`cc_int_due`  AS  `cc_int_due` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`od_int_due`  AS  `od_int_due` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`cur_due_amt`  AS  `cur_due_amt` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`jer_amt`  AS  `jer_amt` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`no_inst`  AS  `no_inst` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`loan_amt`  AS  `loan_amt` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`Inst_amt`  AS  `Inst_amt` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`clear_amt`  AS  `clear_amt` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`total_pay`  AS  `total_pay` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`sum(prin_amt)`  AS  `sum(prin_amt)` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`pay_date`  AS  `pay_date` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`days`  AS  `days` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`cc_days`  AS  `cc_days` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`od_days`  AS  `od_days` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`inst_day`  AS  `inst_day` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`dur_day`  AS  `dur_day` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`issue_date`  AS  `issue_date` ,\n `co-operativebank-neturia`.`loan_collection1120001000260`.`imst_date`  AS  `imst_date` ,\n( to_days(  \'2020-09-30\'  )  - to_days( if( (  `co-operativebank-neturia`.`loan_collection1120001000260`.`imst_date`  >=  `co-operativebank-neturia`.`loan_collection1120001000260`.`pay_date`  ),  `co-operativebank-neturia`.`loan_collection1120001000260`.`imst_date` ,  `co-operativebank-neturia`.`loan_collection1120001000260`.`pay_date`  )  )  ) AS  `oddays`  from  `co-operativebank-neturia`.`loan_collection1120001000260`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-neturia`.`loan_collection1120001000260`.`last_day` AS `last_day`,`co-operativebank-neturia`.`loan_collection1120001000260`.`nsc` AS `nsc`,`co-operativebank-neturia`.`loan_collection1120001000260`.`acc_no` AS `acc_no`,`co-operativebank-neturia`.`loan_collection1120001000260`.`fianl_date` AS `fianl_date`,`co-operativebank-neturia`.`loan_collection1120001000260`.`duration` AS `duration`,`co-operativebank-neturia`.`loan_collection1120001000260`.`duration_type` AS `duration_type`,`co-operativebank-neturia`.`loan_collection1120001000260`.`loan_inst` AS `loan_inst`,`co-operativebank-neturia`.`loan_collection1120001000260`.`ins_type` AS `ins_type`,`co-operativebank-neturia`.`loan_collection1120001000260`.`cc_int` AS `cc_int`,`co-operativebank-neturia`.`loan_collection1120001000260`.`od_int` AS `od_int`,`co-operativebank-neturia`.`loan_collection1120001000260`.`cc_int_due` AS `cc_int_due`,`co-operativebank-neturia`.`loan_collection1120001000260`.`od_int_due` AS `od_int_due`,`co-operativebank-neturia`.`loan_collection1120001000260`.`cur_due_amt` AS `cur_due_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`jer_amt` AS `jer_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`no_inst` AS `no_inst`,`co-operativebank-neturia`.`loan_collection1120001000260`.`loan_amt` AS `loan_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`Inst_amt` AS `Inst_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`clear_amt` AS `clear_amt`,`co-operativebank-neturia`.`loan_collection1120001000260`.`total_pay` AS `total_pay`,`co-operativebank-neturia`.`loan_collection1120001000260`.`sum(prin_amt)` AS `sum(prin_amt)`,`co-operativebank-neturia`.`loan_collection1120001000260`.`pay_date` AS `pay_date`,`co-operativebank-neturia`.`loan_collection1120001000260`.`days` AS `days`,`co-operativebank-neturia`.`loan_collection1120001000260`.`cc_days` AS `cc_days`,`co-operativebank-neturia`.`loan_collection1120001000260`.`od_days` AS `od_days`,`co-operativebank-neturia`.`loan_collection1120001000260`.`inst_day` AS `inst_day`,`co-operativebank-neturia`.`loan_collection1120001000260`.`dur_day` AS `dur_day`,`co-operativebank-neturia`.`loan_collection1120001000260`.`issue_date` AS `issue_date`,`co-operativebank-neturia`.`loan_collection1120001000260`.`imst_date` AS `imst_date`,(to_days(\'2020-09-30\') - to_days(if((`co-operativebank-neturia`.`loan_collection1120001000260`.`imst_date` >= `co-operativebank-neturia`.`loan_collection1120001000260`.`pay_date`),`co-operativebank-neturia`.`loan_collection1120001000260`.`imst_date`,`co-operativebank-neturia`.`loan_collection1120001000260`.`pay_date`))) AS `oddays` from `co-operativebank-neturia`.`loan_collection1120001000260`
