You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

A column corresponds to a specific attribute of an information object. Each column has its own strictly determined data type, which is supported and controlled by the platform.

Column attributes and properties


The column attributes determine their type, the table they belong to and others:

  • Table – determines the table to which the column belongs.
  • Column type – determines the type of stored data and functional purpose of a column.
  • Titlethe name of a column displayed in forms and lists.
  • Name – the system name of a column used in the business logic. Column names follow set rules.
  • Comments – 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 apply to them:

  • Active – determines whether a column can be used.
  • Read only – protects column values from accidental modification by users.
  • Mandatory – denotes columns that must be filled to save a record.
  • Full text search – denotes the columns the values of which are available for the global search.
  • Display by ref – determines a column that represents the table records in the Reference fields.
  • Unique – ensures that each column value in a table is unique.

Dot-walking in scripts


Learn about using the dot-walking mechanism in scripts and context processing.

Change Column Settings


In some exceptional cases you may need to change the type or the name of a column. Read this article to learn when it is possible and how to do it without disrupting the system.

  • No labels