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
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. |