AuthorizationDetails
Returns details about authorizations.
View-Specific Information
SELECT
The only filter supported by the PayPal API is Id, which is required. The provider processes all other filters client-side.
For example, the provider processes the following queries server-side to retrieve details for a specific authorization.
SELECT * FROM AuthorizationDetails WHERE Id = '70K15739YA1955155'
SELECT * FROM AuthorizationDetails WHERE Id IN ('70K15739YA1955155', '70K15739YA1955156')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The PayPal-generated ID for the authorized payment. | |
| Status | String | The status for the authorized payment.
The allowed values are CREATED, CAPTURED, DENIED, PARTIALLY_CAPTURED, VOIDED, PENDING. | |
| StatusDetails | String | The details of the authorized order pending status.
The allowed values are PENDING_REVIEW, DECLINED_BY_RISK_FRAUD_FILTERS. | |
| AmountTotal | Decimal | The amount for this authorized payment. | |
| AmountCurrency | String | The currency of the amount. | |
| 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.
The allowed values are ELIGIBLE, PARTIALLY_ELIGIBLE, NOT_ELIGIBLE. | |
| ExpirationTime | Datetime | The amount being charged for the handling fee. Only supported when the payment method is set to Paypal. | |
| CreateTime | Datetime | The time of authorization. | |
| UpdateTime | Datetime | The time that the resource was last updated. | |
| PayeeEmailAddress | String | The email address of the payee. | |
| PayeeMerchantId | String | The merchant ID of the payee. | |
| RelatedOrderId | String | The ID of the order related to the resource. | |
| RelatedAuthorizationId | String | The ID of the authorization related to the resource. | |
| RelatedCaptureId | String | The ID of the capture related to the resource. |