Configure LITERATURE Field Type

You can configure a field ID as LITERATURE field type. This field type enables the Literature menu to open the Literature browser from menu. With this browser you can search literature. To configure the new field ID as LITERATURE field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:

Table 1-14 Configurations for Field Type LITERATURE

Column Sample Value Description

ENTERPRISE_ID

3

Current Enterprise ID

FIELD_TYPE_ID

8

LITERATURE

FIELD_ID

30000000

Field ID entered in the table CMN_FIELDS.

KEY

NULL

Enter NULL.

VALUE

1

Enter the Return Type ID as 1.

This is a mandatory column.

Note:

You can also refer to existing field GENERAL > Literature > Literature, (CMN_FIELDS.Field_ID - 202810741) of INGREDIENT field type.