IntelliMatch – Lookup Tables

Working with Lookup Tables

Lookup tables are used in conjunction with import formats.  They are used to translate a value read from an input file into another value before populating a field.  The advantage of using lookup tables is that one table can be used by many import formats and can be applied to any field.

The most common lookup table is one that translates D into Debit and C into Credit.  Lookup tables are also used to translate account numbers because the account number in the file may not be the same as the account number you have set up in intelliMATCH.

There are two types of lookup tables:

  • Absolute
  • Reference