Sage EasyPay Data Model

Entity LicenseRecord

Description of Entity LicenseRecord

This entity stores details about the the license for Sage EasyPay. Allowing or restricting access to certain modules.

List of all Dependencies of the Entity LicenseRecord

Reference

List of Attributes of the Entity LicenseRecord

License Expiring Date

LicenseExpiringDate

Sub Company Name

Purchased Functions

Customised Module

Exp Date dd mm yyyy

Max Personal Record

No Of Evaluation Login

No of Core User

No of Leave User

No of Income Tax User

No of Report Designer

No of Import Designer

No of Screen Designer

No of Costing User

No of Alert User

No of Export Designer

No of Benefit_Compensation

Max Employee Record

Entity Attribute Name of the Entity LicenseRecord

Card of Attribute Name of the Entity LicenseRecord

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

Description of Attribute Name of the Entity LicenseRecord

Stores the name of the company.
Example: Sage Software Asia Pte. Ltd.

Entity Attribute Serial No of the Entity LicenseRecord

Card of Attribute Serial No of the Entity LicenseRecord

Name	Serial No
Code	SerialNo
Data Type	char(20)
Mandatory	No

Description of Attribute Serial No of the Entity LicenseRecord

Stores the serial number for the record.

Entity Attribute License Expiring Date of the Entity LicenseRecord

Card of Attribute License Expiring Date of the Entity LicenseRecord

Name	License Expiring Date
Code	LicenseExpiringDate
Data Type	date
Mandatory	No

Description of Attribute License Expiring Date of the Entity LicenseRecord

Shows the date of expiry for the license.
It is in the format: DD-MM-YYYY.

Entity Attribute Sub Serial No of the Entity LicenseRecord

Card of Attribute Sub Serial No of the Entity LicenseRecord

Name	Sub Serial No
Code	SubSerialNo
Data Type	char(20)
Mandatory	No

Description of Attribute Sub Serial No of the Entity LicenseRecord

Shows the sub serial number for the license record.

Entity Attribute Sub Company Name of the Entity LicenseRecord

Card of Attribute Sub Company Name of the Entity LicenseRecord

Name	Sub Company Name
Code	SubCompanyName
Data Type	char(200)
Mandatory	No

Description of Attribute Sub Company Name of the Entity LicenseRecord

Shows the sub company name.

Entity Attribute Purchased Functions of the Entity LicenseRecord

Card of Attribute Purchased Functions of the Entity LicenseRecord

Name	Purchased Functions
Code	Functionlist
Data Type	varchar(2048)
Mandatory	No

Description of Attribute Purchased Functions of the Entity LicenseRecord

Shows the list of functions that you have purchased for the license record.
Example: Appraisal / Job History / Medisave etc

Entity Attribute Customised Module of the Entity LicenseRecord

Card of Attribute Customised Module of the Entity LicenseRecord

Name	Customised Module
Code	StrKey1
Data Type	char(100)
Mandatory	No

Description of Attribute Customised Module of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute Exp Date dd mm yyyy of the Entity LicenseRecord

Card of Attribute Exp Date dd mm yyyy of the Entity LicenseRecord

Name	Exp Date dd mm yyyy
Code	StrKey2
Data Type	char(100)
Mandatory	No

Description of Attribute Exp Date dd mm yyyy of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey3 of the Entity LicenseRecord

Card of Attribute StrKey3 of the Entity LicenseRecord

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

Description of Attribute StrKey3 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey4 of the Entity LicenseRecord

Card of Attribute StrKey4 of the Entity LicenseRecord

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

Description of Attribute StrKey4 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey5 of the Entity LicenseRecord

Card of Attribute StrKey5 of the Entity LicenseRecord

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

Description of Attribute StrKey5 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey6 of the Entity LicenseRecord

Card of Attribute StrKey6 of the Entity LicenseRecord

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

Description of Attribute StrKey6 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey7 of the Entity LicenseRecord

