Entity AccrualLookupField

Description of Entity AccrualLookupField

This is where you select the fields for defining the formula on Item Basis. The fields are grouped by its module and type. Items selected here will be marked from K1 onwards. You can select up to 10 fields.


List of Attributes of the Entity AccrualLookupField

Name

Code

Module

AccrualModule

Type

AccrualType

Field

AccrualField

AccrualBasisAmt

AccrualBasisAmt

AccrIsSearchItem

AccrIsSearchItem

AccrualSQL

AccrualSQL

AccrualLKField

AccrualLKField

AccrualSelected1

AccrualSelected1

AccrualSelected2

AccrualSelected2


Entity Attribute Module of the Entity AccrualLookupField

Card of Attribute Module of the Entity AccrualLookupField

Name

Module

Code

AccrualModule

Data Type

char(20)

Mandatory

Yes


Description of Attribute Module of the Entity AccrualLookupField

Shows the accrual module for the lookup field. This is the primary key for the AccrualLookupField table.
Example: Payroll / Leave / Benefit etc


Entity Attribute Type of the Entity AccrualLookupField

Card of Attribute Type of the Entity AccrualLookupField

Name

Type

Code

AccrualType

Data Type

char(20)

Mandatory

Yes


Description of Attribute Type of the Entity AccrualLookupField

Shows the accrual type for the lookup field. This is the primary key for the AccrualLookupField table.
Example: System / AllowanceRecord / LeaveType etc


Entity Attribute Field of the Entity AccrualLookupField

Card of Attribute Field of the Entity AccrualLookupField

Name

Field

Code

AccrualField

Data Type

char(20)

Mandatory

Yes


Description of Attribute Field of the Entity AccrualLookupField

Shows the accrual field for the lookup field. This is the primary key for the AccrualLookupField table.
Example: Foreign Worker's Levy / Full basic rate / Employer CPF etc


Entity Attribute AccrualBasisAmt of the Entity AccrualLookupField

Card of Attribute AccrualBasisAmt of the Entity AccrualLookupField

Name

AccrualBasisAmt

Code

AccrualBasisAmt

Data Type

char(20)

Mandatory

Yes


Description of Attribute AccrualBasisAmt of the Entity AccrualLookupField

Shows the accrual basis amount for the lookup field. This is the primary key for the AccrualLookupField table.
Example: Rate / Amount / Frequency etc


Entity Attribute AccrIsSearchItem of the Entity AccrualLookupField

Card of Attribute AccrIsSearchItem of the Entity AccrualLookupField

Name

AccrIsSearchItem

Code

AccrIsSearchItem

Data Type

smallint

Mandatory

No


Description of Attribute AccrIsSearchItem of the Entity AccrualLookupField

Shows the accrual search item for the lookup field.


Entity Attribute AccrualSQL of the Entity AccrualLookupField

Card of Attribute AccrualSQL of the Entity AccrualLookupField

Name

AccrualSQL

Code

AccrualSQL

Data Type

char(255)

Mandatory

No


Description of Attribute AccrualSQL of the Entity AccrualLookupField

Shows the accrual SQL for the lookup field.
Example:
SELECT AccrItemId, AccrItemDesc
FROM AccrualItem


Entity Attribute AccrualLKField of the Entity AccrualLookupField

Card of Attribute AccrualLKField of the Entity AccrualLookupField

Name

AccrualLKField

Code

AccrualLKField

Data Type

char(50)

Mandatory

No


Description of Attribute AccrualLKField of the Entity AccrualLookupField

Shows the accrual field for the lookup field.


Entity Attribute AccrualSelected1 of the Entity AccrualLookupField

Card of Attribute AccrualSelected1 of the Entity AccrualLookupField

Name

AccrualSelected1

Code

AccrualSelected1

Data Type

char(100)

Mandatory

No


Description of Attribute AccrualSelected1 of the Entity AccrualLookupField

Shows the selected accrual for the lookup field.


Entity Attribute AccrualSelected2 of the Entity AccrualLookupField

Card of Attribute AccrualSelected2 of the Entity AccrualLookupField

Name

AccrualSelected2

Code

AccrualSelected2

Data Type

char(100)

Mandatory

No


Description of Attribute AccrualSelected2 of the Entity AccrualLookupField

Shows the selected accrual for the lookup field.