ODBC Driver for PayPal

Build 24.0.9175

PaymentTokens

Lists merchant-created templates with associated details.

Table 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 本製品 processes other filters client side within the 本製品.

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.
PaymentSourceCardVerificationNetworkTransactionId String Transaction Identifier as given by the network to indicate a previously executed CIT authorization.
PaymentSourceCardVerificationDate Datetime The date that the transaction was authorized by the scheme.
PaymentSourceCardVerificationNetwork String Name of the card network through which the transaction was routed.
PaymentSourceCardVerificationTime String The date and time when the instrument was verified.
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
PaymentSourceCardVerificationStatus String 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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175