I would like to go into our history for all closed orders and update the Notifications Email Billing field that is pulled from the main customer address.
the reason is I need to update orders with the email address that are in history for a specific customer to make it easier for our accounting people to email orders that are in RETURNS. I need to do am update statement to that field but I don't know where the table is to do it. I tried SOP30100 and SOP30200 and there is no billing address column. If someone can point me the way I would really appreciate that.
John