Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

defaultValue

DEFAULT_VALUE

(VARCHAR2)

Default Value

(Custom Fields tab, Object Definition)

x

longString

The default value of the custom field.

detailFieldTypeIID

DETAIL_FIELD_TYPE_IID

(NUMBER)

Field Type

(Custom Fields tab, Object Definition)

x

int

Specifies the custom field type, which is either:

1 - Text

2 - Number

3 - Date Field

4 - Scroll Text

5 - Check Box

6 - List

8 - Involved

9 - Memo Text

10 - Label Only

11 - Custom Object

extraInfo

EXTRA_INFO

(VARCHAR2) (50)

Label

(Custom Fields tab, Object Definition)

x

string (50)

The label of the custom field.

invlCategory-->

INVOLVED_CATEGORY_ID

(NUMBER)

The list for selecting involved role, if field is of type Involved

(Custom Fields tab, Object Definition)

x

x

YRecentlyViewedRecord

object

The involved role selection for the custom field, if it is of type Involved.

isDataMart

IS_DATA_MART

(NUMBER)

Include in Data Warehouse (Custom Fields tab, Object Definition)

x

boolean

Indicates whether the field is to be included in the Data Warehouse tables.

isExcludedFromCu stomSearch

IS_EXCLUDED_FROM_CUSTOM_SEARCH

(NUMBER)

Is Excluded from Custom Search?

(Custom Fields tab, Object Definition)

x

boolean

Indicates whether the custom field is hidden when constructing custom searches, or not.

isRequired

IS_REQUIRED

(NUMBER)

Is Required?

(Custom Fields tab, Object Definition)

x

boolean

Indicates whether the custom field is required or not.

isTimeZoneIndepe ndent

IS_TIME_ZONE_INDEPENDENT

(NUMBER)

Is Time Zone Independent

(Custom Fields tab, Object Definition)

x

boolean

Indicates whether the custom field of date datatype is adjusted in the UI for the end user's timezone (FALSE), or not (TRUE).

name

NAME

(VARCHAR2) (30)

Field Name

(Custom Fields tab, Object Definition)

x

string (30)

The database name for the custom field.

objectQualifier

OBJECT_QUALIFIER

(VARCHAR2) (2000)

Qualifier

(Custom Fields tab, Object Definition)

x

string (2000)

The qualifier path that is used to filter the available records for the custom field, if the field is of type Custom Object.

owner-->

CATEGORY_ID

(NUMBER)

For Category

(Custom Fields tab, Object Definition)

x

x

object

8 The category to which this custom field belongs.

--> Links to the definition information of the category.

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

Unique ID for the custom field.

searchView

SEARCH_VIEW_ID

(NUMBER)

Search View

(Custom Fields tab, Object Definition)

x

object

Available only for custom fields of type Involved or Custom Object.

table-->

TABLE_ID

(NUMBER)

The list for selecting a lookup table, if the field is of type List

(Custom Fields tab, Object Definition)

x

x

YDetailLookupTable

object

Specifies the custom lookup table linked to the custom field, if the field is of type List.

version

VERSION

(NUMBER)

x

int

Number that indicates how many times the custom field has been updated.