Lookups

Note: This tab is displayed only for projects created using the previous versions of Studio.

Lookups are used to map ERP-specific values to common values so that you have the flexibility to build a common set of rules in Infor Risk & Compliance for all ERPs. For example, the currency American dollars might be represented differently in different ERPs. The different values would be converted to the common value 'USD' in the CDM destination column CURRENCY_CODE via a lookup category.

Infor Risk & Compliance ships with several pre-defined lookup categories but new categories can be added as needed. When you click the Lookups tab, the panels on the left and right both display the existing lookup categories. The panel on the right provides additional details such as the friendly name for a category and the destination tables that are associated with that lookup category.

Click on a category in the left panel to view the details of that category on the right panel.