Entity VnC47Record

Description of Entity VnC47Record

This entity is for the Vietnam Payroll.


List of all Dependencies of the Entity VnC47Record

Name

Code

Class Name

Relation_1075251

Relation_1075251

Reference

Relation_1085213

Relation_1085213

Reference

Relation_1085218

Relation_1085218

Reference

Relation_1109208

Relation_1109208

Reference


List of Attributes of the Entity VnC47Record

Name

Code

EmployeeSysId

EmployeeSysId

VnC47SGSPGenId

VnC47SGSPGenId

VnC47Section

VnC47Section

VnC47SubSection

VnC47SubSection

VnC47SubmitDate

VnC47SubmitDate

PreviousSIWage

PreviousSIWage

CurrentSIWage

CurrentSIWage

C47Remarks

C47Remarks

CapPrevSIWage

CapPrevSIWage

CapCurSIWage

CapCurSIWage

PreviousSIWageF

PreviousSIWageF

CurrentSIWageF

CurrentSIWageF


Entity Attribute EmployeeSysId of the Entity VnC47Record

Card of Attribute EmployeeSysId of the Entity VnC47Record

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity VnC47Record

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


Entity Attribute VnC47SGSPGenId of the Entity VnC47Record

Card of Attribute VnC47SGSPGenId of the Entity VnC47Record

Name

VnC47SGSPGenId

Code

VnC47SGSPGenId

Data Type

char(30)

Mandatory

Yes


Entity Attribute VnC47Section of the Entity VnC47Record

Card of Attribute VnC47Section of the Entity VnC47Record

Name

VnC47Section

Code

VnC47Section

Data Type

char(20)

Mandatory

No


Entity Attribute VnC47SubSection of the Entity VnC47Record

Card of Attribute VnC47SubSection of the Entity VnC47Record

Name

VnC47SubSection

Code

VnC47SubSection

Data Type

char(20)

Mandatory

No


Entity Attribute VnC47SubmitDate of the Entity VnC47Record

Card of Attribute VnC47SubmitDate of the Entity VnC47Record

Name

VnC47SubmitDate

Code

VnC47SubmitDate

Data Type

date

Mandatory

No


Entity Attribute PreviousSIWage of the Entity VnC47Record

Card of Attribute PreviousSIWage of the Entity VnC47Record

Name

PreviousSIWage

Code

PreviousSIWage

Data Type

double

Mandatory

No


Entity Attribute CurrentSIWage of the Entity VnC47Record

Card of Attribute CurrentSIWage of the Entity VnC47Record

Name

CurrentSIWage

Code

CurrentSIWage

Data Type

double

Mandatory

No


Entity Attribute C47Remarks of the Entity VnC47Record

Card of Attribute C47Remarks of the Entity VnC47Record

Name

C47Remarks

Code

C47Remarks

Data Type

char(100)

Mandatory

No


Entity Attribute CapPrevSIWage of the Entity VnC47Record

Card of Attribute CapPrevSIWage of the Entity VnC47Record

Name

CapPrevSIWage

Code

CapPrevSIWage

Data Type

double

Mandatory

No


Entity Attribute CapCurSIWage of the Entity VnC47Record

Card of Attribute CapCurSIWage of the Entity VnC47Record

Name

CapCurSIWage

Code

CapCurSIWage

Data Type

double

Mandatory

No


Entity Attribute PreviousSIWageF of the Entity VnC47Record

Card of Attribute PreviousSIWageF of the Entity VnC47Record

Name

PreviousSIWageF

Code

PreviousSIWageF

Data Type

double

Mandatory

No


Entity Attribute CurrentSIWageF of the Entity VnC47Record

Card of Attribute CurrentSIWageF of the Entity VnC47Record

Name

CurrentSIWageF

Code

CurrentSIWageF

Data Type

double

Mandatory

No


Previous
Home
Next