JDBC Driver for PayPal

Build 22.0.8462

CaptureDetails

Query details about a captured Payment.

Table Specific Information

Select

The only filter supported by the PayPal API is Id, which is required. 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 queries are processed server side and retrieve details for a specific Capture.

SELECT * FROM CaptureDetails WHERE Id = '9G02572041588110H'

SELECT * FROM CaptureDetails WHERE Id IN ('9G02572041588110H', '9G02572041588111H')

Columns

Name Type References Description
Id [KEY] String The PayPal-generated ID for the captured payment.
Status String The status of the captured payment.
StatusDetails String The details of the captured payment status.
AmountValue Decimal The amount for this captured payment.
AmountCurrency String The currency of the amount for this captured payment.
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.
FinalCapture Boolean Indicates whether you can make additional captures against the authorized payment.
DisbursementMode String The funds that are held on behalf of the merchant.
SellerGrossAmount Decimal The amount for this captured payment.
SellerPaypalFee Decimal The applicable fee for this captured payment.
SellerNetAmount Decimal The net amount that the payee receives for this captured payment in their PayPal account.
SellerReceivableAmount Decimal The net amount that is credited to the payee's PayPal account. Returned only when the currency of the captured payment is different from the currency of the PayPal account where the payee wants to credit the funds.
SellerExchangeRate Decimal The exchange rate that determines the amount that is credited to the payee's PayPal account. Returned when the currency of the captured payment is different from the currency of the PayPal account where the payee wants to credit the funds.
CreateTime Datetime The time of authorization.
UpdateTime Datetime The time that the resource was last updated.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462