change attachment location in AP

SUGGESTED

We just changed our storage server and in the process "simplified" where we scan AP invoices.

The problem is, the links in AP are now pointing to a non-existent location.  Is there a way to redirect the file location?  Or, where is this info stored in the Database....I'm not opposed to going in and writing a script to change the file location link directly in the DB.  But I couldn't find which table held this info.

Thank you in advance.