Database – Recurrent Charges on Loan Specific Settings (loan__recurrent_charge)
Provides a many-to-many relationship between loans and recurrent charges.
Column | Data Type | Column Info | Value Notes | Other |
loan_id | int(11) | The id of the associated loan account | ||
recurrent_charge_id | int(11) | Associated recurrent charge id | ||
enabled | tinyint(1) | Whether or not is enabled | 1 - yes, 0 - no | |
fixed_amount | decimal(11,2) | fixed amount | ||
percentage | decimal(5,2) | percentage | ||
percentage_base | char(36) | percentage base | charge.recurring.percentagebase.apd, charge.recurring.percentagebase.cpb, charge.recurring.percentagebase.npa, charge.recurring.percentagebase.ola | |
contingency_bracket_id | char(33) | associated contingency bracket | ||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |