DisputeDetailsCData BizTalk Adapter for PayPal 2019 - Build 19.0.7354
PayPal merchants, partners, and external developers can use the PayPal Disputes API to manage disputes.
Table Specific Information
This view returns a list of disputes with detailed information for the authenticated user.
The following filters are supported by the PayPal API:
The adapter processes other filters client side within the adapter. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
For example, the following queries are processed server side.
- The following query retrieves details for a specific Dispute:
SELECT * FROM DisputeDetails WHERE DisputeId = 'PP-D-12345'
|DisputeId [KEY]||String||The ID of the dispute.|
|CreatedTime||Datetime||The date and time when the dispute was created.|
|UpdatedTime||Datetime||The date and time when the dispute was updated.|
|Status||String||The status of the dispute.
The allowed values are OPEN, WAITING_FOR_BUYER_RESPONSE, WAITING_FOR_SELLER_RESPONSE, UNDER_REVIEW, RESOLVED, OTHER.
|Reason||String||The reason for the item-level dispute.
The allowed values are MERCHANDISE_OR_SERVICE_NOT_RECEIVED, MERCHANDISE_OR_SERVICE_NOT_AS_DESCRIBED, UNAUTHORISED, CREDIT_NOT_PROCESSED, DUPLICATE_TRANSACTION, INCORRECT_AMOUNT, PAYMENT_BY_OTHER_MEANS, CANCELED_RECURRING_BILLING, PROBLEM_WITH_REMITTANCE, OTHER.
|DisputeState||String||The state of the dispute.
The allowed values are OPEN_INQUIRIES, REQUIRED_ACTION, REQUIRED_OTHER_PARTY_ACTION, UNDER_PAYPAL_REVIEW, APPEALABLE, RESOLVED.
|DisputeCurrencyCode||String||The three-character ISO-4217 currency code that identifies the currency.|
|DisputeAmountValue||Decimal||The value of the amount.|
|ExternalReasonCode||String||The code that identifies the reason for the credit card chargeback.|
|DisputeOutcomeCode||String||The outcome of a resolved dispute.|
|DisputeOutcomeAmountRefundedCode||String||The three-character ISO-4217 currency code that identifies the currency.|
|DisputeOutcomeAmountRefundedValue||Decimal||The value of the amount.|
|DisputeLifecycleStage||String||The stage in the dispute lifecycle.|
|DisputeChannel||String||The channel where the customer created the dispute.|
|OfferType||String||The merchant-proposed offer type for the dispute.|
|BuyerRequestedAmountCode||String||The three-character ISO-4217 currency code that identifies the currency.|
|BuyerRequestedAmountValue||Decimal||The value of the amount.|
|BuyerResponseDueDate||Datetime||The date and time by when the customer must respond to the dispute.|
|SellerOfferedAmountCode||String||The three-character ISO-4217 currency code that identifies the currency.|
|SellerOfferedAmountValue||Decimal||The value of the amount.|
|SellerResponseDueDate||Datetime||The date and time by when the seller must respond to the dispute.|
|String||The email address that is provided by the merchant where the customer can share the evidences.|
|Note||String||The merchant provided notes that are visible to both the customer and PayPal.|
|TimePosted||Datetime||The date and time when the contact details were posted.|