Card of Attribute StrKey7 of the Entity LicenseRecord

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

Description of Attribute StrKey7 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey8 of the Entity LicenseRecord

Card of Attribute StrKey8 of the Entity LicenseRecord

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

Description of Attribute StrKey8 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey9 of the Entity LicenseRecord

Card of Attribute StrKey9 of the Entity LicenseRecord

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

Description of Attribute StrKey9 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey10 of the Entity LicenseRecord

Card of Attribute StrKey10 of the Entity LicenseRecord

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

Description of Attribute StrKey10 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey11 of the Entity LicenseRecord

Card of Attribute StrKey11 of the Entity LicenseRecord

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

Description of Attribute StrKey11 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey12 of the Entity LicenseRecord

Card of Attribute StrKey12 of the Entity LicenseRecord

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

Description of Attribute StrKey12 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey13 of the Entity LicenseRecord

Card of Attribute StrKey13 of the Entity LicenseRecord

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

Description of Attribute StrKey13 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey14 of the Entity LicenseRecord

Card of Attribute StrKey14 of the Entity LicenseRecord

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

Description of Attribute StrKey14 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey15 of the Entity LicenseRecord

Card of Attribute StrKey15 of the Entity LicenseRecord

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

Description of Attribute StrKey15 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey16 of the Entity LicenseRecord

Card of Attribute StrKey16 of the Entity LicenseRecord

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

Description of Attribute StrKey16 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey17 of the Entity LicenseRecord

Card of Attribute StrKey17 of the Entity LicenseRecord

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

Description of Attribute StrKey17 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey18 of the Entity LicenseRecord

Card of Attribute StrKey18 of the Entity LicenseRecord

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

Description of Attribute StrKey18 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey19 of the Entity LicenseRecord

Card of Attribute StrKey19 of the Entity LicenseRecord

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

Description of Attribute StrKey19 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute StrKey20 of the Entity LicenseRecord

Card of Attribute StrKey20 of the Entity LicenseRecord

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

Description of Attribute StrKey20 of the Entity LicenseRecord

A string key for the license record. It would appear under the General tab in the license information.

Entity Attribute Max Personal Record of the Entity LicenseRecord

Card of Attribute Max Personal Record of the Entity LicenseRecord

Name	Max Personal Record
Code	NumKey1
Data Type	integer
Mandatory	No

Description of Attribute Max Personal Record of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No Of Evaluation Login of the Entity LicenseRecord

Card of Attribute No Of Evaluation Login of the Entity LicenseRecord

Name	No Of Evaluation Login
Code	NumKey2
Data Type	integer
Mandatory	No

Description of Attribute No Of Evaluation Login of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Core User of the Entity LicenseRecord

Card of Attribute No of Core User of the Entity LicenseRecord

Name	No of Core User
Code	NumKey3
Data Type	integer
Mandatory	No

Description of Attribute No of Core User of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Pay User of the Entity LicenseRecord

Card of Attribute No of Pay User of the Entity LicenseRecord

Name	No of Pay User
Code	NumKey4
Data Type	integer
Mandatory	No

Description of Attribute No of Pay User of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Leave User of the Entity LicenseRecord

Card of Attribute No of Leave User of the Entity LicenseRecord

Name	No of Leave User
Code	NumKey5
Data Type	integer
Mandatory	No

Description of Attribute No of Leave User of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of HR User of the Entity LicenseRecord

Card of Attribute No of HR User of the Entity LicenseRecord

Name	No of HR User
Code	NumKey6
Data Type	integer
Mandatory	No

Description of Attribute No of HR User of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Income Tax User of the Entity LicenseRecord

Card of Attribute No of Income Tax User of the Entity LicenseRecord

Name	No of Income Tax User
Code	NumKey7
Data Type	integer
Mandatory	No

Description of Attribute No of Income Tax User of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Report Designer of the Entity LicenseRecord

