Sage EasyPay Data Model

Entity SystemAttribute

Description of Entity SystemAttribute

The system attribute handles parameters and pose as data provided to a program.

List of all Dependencies of the Entity SystemAttribute

Relation_616149

Relation_616149

Reference

Relation_718698

Relation_718698

Reference

Relation_817398

Relation_817398

Reference

Relation_616130

Relation_616130

Reference

List of Attributes of the Entity SystemAttribute

SysUserdefinedName

SysUserdefinedName

SysSpecialAttribute

SysSpecialAttribute

Entity Attribute SysTableId of the Entity SystemAttribute

Card of Attribute SysTableId of the Entity SystemAttribute

Name	SysTableId
Code	SysTableId
Data Type	char(100)
Mandatory	Yes

Description of Attribute SysTableId of the Entity SystemAttribute

Shows the identity of the system table. It is also the primary key for the SystemTable entity.
Example: Country / Leave Policy / TMSShift etc

Entity Attribute SysAttributeId of the Entity SystemAttribute

Card of Attribute SysAttributeId of the Entity SystemAttribute

Name	SysAttributeId
Code	SysAttributeId
Data Type	char(100)
Mandatory	Yes

Description of Attribute SysAttributeId of the Entity SystemAttribute

Shows the identity of the system attribute. It is the primary key for the SystemAttribute table.
Example: AdjType / AlertIsSummarized / AllowanceSGSPGenId etc

Entity Attribute SysUserdefinedName of the Entity SystemAttribute

Card of Attribute SysUserdefinedName of the Entity SystemAttribute

Name	SysUserdefinedName
Code	SysUserdefinedName
Data Type	char(100)
Mandatory	No

Description of Attribute SysUserdefinedName of the Entity SystemAttribute

A user defined name for the system attribute.
Example: Adjustment Type / Summary Listing / AllowanceSGSPGenId etc

Entity Attribute SysSpecialAttribute of the Entity SystemAttribute

Card of Attribute SysSpecialAttribute of the Entity SystemAttribute

Name	SysSpecialAttribute
Code	SysSpecialAttribute
Data Type	smallint
Mandatory	No

Description of Attribute SysSpecialAttribute of the Entity SystemAttribute

Indicates if the system table is a special attribute, in a form of a checkbox.

Entity Attribute SysParameter1 of the Entity SystemAttribute

Card of Attribute SysParameter1 of the Entity SystemAttribute

Name	SysParameter1
Code	SysParameter1
Data Type	char(250)
Mandatory	No

Description of Attribute SysParameter1 of the Entity SystemAttribute

Shows the parameter for the system attribute.

Entity Attribute SysParameter2 of the Entity SystemAttribute

Card of Attribute SysParameter2 of the Entity SystemAttribute

Name	SysParameter2
Code	SysParameter2
Data Type	char(250)
Mandatory	No

Description of Attribute SysParameter2 of the Entity SystemAttribute

Shows the parameter for the system attribute.

Entity Attribute SysParameter3 of the Entity SystemAttribute

Card of Attribute SysParameter3 of the Entity SystemAttribute

Name	SysParameter3
Code	SysParameter3
Data Type	char(250)
Mandatory	No

Description of Attribute SysParameter3 of the Entity SystemAttribute

Shows the parameter for the system attribute.

Entity Attribute SysParameter4 of the Entity SystemAttribute

Card of Attribute SysParameter4 of the Entity SystemAttribute

Name	SysParameter4
Code	SysParameter4
Data Type	char(250)
Mandatory	No

Description of Attribute SysParameter4 of the Entity SystemAttribute

Shows the parameter for the system attribute.

Entity Attribute SysParameter5 of the Entity SystemAttribute

Card of Attribute SysParameter5 of the Entity SystemAttribute

Name	SysParameter5
Code	SysParameter5
Data Type	char(250)
Mandatory	No

Description of Attribute SysParameter5 of the Entity SystemAttribute

Shows the parameter for the system attribute.