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 

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