For my labor hour reporting, I have chosen to look at the Job Cost tables and filter for the Labor Costs.  I am able to get the RT and OT hours and cost without using the PR tables.  Specifically, I use JCT_CURRENT__TRANSACTION.

Related to your question re: PRT, RTT, PJF.  The 1st 2 letters relate to the module, and the last letter relates to whether the table contents are Transaction, Master, Activity, etc:

PRT = Payroll Module - Transaction

Thanks for the reply, that helps a ton.

Regarding getting Labor costs from JCT_CURRENT__TRANSACTION, what column are you matching on? Also how do you differentiate between overtime and non-overtime?

In my case I am looking for hours rather than costs... would that be in the same table?

Glad you found it helptul!

Based on my setup, I can filter down to just PR transactions by Category.  My payroll setup has a separate Job Cost Category for Regular Time and Overtime.  To get the hours, I use the [Units] column.

Can you clarify your question re: column matching?

Regarding column matching, I was curious which column you use to filter the rows of data to just labor, but you have answered that.

Hi FDZeeland,

To see the list of table names an what they contain, you can go into Report Designer, Tools, Available Fields, select all the tables. Select the Include information for ODBC Reporting information checkbox. This will show you the tables and fields in each file.

You may also want to review our SQL Data Dictionary in our knowledgebase at www.sageKB.com:

https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=91722