Cmdlets for au PAY Market

Build 24.0.9062

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062