Skip to main content
April 18, 2024
Solved

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

  • April 18, 2024
  • 1 reply
  • 0 views

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?

Best answer by RobbSalzmann

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.

1 reply

April 18, 2024

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.

GregMAuthor
April 18, 2024

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