InventoryHorizontalChoices
Retrieve information related to inventory horizontal choices.
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 InventoryHorizontalChoices WHERE ItemCode LIKE 'CD001'
SELECT * FROM InventoryHorizontalChoices WHERE LotNumber = 1234455 AND ShopId = '123'
Insert
Insert is not supported from for this table
Update
au PAY Market allows updates for ChoicesHorizontalName column. ItemCode and ChoicesHorizontalCode are required.
UPDATE InventoryHorizontalChoices SET ChoicesHorizontalName = 'Mm' WHERE ItemCode = 'CD001' AND ChoicesHorizontalCode = 'M'
Batch Update
au PAY Market allows updates in batches for ChoicesHorizontalName. ItemCode and ChoicesHorizontalCode are required.
INSERT INTO InventoryHorizontalChoices#TEMP (ItemCode, ChoicesHorizontalCode, ChoicesHorizontalName) VALUES ('CD001', 'S', 'S')
INSERT INTO InventoryHorizontalChoices#TEMP (ItemCode, ChoicesHorizontalCode, ChoicesHorizontalName) VALUES ('CD001', 'M', 'M')
UPDATE InventoryHorizontalChoices SET (ItemCode, ChoicesHorizontalCode, ChoicesHorizontalName) SELECT ItemCode, ChoicesHorizontalCode, ChoicesHorizontalName FROM InventoryHorizontalChoices#TEMP
Delete
Delete is not supported for this table
Columns
Name | Type | ReadOnly | References | Description |
ItemCode [KEY] | String | False |
Inventory.ItemCode |
Product code. |
LotNumber | Long | False |
Inventory.LotNumber |
Lot number. |
ChoicesStockHorizontalItemName | String | False |
Choices by stock horizontal axis item name. | |
ChoicesHorizontalCode [KEY] | String | False |
Horizontal choice code. | |
ChoicesHorizontalName | String | False |
Horizontal choice name. | |
ChoicesHorizontalSeq | String | False |
Horizontal choice sequence. | |
ShopId | String | False |
Store account. |