Sage EasyPay Data Model

Entity HKPlaceOfRes

Description of Entity HKPlaceOfRes

This entity is for the Hong Kong income Tax.

List of all Dependencies of the Entity HKPlaceOfRes

Relation_1195933

Relation_1195933

Reference

List of Attributes of the Entity HKPlaceOfRes

Entity Attribute EmployeeSysId of the Entity HKPlaceOfRes

Card of Attribute EmployeeSysId of the Entity HKPlaceOfRes

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity HKPlaceOfRes

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

Entity Attribute HKPlaceOfResSysId of the Entity HKPlaceOfRes

Card of Attribute HKPlaceOfResSysId of the Entity HKPlaceOfRes

Name	HKPlaceOfResSysId
Code	HKPlaceOfResSysId
Data Type	integer
Mandatory	Yes

Entity Attribute HKResAddress of the Entity HKPlaceOfRes

Card of Attribute HKResAddress of the Entity HKPlaceOfRes

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

Entity Attribute HKResNature of the Entity HKPlaceOfRes

Card of Attribute HKResNature of the Entity HKPlaceOfRes

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

Entity Attribute HKProvideFromDate of the Entity HKPlaceOfRes

Card of Attribute HKProvideFromDate of the Entity HKPlaceOfRes

Name	HKProvideFromDate
Code	HKProvideFromDate
Data Type	date
Mandatory	No

Entity Attribute HKProvideToDate of the Entity HKPlaceOfRes

Card of Attribute HKProvideToDate of the Entity HKPlaceOfRes

Name	HKProvideToDate
Code	HKProvideToDate
Data Type	date
Mandatory	No

Entity Attribute HKEmpeePaid of the Entity HKPlaceOfRes

Card of Attribute HKEmpeePaid of the Entity HKPlaceOfRes

Name	HKEmpeePaid
Code	HKEmpeePaid
Data Type	double
Mandatory	No

Entity Attribute HKEmperPaid of the Entity HKPlaceOfRes

Card of Attribute HKEmperPaid of the Entity HKPlaceOfRes

Name	HKEmperPaid
Code	HKEmperPaid
Data Type	double
Mandatory	No

Entity Attribute HKRefundToEmpee of the Entity HKPlaceOfRes

Card of Attribute HKRefundToEmpee of the Entity HKPlaceOfRes

Name	HKRefundToEmpee
Code	HKRefundToEmpee
Data Type	double
Mandatory	No

Entity Attribute HKRefundToEmpeeAdj of the Entity HKPlaceOfRes

Card of Attribute HKRefundToEmpeeAdj of the Entity HKPlaceOfRes

Name	HKRefundToEmpeeAdj
Code	HKRefundToEmpeeAdj
Data Type	double
Mandatory	No

Entity Attribute HKPaidToEmper of the Entity HKPlaceOfRes

Card of Attribute HKPaidToEmper of the Entity HKPlaceOfRes

Name	HKPaidToEmper
Code	HKPaidToEmper
Data Type	double
Mandatory	No

Entity Attribute HKPaidToEmperAdj of the Entity HKPlaceOfRes

Card of Attribute HKPaidToEmperAdj of the Entity HKPlaceOfRes

Name	HKPaidToEmperAdj
Code	HKPaidToEmperAdj
Data Type	double
Mandatory	No

Entity Attribute HKSystemGenerate of the Entity HKPlaceOfRes

Card of Attribute HKSystemGenerate of the Entity HKPlaceOfRes

Name	HKSystemGenerate
Code	HKSystemGenerate
Data Type	smallint
Mandatory	No