|
To create formula based elements. The definition of these elements varies and depends on where you have launched the Formula Generator from. The Formula Generator may appear slightly different as not all its features are applicable to all modules in Sage EasyPay, however the overall concept of creating and modifying a formula is the same. The advantage of using formula based elements is the flexibility as you can use pre-defined system variables alongside variables of your own definition. The formula is similar to algebraic expressions. Each expression is made up of variables and operators and/or values. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the formula on what leave / deduction / allowance etc, the employee has taken. This is the primary key for the Formula table. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Shows if the formula is working, then it will display records having this attribute as true. This is to enable easy selection and to prevent any wrong calculations from happening. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Shows the preprocessed formula. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Shows the recurring formula. Otherwise, "0". |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
States which category the formula falls under. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
This is the sub category for FormulaCategory. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores what type of formula being used. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Holds the range basis for the formula. It is used for Maximum and Minimum in the FormulaRange Entity. |
|
Name |
|
|
Code |
|
|
Data Type |
char(255) |
|
Mandatory |
No |
|
Shows the full description of the formula. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the identity of the exchange rate for the formula. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows which stage the formula is at. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the rank of the formula. |
|
|
|