Sage EasyPay Data Model

Entity VnC47aRecord

Description of Entity VnC47aRecord

This entity is for the Vietnam Payroll.

List of all Dependencies of the Entity VnC47aRecord

Relation_1031887

Relation_1031887

Reference

Relation_1075252

Relation_1075252

Reference

Relation_1085212

Relation_1085212

Reference

Relation_1085219

Relation_1085219

Reference

List of Attributes of the Entity VnC47aRecord

VnC47aSGSPGenId

VnC47aSGSPGenId

VnC47aSubmitDate

VnC47aSubmitDate

SIDeductionRate

SIDeductionRate

HIDeductionRate

HIDeductionRate

EE_SIContribution

EE_SIContribution

ER_SIContribution

ER_SIContribution

EE_HIContribution

EE_HIContribution

ER_HIContribution

ER_HIContribution

VnC47aIncrement

VnC47aIncrement

PreviousSIWageF

PreviousSIWageF

Entity Attribute EmployeeSysId of the Entity VnC47aRecord

Card of Attribute EmployeeSysId of the Entity VnC47aRecord

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity VnC47aRecord

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

Entity Attribute VnC47aSGSPGenId of the Entity VnC47aRecord

Card of Attribute VnC47aSGSPGenId of the Entity VnC47aRecord

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

Entity Attribute VnC47aSection of the Entity VnC47aRecord

Card of Attribute VnC47aSection of the Entity VnC47aRecord

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

Entity Attribute VnC47aSubmitDate of the Entity VnC47aRecord

Card of Attribute VnC47aSubmitDate of the Entity VnC47aRecord

Name	VnC47aSubmitDate
Code	VnC47aSubmitDate
Data Type	date
Mandatory	No

Entity Attribute PreviousSIWage of the Entity VnC47aRecord

Card of Attribute PreviousSIWage of the Entity VnC47aRecord

Name	PreviousSIWage
Code	PreviousSIWage
Data Type	double
Mandatory	No

Entity Attribute CurrentSIWage of the Entity VnC47aRecord

Card of Attribute CurrentSIWage of the Entity VnC47aRecord

Name	CurrentSIWage
Code	CurrentSIWage
Data Type	double
Mandatory	No

Entity Attribute C47aFromYear of the Entity VnC47aRecord

Card of Attribute C47aFromYear of the Entity VnC47aRecord

Name	C47aFromYear
Code	C47aFromYear
Data Type	integer
Mandatory	No

Entity Attribute C47aFromMonth of the Entity VnC47aRecord

Card of Attribute C47aFromMonth of the Entity VnC47aRecord

Name	C47aFromMonth
Code	C47aFromMonth
Data Type	integer
Mandatory	No

Entity Attribute C47aToYear of the Entity VnC47aRecord

Card of Attribute C47aToYear of the Entity VnC47aRecord

Name	C47aToYear
Code	C47aToYear
Data Type	integer
Mandatory	No

Entity Attribute C47aToMonth of the Entity VnC47aRecord

Card of Attribute C47aToMonth of the Entity VnC47aRecord

Name	C47aToMonth
Code	C47aToMonth
Data Type	integer
Mandatory	No

Entity Attribute C47aTime of the Entity VnC47aRecord

Card of Attribute C47aTime of the Entity VnC47aRecord

Name	C47aTime
Code	C47aTime
Data Type	double
Mandatory	No

Entity Attribute SIDeductionRate of the Entity VnC47aRecord

Card of Attribute SIDeductionRate of the Entity VnC47aRecord

Name	SIDeductionRate
Code	SIDeductionRate
Data Type	double
Mandatory	No

Entity Attribute HIDeductionRate of the Entity VnC47aRecord

Card of Attribute HIDeductionRate of the Entity VnC47aRecord

Name	HIDeductionRate
Code	HIDeductionRate
Data Type	double
Mandatory	No

Entity Attribute EE_SIContribution of the Entity VnC47aRecord

Card of Attribute EE_SIContribution of the Entity VnC47aRecord

Name	EE_SIContribution
Code	EE_SIContribution
Data Type	double
Mandatory	No

Entity Attribute ER_SIContribution of the Entity VnC47aRecord

Card of Attribute ER_SIContribution of the Entity VnC47aRecord

Name	ER_SIContribution
Code	ER_SIContribution
Data Type	double
Mandatory	No

Entity Attribute EE_HIContribution of the Entity VnC47aRecord

Card of Attribute EE_HIContribution of the Entity VnC47aRecord

Name	EE_HIContribution
Code	EE_HIContribution
Data Type	double
Mandatory	No

Entity Attribute ER_HIContribution of the Entity VnC47aRecord

Card of Attribute ER_HIContribution of the Entity VnC47aRecord

Name	ER_HIContribution
Code	ER_HIContribution
Data Type	double
Mandatory	No

Entity Attribute VnC47aIncrement of the Entity VnC47aRecord

Card of Attribute VnC47aIncrement of the Entity VnC47aRecord

Name	VnC47aIncrement
Code	VnC47aIncrement
Data Type	smallint
Mandatory	No

Entity Attribute C47aReason of the Entity VnC47aRecord

Card of Attribute C47aReason of the Entity VnC47aRecord

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

Entity Attribute PreviousSIWageF of the Entity VnC47aRecord

Card of Attribute PreviousSIWageF of the Entity VnC47aRecord

Name	PreviousSIWageF
Code	PreviousSIWageF
Data Type	double
Mandatory	No

Entity Attribute CurrentSIWageF of the Entity VnC47aRecord

Card of Attribute CurrentSIWageF of the Entity VnC47aRecord

Name	CurrentSIWageF
Code	CurrentSIWageF
Data Type	double
Mandatory	No

Entity Attribute CapPrevSIWage of the Entity VnC47aRecord

Card of Attribute CapPrevSIWage of the Entity VnC47aRecord

Name	CapPrevSIWage
Code	CapPrevSIWage
Data Type	double
Mandatory	No

Entity Attribute CapCurSIWage of the Entity VnC47aRecord

Card of Attribute CapCurSIWage of the Entity VnC47aRecord

Name	CapCurSIWage
Code	CapCurSIWage
Data Type	double
Mandatory	No