TYPE=VIEW
query=select `co-operativebank-purbadekhali`.`borrowing`.`no` AS `no`,`co-operativebank-purbadekhali`.`borrowing`.`code` AS `code`,max(`co-operativebank-purbadekhali`.`borrowing`.`date`) AS `date`,sum(`co-operativebank-purbadekhali`.`borrowing`.`Amt`) AS `Amt`,`co-operativebank-purbadekhali`.`borrowing`.`interest` AS `interest`,`co-operativebank-purbadekhali`.`borrowing`.`instlmnt_amt` AS `instlmnt_amt`,`co-operativebank-purbadekhali`.`borrowing`.`instlmnt_no` AS `instlmnt_no`,`co-operativebank-purbadekhali`.`borrowing`.`instlmnt_type` AS `instlmnt_type`,`co-operativebank-purbadekhali`.`borrowing`.`scheme` AS `scheme`,`co-operativebank-purbadekhali`.`borrowing`.`sub_head` AS `sub_head`,`co-operativebank-purbadekhali`.`borrowing`.`loan_sub_head` AS `loan_sub_head`,`co-operativebank-purbadekhali`.`borrowing`.`status` AS `status`,`co-operativebank-purbadekhali`.`borrowing`.`Submit_date` AS `Submit_date`,`co-operativebank-purbadekhali`.`borrowing`.`mstr_bnk_acc_no` AS `mstr_bnk_acc_no`,`co-operativebank-purbadekhali`.`borrowing`.`od` AS `od`,`co-operativebank-purbadekhali`.`borrowing`.`certificate` AS `certificate`,`co-operativebank-purbadekhali`.`borrowing`.`bank_brrow_code` AS `bank_brrow_code`,`co-operativebank-purbadekhali`.`borrowing`.`deperment` AS `deperment` from `co-operativebank-purbadekhali`.`borrowing` group by `co-operativebank-purbadekhali`.`borrowing`.`code`
md5=727bc2eda36df140b1c12e727cde6ade
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-11-13 04:56:48
create-version=1
source=SELECT `no`, `code`, max(`date`) as date, sum(`Amt`) as Amt, `interest`, `instlmnt_amt`, `instlmnt_no`, `instlmnt_type`, `scheme`, `sub_head`, `loan_sub_head`, `status`, `Submit_date`, `mstr_bnk_acc_no`, `od`, `certificate`, `bank_brrow_code`, `deperment` FROM `borrowing`  group by code
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `co-operativebank-purbadekhali`.`borrowing`.`no` AS `no`,`co-operativebank-purbadekhali`.`borrowing`.`code` AS `code`,max(`co-operativebank-purbadekhali`.`borrowing`.`date`) AS `date`,sum(`co-operativebank-purbadekhali`.`borrowing`.`Amt`) AS `Amt`,`co-operativebank-purbadekhali`.`borrowing`.`interest` AS `interest`,`co-operativebank-purbadekhali`.`borrowing`.`instlmnt_amt` AS `instlmnt_amt`,`co-operativebank-purbadekhali`.`borrowing`.`instlmnt_no` AS `instlmnt_no`,`co-operativebank-purbadekhali`.`borrowing`.`instlmnt_type` AS `instlmnt_type`,`co-operativebank-purbadekhali`.`borrowing`.`scheme` AS `scheme`,`co-operativebank-purbadekhali`.`borrowing`.`sub_head` AS `sub_head`,`co-operativebank-purbadekhali`.`borrowing`.`loan_sub_head` AS `loan_sub_head`,`co-operativebank-purbadekhali`.`borrowing`.`status` AS `status`,`co-operativebank-purbadekhali`.`borrowing`.`Submit_date` AS `Submit_date`,`co-operativebank-purbadekhali`.`borrowing`.`mstr_bnk_acc_no` AS `mstr_bnk_acc_no`,`co-operativebank-purbadekhali`.`borrowing`.`od` AS `od`,`co-operativebank-purbadekhali`.`borrowing`.`certificate` AS `certificate`,`co-operativebank-purbadekhali`.`borrowing`.`bank_brrow_code` AS `bank_brrow_code`,`co-operativebank-purbadekhali`.`borrowing`.`deperment` AS `deperment` from `co-operativebank-purbadekhali`.`borrowing` group by `co-operativebank-purbadekhali`.`borrowing`.`code`