Card of Attribute No of Report Designer of the Entity LicenseRecord

Name	No of Report Designer
Code	NumKey8
Data Type	integer
Mandatory	No

Description of Attribute No of Report Designer of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Import Designer of the Entity LicenseRecord

Card of Attribute No of Import Designer of the Entity LicenseRecord

Name	No of Import Designer
Code	NumKey9
Data Type	integer
Mandatory	No

Description of Attribute No of Import Designer of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Screen Designer of the Entity LicenseRecord

Card of Attribute No of Screen Designer of the Entity LicenseRecord

Name	No of Screen Designer
Code	NumKey10
Data Type	integer
Mandatory	No

Description of Attribute No of Screen Designer of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Costing User of the Entity LicenseRecord

Card of Attribute No of Costing User of the Entity LicenseRecord

Name	No of Costing User
Code	NumKey11
Data Type	integer
Mandatory	No

Description of Attribute No of Costing User of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Alert User of the Entity LicenseRecord

Card of Attribute No of Alert User of the Entity LicenseRecord

Name	No of Alert User
Code	NumKey12
Data Type	integer
Mandatory	No

Description of Attribute No of Alert User of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Export Designer of the Entity LicenseRecord

Card of Attribute No of Export Designer of the Entity LicenseRecord

Name	No of Export Designer
Code	NumKey13
Data Type	integer
Mandatory	No

Description of Attribute No of Export Designer of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute No of Benefit_Compensation of the Entity LicenseRecord

Card of Attribute No of Benefit_Compensation of the Entity LicenseRecord

Name	No of Benefit_Compensation
Code	NumKey14
Data Type	integer
Mandatory	No

Description of Attribute No of Benefit_Compensation of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute Max Employee Record of the Entity LicenseRecord

Card of Attribute Max Employee Record of the Entity LicenseRecord

Name	Max Employee Record
Code	NumKey15
Data Type	integer
Mandatory	No

Description of Attribute Max Employee Record of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute NumKey16 of the Entity LicenseRecord

Card of Attribute NumKey16 of the Entity LicenseRecord

Name	NumKey16
Code	NumKey16
Data Type	integer
Mandatory	No

Description of Attribute NumKey16 of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute NumKey17 of the Entity LicenseRecord

Card of Attribute NumKey17 of the Entity LicenseRecord

Name	NumKey17
Code	NumKey17
Data Type	integer
Mandatory	No

Description of Attribute NumKey17 of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute NumKey18 of the Entity LicenseRecord

Card of Attribute NumKey18 of the Entity LicenseRecord

Name	NumKey18
Code	NumKey18
Data Type	integer
Mandatory	No

Description of Attribute NumKey18 of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute NumKey19 of the Entity LicenseRecord

Card of Attribute NumKey19 of the Entity LicenseRecord

Name	NumKey19
Code	NumKey19
Data Type	integer
Mandatory	No

Description of Attribute NumKey19 of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute NumKey20 of the Entity LicenseRecord

Card of Attribute NumKey20 of the Entity LicenseRecord

Name	NumKey20
Code	NumKey20
Data Type	integer
Mandatory	No

Description of Attribute NumKey20 of the Entity LicenseRecord

A number key for the license record. It would appear under the License Count tab in the license information.

Entity Attribute Generate Date of the Entity LicenseRecord

Card of Attribute Generate Date of the Entity LicenseRecord

Name	Generate Date
Code	GenerateDate
Data Type	date
Mandatory	No

Description of Attribute Generate Date of the Entity LicenseRecord

Shows the generated date for the license record.
It is in the format: DD-MM-YYYY.

Entity Attribute License Key of the Entity LicenseRecord

Card of Attribute License Key of the Entity LicenseRecord

Name	License Key
Code	LicenseKey
Data Type	char(17)
Mandatory	No

Description of Attribute License Key of the Entity LicenseRecord

Stores the license key.