You may configure the display order of lookup table items and organize them in a hierarchical structure. As you add items to a lookup table, specify their tree positions so they are uniquely identified in the database.

Hierarchical Tree Structure

Many lookup tables consist of one level, so they appear as a flat list of items. However, lookup tables may also have a hierarchical structure with multiple sub-levels. These lookup tables also display in a drop-down list and appear in the end-user interface with headings and indents. The names of the sub-levels appear in their appropriate positions in the hierarchy, as shown in the following image.

Example: System Lookup Table Hierarchy in Drop-Down List

Levels in the lookup table structure that have their own sub-levels are referred to as Nodes. The tree originates with the Root node, which is the first level and has the following properties:

•Cannot be deleted.

•Not displayed in the end-user interface. Thus, items directly below the Root node appear to end users as first level items.

•In both system and custom lookup tables, the tree position of the Root node is the predefined unique code of the table. For a list of system table unique codes, see the System Lookup Table Information table.