Entity AccrualItem

Description of Entity AccrualItem

An Accrual item requires substantial set up in many different areas.
It is computed in the following way:
Accrual Item amount = Accrual Item Basis Formula amount x Accrual Method formula amount

To setup, you only need 2 items: Accrual Item and Accrual Item Method.
If your accrual item is based on the payroll module, you will need to run the payroll (for the month) before creating the accrual records.


List of all Dependencies of the Entity AccrualItem

Name

Code

Class Name

Relation_1153381

Relation_1153381

Reference

Relation_1139152

Relation_1139152

Reference

Relation_1130080

Relation_1130080

Reference

Relation_1114569

Relation_1114569

Reference

Relation_1104278

Relation_1104278

Reference

Relation_1104259

Relation_1104259

Reference

Relation_1124832

Relation_1124832

Reference

Relation_1104194

Relation_1104194

Reference


List of Attributes of the Entity AccrualItem

Name

Code

Accrual Item ID

AccrItemId

Description

AccrItemDesc

Module

AccrModule

Type

AccrType

Field

AccrFieldId

AccrOnAccrLevel

AccrOnAccrLevel

Accrual By

AccrOption

AccrDLLName

AccrDLLName

Payout Item

IsPayoutItem

CustBoolean

CustBoolean


Entity Attribute Accrual Item ID of the Entity AccrualItem

Card of Attribute Accrual Item ID of the Entity AccrualItem

Name

Accrual Item ID

Code

AccrItemId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Accrual Item ID of the Entity AccrualItem

Shows the identity of the accrual item. It is also the primary key for the AccrualItem table.


Entity Attribute Description of the Entity AccrualItem

Card of Attribute Description of the Entity AccrualItem

Name

Description

Code

AccrItemDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity AccrualItem

Stores the description or full name for the accrual item.
Example: Accrued Annual Leave


Entity Attribute Module of the Entity AccrualItem

Card of Attribute Module of the Entity AccrualItem

Name

Module

Code

AccrModule

Data Type

char(20)

Mandatory

No


Description of Attribute Module of the Entity AccrualItem

Shows the module for the accrual item.
Example: Payroll / Leave etc


Entity Attribute Type of the Entity AccrualItem

Card of Attribute Type of the Entity AccrualItem

Name

Type

Code

AccrType

Data Type

char(20)

Mandatory

No


Description of Attribute Type of the Entity AccrualItem

Shows the type of the accrual item.
Example: Pay Record / Leave type etc


Entity Attribute Field of the Entity AccrualItem

Card of Attribute Field of the Entity AccrualItem

Name

Field

Code

AccrFieldId

Data Type

char(20)

Mandatory

No


Description of Attribute Field of the Entity AccrualItem

Shows the field of the accrual item.
Example: Annual


Entity Attribute AccrOnAccrLevel of the Entity AccrualItem

Card of Attribute AccrOnAccrLevel of the Entity AccrualItem

Name

AccrOnAccrLevel

Code

AccrOnAccrLevel

Data Type

integer

Mandatory

No


Description of Attribute AccrOnAccrLevel of the Entity AccrualItem

Shows the level of the accrual.


Entity Attribute Accrual By of the Entity AccrualItem

Card of Attribute Accrual By of the Entity AccrualItem

Name

Accrual By

Code

AccrOption

Data Type

smallint

Mandatory

No


Description of Attribute Accrual By of the Entity AccrualItem

Shows the option for the accrual.
Example:
Monthly - To compute the accrual every month
User Defined - To compute the accrual at specific timings
Custom Module - A customizable module when the accrual algorithm does not fit into the specific timings. Upon installation and customization, the DLL file will pop-up for selection


Entity Attribute AccrDLLName of the Entity AccrualItem

Card of Attribute AccrDLLName of the Entity AccrualItem

Name

AccrDLLName

Code

AccrDLLName

Data Type

char(100)

Mandatory

No


Description of Attribute AccrDLLName of the Entity AccrualItem

The Dynamic Link Library (dll) name, also the file extension name.
Example: SingaporeLaserPayslip.dll


Entity Attribute Payout Item of the Entity AccrualItem

Card of Attribute Payout Item of the Entity AccrualItem

Name

Payout Item

Code

IsPayoutItem

Data Type

smallint

Mandatory

No


Description of Attribute Payout Item of the Entity AccrualItem

Shows if the record is a payout item, in a form of a checkbox.


Entity Attribute CustBoolean of the Entity AccrualItem

Card of Attribute CustBoolean of the Entity AccrualItem

Name

CustBoolean

Code

CustBoolean

Data Type

smallint

Mandatory

No


Description of Attribute CustBoolean of the Entity AccrualItem

Enables the customer to customize the section. It comes in a form of a checkbox. The customer can create a questionnaire and have the option to either check or uncheck the box. Ticking the box will show “1” in the database while not checking the box will show “0”.