PaymentTokens
Returns merchant-created payment tokens with their associated details.
View-Specific Information
SELECT
The only filters supported by the PayPal API are Id and CustomerId. One of these filters is required to access this view. Server-side processing is only supported for the '=' operator.
SELECT * FROM PaymentTokens WHERE CustomerId = 'BygeLlrpZF'
SELECT * FROM PaymentTokens WHERE Id = 'PMUH786954'
The provider processes all other filters client-side.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The PayPal-generated ID for the vault token. | |
| CustomerId | String | The unique ID for a customer in merchant's or partner's system of records. | |
| MerchantCustomerId | String | Merchants and partners may already have a data store where their customer information is persisted. Use merchant_customer_id to associate the PayPal-generated customer ID to your representation of a customer. | |
| PaymentSourceCardName | String | The card holder's name as it appears on the card. | |
| PaymentSourceCardLastDigits | String | The last digits of the payment card. | |
| PaymentSourceCardVerificationAmountValue | Decimal | The amount used for card verification. | |
| PaymentSourceCardVerificationAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| PaymentSourceCardVerificationProcessorResponseAvsCode | String | The address verification code for Visa, Discover, Mastercard, or American Express transactions. | |
| PaymentSourceCardVerificationProcessorResponseCvvCode | String | The card verification value code for for Visa, Discover, Mastercard, or American Express. | |
| PaymentSourceCardNetworkTransactionReferenceId | String | Transaction reference id returned by the scheme. | |
| PaymentSourceCardNetworkTransactionReferenceDate | Datetime | The date that the transaction was authorized by the scheme. | |
| PaymentSourceCardNetworkTransactionReferenceNetwork | String | Name of the card network through which the transaction was routed. | |
| PaymentSourceCardNetworkTransactionReferenceTime | Datetime | The date and time when the instrument was verified. | |
| PaymentSourceCardBrand | String | The card brand or network. Typically used in the response. | |
| PaymentSourceCardExpiry | String | The card expiration year and month. | |
| PaymentSourceCardAddressLine1 | String | The first line of the address. For example, number or street. | |
| PaymentSourceCardAddressLine2 | String | The second line of the address. For example, suite or apartment number. | |
| PaymentSourceCardAddressAdminArea1 | String | The highest level sub-division in a country, which is usually a province, state, or ISO-3166-2 subdivision. | |
| PaymentSourceCardAddressAdminArea2 | String | A city, town, or village. | |
| PaymentSourceCardAddressPostalCode | String | The postal code, which is the zip code or equivalent. Typically required for countries with a postal code or an equivalent. | |
| PaymentSourceCardAddressCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceCardAddressId | String | The resource ID of the address. | |
| PaymentSourceCardAddressCompany | String | The name of the company or business associated to the address. | |
| PaymentSourceCardAddressPhone | String | The phone number that can go on the mailing label with the address to track the shipping. | |
| PaymentSourceCardAddressGivenName | String | When the party is a person, the party's given, or first, name. | |
| PaymentSourceCardAddressNameSurname | String | When the party is a person, the party's surname or family name. | |
| PaymentSourceCardAddressPhoneNumber | String | The national number. | |
| PaymentSourceCardAddressPhoneNumberCountryCode | String | The country calling code (CC), in its canonical international format as defined by the E.164 numbering plan. | |
| PaymentSourceCardVerificationStatus | String | The card verification status. | |
| PaymentSourceCardType | String | The payment card type. | |
| PaymentSourcePaypalEmailAddress | String | The email address of the payer. | |
| PaymentSourcePaypalPayerId | String | The PayPal-assigned ID for the payer. | |
| PaymentSourcePaypalGivenName | String | When the party is a person, the party's given, or first, name. | |
| PaymentSourcePaypalNameSurname | String | When the party is a person, the party's surname or family name. | |
| PaymentSourcePaypalPhoneNumber | String | The national number. | |
| PaymentSourcePaypalPhoneType | String | The phone type. | |
| PaymentSourcePaypalAddressLine1 | String | The first line of the address. For example, number or street. | |
| PaymentSourcePaypalAddressLine2 | String | The second line of the address. For example, suite or apartment number. | |
| PaymentSourcePaypalAddressAdminArea1 | String | The highest level sub-division in a country, which is usually a province, state, or ISO-3166-2 subdivision. | |
| PaymentSourcePaypalAddressPostalCode | String | The postal code, which is the zip code or equivalent. Typically required for countries with a postal code or an equivalent. | |
| PaymentSourcePaypalAddressCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourcePaypalAccountId | String | The account identifier for a PayPal account. | |
| PaymentSourceVenmoEmailAddress | String | The email address of the payer. | |
| PaymentSourceVenmoPayerId | String | The PayPal-assigned ID for the payer. | |
| PaymentSourceVenmoGivenName | String | When the party is a person, the party's given, or first, name. | |
| PaymentSourceVenmoNameSurname | String | When the party is a person, the party's surname or family name. | |
| PaymentSourceVenmoPhoneNumber | String | The national number. | |
| PaymentSourceVenmoPhoneType | String | The phone type. | |
| PaymentSourceVenmoAddressLine1 | String | The first line of the address. For example, number or street. | |
| PaymentSourceVenmoAddressLine2 | String | The second line of the address. For example, suite or apartment number. | |
| PaymentSourceVenmoAddressAdminArea1 | String | The highest level sub-division in a country, which is usually a province, state, or ISO-3166-2 subdivision. | |
| PaymentSourceVenmoAddressAdminArea2 | String | A city, town, or village. | |
| PaymentSourceVenmoAddressPostalCode | String | The postal code, which is the zip code or equivalent. Typically required for countries with a postal code or an equivalent. | |
| PaymentSourceVenmoAddressCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceVenmoUserName | String | The Venmo username, as chosen by the user. | |
| PaymentSourceApplePayName | String | The card holder's name as it appears on the card. | |
| PaymentSourceApplePayLastDigits | String | The last digits of the payment card. | |
| PaymentSourceApplePayType | String | The payment card type. | |
| PaymentSourceApplePayBrand | String | The card brand or network. | |
| PaymentSourceApplePayAddressLine1 | String | The first line of the address. For example, number or street. | |
| PaymentSourceApplePayAddressLine2 | String | The second line of the address. For example, suite or apartment number. | |
| PaymentSourceApplePayAddressAdminArea1 | String | The highest level sub-division in a country, which is usually a province, state, or ISO-3166-2 subdivision. | |
| PaymentSourceApplePayAddressAdminArea2 | String | A city, town, or village. | |
| PaymentSourceApplePayAddressPostalCode | String | The postal code, which is the zip code or equivalent. Typically required for countries with a postal code or an equivalent. | |
| PaymentSourceApplePayAddressCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. |