Table: Recurrent Charges (Loan Specefic Settings)

Table: Recurrent Charges (Loan Specefic Settings)

Provides a many-to-many relationship between loans and recurrent charges.

Column Data Type Column Info Value Notes Other
loan_idint(11)The id of the associated loan account
recurrent_charge_idint(11)Associated recurrent charge id
enabledtinyint(1)Whether or not is enabled1 - yes, 0 - no
fixed_amountdecimal(11,2)fixed amount
percentagedecimal(5,2)percentage
percentage_basechar(36)percentage base
contingency_bracket_idchar(33)associated contingency bracket
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no

< Back to List