---
title: "SYSTEMTABLES (Data Dictionary)"
description: "Tables"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMTABLES
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMTABLES
updated: 2026-11-16T20:45:46Z
license: https://documentation.invantive.eu/nl/
---

# SYSTEMTABLES: Data Dictionary Tables

`read only`

- Catalogus: `DataDictionary`
- Schema: `Invantive`
- Label: Tables

Tables, function tables and views per active data container.

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `SYSTEMTABLES` 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 |
|---|---|---|:---:|---|---|
| `CACHE_RESULT` | `char` | Cacheresultaat | [ ] |  | Whether the result of the execution can be cached for the lifetime of the statement. |
| `CALL_SAFE_NAME` | `varchar2` | Veilig Naam voor Aanroep | [ ] |  | Name for use within SQL with special characters escaped. |
| `CAN_DELETE` | `char` | Kan Verwijderen | [ ] |  | Indicator whether you can delete data in this table. |
| `CAN_INSERT` | `char` | Kan Invoegen | [ ] |  | Indicator whether you can insert data in this table. |
| `CAN_SELECT` | `char` | Kan Selecteren | [ ] |  | Indicator whether you can select data in this table. |
| `CAN_UPDATE` | `char` | Kan Bijwerken | [ ] |  | Indicator whether you can update data in this table. |
| `CATALOG` | `varchar2` | Catalog | [ ] |  | Catalog where the tables are contained in. |
| `CLIENT_SIDE_CACHEABLE` | `char` | Clientzijde Cachebaar | [ ] |  | Are the contents eligible for caching on the client? |
| `CREATION_DATE_UTC` | `datetime` | Aanmaakdatum | [ ] |  | Date at which the table was originally created (UTC). |
| `DESCRIPTION` | `varchar2` | Description | [ ] |  | Description of the contents. |
| `DOCUMENTATION` | `varchar2` | Documentation | [ ] |  | Documentation. |
| `EDI_CLASS_NAME` | `varchar2(240)` | EDI-klassenaam | [ ] |  | EDI: master class name. |
| `EDI_PATH_FROM_MASTER` | `varchar2(240)` | EDI pad van Master | [ ] |  | EDI: path from the master instance. |
| `ESTIMATED_NUMBER_OF_ROWS` | `int64` | Geschat Aantal Rijen | [ ] |  | Estimated number of rows in this table per partition. |
| `ESTIMATED_SIZE_BYTES` | `int64` | Geschatte Omvang in Bytes | [ ] |  | Estimated size in bytes of this table per partition. |
| `EXAMPLE` | `varchar2` | Example | [ ] |  | Example of the contents. |
| `FULL_QUALIFIED_NAME` | `varchar2` | Volledig Gekwalificeerde Naam | [ ] |  | Fully qualified name. |
| `FULL_SCANS_ELAPSED_TIME_MS` | `double` | Volledige Scans Verstreken Tijd (ms) | [ ] |  | Time elapsed during full scans (ms). |
| `FULL_SCANS_EXECUTED` | `int32` | Volledige Scans Uitgevoerd | [ ] |  | Number of full scans executed. |
| `FULL_SCAN_ROWS` | `int64` | Volledige Scan (rijen) | [ ] |  | Number of full scans row processed. |
| `ID` | `int32` | ID | [ ] |  | Unique ID of the table. |
| `IS_PARTITION_SPECIFIC` | `char` | Is Partitie Specifiek | [ ] |  | Indicator whether the contents of this table typically differ per partition. |
| `LABEL_LIST` | `varchar2` | Label voor Lijst | [ ] |  | Label of the table for use in lists. |
| `LABEL_LIST_I18N` | `varchar2` | Vertaalde Labellijst | [ ] |  | Translated label of the table for use in lists. |
| `LABEL_PLURAL` | `varchar2` | Label Meervoud | [ ] |  | Label of the table contents in plural form. |
| `LABEL_PLURAL_I18N` | `varchar2` | Vertaald Label Meervoud | [ ] |  | Label of the table contents in plural form. |
| `LABEL_SINGULAR` | `varchar2` | Label Enkelvoud | [ ] |  | Label of the table contents in singular form. |
| `LABEL_SINGULAR_I18N` | `varchar2` | Vertaald Label Enkelvoud | [ ] |  | Translated label of the table contents in singular form. |
| `LAST_UPDATE_DATE_UTC` | `datetime` | Laatst Bijgewerkt Datum | [ ] |  | Date at which the table's structure was last modified (UTC). |
| `MEASURED_AVERAGE_ACCESS_LATENCY_MS` | `double` | Gemeten Gemiddelde Toegangsvertraging (ms) | [ ] |  | Measured average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. |
| `MEASURED_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE` | `int32` | Gewogen Gemiddeld Nummer Volledige Scan Rijen per Minuut | [ ] |  | Measured average number of rows that fetched per minute on a full table scan. |
| `MEASURED_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE` | `int32` | Gewogen Gemiddeld Nummer Punt Query Rijen per Minuut | [ ] |  | Measured average number of rows processed per minute on point queries. |
| `MEASURED_AVERAGE_WRITE_ROWS_PER_MINUTE` | `int32` | Gemeten Gemiddeld Nummer Rijen Geschreven per Minuut | [ ] |  | Measured average number of rows written per minute. |
| `NAME` | `varchar2` | Name | [ ] |  | Name of the table or view. |
| `ODATA_BASE_PATH` | `varchar2(240)` | OData Basispad | [ ] |  | OData: base path. |
| `ODATA_FIELD_SELECTION_METHOD` | `varchar2(240)` | OData Veldselectiemethode | [ ] |  | OData: field selection method. |
| `ODATA_METADATA_URL` | `varchar2(4000)` | OData Metadata URL | [ ] |  | OData: URL for retrieving metadata. |
| `ODATA_SERVER_SIDE_FILTERS` | `varchar2` | OData Filters aan Serverzijde | [ ] |  | OData: text representation of server-side filters. |
| `ODATA_SERVICE_URL_FOR_DELETE` | `varchar2(4000)` | OData Service URL voor Verwijderen | [ ] |  | OData: service URL for deleting data. |
| `ODATA_SERVICE_URL_FOR_INSERT` | `varchar2(4000)` | OData Service URL voor Toevoegen | [ ] |  | OData: service URL for inserting data. |
| `ODATA_SERVICE_URL_FOR_SELECT` | `varchar2(4000)` | OData Service URL voor Ophalen | [ ] |  | OData: service URL for retrieving data. |
| `ODATA_SERVICE_URL_FOR_UPDATE` | `varchar2(4000)` | OData Service URL voor Bijwerken | [ ] |  | OData: service URL for updating data. |
| `POINT_QUERIES_ELAPSED_TIME_MS` | `double` | Tijd besteed aan Puntqueries (ms) | [ ] |  | Time elapsed during point queries (ms). |
| `POINT_QUERIES_EXECUTED` | `int32` | Rijen via Puntqueries | [ ] |  | Number of point queries executed. |
| `PRIMARY_KEY_FIELD` | `varchar2(4000)` | Primaire Sleutelkolommen | [ ] |  | Primary key column(s) of the table. |
| `PROVIDER_DATA_CONTAINER_ALIAS` | `varchar2(4000)` | Datacontainer Alias | [ ] |  | Data container alias. |
| `PROVIDER_DATA_CONTAINER_ID` | `varchar2(4000)` | Datacontainer ID | [ ] |  | Data container ID. |
| `PROVIDER_DESCRIPTION` | `varchar2(16000)` | Provideromschrijving | [x] |  | Provider description. |
| `PROVIDER_INSTANCE_UID` | `guid` | Providerinstantie UID | [x] |  | Unique ID of the provider instance. |
| `PROVIDER_NAME` | `varchar2(240)` | Providernaam | [x] |  | Name of the provider. |
| `PROVIDER_SHORT_NAME` | `varchar2(240)` | Provider Korte Naam | [x] |  | Provider short name. |
| `SCHEMA` | `varchar2` | Schema | [ ] |  | Schema within the catalog where the table is contained in. |
| `SHORT_NAME` | `varchar2` | Korte Naam | [ ] |  | Typical alias for the table. |
| `SOAP_ACTION` | `varchar2(240)` | SOAP Actie | [ ] |  | SOAP: action. |
| `STATIC_AVERAGE_ACCESS_LATENCY_MS` | `double` | Statisch Gemiddelde Toegangswachttijd (ms) | [ ] |  | Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. |
| `STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE` | `int32` | Statisch Gemiddelde Aantal Rijen per Minuut bij Volledig Scannen | [ ] |  | Average number of rows that fetched per minute on a full table scan, statically configured. |
| `STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE` | `int32` | Statisch Gemiddelde Aantal Rijen per Minuut op Puntquery | [ ] |  | Average number of rows processed per minute on point queries, statically configured. |
| `STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE` | `int32` | Statisch Gemiddeld Aantal Rijen Schrijven per Minuut | [ ] |  | Average number of rows written per minute, statically configured. |
| `SWAGGER_CONTENT_TYPE` | `varchar2(240)` | Swagger Inhoudssoort | [ ] |  | SWAGGER: content type. |
| `SWAGGER_DELETE_OPERATION` | `varchar2(240)` | Swagger Verwijderoperatie | [ ] |  | SWAGGER: delete operation. |
| `SWAGGER_INSERT_OPERATION` | `varchar2(240)` | Swagger Toevoegoperatie | [ ] |  | SWAGGER: insert operation. |
| `SWAGGER_PRE_MAPPING_TABLE_NAME` | `varchar2(240)` | Swagger Pre-mapping Tabelnaam | [ ] |  | SWAGGER: pre-mapping table name. |
| `SWAGGER_RESPONSE_SCHEMA` | `varchar2(240)` | Swagger Antwoordschema | [ ] |  | SWAGGER: response schema. |
| `SWAGGER_SELECT_OPERATION` | `varchar2(240)` | Swagger Selecteeroperatie | [ ] |  | SWAGGER: select operation. |
| `SWAGGER_UPDATE_OPERATION` | `varchar2(240)` | Swagger Bijwerkoperatie | [ ] |  | SWAGGER: update operation. |
| `TABLE_PARAMETERS` | `varchar2(4000)` | Parameters | [ ] |  | Parameters defined on the table. |
| `TECHNICAL_DOCUMENTATION` | `varchar2` | Technische Documentatie | [ ] |  | Technical documentation. |
| `TYPE` | `varchar2` | Type | [ ] |  | Type, can be either 'view' or 'table'. |
| `VALID` | `char` | Valid | [ ] |  | Whether the structure of the table is valid. |
| `WEBHOOK_KEY_FIELD` | `varchar2(4000)` | Webhook Sleutelkolom | [ ] |  | Key column on webhook messages. |
| `WEBHOOK_TOPIC` | `varchar2(4000)` | Topic | [ ] |  | Webhook topic. |
| `WRITES_EXECUTED` | `int32` | Schrijfacties Uitgevoerd | [ ] |  | Number of writes executed. |
| `WRITE_ELAPSED_TIME_MS` | `double` | Verstreken Schrijftijd (ms) | [ ] |  | Time elapsed during point queries (ms). |
| `WRITTEN_ROWS` | `int64` | Rijen Geschreven | [ ] |  | Number of rows written. |
| `XML_BASE_XPATH` | `varchar2(240)` | Basis XPath | [ ] |  | XML: XPath expression which forms the root containing all rows. |
| `XML_DEFAULT_NAMESPACE_PREFIX` | `varchar2(240)` | Standaard Naamruimte Voorvoegsel | [ ] |  | XML: default namespace prefix. |
| `XML_NAMED_COMPLEX_TYPE` | `varchar2(240)` | Benoemd Complex Type | [ ] |  | XML: name of the complex type. |
| `XML_SERVER_SIDE_FILTERS` | `varchar2` | Serverzijde Filters | [ ] |  | XML: text representation of server-side filters. |
| `XML_SERVICE_URL` | `varchar2(240)` | Service URL | [ ] |  | XML: Service URL. |
| `XML_TOPIC` | `varchar2(240)` | Topic | [ ] |  | XML: topic or action as known on the remote server.Defaults to Name when not set. |
| `XML_XPATH` | `varchar2(240)` | XPath | [ ] |  | XML: XPath expression for the data when specified or the root otherwise.The XPath typically does NOT include the base XPath. |

