ItemOptions
Retrieve and update information related to item options.
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 ItemOptions WHERE ItemCode LIKE '%CD00%'
SELECT * FROM ItemOptions WHERE ItemCode = 'CD001' AND LotNumber = 123543
Insert
All columns can be specified. ItemCode, ItemOptionSeq are required for an insert.
INSERT INTO ItemOptions (ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption) VALUES ('Code0001', '1', 'title1', 'option1')
Batch Insert
All columns can be specified. ItemCode, ItemOptionSeq are required.
INSERT INTO ItemOptions#TEMP (ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption) VALUES ('Code0001', '1', 'title1', 'option1')
INSERT INTO ItemOptions#TEMP (ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption) VALUES ('Code0001', '2', 'title2', 'option2')
INSERT INTO ItemOptions#TEMP (ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption) VALUES ('Code0001', '3', 'title7', 'option7')
INSERT INTO ItemOptions SELECT ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption FROM ItemOptions#TEMP
Update
au PAY Market allows updates for all columns. ItemCode, ItemOptionSeq are required.
UPDATE ItemOptions SET ItemOptionTitle = 'title1', ItemOption = 'Code0001' WHERE ItemCode = 'MD001' AND ItemOptionSeq = '1'
Batch Update
au PAY Market allows updates in batches for all columns. ItemCode, ItemOptionSeq are required.
INSERT INTO ItemOptions#TEMP (ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption) VALUES ('Code0001', '1', 'title1', 'option1')
INSERT INTO ItemOptions#TEMP (ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption) VALUES ('Code0001', '2', 'title2', 'option2')
INSERT INTO ItemOptions#TEMP (ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption) VALUES ('Code0001', '3', 'title7', 'option7')
UPDATE ItemOptions SET ( ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption ) SELECT ItemCode, ItemOptionSeq, ItemOptionTitle, ItemOption FROM ItemOptions#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. |
ItemOptionSeq [KEY] | String | False |
Item option squence. | |
ItemOptionTitle | String | False |
Item option title. | |
ItemOption | String | False |
Item option value. | |
ShopId | String | False |
Store account. |