Field type

Field type defines the characteristics of the data that can be stored in the field. The following table describes the available field types (Type column) and their internal database representation (Database Name column).

TypeDatabase NameDescription
Character StringCHARS

An alphanumeric character string not exceeding 75 characters.

DateDATE

Date format as defined in the regional and time zone settings of the operating system.

DateTimeDATETIME

Date and Time.

The Date display is defined in the regional and time zone settings of the operating system.

Time is displayed in the format:
HH:mm:ss
TypeDatabase NameDescription
IntegerINT

A whole number without decimal points, hyphens, or other punctuation.

Long CharacterSTRING

An alphanumeric character string not exceeding 150 characters.

Long Path StringPATH

An alphanumeric character string not exceeding 255 characters.

Used for fields that contain system path information.

Mime TypeMIME TYPE

Format of the data in the Object.

Used by Contenta to identify the appropriate application for viewing or editing the data.

Name StringNAME

An alphanumeric character string not exceeding 32 characters.

Property SheetSHEETSecondary Property Sheet for an object.
Property ListLIST

A list of values entered by the User.

This field type allows the User (typically the sysadmin) to enter data into the Name row of the table specified by the default value.

Select ListSELECT

A pre-defined list of values.

This field type displays in the Contenta Explorer as a list. The list is comprised of the data in the Name row of the table specified by the default value.

In Contenta Explorer, users select from the select list to populate the field.

The field is not editable; users cannot enter a value.

WebGroupWEBGROUPReserved for future use by RWS.
WebRevIdWEBREVIDReserved for future use by RWS.
Yes/NoYESNO

Displays Yes and No in a select list.

This field type displays a Yes/No select list in the Contenta Explorer. Users select Yes or No from the select list to populate the field.

The field is not editable; users cannot enter a value.

When defining a new Property Sheet field, see the table to specify the characteristics of the field. Some fields require multiple steps as explained in the section Creating Compound Fields .

These fields are:

  • Property Sheet
  • Property List
  • Select List