Database – Enhanced Funding (loan_funding_transaction_entity)
Updated 5 months ago
Description
This table holds information on transactions funding loans.
Table Fields
Column | Data Type | Column Info | Value Notes |
id | int(10) | The id of the loan funding transaction | |
loan_id | int(11) | The id of the loan. | |
status | varchar(45) | The loan status | The default is set to loan.fund.status.none |
source_company_id | int(11) | The id for the source company | |
customer_id | int(11) | The id for the specific customer | |
category_id | int(11) | The id for the loan category | |
cash_drawer_id | int(11) | The id for the cash drawer used | |
cash_drawer_tx_id | int(11) | Cash Drawer transaction ID | |
payment_account_id | int(11) | The id for the payment account | |
payment_processor | varchar(255) | The payment processor used | |
payment_id | int(11) | The id for the payment | |
agent_id | int(11) | The id for the agent handling the loan | |
authorization_type | char(23) | ||
method | char(31) | ||
amount | decimal(11,2) | The amount of the transaction | |
date | date | The date of the transaction | |
created | timestamp | When the loan funding transaction was created | |
lastUpdated | timestamp | When the loan funding transaction was last updated | |
active | tinyint(1) | Whether the loan is active | 1 - yes; 0 - no |
deleted | tinyint(1) | Whether the loan has been deleted | 1 - yes; 0 - no |
ip_address | varchar(50) | The IP address from which the transaction is initiated | |
merchant_tx_id | varchar(20) | The transaction ID assigned by the payment processor | |
merchant_tx_status | varchar(20) | The status assigned by the payment processor | |
merchant_tx_batch | varchar(70) | The batch ID that the payment processor assigns | |
merchant_tx_processor | varchar(50) | The merchant who processed the transaction | |
cash_drawer_tx_status | varchar(20) | The ID for the cash drawer transaction. | |
cash_drawer_terminal_id | varchar(20) | The ID for the terminal associated with the cash drawer (not to be confused with cash_drawer_id, which is the cash drawer itself.) | |
reversal_reason | varchar(50) | A user-specified reason for the reversal | |
reversal_date | date | If the funding transaction is reversed, the date of that reversal | |
reversal_code | varchar(50) | A NACHA return code | |
merchant_tx_processor_id | int(11) | The ID of the merchant processor used to process the funding transaction. This will be NULL if no merchant processor was used (e.g. the funding was done from a cash drawer). | |
reversal_comment | VARCHAR(300) | The comment about why the funding transaction was reversed. The value will be NULL if the transaction was not reversed. | |
print_check_number | int(11) | The number for the printed check if the funding transaction was done via check. The value will be NULL if the funding was not done via check. | |
print_check_source_company_id | int(11) | The ID of the source company from which the check was printed. The value will be NULL if the funding was not done via check. | |
print_check_has_downloaded | tinyint(1) | Whether the check has been downloaded. | 1 - Downloaded 2 - Not yet downloaded |
print_check_downloaded_by_agent_name | varchar(1000) | If the check has been downloaded, this is the name of the agent who did so. | |
print_check_downloaded_date | timestamp | When the check was downloaded. |