This table will contain the different ranges for each FormulaId and each range can has its own set of formula.

C1 - C5 are the constant
K1 - K10 are the keywords where the values will be supplied by the system.
U1 - U5 are the userdefined keywords where the user will supply the values.

Shows the formula on what leave / deduction / allowance etc, the employee has taken. This is the primary key for the Formula table.
Example: ANL (Annual leave) / Deduction of Sick leave / HOL (Paid Holiday)

Shows the identity of the formula range. This holds the primary key for the FormulaRange table.

Shows the maximum range.

Shows the minimum range.

Shows the formula for the entity.

Shows a first constant for the record.

Shows a second constant for the record.

Shows a third constant for the record.

Shows a forth constant for the record.

Shows a fifth constant for the record.

Show the first selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Show the second selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Show the third selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Show the forth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Show the fifth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Show the sixth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Show the seventh selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Show the eighth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Show the ninth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Show the tenth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc

Shows the first user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.

Shows the second user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.

Shows the third user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.

Shows the forth user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.

Shows the fifth user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.

Shows the first selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: ANLP (Annual Leave Pay)

Shows the second selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: BACK (Back Pay of Basic Increment)

Shows the third selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: SICK Leave Deduct (Deduction of Sick Leave)

Shows the forth selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: EUCF (Eurasian Community Fund)

Shows the fifth selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: ANL (Paid Annual Leave Pay)

Shows the sixth selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: PUBH (Public Holiday Pay)

Shows the seventh selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: Transport (Transport Allowance)

Shows the eighth selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: NOL_A (Wage Payment in Lieu Of Notice)

Shows the ninth selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: MAT (Paid Maternity Leave)

Shows the tenth selected pay element for generating the formula. Existing pay elements and the ones you have created are available here.
Example: YMF (Yayasan Mendaki Fund)

Shows the first selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Bonus Code

Shows the second selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Commission Code

Shows the third selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Director Fee Code

Shows the forth selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Education Code

Shows the fifth selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Gross Salary Code

Shows the sixth selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Loan Code

Shows the seventh selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Meal Allowance

Shows the eighth selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Non Taxable Code

Shows the ninth selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Pension Code

Shows the tenth selected property for generating the formula. These are the properties of pay elements. Use this with pay elements.
Example: Transport Code