---
title: "SYSTEMTABLECOLUMNS (Data Dictionary)"
description: "Table Columns"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMTABLECOLUMNS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMTABLECOLUMNS
updated: 2026-11-16T20:45:42Z
license: https://documentation.invantive.eu/fr/
---

# SYSTEMTABLECOLUMNS: Data Dictionary Table Columns

`read only`

- Catalogue : `DataDictionary`
- Schéma : `Invantive`
- Label: Table Columns

Columns per table.

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `SYSTEMTABLECOLUMNS` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CAN_FILTER_SERVER_SIDE` | `char` | Possibilité de filtrer côté serveur | [x] |  | Whether the column can be filtered on server-side. |
| `CAN_FILTER_SERVER_SIDE_ADJACENT_TERMS` | `char` | Permet de filtrer les termes adjacents côté serveur | [ ] |  | Whether the column can be filtered on server-side using adjacent search terms. |
| `CAN_FILTER_SERVER_SIDE_ALL_TERMS` | `char` | Permet de filtrer tous les termes côté serveur | [ ] |  | Whether the column can be filtered on server-side using all search terms. |
| `CAN_FILTER_SERVER_SIDE_ANY_TERM` | `char` | Permet de filtrer n'importe quel terme côté serveur | [ ] |  | Whether the column can be filtered on server-side using any search term. |
| `CAN_FILTER_SERVER_SIDE_CONTAINS` | `char` | Permet de filtrer les occurrences de « contient » côté serveur | [ ] |  | Whether the column can be filtered on server-side using contains text. |
| `CAN_FILTER_SERVER_SIDE_EQUALS` | `char` | Permet de filtrer les égalités côté serveur | [ ] |  | Whether the column can be filtered on server-side using equals. |
| `CAN_FILTER_SERVER_SIDE_GREATER_THAN` | `char` | Permet de filtrer côté serveur les valeurs supérieures à | [ ] |  | Whether the column can be filtered on server-side using greater than. |
| `CAN_FILTER_SERVER_SIDE_GREATER_THAN_OR_EQUAL` | `char` | Permet de filtrer côté serveur les valeurs supérieures ou égales à | [ ] |  | Whether the column can be filtered on server-side using greater than or equal. |
| `CAN_FILTER_SERVER_SIDE_LESS_THAN` | `char` | Peut-il filtrer côté serveur les valeurs inférieures à | [ ] |  | Whether the column can be filtered on server-side using less than. |
| `CAN_FILTER_SERVER_SIDE_LESS_THAN_OR_EQUAL` | `char` | Permet de filtrer côté serveur les valeurs inférieures ou égales à | [ ] |  | Whether the column can be filtered on server-side using less than or equal. |
| `CAN_FILTER_SERVER_SIDE_NOT_EQUALS` | `char` | Possibilité de filtrer côté serveur selon la condition « différent de » | [ ] |  | Whether the column can be filtered on server-side using not equals. |
| `CAN_SCAN_SERVER_SIDE` | `char` | Possibilité de numérisation côté serveur | [ ] |  | Whether the column can be scanned on server-side for search terms. |
| `CAN_SORTER_SERVER_SIDE` | `char` | Tri possible côté serveur | [ ] |  | Whether the column can be sorted on server-side. |
| `CHECK_SPELLING` | `char` | Vérifier l'orthographe | [x] |  | Whether the column's value should preferably be checked for spelling and grammar errors in a user interface. |
| `CLIENT_SIDE_CACHEABLE` | `char` | Table Client-Side Cacheable | [ ] |  | Are the contents eligible for caching on the client? |
| `DATABASE_DATA_TYPE` | `varchar2(240)` | Type de données de la base de données | [ ] |  | Data type in the database. |
| `DERIVED_VALUE` | `char` | Valeur dérivée | [x] |  | Whether the column contains a derived value (calculated using an expression). |
| `DISPLAY_CONTROL` | `varchar2(240)` | Contrôle de l'affichage | [ ] |  | Display control for displaying the column's contents. |
| `DISPLAY_IN_FILTER` | `char` | Afficher dans le filtre | [x] |  | Whether the column should be included in a search window. |
| `DISPLAY_IN_LOV` | `char` | Afficher dans la liste des valeurs | [x] |  | Whether the column should be included in a pick list. |
| `DISPLAY_IN_RECORD` | `char` | Afficher dans l'enregistrement | [x] |  | Whether the column should be included in a single record view. |
| `DISPLAY_IN_RESULTS` | `char` | Affichage dans les résultats | [x] |  | Whether the column should be included in a multiple records view. |
| `DISPLAY_LENGTH_AVERAGE` | `int32` | Longueur d'affichage (en moyenne) | [ ] |  | Average length in characters of the contents of the column. |
| `DISPLAY_LENGTH_SD` | `int32` | Affichage de longueur (écart type) | [ ] |  | Standard deviation in characters of the contents of the column. |
| `DISPLAY_ORDER` | `int32` | Afficher la commande | [ ] |  | Relative position in which the column should be displayed compared to other columns. |
| `DOCUMENTATION` | `varchar2(4000)` | Documentation | [ ] |  | Documentation. |
| `DOTNET_DATA_TYPE` | `varchar2(240)` | Type de données .NET | [ ] |  | Data type for .NET. |
| `EXAMPLE` | `varchar2(4000)` | Example | [ ] |  | Example. |
| `FETCH_BY_DEFAULT` | `char` | Récupération par défaut | [x] |  | Whether this field is fetched by default.True if the column is fetched by default, or false if it is being fetched when accessed. |
| `ID` | `int32` | ID | [ ] |  | Unique ID of the column. |
| `INFLUENCES_INSERT` | `char` | Insérer des Influences | [x] |  | Whether the column's value has an impact on the database's contents. |
| `LABEL_HEADING` | `varchar2(240)` | Titre de l'étiquette | [ ] |  | Optional heading label to be shown before the column's normal label. |
| `LABEL_PLURAL` | `varchar2(4000)` | Étiquette pluriel | [ ] |  | Translatable label in plural. |
| `LABEL_PLURAL_COMPOSED` | `varchar2(4000)` | Étiquette « Pluriel composé » | [ ] |  | Translatable label composed of the prefix and the plural label. |
| `LABEL_PLURAL_POSTFIX` | `varchar2(240)` | Étiquette « Plural » en suffixe | [ ] |  | Translatable label postfix in plural. |
| `LABEL_PLURAL_PREFIX` | `varchar2(240)` | Préfixe d'étiquette plurielle | [ ] |  | Translatable label prefix in plural. |
| `LABEL_SINGULAR` | `varchar2(4000)` | Étiquette singulier | [ ] |  | Human-readable label in singular form. |
| `LABEL_SINGULAR_COMPOSED` | `varchar2(4000)` | Étiquette « Singulier composé » | [ ] |  | Translatable label composed of the prefix and the singular label. |
| `LABEL_SINGULAR_I18N` | `varchar2(4000)` | Étiquette traduite (au singulier) | [ ] |  | Translated human-readable label in singular form. |
| `LABEL_SINGULAR_POSTFIX` | `varchar2(240)` | Étiquette au singulier avec suffixe | [ ] |  | Translatable label postfix in singular. |
| `LABEL_SINGULAR_PREFIX` | `varchar2(240)` | Préfixe d'étiquette singulière | [ ] |  | Translatable label prefix in singular. |
| `MAX_LENGTH` | `int32` | Maximum Length | [ ] |  | Maximum length. |
| `MINIMUM_LENGTH` | `int32` | Longueur minimale | [x] |  | Minimum required length for a text field. |
| `MINIMUM_LENGTH_PADDING` | `varchar2(240)` | Remplissage de longueur minimale | [x] |  | Which side padding has to be applied if the minimum length is not met. |
| `MOST_UNQUALIFIED_NAME` | `varchar2(240)` | Le nom le plus inapproprié | [x] |  | The most unique name ('users' for 'exactonline.crm.users') |
| `NAME` | `varchar2(240)` | Name | [ ] |  | Name of the column. |
| `NULLABLE` | `char` | Nullable | [ ] |  | Whether the value is optional. |
| `POSITION` | `int32` | Position | [x] |  | Numeric ID of the column. |
| `PRECISION` | `int16` | Precision | [ ] |  | Precision. |
| `PROVIDER_DATA_CONTAINER_ALIAS` | `varchar2(4000)` | Alias du conteneur de données | [ ] |  | Data container alias. |
| `PROVIDER_DATA_CONTAINER_ID` | `varchar2(4000)` | ID du conteneur de données | [ ] |  | Data container ID. |
| `PROVIDER_DESCRIPTION` | `varchar2(16000)` | Description du fournisseur | [x] |  | Provider description. |
| `PROVIDER_INSTANCE_UID` | `guid` | UID de l'instance du fournisseur | [x] |  | Unique ID of the provider instance. |
| `PROVIDER_NAME` | `varchar2(240)` | Nom du fournisseur | [x] |  | Name of the provider. |
| `PROVIDER_SHORT_NAME` | `varchar2(240)` | Nom abrégé du fournisseur | [x] |  | Provider short name. |
| `SCALE` | `int16` | Scale | [ ] |  | Scale. |
| `SOURCE_ADDITIONAL_INFO_1` | `varchar2(4000)` | Source Informations supplémentaires 1 | [ ] |  | Additional information, no predefined structure. |
| `SOURCE_ADDITIONAL_INFO_2` | `varchar2(4000)` | Source Informations supplémentaires 2 | [ ] |  | Additional information, no predefined structure. |
| `SOURCE_ADDITIONAL_INFO_3` | `varchar2(4000)` | Source Informations supplémentaires 3 | [ ] |  | Additional information, no predefined structure. |
| `SOURCE_PATH` | `varchar2(4000)` | Chemin source | [ ] |  | Path of the source of the value. |
| `TABLE_CALL_SAFE_NAME` | `varchar2(240)` | Table Call Safe Name | [ ] |  | Name for use within SQL with special characters escaped. |
| `TABLE_CAN_DELETE` | `char` | Table Can Delete | [ ] |  | Indicator whether you can delete data in this table. |
| `TABLE_CAN_INSERT` | `char` | Table Can Insert | [ ] |  | Indicator whether you can insert data in this table. |
| `TABLE_CAN_SELECT` | `char` | Table Can Select | [ ] |  | Indicator whether you can select data in this table. |
| `TABLE_CAN_UPDATE` | `char` | Table Can Update | [ ] |  | Indicator whether you can update data in this table. |
| `TABLE_CATALOG_NAME` | `varchar2(240)` | Table Catalog | [ ] |  | Catalog where the tables are contained in. |
| `TABLE_CREATION_DATE_UTC` | `datetime` | Table Creation Date | [ ] |  | Date at which the table was originally created (UTC). |
| `TABLE_DESCRIPTION` | `varchar2(4000)` | Description de la table | [ ] |  | Description of the contents. |
| `TABLE_DOCUMENTATION` | `varchar2(4000)` | Table Documentation | [ ] |  | Documentation of the table or view. |
| `TABLE_ESTIMATED_NUMBER_OF_ROWS` | `int64` | Table Estimated Number of Rows | [ ] |  | Estimated number of rows in this table per partition |
| `TABLE_ESTIMATED_SIZE_BYTES` | `int64` | Table Estimated Size in Bytes | [ ] |  | Estimated size in bytes of this table per partition. |
| `TABLE_EXAMPLE` | `varchar2(4000)` | Table Example | [ ] |  | Example of the contents. |
| `TABLE_FULL_QUALIFIED_NAME` | `varchar2(240)` | Nom complet de la table | [ ] |  | Full qualified name. |
| `TABLE_FULL_TABLE_SCANS_EXECUTED` | `int32` | Table Number of Full Table Scans Executed | [ ] |  | Total number of full table scans executed. |
| `TABLE_FULL_TABLE_SCAN_ROWS_RETRIEVED` | `int64` | Table Rows Retrieved during Full Table Scans | [ ] |  | Total number of rows retrieved using full table scans. |
| `TABLE_FULL_TABLE_SCAN_ROW_RETRIEVAL_TOTAL_CLOCK_TIME_MS` | `double` | Table Full Table Scan Row Retrieval Total Clock Time (ms) | [ ] |  | Total clock time spent retrieving data using full table scans. |
| `TABLE_IS_PARTITION_SPECIFIC` | `char` | Table Is Partition Specific | [ ] |  | Indicator whether the contents of this table typically differ per partition. |
| `TABLE_LABEL_LIST` | `varchar2(4000)` | Table Label for List | [ ] |  | Label of the table for use in lists. |
| `TABLE_LABEL_PLURAL` | `varchar2(4000)` | Table Label Plural | [ ] |  | Label of the table contents in plural form. |
| `TABLE_LABEL_SINGULAR` | `varchar2(4000)` | Table Label Singular | [ ] |  | Label of the table contents in singular form. |
| `TABLE_LAST_UPDATE_DATE_UTC` | `datetime` | Table Last Update Date | [ ] |  | Date at which the table's structure was last modified (UTC). |
| `TABLE_MEASURED_AVERAGE_ACCESS_LATENCY_MS` | `double` | Table Measured Average Access Latency (ms) | [ ] |  | Measured Average Access Latency in milliseconds. |
| `TABLE_NAME` | `varchar2(240)` | Nom de la table | [ ] |  | Name of the table or view. |
| `TABLE_PARAMETERS` | `varchar2(4000)` | Parameters | [ ] |  | Parameters defined on the table. |
| `TABLE_POINT_QUERIES_EXECUTED` | `int32` | Table Number of Point Queries Executed | [ ] |  | Number of point queries executed. |
| `TABLE_POINT_QUERIES_EXECUTED_TOTAL_CLOCK_TIME_MS` | `double` | Table Total Clock Time Spent Executing Point Queries (ms) | [ ] |  | Total clock time spent retrieving data using point queries. |
| `TABLE_PRIMARY_KEY_FIELD` | `varchar2(4000)` | Colonnes de clé primaire | [ ] |  | Primary key column(s) of the table. |
| `TABLE_ROWS_WRITE_TOTAL_CLOCK_TIME_MS` | `double` | Table Total Time Spent Writing Rows (ms) | [ ] |  | Total clock time spent writing rows in milliseconds. |
| `TABLE_ROWS_WRITTEN` | `int64` | Table Number of Rows Written | [ ] |  | Number of rows written. |
| `TABLE_SCHEMA_NAME` | `varchar2(240)` | Table Schema | [ ] |  | Schema within the catalog where the table is contained in. |
| `TABLE_SHORT_NAME` | `varchar2(240)` | Table Short Name | [ ] |  | Typical alias for the table. |
| `TABLE_STATIC_AVERAGE_ACCESS_LATENCY_MS` | `double` | Table Static Average Access Latency (ms) | [ ] |  | Statically determined average access latency in milliseconds. |
| `TABLE_STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE` | `int32` | Table Static Average Rows per Minute on Full Scan | [ ] |  | Statically determined average number of rows accessible per minute. |
| `TABLE_STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE` | `int32` | Table Static Average Rows per Minute on Point Query | [ ] |  | Statically determined average of points queries throughput per minute. |
| `TABLE_STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE` | `int32` | Table Static Average Rows per Minute Written | [ ] |  | Statically determined throughput of written rows per minute. |
| `TABLE_TYPE` | `varchar2(30)` | Type de table | [ ] |  | Type, can be either 'view' or 'table'. |
| `TABLE_VALID` | `char` | Table Valid | [ ] |  | Whether the structure of the table is valid. |
| `TABLE_WRITES_EXECUTED` | `int32` | Table Number of Writes | [ ] |  | Total number of writes executed. |
| `USER_CHANGEABLE` | `char` | Modifiable par l'utilisateur | [x] |  | Whether the column's value can be changed ever by a human user with sufficient access rights. |

## Clés

| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk` | `PROVIDER_INSTANCE_UID` | [SYSTEMDATACONTAINERS](DataDictionary.Invantive.SYSTEMDATACONTAINERS)`.PROVIDER_INSTANCE_UID` | Key |  |
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk` | `PROVIDER_INSTANCE_UID` | [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES)`.PROVIDER_INSTANCE_UID` | Key |  |
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk` | `TABLE_CATALOG_NAME` | [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES)`.CATALOG` | Key |  |
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk` | `TABLE_SCHEMA_NAME` | [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES)`.SCHEMA` | Key |  |
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk` | `TABLE_NAME` | [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES)`.NAME` | Key |  |


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

- [Data Dictionary](/fr/release-notes/drivers?driver=data-dictionary)
