6.3.4 Lookup Table

Lookup Tables are user defined database tables that are created to hold user data to match Instrument level measures or attributes and thereby deduce a return factor. The user data is generally matched conditionally with the similar columns of a PBSMCS instrument table and a user specified value is returned that is stored under the return columns of the Lookup table.

A Lookup table by itself is a non executing component of the Profitability application. It is rendered meaning when used inside an allocation rule with the help of a Lookup Table Driver.

Summary and Detail Screens

To open the Summary page, select Profitability Management Cloud Service, select Maintenance, and then select Lookup Tables.

A summary screen is displayed showing a set of Lookup Table rules. Using search criteria, you can control the set of rules displayed. When you Add, Edit, or View a rule, it displays a detailed screen.

Figure 6-67 Lookup Tables - Summary page