Hi Kim
You are able to get this information linking the OOAT table with OAT4 and then with ORCP.
Look this sample:
SELECT T0.Number, T0.BpCode, T0.BpName, T2.Code, T2.DocObjType, T2.DraftEntry FROM OOAT T0 INNER JOIN OAT4 T1 ON T0.AbsID = T1.AgrNo INNER JOIN ORCP T2 ON T2.AbsEntry = T1.RcpEntry
Kind Regards,
Diego Lother
Add comment