TransactionReportsIncentiveDetails
Lists incentive details of transaction reports.
Table Specific Information
Select
The driver uses the PayPal API to process WHERE clause conditions that are built with the following filters.
- StartDate
- EndDate
- TransactionId
- PaymentInstrumentType
- BalanceAffectingRecordsOnly
- StoreId
- TerminalId
- TransactionAmount
- TransactionCurrency
- TransactionStatus
- TransactionType
Server-side processing is only supported for the = operator. For example:
SELECT * FROM TransactionReportsIncentiveDetails WHERE StartDate = '2021-09-06 12:12:12' AND EndDate = '2021-09-11 12:12:12'
For the TransactionAmount filter, specify amounts in cents. For example, to search for transactions from $6.00 to $10.05, enter the range 600 to 1005.
Supported operators include: =, <, <=, >, >=.
SELECT * FROM TransactionReportsIncentiveDetails WHERE TransactionAmount > 600 AND TransactionAmount < 1005
The driver processes other filters client-side within the driver.
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. |