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

# SYSTEMTABLECOLUMNSLIVE: Data Dictionary Live Retrieved Table Columns

`read only`

- Catalogus: `DataDictionary`
- Schema: `Invantive`
- Label: Live Retrieved Table Columns

Live retrieval of the available columns per table per data container.

Kan alleen gegevens ophalen.

## Samenvatting

Availability varies per platform.

## Tabelkolommen

De kolommen van de tabel `SYSTEMTABLECOLUMNSLIVE` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CLIENT_SIDE_CACHEABLE` | `char` | Table Client-Side Cacheable | [ ] |  | Are the contents eligible for caching on the client? |
| `DATABASE_DATA_TYPE` | `varchar2` | Database Datatype | [ ] |  | Data type in the database. |
| `DATA_CONTAINER_ALIAS` | `varchar2(240)` | Datacontainer Alias | [ ] |  | Alias of the data container. |
| `DOCUMENTATION` | `varchar2` | Documentation | [ ] |  | Documentation. |
| `DOTNET_DATA_TYPE` | `varchar2` | .NET Datatype | [ ] |  | Data type for .NET. |
| `GET_VALUE` | `varchar2` | Verkrijg Waarde | [ ] |  | Function used for post-processing. |
| `ID` | `int32` | ID | [ ] |  | Unique ID of the column. |
| `IS_NEW` | `char` | Is Nieuw | [ ] |  | Is the field new. |
| `LABEL_SINGULAR` | `varchar2` | Label Enkelvoud | [ ] |  | Human-readable label in singular form. |
| `MAX_LENGTH` | `int64` | Maximum Lengte | [ ] |  | Maximum length. |
| `NAME` | `varchar2` | Name | [ ] |  | Name of the column. |
| `NULLABLE` | `char` | Nullable | [ ] |  | Whether the value is optional. |
| `POST_PROCESS_GET_VALUE` | `varchar2` | Waarde Ophalen na Verwerken | [ ] |  | Whether the value is completed by Invantive after processing. |
| `PRECISION` | `int64` | Precision | [ ] |  | Precision. |
| `PROVIDER_INSTANCE_UID` | `guid` | Providerinstantie UID | [x] |  | Unique ID of the provider instance. |
| `SCALE` | `int64` | Scale | [ ] |  | Scale. |
| `SERVICE_URL` | `varchar2` | URL | [ ] |  | URL being accessed |
| `TABLE_CALL_SAFE_NAME` | `varchar2` | 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` | 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` | Tabel Omschrijving | [ ] |  | Description of the contents. |
| `TABLE_DOCUMENTATION` | `varchar2` | 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` | Table Example | [ ] |  | Example of the contents. |
| `TABLE_IS_NEW` | `char` | Table is Nieuw | [ ] |  | Is the table new. |
| `TABLE_IS_PARTITION_SPECIFIC` | `char` | Table Is Partition Specific | [ ] |  | Indicator whether the contents of this table typically differ per partition. |
| `TABLE_LABEL_LIST` | `varchar2` | Table Label for List | [ ] |  | Label of the table for use in lists. |
| `TABLE_LABEL_PLURAL` | `varchar2` | Table Label Plural | [ ] |  | Label of the table contents in plural form. |
| `TABLE_LABEL_SINGULAR` | `varchar2` | 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_NAME` | `varchar2` | Tabelnaam | [ ] |  | Name of the table or view. |
| `TABLE_PRIMARY_KEY_FIELD` | `varchar2` | Table Primary Key | [ ] |  | The primary key field of the table. |
| `TABLE_SCHEMA_NAME` | `varchar2` | Table Schema | [ ] |  | Schema within the catalog where the table is contained in. |
| `TABLE_SHORT_NAME` | `varchar2` | Table Short Name | [ ] |  | Typical alias for the table. |
| `TABLE_TYPE` | `varchar2` | Tabelsoort | [ ] |  | Type, can be either 'view' or 'table'. |
| `TABLE_VALID` | `char` | Table Valid | [ ] |  | Whether the structure of the table is valid. |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

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