C

STRTOVAL

N

N

Converts the data indicated in the operand 1 character type in numeric. Character type data, or string, can be a file type mnemonic, reserved or a constant. To identify the decimals, use dot (12.5). If there is comma character (,), as decimal separator, this is not considered.  In operand 2, the number of decimals to return is indicated. If n number is indicated in this field, a full number is returned.

N

VALTOSTR

N

C

Converts data indicated in operand 1 numeric type (file type, reserved or constant) in a character or string. The dot is used (.) as a separator in the decimals. In operand 2, the size of the character that is returned must be indicated, considering the decimal dot in a characters account.  For example: 12.45 has the size of 5. If it is not indicated, or the indicated size is smaller, the exact value converted in string is returned. If the sizer is bigger, it is filled out by using zeros on the left.

F

GET_MONEDA

Número Moneda

N

It returns the rate value corresponding to determined date and requested currency. In the Financials, the currencies are identified with numbers that are defined to each customer. For example: 1 for local currency; 2 for Dollars.

Example 1: If March 21st, 2012 corresponds to 39.12 Pesos Dominican Republic X Dollars, and this is currency 3. The worker salary is 1000 USD. To obtain salary in Pesos.

Example 2:

If a bonus of 500 USD is granted to the employee, calculated with end date of the Period, you get the bonus in Pesos.

YEAR

F

N

Returns a determined date year:

Month

F

N

Returns a determined date month:

Day

F

N

Returns a determined date day:

DIA_SEMANA

F

N

Returns the week day a determined date considering 1=Sunday and 7=Saturday

MUEVE

N, F, C, L

N, F, C, L

Operator MUEVE allocates the content of the data in mnemonic where the result is found.

CONVIERTE_FECHA

Dato {AAAAMMDD}

F

It is used to arrange dates. For example, to obtain birth date, take the mnemonic year of the start date of the period and the month and day of the hiring date. To obtain the date in format yyyymmdd, multiply year by 10000 + month * 100 + day. To apply the CONVIERTE_FECHA, there will be a date type mnemonic that can be kept, compared, summed or subtracted as date.

Example: Pay 12 days of vacation premium for all the employees, if birth date is between start and end date of the period. If Period is 01/01/2009 to 01/15/2009 and the hiring date is 01/05/2004

Start day

SUMA_DIAS

End day

N

There are three ways to capture the incidences: Incidences per Employee, Incidences per Payroll Item and Extra Time. This last way, generally, occupies the extra time, that is the reason of its denomination, and it enables capturing the incidences day by day, considering a record per week.

Data are captured from day 1 to 7, that corresponds to the week days, day 1 is the first day of the week for the company. Irrespective of the capture per each day in the time field, the total captured is accrued in the 7 days.

With this operator, the incidences of each day or a range of days are read. It is occupied not to perform the calculation of each day, repeating the same seven times. Therefore, a cycle together with the operator SI_MENOR can be used.

For example: Determine the double or triple extra times that can be integrated, saved or exempt, considering until 3 hours x integrated days and until 3 days per week. Until 9 double and the remained ones tripled. Exemption of 50% until 5 SMG per week, the remaining ones saved. For this, each week is captured in one incidence record per day.

<Valor a Filtrar>

<VAZIO>

FILTRO_MOVLI

<Campo SRV>

<lista verbas>

<VAZIO>

Operator FILTRO_MOVLI aims at performing a pre filter by using, as reference, the payroll items catalog fields. It will work together with the operator SUMA_MOVLI, where the table Payroll Transactions (SRC) is filter per payroll items (RC_PD).

Use of operator FILTRO_MOVLI with SUMA_MOVLI only works if there are payroll values previously calculated in the Payroll Transactions (SRC). Several FILTRO_MOVLI can be added and they will connect to an AND.

If the SUMA_MOVLI does not have data in the first or second expression, it means filter indicated in FILTRO_MOVLI must be considered.

Example 01: just with a filter inFILTRO_MOVLI

Example 02: just with a filter in SUMA_MOVLI

Example 03: just with a filter in SUMA_MOVLI and taking the value 1 or S as standard

Example 04: just with a filter in FILTRO_MOVLI and searching several values

Example 05: search different values of the same field.

Content

SUMA_MOVLI

SRV Mnemonic or

BASE_PENSIÓN or

Payroll Items List

N

The SUMA_MOVLI operator is available and allows the calculation through its formula (adding/subtracting) of payment values already calculated in Monthly Transactions (table SRC), according to the selected list of payments. It also allows the calculation for beneficiaries according to definition of the BASE_PENSION operator.

As default, the values (RC_VALOR) are obtained from the indicated list; however, you need to obtain the total of T=Time or D=Days must be indicated in the reserved mnemonic TP_SUMA_MOVLI.

The position for the table of beneficiaries must be carried out with operator SUMA_MOVLI and reserved Mnemonic BASE_PENSION, identified in the second expression of formula used.

It is also possible to use the SUMA_MOVLI operator with a Mnemonic that identifies an incidence field from table SRV, for instance, RV_PENSAO. Therefore, all payroll items with the value of this field equal to Yes, to affect:

Another possibility is to directly use values in the formula's expression. They must be registered payment codes in table SRV, in the Code field (RV_COD).

Example:

Sums the payroll items values calculated to this moment, according to the selected payroll items list. Follows the payroll item type, that is, if it is Collections or Collection Base, it will be summed up; if it is Deduction or Deduction Base, it will be subtracted.

Example 1: Mnemonic CONISR is associated to the table SRV=Payroll Items and the field RV_IR=ISR

“2”        SUMA_MOVLI        CONISR        NAUX_01

Example 2: Mnemonic CONSDO is associated to the table SRV=Payroll Items and the field RV_INCORP

In case you want to obtain the incorporated days to the salary, to determine the days to be paid.

ie_total_con

<critério>

N

IE_TOTAL_EMP

<critério>

N

These operators are used together with an alphanumeric table called Criterion, that has a key and a description. A criterion is attributed to each employee.

IE_TOTAL_CON gets the sum of the values of the month that is processed (RCH_MES, RCH_ANO), the payroll item that is calculated and all employees that follow the indicated <criterion> .

IE_TOTAL_EMP gets the Total of Employees that, in the month that is processed (RCH_MES, RCH_ANO), had value in the payroll item that is calculated, and follow the indicated <criterion> .

Example: Sum the month state tax base, all employees with criterion 004. From this base, subtract 8 monthly minimum salaries, considering the factor 30.5. From this result, divide between the original base to obtain a factor. The State Tax is obtained by summing up the month state tax base of the employee and by multiplying by the factor (State Tax Calculation Script of Querétar, Mexico).