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.