• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Table for PR51 Data

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Kristie Starzyk
Veteran Member Send Private Message
Posts: 76
Veteran Member
5/17/2017 6:33 PM

I'm trying to run a report in my report writing tool for Worker's Comp Wage Statements, and I need data off of the paychecks on PR51.  Does anyone know what table that data sits on?  I've been trying to find it all morning. I can find the deductions from the checks, but I'm having a hard time finding the income/pay codes.

Thank you in advance!

Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
5/17/2017 6:40 PM
Off the top of my head, I would say EMPLOYEE, PRTIME and PAYDEDUCTN.
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
5/17/2017 6:42 PM
To get all descriptors, etc. You will need some additional tables. Technical Text lists these tables -
DEDCODE -
EMPLOYEE -
HRSECLEV -
PAYDEDUCTN -
PAYMASTR -
PAYSUMGRP -
PRCHECK -
PRSYSTEM -
PRTIME -
Kristie Starzyk
Veteran Member Send Private Message
Posts: 76
Veteran Member
5/17/2017 6:55 PM
Thank you so much, Margie!! PRTIME and PAYSUMGRP were my missing pieces!

You are the best!