ItemOptionComissions
Retrieve information related to item option commissions.
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.
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. |