jmcfarland 3/23/2019 2:28:07 PM

Access OLE Notes Attachments From Outside GP

I have a client using the OLE Notes window to attached documents to PM Transactions.  They are using GP2016.  I believe that when they attach a Word document or PDF document it is stored somehow in the database on the more recent releases of GP.  It seems like it stores this information in the CO00101 through CO00105 tables.  I was able to locate these records and link back to the PM transaction records.  GP somehow allows the user to open the attachments via the user interface from the Inquiry screens.  Is there a way to open these attachments via a web browser via an SSRS report or through a URL?

Thanks,

John

Version: GP 2015
Section: Dynamics GP, SQL Scripts, SSRS


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3