ODBC Driver for au PAY Market

Build 23.0.8839

ItemOptionComissionValues

Retrieve information related to item option commission values.

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 ItemOptionComissionValues WHERE ItemCode LIKE '%CD00%'

SELECT * FROM ItemOptionComissionValues WHERE ItemCode = 'CD001' AND LotNumber = 123543 

Columns

Name Type References Description
LotNumber Long

ItemOptionComissions.LotNumber

Lot number.
ItemCode [KEY] String

ItemOptionComissions.ItemCode

Product code.
ItemOptionCommissionSeq [KEY] String

ItemOptionComissions.ItemOptionCommissionSeq

Item option commission sequence.
ItemOptionCommissionValSeq [KEY] String Item option commission value sequence.
ItemOptionCommissionVal String Item option commission value.
ItemOptionCommissionPrice Decimal Item option commission price.
ShopId String Store account.

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