6.5 Configuring the Due Date Indicator Period

This parameter specifies the Near Due days set for CTR and Exemption. This parameter is used to control at which point the UI will provide a visual indicator that the due date is getting close.The parameter should be set to Y.

The following table describes the attributes which must be configured for Due Date Indicators parameters.

Table 6-3 Configuring the Attributes for Due Date Indicators Parameters

Attribute	Description	Column Name
CTR_NEAR	This attribute specifies the Near Due days for CTR. This attribute accepts only natural numbers.	attr_4_value_tx
EXM_NEAR	This attribute specifies the Near Due days for Exemption. This attribute accepts only natural numbers.	attr_5_value_tx

To modify the Near Due days parameter or its attribute, an update query must be executed in the MANTAS Schema of the Database with an appropriate user.

To update the Near Due days parameter to Y, execute the following query:

UPDATE kdd_install_param t SET t.param_value_tx = 'Y' WHERE t.param_id = 104

To update the CTR_NEAR attribute to 5 days, execute the following query:

UPDATE kdd_install_param t SET t.attr_4_value_tx ='5' WHERE t.param_id = 104