TDV Adapter for PayPal

Build 22.0.8462

Referral

Query Transactions involving Referrals.

Columns

Name Type References Description
Id [KEY] String The Id of the transaction record of the merchant.
PayerDisplayName String The display name of the buyer.
NetAmount Decimal The net amount of the transaction.
FeeAmount Decimal The fee that PayPal charged for the transaction.
GrossAmount Decimal The total gross amount charged, including any profile shipping cost and taxes.
Status String The status of the transaction. This field is one of the following values: Pending, Processing, Success, Denied, or Reversed.

The allowed values are Pending, Processing, Success, Denied, Reversed.

Date Datetime The date and time that the transaction occurred.
Timezone String The time zone of the transaction. The value is always GMT.
Type String The type of the transaction. It is one of the following values: Currency Conversion (credit), Currency Conversion (debit), Payment, Recurring Payment, Temporary Hold, Transfer, Donation.
Payer String The email address of the buyer. Character length and limitations: 127 single-byte alphanumeric characters.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Amount String Search by the transaction amount. You must set the CurrencyCode input to one of the 3-character currency codes for any of the supported PayPal currencies. This value cannot exceed 10,000.00 USD or the per transaction limit for the currency. It includes no currency symbol.
AuctionItemNumber String Search by the auction item number of the purchased goods. This field is not applicable to point-of-sale.
CardNumber String Search by the credit card number, as set by you for the original transaction. This field searches the records for items the merchant sells. The field is not applicable to point-of-sale.
CurrencyCode String Search by the 3-character, ISO 4217 currency code.
InvoiceId String Search by invoice identification key, as set by you for the original transaction. This field searches the records for items the merchant sells. Character length and limitations: 127 single-byte characters maximum with no wildcards allowed.
ProfileId String Search by the alphanumeric string (generated by PayPal) that uniquely identifies a recurring profile. You can specify the Profile Id to obtain all payments associated with the identified profile.
ReceiptId String Search by the PayPal Account Optional receipt Id. This field is not applicable to point-of-sale transactions.
Receiver String Search by the email address of the receiver. If the merchant account has only one email address, this is the primary email. It can also be a non-primary email address.
PayerName String Search by the name of the buyer.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462