Forum Discussion

GregM's avatar
GregM
New Contributor
8 months ago

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

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?

  • 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.

  • GregM's avatar
    GregM
    8 months ago

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

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II

    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.

    • GregM's avatar
      GregM
      New Contributor

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