Database – Enhanced Funding (loan_funding_transaction_entity)

Description

This table holds information on transactions funding loans.

Table Fields

Column

Data Type

Column Info

Value Notes

Other

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.


How did we do?


Powered by HelpDocs (opens in a new tab)