Sage EasyPay Data Model

Entity VnC04Record

Description of Entity VnC04Record

This entity is for the Vietnam Payroll.

List of all Dependencies of the Entity VnC04Record

Relation_1036887

Relation_1036887

Reference

Relation_1075249

Relation_1075249

Reference

Relation_1085215

Relation_1085215

Reference

Relation_1085216

Relation_1085216

Reference

List of Attributes of the Entity VnC04Record

Entity Attribute EmployeeSysId of the Entity VnC04Record

Card of Attribute EmployeeSysId of the Entity VnC04Record

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity VnC04Record

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.

Entity Attribute VnC04SGSPGenId of the Entity VnC04Record

Card of Attribute VnC04SGSPGenId of the Entity VnC04Record

Name	VnC04SGSPGenId
Code	VnC04SGSPGenId
Data Type	char(30)
Mandatory	Yes

Entity Attribute VnC04InPeriod of the Entity VnC04Record

Card of Attribute VnC04InPeriod of the Entity VnC04Record

Name	VnC04InPeriod
Code	VnC04InPeriod
Data Type	integer
Mandatory	No

Entity Attribute VnC04InYear of the Entity VnC04Record

Card of Attribute VnC04InYear of the Entity VnC04Record

Name	VnC04InYear
Code	VnC04InYear
Data Type	integer
Mandatory	No

Entity Attribute SILeaveTypeId of the Entity VnC04Record

Card of Attribute SILeaveTypeId of the Entity VnC04Record

Name	SILeaveTypeId
Code	SILeaveTypeId
Data Type	char(20)
Mandatory	No

Entity Attribute RateOfContribution of the Entity VnC04Record

Card of Attribute RateOfContribution of the Entity VnC04Record

Name	RateOfContribution
Code	RateOfContribution
Data Type	double
Mandatory	No

Entity Attribute SIWage of the Entity VnC04Record

Card of Attribute SIWage of the Entity VnC04Record

Name	SIWage
Code	SIWage
Data Type	double
Mandatory	No

Entity Attribute VnAllowancePerDay of the Entity VnC04Record

Card of Attribute VnAllowancePerDay of the Entity VnC04Record

Name	VnAllowancePerDay
Code	VnAllowancePerDay
Data Type	double
Mandatory	No

Entity Attribute VnC04LeaveDays of the Entity VnC04Record

Card of Attribute VnC04LeaveDays of the Entity VnC04Record

Name	VnC04LeaveDays
Code	VnC04LeaveDays
Data Type	double
Mandatory	No

Entity Attribute VnC04AccuDays of the Entity VnC04Record

Card of Attribute VnC04AccuDays of the Entity VnC04Record

Name	VnC04AccuDays
Code	VnC04AccuDays
Data Type	double
Mandatory	No

Entity Attribute VnC04Allowance of the Entity VnC04Record

Card of Attribute VnC04Allowance of the Entity VnC04Record

Name	VnC04Allowance
Code	VnC04Allowance
Data Type	double
Mandatory	No