Payments
Query details about authorized Payments.
Table Specific Information
Select
The only supported filters are Id and OrderId. Filters only supports the = operator The cmdlet processes other filters client side within the cmdlet.
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. |