Returns data regarding order delivery specific items.

Select

The 本製品 will use the GMO MakeShop API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

• OrderNumber column supports the = operator.
• Date column supports the >,>=,=,<=,< operators. When no column filters are specified, we will default to retrieving information related to orders from the last 6 months.
• Canceled pseudo-column supports the = operator.

For example, the following queries are processed server side:

SELECT * FROM OrderDeliveryLineItems WHERE OrderNumber = 'ORD12345' AND Date >= '2018-09-04 22:54:43+01:00' AND Date <= '2018-09-04 23:54:43+01:00' 

SELECT * FROM OrderDeliveryLineItems WHERE Date > '2018-09-04 22:54:43+01:00' AND Date < '2018-09-04 23:54:43+01:00' 

SELECT * FROM OrderDeliveryLineItems WHERE Date = '2018-09-04 23:54:43+01:00' AND Canceled = 1 

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an unfiltered data to be pushed.

Columns

Name	Type	Description
OrderNumber [KEY]	String	Order number.
Date	Datetime	Order date.
DeliveryId [KEY]	Integer	Id of the order delivery.
BrandCode [KEY]	String	System product code.
OriginalCode	String	Original product code.
Name	String	Product name.
Price	Integer	Selling price.
Point	Integer	Product points.
Amount	Integer	Order quantity.
ConsumptionTaxRate	Integer	Sales tax rate.
Option	String	Product option names.
OriginalOptionCode	String	Original option code.
NameOptions	String	Original option code.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
Canceled	Integer	Specify this as 1 to acquire cancelled orders. Defaults to 0 and cancelled orders will not be retrieved. 使用できる値は次のとおりです。0, 1