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

Creating a CSV with the pay-period deduction codes and pay-period amounts

 2 Replies
 1 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
tambrosi
Veteran Member Send Private Message
Posts: 55
Veteran Member
6/27/2016 6:34 PM

Hello all,  hope somebody can help me with a question. We are pretty new to the Lawson software.

I need to create a HSA bank file to be sent to the bank with current pay period amounts.  Would anybody know what table(s) that I can pull that data from.   I looked at theses tables but did not find the values that are printed on the PR140 Earnings and Deductions Calc. report. 

I thought I could just pull the deduction (DED_CODE)  from the PAYDEDUCTN, but that looks to be a YTD value.   I need the value for the payperiod.   

Select * from dbo.PREMDEDHST 

Select * from dbo.EMDEDMASTR 

Select * from dbo.QUARTDED 
Select * from dbo.PRDEDDTL 

Would PR197 have to be run before those values are available someplace.  

I scanned the entire database for a given value, but did not find the entry on any field within the database, 

Any help would sure be appreciated. 

Thanks

Terry

 

Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
6/27/2016 7:45 PM
paydeductn is the table you need. You can pull by check date.
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
6/30/2016 9:47 AM
I also use PAYDEDUCTN. I use the fields PYD-DED-CODE, PYD-DED-AMT and PYD-CHECK-DATE.