Retrieve and information related to item delivery methods.

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 ItemDeliveryMethods WHERE ItemCode LIKE '%CD00%'

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

Insert

All columns can be specified. ItemCode, DeliveryMethodId, DeliveryMethodSeq are required for an insert.

INSERT INTO ItemDeliveryMethods (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'M', 1) 

Batch Insert

All columns can be specified. ItemCode, DeliveryMethodId, DeliveryMethodSeq are required.

INSERT INTO  ItemDeliveryMethods#TEMP (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'M', 1)

INSERT INTO  ItemDeliveryMethods#TEMP (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'S', 2)

INSERT INTO  ItemDeliveryMethods#TEMP (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'F', 3)

INSERT INTO   ItemDeliveryMethods SELECT ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq FROM ItemDeliveryMethods#TEMP

Update

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

UPDATE ItemDeliveryMethods SET DeliveryMethodId = 'M', DeliveryMethodSeq = 1 WHERE ItemCode = 'MD001' AND LotNumber = '9808450'

Batch Update

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

INSERT INTO  ItemDeliveryMethods#TEMP  (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'M', 1)

INSERT INTO  ItemDeliveryMethods#TEMP  (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'S', 2)

INSERT INTO  ItemDeliveryMethods#TEMP  (ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq) VALUES ('MD001', '9808450', 'F', 3)

UPDATE ItemDeliveryMethods SET ( ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq ) SELECT  ItemCode, LotNumber, DeliveryMethodId, DeliveryMethodSeq  FROM ItemDeliveryMethods#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.
DeliveryMethodId [KEY]	String	False		Delivery method id.
DeliveryMethodSeq	String	False		Delivery method sequence.
DeliveryMethodName	String	False		Delivery method name.
ShopId	String	False		Store account.