on 02-11-2018 10:28 PM
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!
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 camall ADOC is use for transaction table I think.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use table OFPR and AFPR to get change log for posting period.
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Corina,
It is ADOC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.