Configure COMPANY_DRUG Field Type
You can configure a field ID as COMPANY_DRUG field type. This field type enables the Company Drug menu to open the Product browser. With this browser you can search the following:
- Ingredient
- Product Family
- Product Name
- Trade Name
To configure the new field ID as COMPANY_DRUG field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-9 Configurations for Field Type COMPANY_DRUG
| Column | Sample Value | Description |
|---|---|---|
|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
|
FIELD_TYPE_ID |
5 |
COMPANY_DRUG |
|
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
|
KEY |
PRODUCT_NAME |
Enter the Return Type text. See Table 1-10. This is a mandatory column. |
|
VALUE |
1 |
Enter the Return Type ID. See Table 1-10. This is a mandatory column. |
For more information, see: