JDBC Driver for PayPal

Build 24.0.9060

TransactionReportsIncentiveDetails

List Incentive Details of Transaction Reports.

Columns

Name Type References Description
AccountNumber String The merchant account number.
LastRefreshedDatetime Datetime The date and time when the data was last refreshed, in Internet date and time format.
IncentiveAmountCurrencyCode String The three-character ISO-4217 currency code that identifies the currency.
IncentiveAmountValue String The value of incentive amount.
IncentiveCode String The code that identifies an incentive, such as a coupon.
IncentiveProgramCode String The incentive program code that identifies a merchant loyalty or incentive program.
IncentiveType String The type of incentive, such as a special offer or coupon.

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
StartDate Datetime The start date and time, in Internet date and time format.
EndDate Datetime The end date and time, in Internet date and time format.
TransactionId String The PayPal-generated transaction ID.
PaymentInstrumentType String Filters the transactions in the response by a payment instrument type.
BalanceAffectingRecordsOnly String Indicates whether the response includes only balance-impacting transactions or all transactions.

The allowed values are Y, N.

StoreId String Filters the transactions in the response by a store ID.
TerminalId String Filters the transactions in the response by a terminal ID.
TransactionAmount String Filters the transactions in the response by a gross transaction amount range. For example, to search for transactions from $5.00 to $10.05, specify [500 TO 1005].
TransactionCurrency String Filters the transactions in the response by a three-character ISO-4217 currency code for the PayPal transaction currency.
TransactionStatus String Filters the transactions in the response by a PayPal transaction status code.

The allowed values are D, P, S, V.

TransactionType String Filters the transactions in the response by a PayPal transaction event code.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060