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