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
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
    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
      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
        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!