...
Mifos system, calculates provision date for all active loans and will generate a tabular view as shown below. Once user selects OK on this screen, this data will be saved into 'acc_gl_journal_entry table'
As current journal entry is not sufficient for provision reports, we need to introduce a new table in the database. The table name is 'm_loan_provision_entry' and the table definition is shown below.
| Name | Datatype | Length | Remarks |
|---|---|---|---|
| id | BIGINT | 20 | PRIMARY KEY and AUTOINCREMENT |
| currency_code | BIGINT | 20 | FOREIGN KEY m_currency.id |
| office_id | BIGINT | 20 | FOREIGN KEY m_office.id |
| loan_id | BIGINT | 20 | FOREIGN KEY m_loan.id |
| category_id | BIGINT | 20 | FOREIGN KEY m_provision_category.id |
| overdue_in_days | BIGINT | 20 | DEFAULT 0 |
| loan_outstanding_balance | BIGINT | 20 | DEFAULT 0 |
| amount_to_bereserved | BIGINT | 20 | DEFAULT 0 |
| created_by | BIGINT | 20 | FOREIGN KEY |
| created_on | DATE | NOT NULL | |
| modified_by | BIGINT | 20 | FOREIGN KEY |
| modified_on | DATE |