Transactions
Query all transactions in which the authenticated user is either the buyer or seller. By default, only transactions of orders made in the last 90 days are returned. Transactions of orders older than 90 days can be retrieved by specifying OrderId.
View Specific Information
Select
Examples of querying the Transactions view.
SELECT * FROM Transactions WHERE OrderRole = 'Seller' SELECT * FROM Transactions WHERE OrderId = '110276240386-28854859001' SELECT * FROM Transactions WHERE CreateTimeFrom = '2/10/2018' AND CreateTimeTo = '3/16/2018'
Columns
| Name | Type | Description |
| TransactionId [KEY] | String | Unique identifier for an eBay order line item. An order line item is created once there is a commitment from a buyer to purchase an item. |
| OrderId | String | The Id that uniquely identifies the item listing. The Id is generated by eBay after an item is listed. You cannot choose or revise this value. |
| ItemId | String | The unique identifier of the eBay listing. This identifier is generated by eBay and returned in the response of an Add call if an item is successfully listed. |
| ItemSite | String | The name of the site on which the item is listed. |
| ItemTitle | String | This field is used to specify the title of the listing. |
| ActualHandlingCost | Decimal | The handling cost that the seller has charged for the order line item. |
| ActualShippingCost | Decimal | The shipping cost paid by the buyer for the order line item. This field is only returned after checkout is complete. |
| BuyerEmail | String | Email address for the user. |
| BuyerFirstName | String | The first name of the buyer who purchased the order. |
| BuyerLastName | String | The last name of the buyer who purchased the order. |
| CreatedDate | Datetime | Indicates the creation time of the order line item. |
| Price | Decimal | The price of the order line item. |
| SiteId | String | The site upon which the order line item (transaction) was created. |
| PaidTime | Datetime | Indicates the time when the order was marked paid. |
| DigitalRecipientEmail | String | This field displays the email address of the sender/purchaser of the digital gift card. |
| DigitalRecipientName | String | This field displays the actual name (not the eBay user ID) of the sender/purchaser of the digital gift card. |
| DigitalSenderEmail | String | This field displays the email address of the sender/purchaser of the digital gift card. |
| DigitalSenderName | String | This field displays the actual name (not the eBay user ID) of the sender/purchaser of the digital gift card |
| DigitalDeliveryMethod | String | This value indicates the method in which the digital gift card will be delivered to the buyer. |
| EBayPlusTransaction | Boolean | If true, this transaction is for an item that was purchased under the eBay Plus program. |
| ExternalTransactionId | String | Unique identifier for a PayPal payment of an eBay order. |
| ExternalTransactionStatus | String | The current processing status of a PayPal payment for an eBay order. |
| ExternalTransactionTime | Datetime | Timestamp for payment transaction. |
| ExternalFeeOrCreditAmount | Decimal | Fee Amount is a positive value and Credit Amount is a negative value. |
| ExternalPaymentOrRefundAmount | Decimal | If positive, the amount the buyer pays the seller through PayPal on the purchase of items. If negative, the amount refunded the buyer. Default = 0. |
| FinalValueFee | Decimal | A Final Value Fee is calculated and charged to a seller's account immediately upon creation of an order line item. |
| GuaranteedDelivery | Boolean | This field is returned as true if the order line item is qualified for eBay Guaranteed Delivery, or false if it is not eligible. |
| GuaranteedShipping | Boolean | This field is returned as true if the seller chose to use eBay's Guaranteed Shipping feature at listing time. |
| InvoiceSentTime | Datetime | This field indicates the date/time that an order invoice was sent from the seller to the buyer. |
| DigitalStatus | String | This enumeration value indicates the current state of a purchased digital gift card. |
| InquiryStatus | String | This field gives the status of a buyer's Item Not Received (INR) Inquiry. |
| ReturnStatus | String | This field gives the status of a buyer's return request. |
| TotalTaxAmount | Decimal | This value indicates the total tax amount for the order line item, including the sales tax on the item, the sales tax on shipping and handling, and any electronic waste recycling fee. |
| UnpaidItemStatus | String | This field indicates the status of the Unpaid Item case. This field is always returned with the UnpaidItem container. |
| UnpaidItemType | String | This field indicates if the Unpaid Item case was opened manually by the customer or opened automatically by eBay's Unpaid Item Assistant feature. |
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 |
| CreateTimeFrom | Datetime | Specifies the start of the date range for which to retrieve transactions of orders created within this date range. |
| CreateTimeTo | Datetime | Specifies the end of the date range for which to retrieve transactions of orders created within this date range. |
| ModTimeFrom | Datetime | Specifies the start of the date range for which to retrieve transactions of orders modified within this date range. The maximum time range that may be specified is 30 days. |
| ModTimeTo | Datetime | Specifies the end of the date range for which to retrieve transactions of orders modified within this date range. The maximum time range that may be specified is 30 days. |
| NumberOfDays | Integer | All eBay transactions that were either created or modified within this period are returned in the output. Min: 1. Max: 30. |
| OrderRole | String | Filters the returned transactions based on the role of the user. The user's role is either buyer or seller. |
| OrderStatus | String | Filters the returned transactions based on the status of the order. Applicable Values: Active, All, Completed, Inactive. |