Attribute

Database column name

Field in UI

End of path

Bridge

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

childList-->

n/a

Do not apply. These lookup items cannot have a hierarchical structure.

parent-->

PARENT_ID

(NUMBER)

displayOrder

DISPLAY_ORDER

(NUMBER)

Order

x

int

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

name

NAME

(VARCHAR2) (50)

Item Name

x

string (50)

The name of the relation type.

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the relation type list item.

treePosition

TREE_POSITION

(VARCHAR2) (250)

Tree Position

x

string (250)

The unique four-character alphanumeric code that is created when the relation type is defined.

version

VERSION

(NUMBER)

x

int

Indicates how many times the relation type list item was updated.