Announcements
No record found.
I am looking for the sql table that displays the transaction on this window. I am not finding a table with the Account numbers along with the Debits and Credits by employee
*This post is locked for comments
Hi,
Look at UPR30401. This is the Payroll Distribution History Detail. You'll need to create a join between this table and the GL00105 table in order to get the actual account number string to show.
Kind regards,
Leslie
I don't see a relationship between the 2 tables
sorry I see the actindx is in both tables
That's the one! The field to show the whole account number is the ACTNUMST, it's just before the DEX_ROW_ID.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
