Skip to Content
0

TABLE FOR SHOW DIFFERENCE WINDOW

Feb 11 at 10:28 PM

39

avatar image

Hi,

I would like to know which table located is the show difference window (CHANGE LOG> DIFFERENCE)? I am doing a Posting Period change log report and the requirement is to give the field value of Updater, Date Updated, Changed Field, Previous Value and New Value.It would really be helpful if you can give me the query for it.

Thanks!

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Nagarajan K Feb 12 at 02:40 PM
0

Hi,

Use table OFPR and AFPR to get change log for posting period.

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
I H Feb 12 at 08:12 AM
0

Dear Corina,

It is ADOC

Share
10 |10000 characters needed characters left characters exceeded
Corina Alonzo Feb 13 at 03:17 AM
0

Hi Nagarajan,

I tried the AFPR and OFPR table but this not gives correct outcome.

Select *

FROM AFPR T0 left join OFPR T1 on T0.[AbsEntry] = T1.[AbsEntry]
and t0.loginstanc = t1.loginstanc-1
left join OUSR T2 on t2.userid = t0.usersign2
left JOIN OUSR T3 ON T3.USERID = T0.usersign2 ORDER BY T0.[AbsEntry]

To mll md ADOC is use for transaction table I think.

Thanks.

Share
10 |10000 characters needed characters left characters exceeded