Configure BATCH_LOT_NO Field Type
You can configure a field ID as BATCH_LOT_NO field type. This field type enables the Batch Lot # menu to open the Batch Lot # Lookup browser from menu. With this browser you can search batch or lot number. To configure the new field ID as BATCH_LOT_NO field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-19 Configurations for Field Type BATCH_LOT_NO
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
12 |
BATCH_LOT_NO |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
NULL |
Enter Return type text as NULL. |
VALUE |
NULL |
Enter the Return Type ID as NULL. |
Note:
You can also refer to existing field PRODUCTS > Dosage Regimen > Batch/Lot #, (CMN_FIELDS.Field_ID - 201350479) of BATCH_LOT_NO field type.
Parent topic: Configure CMN_FIELD_CONFIGURATION Table