Configure GENERIC Field Type

You can configure a field ID as GENERIC field type. This field type enables the Generic Name menu to open the Generic Name browser from menu. With this browser you can search and select generic name of a product. To configure the new field ID as GENERIC field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:

Table 1-24 Configurations for Field Type GENERIC

Column Sample Value Description

ENTERPRISE_ID

3

Current Enterprise ID

FIELD_TYPE_ID

16

GENERIC

FIELD_ID

30000000

Field ID entered in the table CMN_FIELDS.

KEY

NULL

Enter key as NUL

VALUE

NULL

Enter value as NULL

Note:

You can also refer to existing field PRODUCTS > Product Information > Generic Name, (CMN_FIELDS.Field_ID - 203650842) of GENERIC field type.