A table column is one piece of information of a row of a [[Invantive Studio/Repository/Applications/Tables|table]], such as the birth date of a person. The columns of a table are listed under the table as "Columns", in their display order; each column lists the view columns that show it under "Used by View Columns". The columns of the table of banks of Invantive Estate: ![[20261004-studio-table-columns.png]] The definition of a column decides how it is stored, with its [[Invantive Studio/Repository/Reference/Data Types|data type]], length and nullability, and how screens present it, with its labels, its [[Invantive Studio/Repository/Reference/Display Controls|display control]] and whether it appears in filters, search results and lists of values. "Conversion" fills a column that is added to a table that already holds rows. ## Fields The details of a table column show these fields: - "Name": Name of the table column. - "Legacy Name": Original name of the column in a system from which it was migrated. - "Data Type": Data type of the table column. - "Data Length": Length of the column. - "Data Length Type": Acronym of the data type with the length. - "Data Precision": Precision with the data type. - "Data Scale": Scale with the data type. - "Label Singular": Label of the column for one value, as a resource code. - "Label Plural": Label of the column for several values, as a resource code. - "Label Singular as Reference": Label singular when referenced. - "Label Plural as Reference": Label plural when referenced. - "Label Heading": Label of the heading to be displayed before this column. - "Create": Whether the table column will be created. - "Definition": Functional definition of the table column. - "Definition for Manual": Definition of the column as it should appear in a manual. - "Example": Example of the content of the column. - "Added in Version": Release or version in which the column was added. - "Conversion": Conversion if field depends on other values. - "Documentation": Documentation on the table column. - "Nullable": Whether the column may be left empty. - "User Changeable": Whether the value of the column may be maintained at any time by a user. - "Confidential": Whether the column holds confidential information. - "Translatable": Whether the column contains translatable text. - "Check Spelling": Whether the contents of this column can be checked for spelling. - "Derived": Whether the value of the column is derived from other data. - "Display Order": Order in which the controls are displayed. - "Display Control Name": Type of control to be used for in/output. - "Display Control Options": Options for the control. - "Display Length (Average)": Average displayed length of the column. - "Display Length (SD)": Standard deviation of displayed length of the column. - "Display in Filter": Whether to display in filter. - "Display in Search Results": Whether to display in search results. - "Display in LOV": Whether to display in LOV. - "Display in Record": Whether to display in record area. - "Default Value Expression": Expression for the default value. ## Tabs The summary window of a table column shows its related rows on these tabs: - [[Invantive Studio/Repository/Applications/Tables|Table]] - [[Invantive Studio/Repository/Applications/Index Columns|Index Columns]] - [[Invantive Studio/Repository/Applications/Referential Constraints|Referential Constraints Role From]] - [[Invantive Studio/Repository/Applications/Referential Constraints|Referential Constraints Role To]] - [[Invantive Studio/Repository/Applications/View Columns|View Columns]]