Custom PO Print - Text Attachment Content on BI Publisher Report

Summary

We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Document tables but creating a file in UCM

Content

We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Document tables but creating a file in UCM with .txt file.

Approach we Tried:
i) Create a SQL dataset “DocumentID” with the corresponding query:
SELECT FndDocumentsEO.dm_version_number AS "DOCUMENT_ID",
headers.po_header_id AS "PoHeaderId"