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.

For example, the following queries are processed server side:

SELECT * FROM InventoryVerticalChoices WHERE ItemCode LIKE 'CD001'

SELECT * FROM InventoryVerticalChoices WHERE LotNumber  = 1234455 AND ShopId = '123'

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an unfiltered data to be pushed.

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.