Have a look at AdagioODBCv2.chm, Setting Up a DSN
Columns:
Common - Does not show 'hidden' fields in the table and translates coded values. Fields with coded values will have a "_T" suffix added to the field name. 'Translated coded values' should not be used in the WHERE or JOIN clauses of an SQL statement.
For example, WHERE SRTransactions_as80aitm.Type_T="Tax" will not work properly.
Instead, use the All option described below and WHERE SRTransactions_as80aitm.Type="T".
All - Shows the hidden fields and does not translate coded values.