Database – Additional Payment Information (payment_info_entity)
This table holds additional information that is captured when payments are processed through Secure Payments (formerly PCI Wallet).
This table is commonly used to find:
- Secure Payments transaction IDs
- Processor statuses
The ID of the payment information.
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.
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.
The ID of the transaction from the payment processor.
The Secure Payments transaction ID.
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.
The status of the payment.
The description of the entity instance
payment applied date
Pay Near Me retailer name
Pay Near Me retailer\_ID
Pay Near Me retailer Address
Pay Near Me retailer\_Latitude
Pay Near Me retailer\_Longitude
timestamp of when the entity was last updated
Whether or not the entity was deleted
1 - yes, 0 - no