ODBC Driver for PayPal

Build 23.0.8839

AuthorizationDetails

Query details about Authorizations.

Table Specific Information

Select

The only filter supported by the PayPal API is Id, which is required. The 本製品 processes other filters client side within the 本製品.

For example, the following queries are processed server side and retrieve details for a specific Authorization.

SELECT * FROM AuthorizationDetails WHERE Id = '70K15739YA1955155'

SELECT * FROM AuthorizationDetails WHERE Id IN ('70K15739YA1955155', '70K15739YA1955156')

Columns

Name Type References Description
Id [KEY] String The PayPal-generated ID for the authorized payment.
Status String The status for the authorized payment.
StatusDetails String The details of the authorized order pending status.
AmountTotal Decimal The amount for this authorized payment.
AmountCurrency String The currency of the amount.
InvoiceId String The API caller-provided external invoice number for this order. Appears in both the payer's transaction history and the emails that the payer receives.
CustomId String The API caller-provided external ID. Used to reconcile API caller-initiated transactions with PayPal transactions. Appears in transaction and settlement reports.
SellerProtectionStatus String The level of protection offered as defined by PayPal Seller Protection for Merchants.
ExpirationTime Datetime The amount being charged for the handling fee. Only supported when the payment method is set to paypal.
CreateTime Datetime The time of authorization.
UpdateTime Datetime The time that the resource was last updated.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839