ProductNameOptionGroups
Returns information related to product naming option groups and items.
Select
The 本製品 will use the GMO MakeShop API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- BrandCode column supports the = operator.
SELECT * FROM ProductNameOptionGroups WHERE BrandCode = 'CD12345'
Columns
| Name | Type | Description |
| BrandCode [KEY] | String | System product code. |
| NameOptionGroupId | Integer | Insert name group ID. |
| NameOptionGroupLabel | String | Insert name group name. |
| NameOptionGroupDescription | String | Insert name group description. |
| ItemId [KEY] | Integer | Item ID. |
| AdminItemName | String | Administrator item name. |
| DisplayItemName | String | Display item name. |
| IsRequired | String | Selection requirement - Y: Required input N: Optional input. |
| IsAlphabet | String | Alphabetical validation - Y: Can be input N: Can not be input. |
| IsNumber | String | Numerical validation - Y: Can be input N: Can not be input. |
| IsSymbol | String | Symbols |
| IsDoubleByte | String | Double byte character validation - Y: Can be input N: Can not be input. |
| RowMaxlength | Integer | Number of characters per line. |
| MaxRow | Integer | Number of lines. |
| MaxLength | Integer | Maximum number of characters. |