TransactionReportsIncentiveDetails
Lists incentive details of transaction reports.
Table Specific Information
Select
The 本製品 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 本製品 processes other filters client-side within the 本製品.
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。D, P, S, V | |
| TransactionType | String | Filters the transactions in the response by a PayPal transaction event code. |