Configure MINUTES_CALCULATOR Field Type
You can configure a field ID as MINUTES_CALCULATOR field type. This field type enables the Minutes Calculator menu to open the Duration Calculator Browser from menu. This browser allows you enter the time in hours, day, weeks, months, or year, and then converts the time to minutes/seconds. Alternatively, you can select duration band and value, if available. To configure the new field ID as MINUTES_CALCULATOR field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-12 Configurations for Field Type MINUTES_CALCULATOR
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
7 |
MINUTES_CALCULATOR |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
DVB_SEC |
Enter the Return Type text. See Table 1-13. This is a mandatory column. |
VALUE |
1 |
Enter the Return Type ID. See Table 1-13. This is a mandatory column. |
For more information, see:
- Supported Return Type Texts and IDs (Key/Value):
The Duration Calculator browser returns one the following texts as per the return type configured against the new field ID to the Advance Condition Editor page.
Parent topic: Configure CMN_FIELD_CONFIGURATION Table