ODBC Driver for au PAY Market

Build 23.0.8839

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.
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'

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839