|
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 |
|
|
