Retrieve and update information related to item deliveries.

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.

• LotNumber, ShopId columns support the = operator.
• ItemCode column supports the LIKE operator.

For example, the following queries are processed server side:

SELECT * FROM ItemDeliveries WHERE ItemCode LIKE '%CD00%'

SELECT * FROM ItemDeliveries WHERE ItemCode = 'CD001' AND LotNumber = 123543 

Insert

All columns can be specified. ItemCode, DeliveryId, DeliverySeq are required for an insert.

 INSERT INTO ItemDeliveries (ItemCode, LotNumber, DeliveryId, DeliverySeq)  VALUES ('Code0001', '9804120', '10', 1) 

Batch Insert

All columns can be specified. ItemCode, DeliveryId, DeliverySeq are required.

INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq)  VALUES ('Code0001', '9804120', '10', 1)

INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq)  VALUES ('Code0001', '9804120', '11', 2)

INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq)  VALUES ('Code0001', '9804120', '12', 3)

INSERT INTO ItemDeliveries  SELECT ItemCode, LotNumber, DeliveryId, DeliverySeq FROM ItemDeliveries#TEMP

Update

au PAY Market allows updates for all columns. ItemCode, DeliveryId are required.

UPDATE ItemDeliveries SET DeliveryId = '10', DeliverySeq = 1 WHERE ItemCode = 'Code0001' AND LotNumber = 9804120

Batch Update

au PAY Market allows updates in batches for all columns. ItemCode, DeliveryId are required.

INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '10', 1)

INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '11', 2)

INSERT INTO ItemDeliveries#TEMP (ItemCode, LotNumber, DeliveryId, DeliverySeq) VALUES ('Code0001', '9804120', '12', 3)

UPDATE ItemDeliveries SET (ItemCode, LotNumber, DeliveryId, StockSegment) SELECT ItemCode, LotNumber, DeliveryId, DeliverySeq FROM ItemDeliveries#TEMP

Delete

Delete is not supported for this table

Columns

Name	Type	ReadOnly	References	Description
ItemCode [KEY]	String	False	Items.ItemCode	Product code.
LotNumber	Long	False	Items.LotNumber	Lot number.
DeliveryId [KEY]	String	False		Delivery id.
DeliverySeq	String	False		Delivery sequence.
ShopId	String	False		Store account.