## Toetsen

| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
| `SYSTEMTABLES_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk` | `PROVIDER_INSTANCE_UID` | [SYSTEMDATACONTAINERS](DataDictionary.Invantive.SYSTEMDATACONTAINERS)`.PROVIDER_INSTANCE_UID` | Key |  |
| `SYSTEMTABLES_PROVIDER_INSTANCE_UID_SYSTEMSCHEMAS_fk` | `PROVIDER_INSTANCE_UID` | [SYSTEMSCHEMAS](DataDictionary.Invantive.SYSTEMSCHEMAS)`.PROVIDER_INSTANCE_UID` | Key |  |
| `SYSTEMTABLES_PROVIDER_INSTANCE_UID_SYSTEMSCHEMAS_fk` | `CATALOG` | [SYSTEMSCHEMAS](DataDictionary.Invantive.SYSTEMSCHEMAS)`.CATALOG` | Key |  |
| `SYSTEMTABLES_PROVIDER_INSTANCE_UID_SYSTEMSCHEMAS_fk` | `SCHEMA` | [SYSTEMSCHEMAS](DataDictionary.Invantive.SYSTEMSCHEMAS)`.NAME` | Key |  |
| `SYSTEMTABLES_PROVIDER_NAME_SYSTEMPROVIDERS_fk` | `PROVIDER_NAME` | [SYSTEMPROVIDERS](DataDictionary.Invantive.SYSTEMPROVIDERS)`.NAME` | Key |  |

