435
Hello,
I am looking for the table name/s of where all payroll information would be contained on a check - I can find the basic information such as employee name/id but where would the address info and deposit/deduction etc information be contained.
I can trying to create a report and this information is needed.
Thanks
*This post is locked for comments
While Victoria Yudin list many of the tables on her blog, and you can get some tables from Microsoft Dynamics GP / Tools / Resource Descriptions / Tables.
Here are the ones that I can remember off the top of my head.
UPR00100 - Employee Master, sounds like you have already found that one.
UPR00102 - Employee Address, Note: use both the employid and the adrscode to connect these two tables
Then there are these setup tables:
Employee PayCodes is UPR00400
Employee Deductions is UPR00500
Employee Benefits is UPR00600
But for check information I mainly use the first two and the following two tables: UPR30300 and UPR30100
There may be more but that's about all that I use.
till later,
John
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (