Sage EasyPay Data Model

Entity WageProperty

Description of Entity WageProperty

The wage property is the type of wage you have.
Example: Additional Wage / Gross Wage / Ordinary Wage etc

List of all Dependencies of the Entity WageProperty

Reference

List of Attributes of the Entity WageProperty

Wage Property Used

WagePropertyUsed

Entity Attribute KeyWord ID of the Entity WageProperty

Card of Attribute KeyWord ID of the Entity WageProperty

Name	KeyWord ID
Code	KeyWordId
Data Type	char(20)
Mandatory	Yes

Description of Attribute KeyWord ID of the Entity WageProperty

Shows the identity of the keyword. This also acts as a primary key for the KeyWord table.
Example: Allowance / Basic Rate / Decrement etc

Entity Attribute Wage ID of the Entity WageProperty

Card of Attribute Wage ID of the Entity WageProperty

Name	Wage ID
Code	WageId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Wage ID of the Entity WageProperty

Shows the identity of the wage. This is the primary key for the WageProperty table.
Example: OrdWage / AddWage / TotalWage etc

Entity Attribute Wage Property Used of the Entity WageProperty

Card of Attribute Wage Property Used of the Entity WageProperty

Name	Wage Property Used
Code	WagePropertyUsed
Data Type	smallint
Mandatory	No

Description of Attribute Wage Property Used of the Entity WageProperty

Shows which wage property it is using.