ItemSpecifications
Retrieve and update information related to item specifications.
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 本製品.
- LotNumber, ShopId columns support the = operator.
- ItemCode column supports the LIKE operator.
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. |