Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

isActive

IS_ACTIVE

activate and inactivate buttons

x

int

Indicates whether the table entry is active (value 1) and can be used when editing records containing that entry. If it is inactive (value 0), records may contain that entry for reporting and historical purposes, but cannot be saved when editing, unless that entry is changed to some other, active table entry.

name

NAME

(VARCHAR2) (50)

Show items belonging to

(Lookup Tables, Custom tab)

x

string (50)

The name of the custom lookup table.

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

Unique ID for the custom lookup table.

rootItem-->

ROOT_ITEM_ID

(NUMBER)

x

YDetailLookupItem

object

Links to the information about the root node in the lookup table, such as its name and its child items.

uniqueCode

UNIQUE_CODE

(VARCHAR) (4)

Unique Code

(Lookup Tables, Custom tab)

x

string (4)

Four-character alphanumeric code that uniquely identifies the lookup table.

version

VERSION

(NUMBER)

x

int

Indicates how many times the lookup table has been updated.