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


How did we do?


Powered by HelpDocs (opens in a new tab)