Sage EasyPay Data Model

Entity AnItemType

Description of Entity AnItemType

This entity generates the Statistics report. It shows the different item types and customizable fields for the item.

List of all Dependencies of the Entity AnItemType

Relation_718707

Relation_718707

Reference

Relation_718719

Relation_718719

Reference

List of Attributes of the Entity AnItemType

Anlys Item Type ID

AnlysItemTypeId

AnlysItemTypeDesc

Anlys Item Is System

AnlysItemIsSystem

AnlysItem1Field

AnlysItem1Field

AnlysItem2Field

AnlysItem2Field

AnlysItem3Field

AnlysItem3Field

AnlysItem4Field

AnlysItem4Field

AnlysItem5Field

AnlysItem5Field

Entity Attribute Anlys Item Type ID of the Entity AnItemType

Card of Attribute Anlys Item Type ID of the Entity AnItemType

Name	Anlys Item Type ID
Code	AnlysItemTypeId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Anlys Item Type ID of the Entity AnItemType

Shows the identity type of the analysis item. It also holds the primary key for the AnItemType table.
Example: OTRecord / AccrualRecord / LeaveSystem etc

Entity Attribute Description of the Entity AnItemType

Card of Attribute Description of the Entity AnItemType

Name	Description
Code	AnlysItemTypeDesc
Data Type	char(100)
Mandatory	No

Description of Attribute Description of the Entity AnItemType

Stores a description about the analysis item type.
Example: OT Record / Accrual Record / Leave System etc

Entity Attribute Anlys Item Is System of the Entity AnItemType

Card of Attribute Anlys Item Is System of the Entity AnItemType

Name	Anlys Item Is System
Code	AnlysItemIsSystem
Data Type	smallint
Mandatory	No

Description of Attribute Anlys Item Is System of the Entity AnItemType

Indicates if the item is a system or not, in a form of a checkbox.

Entity Attribute AnlysItem1Field of the Entity AnItemType

Card of Attribute AnlysItem1Field of the Entity AnItemType

Name	AnlysItem1Field
Code	AnlysItem1Field
Data Type	char(50)
Mandatory	No

Description of Attribute AnlysItem1Field of the Entity AnItemType

Shows the analysis item field.

Entity Attribute AnlysItem2Field of the Entity AnItemType

Card of Attribute AnlysItem2Field of the Entity AnItemType

Name	AnlysItem2Field
Code	AnlysItem2Field
Data Type	char(50)
Mandatory	No

Description of Attribute AnlysItem2Field of the Entity AnItemType

Shows the analysis item field.

Entity Attribute AnlysItem3Field of the Entity AnItemType

Card of Attribute AnlysItem3Field of the Entity AnItemType

Name	AnlysItem3Field
Code	AnlysItem3Field
Data Type	char(50)
Mandatory	No

Description of Attribute AnlysItem3Field of the Entity AnItemType

Shows the analysis item field.

Entity Attribute AnlysItem4Field of the Entity AnItemType

Card of Attribute AnlysItem4Field of the Entity AnItemType

Name	AnlysItem4Field
Code	AnlysItem4Field
Data Type	char(50)
Mandatory	No

Description of Attribute AnlysItem4Field of the Entity AnItemType

Shows the analysis item field.

Entity Attribute AnlysItem5Field of the Entity AnItemType

Card of Attribute AnlysItem5Field of the Entity AnItemType

Name	AnlysItem5Field
Code	AnlysItem5Field
Data Type	char(50)
Mandatory	No

Description of Attribute AnlysItem5Field of the Entity AnItemType

Shows the analysis item field.