ODBC Driver for eBay

Build 20.0.7587

OrderPayments

Query all payments of the orders, in which the authenticated user is either the buyer or seller. By default, only payment details of orders made in the last 90 days are returned. Payment details of orders older than 90 days can be retrieved by specifying OrderId.

View Specific Information

Select

Examples of querying the OrderPayments view:

SELECT * FROM OrderPayments WHERE ModTimeFrom = '2/22/2018'

SELECT * FROM OrderPayments WHERE NumberOfDays = '30'

Columns

Name Type Description
PaymentId [KEY] String A unique transaction ID for the payment.
OrderId String A unique identifier for an eBay order.
FeeOrCreditAmount Decimal Fee Amount is a positive value and Credit Amount is a negative value.
Payee String The person or organization who is to receive the payment allocation.
Payer String This field indicates the eBay user or eBay partner who submitted the payment.
PaymentAmount Decimal The amount of the payment that is allocated to the payee.
PaymentStatus String The current status of a buyer payment that is allocated to a specified payee.
PaymentTime Datetime The date and time when the payment is received by the payee.

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 payment details of the orders created within this date range.
CreateTimeTo Datetime Specifies the end of the date range for which to retrieve payment details of the orders created within this date range.
ModTimeFrom Datetime Specifies the start of the date range for which to retrieve payment details of the 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 payment details of the orders modified within this date range. The maximum time range that may be specified is 30 days.
NumberOfDays Integer All eBay payment details of the orders that were either created or modified within this period are returned in the output. Min: 1. Max: 30.
OrderRole String Filters the returned payment details of the orders based on the role of the user. The user's role is either buyer or seller.
OrderStatus String Filters the returned payment details of the orders based on the status of the order. Applicable Values: Active, All, Completed, Inactive.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587