Table: Charge Entity

Table: Charge Entity

The charge entity holds charge (aka. fee) information for loans. This includes servicing fees, late fees, convinience charges, etc.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
display_idint(11)Display ID
charge_application_typevarchar(100)charge application type
typeint(11)Identifier for the entity type
amountdecimal(11,2)Charge amount
apply_datedateDate of application
infovarchar(255)Extra information about an entity instance
paid_amountdecimal(11,2)Amount of the charge that's been paid
paid_percentdecimal(11,2)Percentage of the charge that's been paid
past_due_calculationchar(30)Past due calculation collectionloan.feepastduecalc.*
interest_bearingtinyint(1)Whether or not is interest bearing1 - yes, 0 - no
edit_commentvarchar(255)User provided comment about why the charge was edited
parentint(11)Parent modification
childint(11)child paymen tid
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
mod_idint(11)The id of the associated loan modification
entity_idint(11)ID of the associated entity
entity_typevarchar(100)Type of the associated entity
related_payment_idint(11)ID of related payment entity
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List