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 

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