ODBC Driver for au PAY Market

Build 23.0.8839

ItemOptionComissions

Retrieve information related to item option commissions.

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

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

Columns

Name Type References Description
ItemCode [KEY] String

Items.ItemCode

Product code.
LotNumber Long

Items.LotNumber

Lot number.
ItemOptionCommissionSeq [KEY] String Item option commission sequence.
ItemOptionCommissionTitle String Item option commission title.
ItemOptionCommissionNote String Item option commission note.
ShopId String Store account.

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