## Geciteerd door

- [SYSTEMTABLECOLUMNS](DataDictionary.Invantive.SYSTEMTABLECOLUMNS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMTABLECOLUMNS](DataDictionary.Invantive.SYSTEMTABLECOLUMNS) `TABLE_CATALOG_NAME` (Key)
- [SYSTEMTABLECOLUMNS](DataDictionary.Invantive.SYSTEMTABLECOLUMNS) `TABLE_SCHEMA_NAME` (Key)
- [SYSTEMTABLECOLUMNS](DataDictionary.Invantive.SYSTEMTABLECOLUMNS) `TABLE_NAME` (Key)
- [SYSTEMTABLEFOREIGNKEYS](DataDictionary.Invantive.SYSTEMTABLEFOREIGNKEYS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMTABLEFOREIGNKEYS](DataDictionary.Invantive.SYSTEMTABLEFOREIGNKEYS) `TABLE_CATALOG_NAME` (Key)
- [SYSTEMTABLEFOREIGNKEYS](DataDictionary.Invantive.SYSTEMTABLEFOREIGNKEYS) `TABLE_SCHEMA_NAME` (Key)
- [SYSTEMTABLEFOREIGNKEYS](DataDictionary.Invantive.SYSTEMTABLEFOREIGNKEYS) `TABLE_NAME` (Key)
- [SYSTEMTABLEFUNCTIONPARAMETERS](DataDictionary.Invantive.SYSTEMTABLEFUNCTIONPARAMETERS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMTABLEFUNCTIONPARAMETERS](DataDictionary.Invantive.SYSTEMTABLEFUNCTIONPARAMETERS) `TABLE_CATALOG_NAME` (Key)
- [SYSTEMTABLEFUNCTIONPARAMETERS](DataDictionary.Invantive.SYSTEMTABLEFUNCTIONPARAMETERS) `TABLE_SCHEMA_NAME` (Key)
- [SYSTEMTABLEFUNCTIONPARAMETERS](DataDictionary.Invantive.SYSTEMTABLEFUNCTIONPARAMETERS) `TABLE_NAME` (Key)
- [SYSTEMTABLEKEYS](DataDictionary.Invantive.SYSTEMTABLEKEYS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMTABLEKEYS](DataDictionary.Invantive.SYSTEMTABLEKEYS) `TABLE_CATALOG_NAME` (Key)
- [SYSTEMTABLEKEYS](DataDictionary.Invantive.SYSTEMTABLEKEYS) `TABLE_SCHEMA_NAME` (Key)
- [SYSTEMTABLEKEYS](DataDictionary.Invantive.SYSTEMTABLEKEYS) `TABLE_NAME` (Key)
- [SYSTEMVIEWS](DataDictionary.Invantive.SYSTEMVIEWS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMVIEWS](DataDictionary.Invantive.SYSTEMVIEWS) `CATALOG` (Key)
- [SYSTEMVIEWS](DataDictionary.Invantive.SYSTEMVIEWS) `SCHEMA` (Key)
- [SYSTEMVIEWS](DataDictionary.Invantive.SYSTEMVIEWS) `NAME` (Key)


## 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)
