Using Lookup Table Designer

Lookup Table Designer allows you to create and edit lookup tables, which are used by the transformations in Transformation Designer. A lookup table allows you to define a list of 'transformed output values' dependent on ranges of source data.

Note: Lookup functionality uses alpha collation only, that is, text strings in alphabetical order. For example, lookup tables can be used for ranges of account codes and analysis codes, as they are alphanumeric. However, it is not recommended to use lookup tables for ranges of numeric data, such as dates, journal numbers or financial amounts.

A lookup table contains either business unit specific data, or global data. Lookup Table Designer enables you to make changes to lookup-based transformations of any SunSystems data on both export and import, either globally or specific to a business unit. This eliminates the need to perform hard-coded mappings using JavaScript functionality.

To access Lookup Table Designer, click Lookup Table Designer on the Transfer Desk toolbar.

Note: It is recommended that you are fully conversant with the Transformation Designer functionality before using Lookup Table Designer.