Database – Enhanced Funding (loan_funding_transaction_entity)
This table holds information on transactions funding loans.
The id of the loan funding transaction
The id of the loan.
The loan status
The default is set to
The id for the source company
The id for the specific customer
The id for the loan category
The id for the cash drawer used
Cash Drawer transaction ID
The id for the payment account
The payment processor used
The id for the payment
The id for the agent handling the loan
The amount of the transaction
The date of the transaction
When the loan funding transaction was created
When the loan funding transaction was last updated
Whether the loan is active
1 - yes; 0 - no
Whether the loan has been deleted
1 - yes; 0 - no
The IP address from which the transaction is initiated
The transaction ID assigned by the payment processor
The status assigned by the payment processor
The batch ID that the payment processor assigns
The merchant who processed the transaction
The ID for the cash drawer transaction.
The ID for the terminal associated with the cash drawer (not to be confused with cash_drawer_id, which is the cash drawer itself.)
A user-specified reason for the reversal
If the funding transaction is reversed, the date of that reversal
A NACHA return code
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).
The comment about why the funding transaction was reversed. The value will be NULL if the transaction was not reversed.
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.
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.
Whether the check has been downloaded.
1 - Downloaded
2 - Not yet downloaded
If the check has been downloaded, this is the name of the agent who did so.
When the check was downloaded.