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.
使用できる値は次のとおりです。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. |