Database – Transaction Child Entity (transaction_child_entity)
Description
This table holds transaction information for loans with a child relationship to another loan.
Column | Data Type | Column Info | Value Examples |
id | int(11) | The system loan ID | 911534 |
entity_type | char(100) | The entity type that the system note is about. There is an entity type for each entity inside LoanPro (e.g. loan, customers, document, autopay, etc.) | Entity.Loan, Entity.Customer, Entity.Document, Entity.Autopay |
entity_id | int(11) | The ID of the entity | 123 |
child_entity_id | int(11) | The ID of the child entity | 5312 |
loan_child_id | int(11) | The ID of the child loan | 9114 |
amount | decimal(11,2) | The amount of the transaction | 327.89 |
transaction_enrollment | tinyint(11) | Determines whether the child loan is enrolled in receiving transactions posted to parent loan | 1 |
transaction_percentage | decimal(9,6) | Determines the percentage of the transaction that is applied to the child loan if enrolled | 33.33333 |
lastUpdated | timestamp | Timestamp of when the entity was last updated | 2022-04-21 7:08:04 |
deleted | tinyint(1) | Displays whether the entity was deleted | 1 - yes, 0 - no |