BillPayCData BizTalk Adapter for PayPal 2019 - Build 19.0.7354
Query Transactions involving BillPay Transactions.
|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 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.
|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. The field is not applicable to point-of-sale.|
|CurrencyCode||String||Search by the 3-character, ISO 4217 currency code.|
|InvoiceId||String||Search by the invoice identification key, as set by you for the original transaction. 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.|