OrderDetails
Returns detailed information for an order.
View-Specific Information
SELECT
Note: PayPal REST API does not support listing all OrderIds. An OrderId must be specified. For scenarios that require listing transactions, use the Transactions and TransactionDetails views in the SOAP schema.
The only filter supported by the PayPal API is Id, which is required. The provider processes other filters client-side within the provider.
For example, the following queries are processed server-side and retrieve details for a specific order.
SELECT * FROM OrderDetails WHERE Id = 'O-1HE90236LH9332431'
SELECT * FROM OrderDetails WHERE Id IN ('O-1HE90236LH9332431', 'O-7D635956955612146')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The ID of the order. | |
| Status | String | The order status. The possible values are: CREATED, SAVED, APPROVED, VOIDED, COMPLETED. | |
| Intent | String | The intent to either capture payment immediately or authorize a payment for an order after order creation. The possible values are: CAPTURE, AUTHORIZE. | |
| CreatedTime | Datetime | The date and time when the transaction occurred. | |
| UpdatedTime | Datetime | The date and time when the transaction was last updated. | |
| PayerId | String | Deprecated. Use the PaymentSourcePaypal fields instead. The ID of the customer who approves and pays for the order. The customer is also known as the payer. | |
| PayerGivenName | String | Deprecated. Use the PaymentSourcePaypal fields instead. The name of the customer who approves and pays for the order. The customer is also known as the payer. | |
| PayerSurname | String | Deprecated. Use the PaymentSourcePaypal fields instead. The last name of the customer who approves and pays for the order. The customer is also known as the payer. | |
| PayerEmail | String | Deprecated. Use the PaymentSourcePaypal fields instead. The email of the customer who approves and pays for the order. The customer is also known as the payer. | |
| PayerPhoneType | String | Deprecated. Use the PaymentSourcePaypal fields instead. The phone type. | |
| PayerPhoneNumber | String | Deprecated. Use the PaymentSourcePaypal fields instead. The phone number, in its canonical international E.164 numbering plan format. | |
| PayerBirthDate | Date | Deprecated. Use the PaymentSourcePaypal fields instead. The birth date of the payer in YYYY-MM-DD format. | |
| PayerTaxId | String | Deprecated. Use the PaymentSourcePaypal fields instead. The customer's tax ID. Supported for the PayPal payment method only. | |
| PayerTaxType | String | Deprecated. Use the PaymentSourcePaypal fields instead. The customer's tax ID type. Supported for the PayPal payment method only.
The allowed values are BR_CPF, BR_CNPJ. | |
| PayerAddressLine1 | String | Deprecated. Use the PaymentSourcePaypal fields instead. The first line of the address. For example, number or street. | |
| PayerAddressLine2 | String | Deprecated. Use the PaymentSourcePaypal fields instead. The second line of the address. For example, suite or apartment number. | |
| PayerAddressPostalCode | String | Deprecated. Use the PaymentSourcePaypal fields instead. The postal code, which is the zip code or equivalent. Typically required for countries with a postal code or an equivalent. | |
| PayerAddressCountryCode | String | Deprecated. Use the PaymentSourcePaypal fields instead. The two-character ISO 3166-1 code that identifies the country or region. | |
| PayerAddressAdminArea1 | String | Deprecated. Use the PaymentSourcePaypal fields instead. The highest level sub-division in a country, which is usually a province, state, or ISO-3166-2 subdivision. | |
| PayerAddressAdminArea2 | String | Deprecated. Use the PaymentSourcePaypal fields instead. A city, town, or village. | |
| PurchaseUnits | String | An array of purchase units. | |
| PaymentSourcePaypalAccountId | String | The PayPal-assigned ID for the payer. | |
| PaymentSourcePaypalAccountStatus | String | The account status indicates whether the buyer has verified the financial details associated with their PayPal account. | |
| PaymentSourcePaypalEmailAddress | String | The email address of 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. | |
| PaymentSourcePaypalPhoneType | String | The phone type. | |
| PaymentSourcePaypalPhoneNumber | String | The national number, in its canonical international E.164 numbering plan format. | |
| PaymentSourcePaypalBirthDate | Date | The birth date of the payer in YYYY-MM-DD format. | |
| PaymentSourcePaypalBusinessName | String | The business name of the PayPal account holder (populated for business accounts). | |
| PaymentSourcePaypalTaxInfoTaxId | String | The customer's tax ID value. | |
| PaymentSourcePaypalTaxInfoTaxIdType | String | The customer's tax ID type.
The allowed values are BR_CPF, BR_CNPJ. | |
| 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. | |
| PaymentSourcePaypalAddressAdminArea2 | String | A city, town, or village. | |
| 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. | |
| PaymentSourceCardName | String | The card holder's name as it appears on the card. | |
| PaymentSourceCardLastDigits | String | The last digits of the payment card. | |
| PaymentSourceCardAvailableNetworks | String | Array of brands or networks associated with the card. | |
| PaymentSourceCardBrand | String | The card brand or network. Typically used in the response. | |
| PaymentSourceCardType | String | The payment card type. | |
| PaymentSourceCardExpiry | String | The card expiration year and month, in Internet date format. | |
| PaymentSourceCardBinDetailsBin | String | The Bank Identification Number (BIN) signifies the number that is being used to identify the granular level details of the bank. | |
| PaymentSourceCardBinDetailsIssuingBank | String | The issuer of the card instrument. | |
| PaymentSourceCardBinDetailsBinCountryCode | String | The two-character ISO-3166-1 country code of the bank. | |
| PaymentSourceCardBinDetailsProducts | String | The type of card product assigned to the BIN by the issuer. | |
| PaymentSourceCardFromRequestExpiry | String | The year and month, in ISO-8601 YYYY-MM date format. | |
| PaymentSourceCardFromRequestLastDigits | String | The last digits of the payment card. | |
| PaymentSourceCardStoredCredentialPaymentInitiator | String | The person or entity who initiated or triggered the payment. | |
| PaymentSourceCardStoredCredentialPaymentType | String | Indicates the type of the stored payment_source payment. | |
| PaymentSourceCardStoredCredentialUsage | String | Indicates if this is a first or subsequent payment using a stored payment source. | |
| PaymentSourceCardAuthenticationResultLiabilityShift | String | Liability shift indicator. The outcome of the issuer's authentication. | |
| PaymentSourceCardAuthenticationResultThreeDSecureAuthStatus | String | The outcome of the issuer's authentication. | |
| PaymentSourceCardAuthenticationResultThreeDSecureEnrollmentStatus | String | Status of authentication eligibility. | |
| PaymentSourceVenmoEmailAddress | String | The email address of the payer. | |
| PaymentSourceVenmoAccountId | String | The Venmo-assigned ID for the payer. | |
| PaymentSourceVenmoUserName | String | The Venmo username, as chosen by the user. | |
| 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, in its canonical international E.164 numbering plan format. | |
| 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. | |
| PaymentSourceApplePayId | String | ApplePay transaction identifier, this will be the unique identifier for this transaction provided by Apple. | |
| PaymentSourceApplePayToken | String | Encrypted ApplePay token, containing card information. This token would be base64encoded. | |
| PaymentSourceApplePayName | String | Name on the wallet. | |
| PaymentSourceApplePayEmailAddress | String | The email address of the account holder associated with this payment method. | |
| PaymentSourceApplePayPhoneNumber | String | The national number, in its canonical international E.164 numbering plan format. | |
| PaymentSourceApplePayCardName | String | The card holder's name as it appears on the card. | |
| PaymentSourceApplePayCardLastDigits | String | The last digits of the payment card. | |
| PaymentSourceApplePayCardAvailableNetworks | String | Array of brands or networks associated with the card. | |
| PaymentSourceApplePayCardType | String | The payment card type. | |
| PaymentSourceApplePayCardBrand | String | The card brand or network. | |
| PaymentSourceApplePayCardExpiry | String | The card expiration year and month, in Internet date format. | |
| PaymentSourceApplePayCardBillingAddressLine1 | String | The first line of the address. For example, number or street. | |
| PaymentSourceApplePayCardBillingAddressLine2 | String | The second line of the address. For example, suite or apartment number. | |
| PaymentSourceApplePayCardBillingAddressAdminArea1 | String | The highest level sub-division in a country, which is usually a province, state, or ISO-3166-2 subdivision. | |
| PaymentSourceApplePayCardBillingAddressAdminArea2 | String | A city, town, or village. | |
| PaymentSourceApplePayCardBillingAddressPostalCode | String | The postal code, which is the zip code or equivalent. Typically required for countries with a postal code or an equivalent. | |
| PaymentSourceApplePayCardBillingAddressCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceApplePayCounterfeitIndicator | String | The indicator to denote if the card is a counterfeit. | |
| PaymentSourceGooglePayName | String | Name on the account holder associated with Google Pay. | |
| PaymentSourceGooglePayEmailAddress | String | The email address of the account holder associated with Google Pay. | |
| PaymentSourceGooglePayPhoneNumberCountryCode | String | The country calling code (CC), in its canonical international E.164 numbering plan format. | |
| PaymentSourceGooglePayPhoneNumber | String | The national number, in its canonical international E.164 numbering plan format. | |
| PaymentSourceGooglePayCardName | String | The card holder's name as it appears on the card. | |
| PaymentSourceGooglePayLastDigits | String | The last digits of the payment card. | |
| PaymentSourceGooglePayType | String | The payment card type. | |
| PaymentSourceGooglePayBrand | String | The card brand or network. | |
| PaymentSourceGooglePayBillingAddressLine1 | String | The first line of the address. For example, number or street. | |
| PaymentSourceGooglePayBillingAddressLine2 | String | The second line of the address. For example, suite or apartment number. | |
| PaymentSourceGooglePayBillingAddressAdminArea1 | String | The highest level sub-division in a country, which is usually a province, state, or ISO-3166-2 subdivision. | |
| PaymentSourceGooglePayBillingAddressAdminArea2 | String | A city, town, or village. | |
| PaymentSourceGooglePayBillingAddressPostalCode | String | The postal code, which is the zip code or equivalent. Typically required for countries with a postal code or an equivalent. | |
| PaymentSourceGooglePayBillingAddressCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceBancontactName | String | The name of the account holder associated with this payment method. | |
| PaymentSourceBancontactCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceBancontactBic | String | The business identification code (BIC). | |
| PaymentSourceBancontactIbanLastChars | String | The last characters of the IBAN used to pay. | |
| PaymentSourceBancontactCardLastDigits | String | The last digits of the card used to fund the Bancontact payment. | |
| PaymentSourceBlikName | String | The name of the account holder associated with this payment method. | |
| PaymentSourceBlikCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceBlikEmail | String | The email address of the account holder associated with this payment method. | |
| PaymentSourceBlikOneClickConsumerReference | String | The merchant generated, unique reference serving as a primary identifier for accounts connected between Blik and a merchant. | |
| PaymentSourceEpsName | String | The name of the account holder associated with this payment method. | |
| PaymentSourceEpsCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceEpsBic | String | The business identification code (BIC). | |
| PaymentSourceGiropayName | String | The name of the account holder associated with this payment method. | |
| PaymentSourceGiropayCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceGiropayBic | String | The business identification code (BIC). | |
| PaymentSourceIdealName | String | The name of the account holder associated with this payment method. | |
| PaymentSourceIdealCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceIdealBic | String | The business identification code (BIC). | |
| PaymentSourceIdealIbanLastChars | String | The last characters of the IBAN used to pay. | |
| PaymentSourceMybankName | String | The name of the account holder associated with this payment method. | |
| PaymentSourceMybankCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceMybankBic | String | The business identification code (BIC). | |
| PaymentSourceMybankIbanLastChars | String | The last characters of the IBAN used to pay. | |
| PaymentSourceP24Name | String | The name of the account holder associated with this payment method. | |
| PaymentSourceP24Email | String | The email address of the account holder associated with this payment method. | |
| PaymentSourceP24CountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceP24PaymentDescriptor | String | P24 generated payment description. | |
| PaymentSourceP24MethodId | Integer | Numeric identifier of the payment scheme or bank used for the payment. | |
| PaymentSourceP24MethodDescription | String | Friendly name of the payment scheme or bank used for the payment. | |
| PaymentSourceSofortName | String | The name of the account holder associated with this payment method. | |
| PaymentSourceSofortCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceSofortBic | String | The business identification code (BIC). | |
| PaymentSourceSofortIbanLastChars | String | The last characters of the IBAN used to pay. | |
| PaymentSourceTrustlyName | String | The name of the account holder associated with this payment method. | |
| PaymentSourceTrustlyCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PaymentSourceTrustlyEmail | String | The email address of the account holder associated with this payment method. | |
| PaymentSourceTrustlyBic | String | The business identification code (BIC). | |
| PaymentSourceTrustlyIbanLastChars | String | The last characters of the IBAN used to pay. |