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 on the Transfer Desk toolbar.
Note: It is recommended that you are fully
conversant with the Transformation Designer functionality before using
Lookup Table Designer.