I was able to determined the the lokup_value_id was the item_id in the item table.If I recall correctly you are right and the lookup_table_id was 143.
IFS is hosting our SaaS environment.They had to white list the IP of my computer for it to be able to establish a connection.
Ok this was resolved by updating to the latest SQLServer Driver V10.2
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.