Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

childList-->

n/a

x

LApptAreaItem

Links to the child items in the Area Item system lookup table that belong to this area list item.

displayOrder

DISPLAY_ORDER

(NUMBER)

Order

(Lookup Tables, System tab)

x

int

The order in which the table items will be listed in the GUI, lowest number first.

name

NAME

(VARCHAR2) (250)

Item Name

(Lookup Tables, System tab)

x

string (50)

The name of the area item (for example, Orange County, Los Angeles).

parent-->

PARENT_ID

(NUMBER)

Show items in node

(Lookup Tables, System tab)

x

x

LApptAreaItem

object

Links to the parent item of this area item in the Area Item system lookup table.

primaryKey

PRIMARY_KEY(NUMB ER)

x

int

The unique ID of the area list item.

treePosition

TREE_POSITION

(VARCHAR2) (250)

Tree Position

(Lookup Tables, System tab)

x

string (250)

The unique four-character alphanumeric code that is created when the area list item is defined.

version

(VERSION)

(NUMBER)

x

int

Indicates how many times the area list item was updated.