Sage EasyPay Data Model

Entity JobCode

Description of Entity JobCode

This entity holds information about the job code.

List of all Dependencies of the Entity JobCode

Relation_1646447

Relation_1646447

Reference

List of Attributes of the Entity JobCode

TMSCostCentreId

Entity Attribute Job Code of the Entity JobCode

Card of Attribute Job Code of the Entity JobCode

Name	Job Code
Code	JobCode
Data Type	char(20)
Mandatory	Yes

Description of Attribute Job Code of the Entity JobCode

Shows the job code. This holds the primary key for the JobCode table.
Example: 100-01 / 100-02 / 100-03 etc

Entity Attribute Description of the Entity JobCode

Card of Attribute Description of the Entity JobCode

Name	Description
Code	JobCodeDesc
Data Type	char(100)
Mandatory	No

Description of Attribute Description of the Entity JobCode

A description of the job code.

Entity Attribute Job Ref No of the Entity JobCode

Card of Attribute Job Ref No of the Entity JobCode

Name	Job Ref No
Code	JobCodeRefNo
Data Type	char(100)
Mandatory	No

Description of Attribute Job Ref No of the Entity JobCode

The reference number of the job code.

Entity Attribute Project ID of the Entity JobCode

Card of Attribute Project ID of the Entity JobCode

Name	Project ID
Code	TMSProjectId
Data Type	char(20)
Mandatory	No

Description of Attribute Project ID of the Entity JobCode

Project identity of the TMS for the job code.

Entity Attribute Cost Centre ID of the Entity JobCode

Card of Attribute Cost Centre ID of the Entity JobCode

Name	Cost Centre ID
Code	TMSCostCentreId
Data Type	char(20)
Mandatory	No

Description of Attribute Cost Centre ID of the Entity JobCode

Cost centre identity of the TMS for the job code.