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.
Parent topic: Configure CMN_FIELD_CONFIGURATION Table