...
Continue having the same design with five main headersaccount "Types"
- Assets
- Liabilities
- Income
- Expenditure
- Equity
...
| Column Name | Data Type | Description | |||
|---|---|---|---|---|---|
| accounting_rule | varchar(45) | The type of accounting required. Either “none”, “cash” or “accrual” *Selecting none would disable posting of all accounting transactions | loan_coa_mapping_id | int | Null-able foreign key to acc_loan_coa_mapping |
7.3 Mapping Loan product to Chart of accounts (acc_
...
product_coa_mapping)
The table maps the GL codes applicable for used by a particular loan/saving product. Going forward, we would be having a similar table for mapping GL codes to saving products
| Column Name | Data Type | Description | |
|---|---|---|---|
id | int |
| |
loan_portfolio_gl_codeacc_id | int | Foreign Key to acc_coa | fund_gl_code |
product_id | int | Foreign Key to acc_coa | |
receivable_interest_gl_code | int | Null-able foreign Key to acc_coa | |
receivable_fee_gl_code | int | Null-able foreign Key to acc_coa | |
receivable_penalty_gl_code | int | Null-able foreign Key to acc_coa | |
interest_income_gl_code | int | Foreign Key to acc_coa | |
fee_income_gl_code | int | Foreign Key to acc_coa | |
penalty_income_gl_code | int | Foreign Key to acc_coa | |
write_off_gl_code | int | Foreign Key to acc_coareference to either Loan or Saving product | |
product_type | varchar(45) | "loan" or "saving" | |
financial_account_type | varchar(45) | Name of a financial Account Type Ex: " Cash", "Interest on Loan" |
7.4 Journal Entries (acc_journal_entry)
...