Fetch Payment File Reference into Disbursement Payment File

Summary:

Fetch Payment File Reference into Disbursement Payment File

Content (please ensure you mask any confidential information):

We have a custom Disbursement payment file RTF template that we used for AP payments. We would like to add the File Reference field as show below to the outbound file.

In reviewing the Data Model that the report template uses I see that it queries from a table named IBY_TRXN_DOCUMENTS

SELECT DOCUMENT_CLOB FROM IBY_TRXN_DOCUMENTS WHERE TRXN_DOCUMENT_ID =:TRXN_DOCUMENT_ID

I'm assuming this is some kind of Temp table as when I query it directly there is no data populated, hence I have no visibility into whats available.