You can connect a field to a specific database table that contains a static list in connection with an ODBC source. Note that the ODBC source and connection need to be set up properly before you can use the procedure below.
Do the following to connect a field to a specific database table:
Edit the field profile for the field you want to connect.
Click Table validation in the navigation pane of the dialog, and specify ODBC connection as the Table type.
Type the name of the source in the Data source box, and click Connect.
The Table name settings are populated with the tables and associated columns that are mapped to the specified data source. Select the name of the desired table in the first dropdown list and the desired column in the second one.
Click OK to save the settings.
Interpreted field values are first validated against the static values found in the database table specified in the above procedure both when they are interpreted and verified. If a match is not found, any special characters in both the interpreted value and the static value in the database are removed, and the values are compared again to see if they match. The special characters that are removed are listed here.
After invoices are interpreted, the process log indicates how the fields were matched with the table values in the following way:
"Connection table validation for <field name>, comparing interpreted field value xxxxx with database value yyyyy" - where xxxxx is the interpreted value and yyyyy is the value found in the specified table..