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


How did we do?


Powered by HelpDocs (opens in a new tab)