Configure INGREDIENT Field Type
You can configure a field ID as INGREDIENT field type. This field type enables the Ingredient menu to open Ingredient Browser. With this browser you can search ingredient. To configure the new field ID as INGREDIENT field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-11 Configurations for Field Type INGREDIENT
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
6 |
INGREDIENT |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
INGREDIENT |
Enter the Return Type text. This is an optional column. |
VALUE |
1 |
Enter the Return Type ID as 1. This is a mandatory column. |
Note:
You can also refer to existing field PRODUCTS > Product Information > Ingredient, (CMN_FIELDS.Field_ID - 203810990) of INGREDIENT field type.
Parent topic: Configure CMN_FIELD_CONFIGURATION Table