Payments
Query details about authorized Payments.
Table Specific Information
Select
The only supported filters are Id and OrderId. Filters only supports the = operator The driver processes other filters client side within the driver.
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
For example, the following query is processed server side and retrieves Payments that were created after the specified date.
SELECT * FROM Payments WHERE Id > 'P-41250-2' AND OrderId = 'O-123550-05'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The PayPal-generated ID for the authorized payment. | |
| Intent | String | The payment intent. | |
| PayerPaymentMethod | String | The payment method. | |
| PayerStatus | String | The status of payer's PayPal account. | |
| PayerEmail | String | The payer's email address. | |
| PayerSalutation | String | The payer's salutation. | |
| PayerFirstName | String | The payer's first name. | |
| PayerMiddleName | String | The payer's middle name. | |
| PayerLastName | String | The payer's last name. | |
| PayerSuffix | String | The payer's suffix. | |
| PayerId | String | The PayPal-assigned encrypted payer ID. | |
| PayerBirthDate | Date | The birth date of the payer, in Internet date format. | |
| PayerTaxId | String | The payer's tax ID. Supported for the PayPal payment method only. | |
| PayerTaxType | String | The payer's tax ID type. Supported for the PayPal payment method only. | |
| PayerBillingAddressLine1 | String | The first line of the address. For example, number, street, and so on. | |
| PayerBillingAddressLine2 | String | The second line of the address. For example, suite or apartment number. | |
| PayerBillingAddressCity | String | The city name. | |
| PayerBillingAddressCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PayerBillingAddressPostalCode | String | The postal code, which is the zip code or equivalent. | |
| PayerBillingAddressState | String | The code for a US state or the equivalent for other countries. | |
| PayerBillingAddressPhone | String | The phone number, in E.123 format. | |
| PayerBillingAddressNormalizationStatus | String | The address normalization status. Returned only for payers from Brazil. | |
| PayerBillingAddressType | String | The type of address. For example, HOME_OR_WORK, GIFT, and so on. | |
| PayerShippingAddressLine1 | String | The first line of the address. For example, number, street, and so on. | |
| PayerShippingAddressLine2 | String | The second line of the address. For example, suite or apartment number. | |
| PayerShippingAddressCity | String | The city name. | |
| PayerShippingAddressCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PayerShippingAddressPostalCode | String | The postal code, which is the zip code or equivalent. | |
| PayerShippingAddressState | String | The code for a US state or the equivalent for other countries. | |
| PayerShippingAddressPhone | String | The phone number, in E.123 format. | |
| PayerShippingAddressNormalizationStatus | String | The address normalization status. Returned only for payers from Brazil. | |
| PayerShippingAddressType | String | The type of address. For example, HOME_OR_WORK, GIFT, and so on. | |
| State | String | The state of the payment, authorization, or order transaction. | |
| ExperienceProfileId | String | The PayPal-generated ID for the merchant's payment experience profile. For information, see create web experience profile. | |
| NoteToPayer | String | A free-form field that clients can use to send a note to the payer. | |
| FailureReason | String | The reason code for a payment failure. | |
| ReturnUrl | String | The URL where the payer is redirected after he or she approves the payment. Required for PayPal account payments. | |
| CancelUrl | String | The URL where the payer is redirected after he or she cancels the payment. Required for PayPal account payments. | |
| BrandName | String | A label that overrides the business name in the merchant's PayPal account on the PayPal checkout pages. | |
| Locale | String | The locale of pages that the PayPal payment experience displays. | |
| LandingPage | String | The type of landing page to show on the PayPal site for customer checkout. | |
| ShippingPreference | String | The shipping preference. | |
| UserAction | String | The user action. Presents the customer with either the Continue or Pay Now checkout flow. | |
| CreatedTime | Datetime | The date and time when the transaction occurred. | |
| UpdatedTime | Datetime | The date and time when the payment was updated, in Internet date and time format. |