RefundDetails

Query details about a specific Refund.

Table Specific Information

The only filter supported by the PayPal API is Id, which is required. The add-in processes other filters client side within the add-in.

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')


Name	Type	References	Description
Id [KEY]	String		The PayPal-generated ID for the captured payment.
Status	String		The status of the captured payment. The allowed values are CANCELLED, FAILED, PENDING, COMPLETED.
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.
CustomId	String		The API caller-provided external ID. Used to reconcile API caller-initiated transactions with PayPal transactions.
AcquirerReferenceNumber	String		Reference ID issued for the card transaction.
PayerEmailAddress	String		The email address of merchant.
PayerMerchantId	String		The encrypted PayPal account ID of the merchant.