Sage EasyPay Data Model

Entity TMSDetail

Description of Entity TMSDetail

This entity shows the details for the Time Management System. This includes the basic rates and the leave types.

List of all Dependencies of the Entity TMSDetail

Relation_1646459

Reference

List of Attributes of the Entity TMSDetail

Entity Attribute TMS Payment Type of the Entity TMSDetail

Card of Attribute TMS Payment Type of the Entity TMSDetail

Name	TMS Payment Type
Code	TMSPaymentType
Data Type	char(20)
Mandatory	No

Description of Attribute TMS Payment Type of the Entity TMSDetail

Shows the payment type for the Time Management System.
Example: DailyPayment etc

Entity Attribute TMS Basic Rate Day Hour Rate of the Entity TMSDetail

Card of Attribute TMS Basic Rate Day Hour Rate of the Entity TMSDetail

Name	TMS Basic Rate Day Hour Rate
Code	TMSBRDayHourRate
Data Type	double
Mandatory	No

Description of Attribute TMS Basic Rate Day Hour Rate of the Entity TMSDetail

Shows the basic rate of the day hour for the Time Management System.

Entity Attribute TMS Working Day Hour of the Entity TMSDetail

Card of Attribute TMS Working Day Hour of the Entity TMSDetail

Name	TMS Working Day Hour
Code	TMSWorkingDayHour
Data Type	double
Mandatory	No

Description of Attribute TMS Working Day Hour of the Entity TMSDetail

Shows the working hour for the Time Management System.

Entity Attribute TMS Basic Rate of the Entity TMSDetail

Card of Attribute TMS Basic Rate of the Entity TMSDetail

Name	TMS Basic Rate
Code	TMSBasicRate
Data Type	double
Mandatory	No

Description of Attribute TMS Basic Rate of the Entity TMSDetail

Stores the basic rate for the Time Management System.

Entity Attribute TMS Exchange Rate ID of the Entity TMSDetail

Card of Attribute TMS Exchange Rate ID of the Entity TMSDetail

Name	TMS Exchange Rate ID
Code	TMSExRateId
Data Type	char(20)
Mandatory	No

Description of Attribute TMS Exchange Rate ID of the Entity TMSDetail

Stores the identity of the exchange rate for the Time Management System.

Entity Attribute TMS Exchange Rate of the Entity TMSDetail

Card of Attribute TMS Exchange Rate of the Entity TMSDetail

Name	TMS Exchange Rate
Code	TMSExRate
Data Type	double
Mandatory	No

Description of Attribute TMS Exchange Rate of the Entity TMSDetail

Stores the exchange rate for the Time Management System.

Entity Attribute TMS Sick Leave of the Entity TMSDetail

Card of Attribute TMS Sick Leave of the Entity TMSDetail

Name	TMS Sick Leave
Code	TMSSickLeave
Data Type	double
Mandatory	No

Description of Attribute TMS Sick Leave of the Entity TMSDetail

Stores the number of sick leave for the Time Management System.

Entity Attribute TMS Annual Leave of the Entity TMSDetail

Card of Attribute TMS Annual Leave of the Entity TMSDetail

Name	TMS Annual Leave
Code	TMSAnnualLeave
Data Type	double
Mandatory	No

Description of Attribute TMS Annual Leave of the Entity TMSDetail

Stores the annual leave for the Time Management System.

Entity Attribute Basic Rate Costing Amount of the Entity TMSDetail

Card of Attribute Basic Rate Costing Amount of the Entity TMSDetail

Name	Basic Rate Costing Amount
Code	BasicRateCostingAmt
Data Type	double
Mandatory	No

Description of Attribute Basic Rate Costing Amount of the Entity TMSDetail

Shows the basic rate of the costing amount.

Entity Attribute BackPay Costing Amount of the Entity TMSDetail

Card of Attribute BackPay Costing Amount of the Entity TMSDetail

Name	BackPay Costing Amount
Code	BackPayCostingAmt
Data Type	double
Mandatory	No

Description of Attribute BackPay Costing Amount of the Entity TMSDetail

Shows the back pay of the costing amount.

Entity Attribute Description of the Entity TMSDetail

Card of Attribute Description of the Entity TMSDetail

Name	Description
Code	Description
Data Type	char(150)
Mandatory	No

Description of Attribute Description of the Entity TMSDetail

A description of the entity.

Home