Retrieve information related to order items.

Select

The connector 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 connector.

• OrderId, ShopId, LotNumber, ItemCode columns support the = operator.
• OrderDate column supports the =,<,<=,>,>= operators.
• ItemManagementId, ItemName columns support the LIKE operator.

For example, the following queries are processed server side:

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.