A column corresponds to a specific attribute of an information object. Each column has its own strictly determined data type is supported and controlled by the platform.
ttributes determine their type, the table that the columns belong to, and others:
- Table – determines the table to which the column belongs.
- Column type – determines the of stored data and functional purpose of a column.
- Title – determines of a column displayed in forms and lists.
- Name – determines the system name of a column used in the business logic. The column name is set according to the following rules.
- Comments – provides a column description or other information that could be useful to system administrators or solution developers.
The column properties determine their behavior and limitations that are to them:
- Active – determines whether a column can be used.
- Read only – protects column values from modification by users with limited access.
- Mandatory – denotes columns that must be filled to save a record.
- Full text search – denotes the columns whose values are available for the global search.
- Display by ref – determines a column whose values are used as the display values in the Reference fields.
- Unique – ensures that each column value in a table is unique.
about using the dot-walking in scripts and context processing.
Find out when you can change the type or system name of a column and how to do it without breaking the system processes.
