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 |