ItemSpecifications

Retrieve and update information related to item specifications.

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, SpecificationSeq are required for an insert.

INSERT INTO ItemSpecifications (ItemCode, LotNumber, SpecificationName, Specificationseq) VALUES ('MD001', '9808450', 'M', 1)

Batch Insert

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

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'TESTtt  1', 'val1', 1)

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'i dyti ', 'val2', 2)

;

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'er', 'val3', 3)

INSERT INTO   ItemSpecifications  SELECT ItemCode, LotNumber, ImageId, SpecificationSeq FROM ItemSpecifications#TEMP

Update

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

UPDATE ItemSpecifications SET SpecificationName = 'M', Specificationseq = 1 WHERE ItemCode = 'MD001' AND LotNumber = 9808450

Batch Update

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

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'TESTtt  1', 'val1', 1)

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'i dyti ', 'val2', 2)

;

INSERT INTO  ItemSpecifications#TEMP  (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq) VALUES ('MD001', '9808450', 'er', 'val3', 3)

UPDATE ItemSpecifications SET (ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq ) SELECT  ItemCode, LotNumber, SpecificationName, SpecificationValue, SpecificationSeq  FROM ItemSpecifications#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.
SpecificationTitle	String	True		Specification title.
SpecificationSeq [KEY]	String	False		Specification item sequence.
SpecificationName	String	False		Specification name.
SpecificationValue	String	False		Specification value.
ShopId	String	False		Store account.

Tableau Connector for au PAY Market