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.