Check Transaction Distribution Inquiry Window

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (5)

Answers (1)

Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I don't see a relationship between the 2 tables

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

sorry I see the actindx is in both tables

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

That's the one! The field to show the whole account number is the ACTNUMST, it's just before the DEX_ROW_ID.

Kind regards,

Leslie

Was this reply helpful? Yes No