Retrieve information related to item option commission values.

Select

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

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