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.

  • payment.status.none
  • payment.status.pending
  • payment.status.pendingRefund
  • payment.status.refunded
  • payment.status.settled
  • payment.status.success
  • payment.status.voidDeclined
  • payment.status.voided

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)