I have inherited a client that is unable to run the Financial Reports in Intelligence and upon investigation, I found that the AUDTORG field has two different company db id's.  This client is using some third party products so can not do database dump and loads.  I suspect that there may have been some SQL data manipulations in the past and the remnants of that is still lingering and causing problems.

What I would like to know is:

1) if we do a SQL update to set the AUDTORG field to the correct id in ALL the tables containing this field, would there be any negative impact that I am not aware of?

2) Is there anything besides a SQL update/restore etc that would cause the AUDTORG field to be different than the ID of the database? Just thinking about the cause and if it will happen again, what might need to be changed/fixed.

Thanks in advance