...
We need to create a table to keep all loan provision categories.The table name is 'm_loan_product_provision_category''. The table definition is defined below.
| Name | Datatype | Length | Remarks |
|---|---|---|---|
| id | BIGINT | 20 | Primary Key & Auto Increment |
| category_name | VARCHAR | 100 | Not Null |
| Description | VARCHAR | 200 |
By default Mifos X system will create and insert the following categories into this table based on customer requirements. So the data will look like below.
| id | category_name | Description | ||
|---|---|---|---|---|
| 1 | STANDARD | Punctual Payment without any dues | ||
| 2 | SUB-STANDARD | Principal and/or Interest overdue by x days | ||
| 3 | DOUBTFUL | Principal and/or Interest overdue by y days with 1 year original term (or) Principal and/or Interest overdue by z days with more than 1 year term
| ||
| 4 | LOSS | Principal and/or Interest overdue by t1 days with 1 year original term (or) Principal and/or Interest overdue by t2 days with more than 1 year term |