Retrieve and update information related to item images.

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

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

Insert

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

INSERT INTO ItemImages (ItemCode, LotNumber, ImageName, ImageSeq) VALUES ('MD001', '9808450', 'M', 1)

Batch Insert

All columns can be specified. ItemCode, ImageSeq are required.

INSERT INTO  ItemImages#TEMP  (ItemCode, LotNumber, ImageName, ImageSeq) VALUES ('MD001', '9808450', 'M', 1) 

INSERT INTO  ItemImages#TEMP  (ItemCode, LotNumber, ImageName, ImageSeq) VALUES ('MD001', '9808450', 'S', 2)

INSERT INTO  ItemImages#TEMP  (ItemCode, LotNumber, ImageName, ImageSeq) VALUES ('MD001', '9808450', 'F', 3) 

INSERT INTO   ItemImages  SELECT ItemCode, LotNumber, ImageId, ImageSeq FROM ItemImages#TEMP 

Update

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

UPDATE ItemImages SET ImageName = 'M', ImageSeq = 1 WHERE ItemCode = 'MD001' AND LotNumber = '9808450'

Batch Update

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

INSERT INTO  ItemImages#TEMP  (ItemCode, LotNumber, ImageName, ImageSeq) VALUES ('MD001', '9808450', 'M', 1) 

INSERT INTO  ItemImages#TEMP  (ItemCode, LotNumber, ImageName, ImageSeq) VALUES ('MD001', '9808450', 'S', 2)

INSERT INTO  ItemImages#TEMP  (ItemCode, LotNumber, ImageName, ImageSeq) VALUES ('MD001', '9808450', 'F', 3) 

UPDATE ItemImages SET ( ItemCode, LotNumber, ImageName, ImageSeq ) SELECT  ItemCode, LotNumber, ImageName, ImageSeq  FROM ItemImages#TEMP 

Delete

Delete is not supported for this table

Columns

Name	Type	ReadOnly	References	Description
LotNumber	Long	False	Items.LotNumber	Lot number.
ItemCode [KEY]	String	False	Items.ItemCode	Product code.
ImageSeq [KEY]	String	False		Product image order.
ImageUrl	String	False		Product image URL.
ImageName	String	False		Product image name.
ShopId	String	False		Store account.