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).
| Type | Database Name | Description |
|---|---|---|
| Character String | CHARS | An alphanumeric character string not exceeding 75 characters. |
| Date | DATE | Date format as defined in the regional and time zone settings of the operating system. |
| DateTime | DATETIME | 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:
|
| Type | Database Name | Description |
|---|---|---|
| Integer | INT | A whole number without decimal points, hyphens, or other punctuation. |
| Long Character | STRING | An alphanumeric character string not exceeding 150 characters. |
| Long Path String | PATH | An alphanumeric character string not exceeding 255 characters. Used for fields that contain system path information. |
| Mime Type | MIME TYPE | Format of the data in the Object. Used by Contenta to identify the appropriate application for viewing or editing the data. |
| Name String | NAME | An alphanumeric character string not exceeding 32 characters. |
| Property Sheet | SHEET | Secondary Property Sheet for an object. |
| Property List | LIST | 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 List | SELECT | 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. |
| WebGroup | WEBGROUP | Reserved for future use by RWS. |
| WebRevId | WEBREVID | Reserved for future use by RWS. |
| Yes/No | YESNO | 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