Claims
Returns data regarding claim info. ClaimStaus column is required to be specified for this view. ClaimStaus = 4 by default. Possible values are 1,2,3,4,5,6.
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 本製品.
- ClaimStatus supports the '=' operator.
- Date supports the '=', '<' and '>' operators.
SELECT * FROM Claims WHERE ClaimStatus=2 SELECT * FROM Claims WHERE ClaimStatus=4 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 |
ClaimStatus | String | Processing state. 1-Cancel request. 2-Cancelling. 3-Cancel completed. 4-Return request. 5-Returning. 6-Return completed.
使用できる値は次のとおりです。1, 2, 3, 4, 5, 6 |
CancelRefundDate | Datetime | Cancel / Return / Exchange Completion Date. |
Reason | String | Reason for return, exchange. |
RequestDate | Datetime | Request date for cancellation / return / exchange. |
OrderDate | Datetime | Date of the order. |
PaymentDate | Datetime | Date of the payment. |
ShippingDate | Datetime | Shipping date. |
DeliveredDate | Datetime | Delivered date. |
OrderNo [KEY] | String | Code of the order. |
PackNo | String | The code of pack. |
ItemCode | String | The item code of Qoo10. |
SellerItemCode | String | Merchant product code. |
ItemTitle | String | Product name. |
OrderQty | Integer | Quantity of the order. |
PaymentNation | String | Payment nation. |
Currency | String | Currency. |
PaymentAmount | String | Settlement amount. |
DeliveryCompanyReturn | String | Delivery company return. |
TrackingNoReturn | String | Tracking code return. |
ZipCode | String | ZipCode. |
PaymentReturnShipping | String | Payment return shipping. |
ItemCondition | String | Condition of the item. |
Receiver | String | Receiver of the order. |
ReceiverTel | String | Telephone number of the receiver. |
ReceiverMobile | String | Mobile number of the receiver. |
Buyer | String | Person who made the order. |
BuyerTel | String | Telephone number of the buyer. |
BuyerMobile | String | Mobile number of the buyer. |
CODCancelPrice | Decimal | COD cancel price. |
CODQrefundPrice | Decimal | COD refound price. |
CODCancelRelatedOrder | String | COD cancel related order. |
Date | Date | Date range. |