system_dictionary
Contains dictionary entries that describe fields, attributes, and relationships in the data model.
Columns
| Name | Type | ReadOnly | References | Description |
| create_roles | String | False |
Specifies which user roles are authorized to create new records or fields defined in the System Dictionary. | |
| sizeclass | String | False |
Defines the display size classification of the field, typically used for user interface rendering. | |
| array | String | False |
Indicates whether the field supports storing multiple values as an array. | |
| active | String | False |
Determines whether the dictionary entry is active and currently in use within the system. | |
| foreign_database | String | False |
Specifies the external or foreign database connection associated with this field, if applicable. | |
| dependent_on_field | String | False |
Identifies another field that this field's behavior or value depends on. | |
| reference_cascade_rule | String | False |
Defines the cascade rule that controls what happens to related records when a referenced record is deleted. | |
| reference | String | False |
Specifies the target table or record that the field references, creating a relationship between data entities. | |
| choice | String | False |
Indicates whether the field presents predefined selectable choices for users. | |
| default_value | String | False |
Specifies the value automatically assigned to the field when a new record is created. | |
| defaultsort | String | False |
Defines the default sorting order applied to records for this field. | |
| sys_id [KEY] | String | False |
Provides the system identifier (sys_id) for the System Dictionary record. | |
| attributes | String | False |
Contains additional configuration attributes that modify the field's behavior or display properties. | |
| xml_view | String | False |
Determines whether the field is visible or configurable in XML views. | |
| delete_roles | String | False |
Specifies which user roles are permitted to delete records associated with this field. | |
| reference_qual | String | False |
Defines a qualification or filter applied to reference fields to limit selectable records. | |
| reference_key | String | False |
Specifies the key field used to establish the relationship between tables in reference fields. | |
| dynamic_creation_script | String | False |
Contains a script that dynamically generates related records when needed. | |
| max_length | String | False |
Defines the maximum number of characters or data length permitted in this field. | |
| column_label | String | False |
Specifies the display label used for this field in forms and lists. | |
| read_only | String | False |
Indicates whether the field is restricted from being edited by users. | |
| dependent | String | False |
Shows whether the field's value is determined by another field's configuration or selection. | |
| unique | String | False |
Specifies whether the field must contain a unique value across all records. | |
| spell_check | String | False |
Indicates whether spell-check functionality is enabled for text-based fields. | |
| write_roles | String | False |
Lists the user roles permitted to edit or modify the field's value. | |
| audit | String | False |
Determines whether changes to this field are tracked in the system audit logs. | |
| staged | String | False |
Indicates whether changes to this field are staged for approval before implementation. | |
| dynamic_ref_qual | String | False |
Enables dynamic reference qualification using scripts or conditions at runtime. | |
| use_dynamic_default | String | False |
Specifies whether a dynamic script or condition determines the field's default value. | |
| dynamic_default_value | String | False |
Stores the dynamic logic or script that calculates the default field value. | |
| use_dependent_field | String | False |
Indicates whether this field uses another field as a dependency for its value or display. | |
| use_reference_qualifier | String | False |
Specifies whether reference qualifiers are used to filter valid reference options. | |
| reference_qual_condition | String | False |
Defines the conditional logic applied to limit records in reference lookups. | |
| choice_field | String | False |
Identifies the field whose values define selectable options for this field. | |
| dynamic_creation | String | False |
Enables the automatic creation of related records when none exist in the referenced table. | |
| calculation | String | False |
Contains a script or expression used to compute the field's value dynamically. | |
| next_element | String | False |
Indicates the next field or element in a sequence, used in ordered data models. | |
| display | String | False |
Determines whether this field is displayed as the primary value in reference lists or related records. | |
| reference_floats | String | False |
Specifies whether reference data maintains floating-point precision when applicable. | |
| element_reference | String | False |
Identifies another element that this field directly references in the dictionary definition. | |
| mandatory | String | False |
Indicates whether the field must have a value before the record can be saved. | |
| read_roles | String | False |
Lists the user roles authorized to view the field's value. | |
| text_index | String | False |
Specifies whether the field is indexed for full-text search capabilities. | |
| comments | String | False |
Contains comments or notes explaining the purpose or configuration of this dictionary entry. | |
| primary | String | False |
Indicates whether this field serves as a primary key for its table. | |
| element | String | False |
Specifies the name of the element or column represented by this dictionary entry. | |
| widget | String | False |
Defines the type of user interface widget used to display the field's value. | |
| reference_type | String | False |
Specifies the type of reference relationship established by this field. | |
| table_reference | String | False |
Identifies the database table to which this field's definition belongs. | |
| internal_type | String | False |
Indicates the internal data type used by the platform to store the field's value. | |
| virtual | String | False |
Determines whether the field is virtual, meaning its value is derived rather than stored in the database. | |
| sys_policy | String | False |
Specifies the system policy that governs how this field behaves during updates or upgrades. | |
| sys_replace_on_upgrade | String | False |
Indicates whether this dictionary entry is replaced during platform upgrades. | |
| sys_customer_update | String | False |
Shows whether this record has been modified by a customer or remains system-delivered. | |
| sys_scope | String | False |
Identifies the application scope that owns this dictionary entry. | |
| sys_package | String | False |
References the application package that includes this field definition. | |
| sys_updated_on | Datetime | False |
Records the date and time when the dictionary record was last updated. | |
| sys_created_on | Datetime | False |
Records the date and time when the dictionary record was originally created. | |
| sys_name | String | False |
Stores the internal name used to identify the dictionary record within the system. | |
| sys_updated_by | String | False |
Identifies the user who last modified the dictionary record. | |
| sys_created_by | String | False |
Identifies the user who originally created the dictionary record. | |
| sys_class_name | String | False |
Defines the system class of the dictionary record, indicating its functional type. | |
| sys_mod_count | String | False |
Tracks how many times the dictionary record has been modified since creation. | |
| sys_update_name | String | False |
Contains the update name used for version control and change tracking in update sets. |