Selection rule

On this window is selected the criteria for selection of the calculation code that is processed. After selecting the option you want, click on the ' OK ' button to dispatch the Server service to run. The available options are:

1-Valid on Scheduled Date- will use the calculation code whose calculation is 11-Monthly Calculation, and whose execution date is within the period of calculation sheet active. The SELECT command to obtain the calculation code would be:

SELECT CODE FROM R044CAL WHERE TIPCAL = 11 AND INICMP <= {Date of execution} AND FIMCMP> = {Date of execution}

2-immediately before- will use the calculation code whose calculation is 11-Monthly Calculation, and whose term is immediately below sheet date of implementation. The SELECT command to obtain the calculation code would be:

CMPATUAL = SELECT INICMP FROM R044CAL WHERE TIPCAL = 11 AND INICMP <= {Date of execution} AND FIMCMP> = {Date of execution}

SELECT CODCAL FROM R044CAL WHERE TIPCAL = 11 AND INICMP = (SELECT MAX (INICMP) FROM R044CAL WHERE TIPCAL = 11 AND < INICMP {CMPATUAL})

3-Follows- will use the calculation code whose calculation is 11-Monthly Calculation, and whose period of leaf is immediately higher than the date of implementation. The SELECT command to obtain the calculation code would be:

CMPATUAL = SELECT INICMP FROM R044CAL WHERE TIPCAL = 11 AND INICMP <= {Date of execution} AND FIMCMP> = {Date of execution}

SELECT CODE FROM R044CAL WHERE TIPCAL = 11 AND INICMP = (SELECT MIN (INICMP) FROM R044CAL WHERE TIPCAL = 11 AND INICMP> {CMPATUAL})