Database – Additional Payment Information (payment_info_entity)
Description
This table holds additional information that is captured when payments are processed through Secure Payments (formerly PCI Wallet).
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) | Batch ID | ||
applied_date | datetime | payment applied date | ||
pnm_retailer_name | varchar(255) | Pay Near Me retailer name | ||
pnm_retailer_id | varchar(45) | Pay Near Me retailer\_ID | ||
pnm_retailer_addr | varchar(255) | Pay Near Me retailer Address | ||
pnm_retailer_lat | varchar(255) | Pay Near Me retailer\_Latitude | ||
pnm_retailer_lon | varchar(255) | Pay Near Me retailer\_Longitude | ||
lastUpdated | timestamp | timestamp of when the entity was last updated | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |