I am trying to pull Timecard information into Crystal Report. Need to know which tables to use?
Try UPTCHD and UPTCDT. That is the timecard header and detail for U.S. Payroll. If you are a Canadian employer, use CPTCHD and CPTCDT.
For earnings and hours you can use upchkd and upchkh. It also contains deduction and tax information. To get a list of tables and fields, from within Sage HRMS run the Data Dictionary report (Reports …
Try UPTCHD and UPTCDT. That is the timecard header and detail for U.S. Payroll. If you are a Canadian employer, use CPTCHD and CPTCDT.
what tables do I need to use to pull Timecard information after it is posted?
For earnings and hours you can use upchkd and upchkh. It also contains deduction and tax information. To get a list of tables and fields, from within Sage HRMS run the Data Dictionary report (Reports > System)
I suggest you run these reports separately (HR then PR). If you select both, HRMS has no rhyme or reason on the sort of the files!
*Community Hub is the new name for Sage City