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