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