OrderItems
Retrieve information related to order items.
Select
The 本製品 will use the au PAY Market API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- OrderId, ShopId, LotNumber, ItemCode columns support the = operator.
- OrderDate column supports the =,<,<=,>,>= operators.
- ItemManagementId, ItemName columns support the LIKE operator.
SELECT * FROM OrderItems WHERE OrderId = 1234
SELECT * FROM OrderItems WHERE OrderDate > '2018/12/13' AND OrderDate < '2019/12/13'
SELECT * FROM OrderItems WHERE ItemManagementId LIKE 'manage id' AND ItemName LIKE 'name' AND OrderDate = '01/01/2019'
Insert
Insert is not supported for this table
Update
au PAY Market allows updates for the ItemPrice, Unit columns. OrderId and OrderItemId are required.
UPDATE OrderItems SET ItemPrice = 123, Unit = 12 WHERE OrderId = 12345 AND OrderItemId = 123456
Batch Update
au PAY Market allows batch updates for the ItemPrice, Unit columns. OrderId and OrderItemId are required.
INSERT INTO OrderItems#TEMP (Unit, OrderItemId, OrderId) VALUES (12, 211700, 211700)
INSERT INTO OrderItems#TEMP (Unit, OrderItemId, OrderId) VALUES (13, 211701, 211700)
INSERT INTO OrderItems#TEMP (Unit, OrderItemId, OrderId) VALUES (14, 211702, 211700)
UPDATE OrderItems SET (Unit, OrderItemId, OrderId) SELECT Unit, OrderItemId, OrderId FROM OrderItems#TEMP
Delete
Delete is not supported for this table
Columns
Name | Type | ReadOnly | References | Description |
OrderId [KEY] | Long | False |
Orders.OrderId |
Order Id. |
OrderItemId [KEY] | Long | False |
Order item Id. | |
OrderDate | Datetime | True |
Order date. | |
ItemManagementId | String | True |
Administrative id. | |
ItemCode | String | True |
Item code. | |
LotNumber | Long | True |
Lot number. | |
ItemName | String | True |
Product name. | |
ItemOption | String | True |
Item option information the buyer has selected. | |
ItemCancelStatus | String | True |
Cancellation status. N = Sold C = Cancelled. | |
BeforeDiscount | Decimal | True |
Itemm price before discount. | |
Discount | Decimal | True |
Applied discount. | |
ItemPrice | Decimal | False |
Item price. | |
Unit | Integer | False |
Number of ordered units. | |
TotalItemPrice | Decimal | True |
Total item price. | |
TaxType | String | True |
Commodity tax classification that has been registered at the time of exhibition. N = No tax, I = Tax included, E = Outside tax. | |
ReducedTax | String | True |
Reduced tax rate setting. | |
TaxRate | String | True |
Sales tax rate. | |
GiftPoint | Long | True |
The number of points granted to the purchaser in the order. | |
ShippingDayDisplayText | String | True |
Shipping day information. | |
ShippingTimelimitDate | Date | True |
Shipping deadline. | |
ShopId | String | True |
Store account. |