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