finDocumentFunctions.GetClientSqlWhereBuilder() function updated

The finDocumentFunctions.GetClientSqlWhereBuilder() may return SQL without specifiying the table, i.e. just include the column name.

For example;

SELECT [Client].[ClientId],[Account].[AccountId] FROM (([Client] INNER JOIN [AccountClient] ON [Client].[Pk]=[AccountClient].[ClientPk]) INNER JOIN [Account] ON [AccountClient].[AccountPk]=[Account].[Pk]) INNER JOIN [MonitorCategory] ON [Account].[MonitorCatAPk]=[MonitorCategory].[Pk] WHERE [Active]=1

Notice the WHERE clause is simple "WHERE [Active]=1". This will now return the WHERE clause as "WHERE [Client].[Active]=1".

Therefore, prior to this change, using this with other joins may cause an erro like "Ambiguous column name".