InventoryVerticalChoices
Retrieve information related to inventory vertical 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 InventoryVerticalChoices WHERE ItemCode LIKE 'CD001'
SELECT * FROM InventoryVerticalChoices WHERE LotNumber = 1234455 AND ShopId = '123'
Columns
Name | Type | References | Description |
LotNumber | Long |
Inventory.ItemCode | Lot number. |
ItemCode [KEY] | String |
Inventory.LotNumber | Product code. |
ChoicesStockVerticalItemName | String | Choices by stock vertical axis item name. | |
ChoicesVerticalCode [KEY] | String | Vertical choice code. | |
ChoicesVerticalName | String | Vertical choice name. | |
ChoicesVerticalSeq | String | Vertical choice sequesnce. | |
ShopId | String | Store account. |