Returns data regarding orders. ShippingStatus column is required to be specified for this view.

Select

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

• ShippingStatus supports the '=' operator.
• SearchCondition supports the '=' operator.
• Date supports the '=', '<' and '>' operators.

For example, the following query is processed server side:

SELECT * FROM Orders WHERE ShippingStatus='1'
SELECT * FROM Orders WHERE ShippingStatus=1 AND SearchCondition='2' AND Date>'2017-04-24' AND Date<'2019-04-23'

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

Columns

Name	Type	Description
OrderNo [KEY]	String	Code of the order.
SellerID	String	Id of the seller.
PackNo	String	The code of pack.
PackingNo	String	Number of the packing.
ShippingStatus	String	Status of the shipping. 1 : Waiting for Shipping 2 : Request Shipping 3 : Check Order.
OrderDate	Datetime	Date of the order.
PaymentDate	Datetime	Date of the payment.
Buyer	String	Person who made the order.
BuyerGata	String	Buyer gata.
BuyerTel	String	Telephone number of the buyer.
BuyerMobile	String	Mobile number of the buyer.
BuyerEmail	String	Email of the buyer.
OrderType	String	Type of the order.
ItemCode	String	The item code of Qoo10.
ItemTitle	String	Title of the item.
Option	String	Order option.
OptionCode	String	Option code.
OrderPrice	Decimal	Price of the order.
OrderQty	Integer	Quantity of the order.
Discount	Decimal	Discount of the order.
Total	Decimal	Total price of the order.
SettlePrice	Decimal	Settle price of the order.
Receiver	String	Receiver of the order.
ReceiverGata	String	Receiver of the order.
ReceiverTel	String	Telephone number of the receiver.
ReceiverMobile	String	Mobile number of the receiver.
SenderName	String	Name of the sender.
SenderTel	String	Telephone number of the sender.
SenderNation	String	Nation of the sender.
SenderZipCode	String	ZipCode of the sender.
SenderAddr	String	Address of the sender.
RelatedOrder	String	Related order.
SellerDeliveryNo	String	Number of the delivery.
VoucherCode	String	Code of the voucher.
PaymentNation	String	Payment nation.
PaymentMethod	String	Method of the payment.
CodPrice	Decimal	Cod price.
CartDiscountSeller	Decimal	Cart Discount Seller.
CartDiscountQoo10	Decimal	Cart Discount Qoo10.
Currency	String	Currency.
Date	Date	Date range.
SearchCondition	String	Inquiry Date Type. 1: (Order date), 2:(Payment date), 3 :(Shipping date), 4 :(Delivered date). Default :1.