Database – Loan Funding (loan_funding_entity)
Description
Holds funding information for a loan.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The ID of the entity | ||
loan_id | int(11) | The ID of the associated loan account | ||
status | varchar(45) | Status code of the entity | loan.funding.status.none, loan.funding.status.success | |
who_entity_type | varchar(100) | Entity type of who got funded | Entity.Customer, Entity.SourceCompany | |
who_entity_id | int(11) | ID of who got funded | ||
cash_drawer_id | int(11) | Associated cash drawer ID | ||
cash_drawer_tx_id | int(11) | Cash drawer transactoin ID | ||
payment_account_id | int(11) | Payment account ID | ||
payment_processor | varchar(255) | payment processor information | ||
merchant_tx_id | varchar(45) | Secure Payments transaction ID | ||
payment_id | int(11) | payment ID | ||
agent | int(11) | ID of the assigned agent | ||
authorization_type | char(23) | Type of authorization used for the funding transaction | loan.funding.auth.web, loan.funding.auth.ppd, loan.funding.auth.ccd, loan.funding.auth.tel | |
method | char(31) | Payment method used for the transaction | loan.funding.method.deposit loan.funding.method.credit loan.funding.method.cashdrawer loan.funding.method.other loan.funding.method.printcheck loan.funding.method.transfer | |
amount | decimal(11,2) | Funding amount | ||
date | date | Funding date | ||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
active | tinyint(1) | Whether the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether the entity was deleted | 1 - yes, 0 - no |