Hi,

I am currently trying to work out where the suppliers email address's are stored, if I go to Purchase Ledger > Suppliers List, there is a column here called "Contact Email"  and if I double click an entry then click "Account Enquiry" the address also appears here in the "E-Mail", however I can not work out where in the DB these are stored.

According to page 9 of this document, they should be in PLSupplierContact, however that table does not contain an email field, I have also checked in every other PL* table and there is no trace of them.

I have searched the DB for all tables with a field containing "email" and then searched each of those for one of the email address's I can see against a supplier in the UI, the only place I am seeing these is in SOPDocDelAddress & SOPInvCredDelAddress, however I am not seeing any way to link these back to the individual suppliers accounts and they seem like these would be tables that have taken the email from somewhere else rather than being the source of the information?

The worse thing is, I am sure I have done this before in the past.

Thanks