Sage EasyPay Data Model

Entity VnC45Record

Description of Entity VnC45Record

This entity is for the Vietnam Payroll.

List of all Dependencies of the Entity VnC45Record

Relation_1031859

Relation_1031859

Reference

Relation_1075250

Relation_1075250

Reference

Relation_1085214

Relation_1085214

Reference

Relation_1085217

Relation_1085217

Reference

List of Attributes of the Entity VnC45Record

EE_SIContribution

EE_SIContribution

ER_SIContribution

ER_SIContribution

Entity Attribute EmployeeSysId of the Entity VnC45Record

Card of Attribute EmployeeSysId of the Entity VnC45Record

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity VnC45Record

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

Entity Attribute VnC45SGSPGenId of the Entity VnC45Record

Card of Attribute VnC45SGSPGenId of the Entity VnC45Record

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

Entity Attribute SIWage of the Entity VnC45Record

Card of Attribute SIWage of the Entity VnC45Record

Name	SIWage
Code	SIWage
Data Type	double
Mandatory	No

Entity Attribute EE_SIContribution of the Entity VnC45Record

Card of Attribute EE_SIContribution of the Entity VnC45Record

Name	EE_SIContribution
Code	EE_SIContribution
Data Type	double
Mandatory	No

Entity Attribute ER_SIContribution of the Entity VnC45Record

Card of Attribute ER_SIContribution of the Entity VnC45Record

Name	ER_SIContribution
Code	ER_SIContribution
Data Type	double
Mandatory	No

Entity Attribute CapSIWage of the Entity VnC45Record

Card of Attribute CapSIWage of the Entity VnC45Record

Name	CapSIWage
Code	CapSIWage
Data Type	double
Mandatory	No

Entity Attribute SIWageF of the Entity VnC45Record

Card of Attribute SIWageF of the Entity VnC45Record

Name	SIWageF
Code	SIWageF
Data Type	double
Mandatory	No