TransactionReportsCartInfoItemDetails
Lists cart information for 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 TransactionReportsCartInfoItemDetails WHERE StartDate = '2021-09-06 12:12:12' AND EndDate = '2021-09-11 12:12:12'
For the TransactionAmount filter, enter values in the smallest denomination. For example, to search for transactions from $6.00 to $10.05, use the range of 600 to 1005 (values are in cents).
Supported operators include: =, <, <=, >, >=.
SELECT * FROM TransactionReportsCartInfoItemDetails 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. | |
| InvoiceNumber | String | The invoice number. An alphanumeric string that identifies a billing for a merchant. | |
| ItemAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| ItemAmountValue | String | The value of item amount. | |
| ItemCode | String | An item code that identifies a merchant's goods or service. | |
| ItemDescription | String | The item description. | |
| ItemName | String | The item name. | |
| ItemQuantity | String | The number of purchased units of goods or a service. | |
| ItemUnitPriceCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| ItemUnitPriceValue | String | The value of item unit price. | |
| TaxAmounts | String | An array of tax amounts levied by a government on the purchase of goods or services. | |
| TotalItemAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| TotalItemAmountValue | String | The value of total item amount. | |
| DiscountAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| DiscountAmountValue | Decimal | The amount for a financial transaction, such as a balance or payment due. | |
| AdjustmentAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| AdjustmentAmountValue | Decimal | The amount for a financial transaction, such as a balance or payment due. | |
| GiftWrapAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| GiftWrapAmountValue | Decimal | The amount for a financial transaction, such as a balance or payment due. | |
| TaxPercentage | Decimal | The percentage, as a fixed-point, signed decimal number. | |
| BasicShippingAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| BasicShippingAmountValue | Decimal | The amount for a financial transaction, such as a balance or payment due. | |
| ExtraShippingAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| ExtraShippingAmountValue | Decimal | The amount for a financial transaction, such as a balance or payment due. | |
| HandlingAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| HandlingAmountValue | Decimal | The amount for a financial transaction, such as a balance or payment due. | |
| InsuranceAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| InsuranceAmountValue | Decimal | The amount for a financial transaction, such as a balance or payment due. | |
| ItemOptions | String | The item options. Describes option choices on the purchase of the item in some detail. |
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. |