Sage 50 SDO field names not necessarily the same as the ODBC names

A heads up, when working with Sage Data Objects, the field names are not necessarily the same as those recognised in ODBC queries. For example, the AUDIT_SPLIT table has a field called EXTRA_REF when using the ODBC driver which is called INTERNAL_REF in Sage Data Objects. Check out the SDO help file documentation if the expected field name (the ODBC name) doesn't work.