ARPB_TX_E_PMT

Description: |
Contains information on electronically made payments.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier for the transaction record.
2 | RESPONSE_TAG | VARCHAR | No |
Authorization code sent back by the merchant
3 | APPROVAL_CODE | VARCHAR | No |
Transaction ID sent back by the merchant
4 | PMT_INSTANT_DTTM | DATETIME (Local) | No |
Instant at which the electronic payment was made.
5 | CARD_BRAND_C_NAME | VARCHAR | No |
The card brand category ID used for the transaction.
May contain organization-specific values: Yes
Category Entries:
Visa
MasterCard
American Express
Discover
Diners Club
Health Benefit
Bank Account (Unknown Type)
Checking Account
Savings Account
Other
6 | TOKEN_NICKNAME | VARCHAR | No |
A helpful name to identify the payment method.
7 | ACCT_HOLDER_NAME | VARCHAR | No |
The name of the credit card account holder or bank account holder.
8 | LAST_4_DIGITS | VARCHAR | No |
The last 4 digits of the card or bank account used for the transaction.
9 | BANK_ACCT_TYPE_C_NAME | VARCHAR | No |
The bank account type for bank account transactions.
May contain organization-specific values: No
Category Entries:
Unknown
Checking
Savings
10 | DIGITAL_WALLET_C_NAME | VARCHAR | No |
Holds the digital wallet used for an electronic payment. Stored on payments made from a digital wallet and on reversals. This item is not stored on refund transactions.
May contain organization-specific values: No
Category Entries:
Apple Pay
Google Pay
11 | SAVED_PMT_DIGITAL_WALLET_C_NAME | VARCHAR | No |
Holds the digital wallet of the saved payment method used to make the payment
The category values for this column were already listed for column: DIGITAL_WALLET_C_NAME