ODBC Driver for PayPal

Build 24.0.9062

RefundDetails

Query details about a specific Refund.

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 Refund.

SELECT * FROM RefundDetails WHERE Id = '4W92068757818534U'

SELECT * FROM RefundDetails WHERE Id IN ('4W92068757818534U', '4W91234757818534U')

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.
NoteToPayer String The reason for the refund. Appears in both the payer's transaction history and the emails that the payer receives.
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.
TotalRefundedMoney Decimal The total amount refunded from the original capture to date.
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 24.0.9062