Database – Loan Funding Transaction (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

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


How did we do?


Powered by HelpDocs (opens in a new tab)