Database – Additional Payment Information (payment_info_entity)

Description

This table holds additional information that is captured when payments are processed through Secure Payments. Additional payment information is viewable within the LMS UI under the Payments section of an individual loan. For API information regarding additional payment information, see our API – Payment Report article.

Common Uses

This table is commonly used to find:

  • Secure Payments transaction IDs
  • Processor statuses

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The ID of the payment information.

payment_id

int(10)

The ID of the associated payment. This is not the display ID, but the database ID. Payments can be found in the payment_entity table.

processor_id

varchar(255)

The ID of the payment processor. Payment processors are set up to work with either a third-party payment processor or through NACHA. Payment processors can be found in the mc_processor_extender table.

processor_tx_id

varchar(45)

The ID of the transaction from the payment processor.

transaction_id

varchar(45)

The Secure Payments transaction ID.

processor_status

varchar(45)

The status of payment processing. This status comes from Secure Payments. The options are: pending, processing, settled successfully, voided, failed, and refunded. The statuses depend, to some degree, on the processor used to process the payment.

status

varchar(45)

The status of the payment.

description

varchar(255)

The description of the entity instance.

batch_id

varchar(45)

The batch ID of the payment.

applied_date

datetime

The payment applied date.

pnm_retailer_name

varchar(255)

The Pay Near Me retailer name.

pnm_retailer_id

varchar(45)

The Pay Near Me retailer\_ID.

pnm_retailer_addr

varchar(255)

The Pay Near Me retailer Address.

pnm_retailer_lat

varchar(255)

The Pay Near Me retailer latitude.

pnm_retailer_lon

varchar(255)

The Pay Near Me retailer longitude.

lastUpdated

timestamp

The timestamp of when the entity was last updated.

deleted

tinyint(1)

States if the entity was deleted.

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)