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