Skip to Content
avatar image
Former Member

List recurring transaction templates linked to a blanked agreement

Hello,

for a project I need to be able to list all the recurring transaction templates that are linked to a particular blanket agreement. Is it possible? They're not appearing in the ORCP or OOAT tables, so i don't know where to look for them.
For example, I've a blanket agreement regarding a BP, this agreement has 3 recurring transaction templates. I'd like to be able to list them with a query

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 30, 2016 at 04:13 PM

    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
    10|10000 characters needed characters exceeded