Where are file attachments stored after attaching them to a Reconciliation?

GregM
New Contributor

When we attach a file to a Reconciliation, where is the file stored and how is it stored?  It it stored in the application database as a BLOB or on the application server in the file system?  Is it encrypted?

2 ACCEPTED SOLUTIONS

RobbSalzmann
Valued Contributor

The files are stored in the application database as varbinary(max) bytes, BLOB.  Unsure as to encryption.

You could test for encryption by extracting the file in an extender and see if the file can be parsed as normal.

View solution in original post

Thank you.  I see the table XFW_RCM_ReconSupportDoc contains the object.

View solution in original post

2 REPLIES 2

RobbSalzmann
Valued Contributor

The files are stored in the application database as varbinary(max) bytes, BLOB.  Unsure as to encryption.

You could test for encryption by extracting the file in an extender and see if the file can be parsed as normal.

Thank you.  I see the table XFW_RCM_ReconSupportDoc contains the object.