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

# SYSTEMDATACONTAINERS: Data Dictionary Datacontainer

`read only`

- Catalogue : `DataDictionary`
- Schéma : `Invantive`
- Label: Datacontainer

Active data containers.

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

## Colonnes de table

Les colonnes de la table `SYSTEMDATACONTAINERS` 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 |
|---|---|---|:---:|---|---|
| `ALIAS` | `varchar2(240)` | Alias | [ ] |  | Alias of the data container. |
| `CONSUMPTION_LAST_CALL` | `number` | Dernier appel pour la consommation | [ ] |  | Number of calls or credits the platform charged for its last answer. |
| `DAILY_LIMIT` | `number` | Limite quotidienne | [ ] |  | Number of calls allowed per day. |
| `DAILY_REMAINING` | `number` | Solde quotidien | [ ] |  | Number of calls left of the current day. |
| `DAILY_RESET_DATE_UTC` | `datetime` | Date de réinitialisation quotidienne (UTC) | [ ] |  | Moment at which the number of calls allowed per day is replenished. |
| `DAILY_USED` | `number` | À usage quotidien | [ ] |  | Number of calls spent of the current day. |
| `HOURLY_LIMIT` | `number` | Limite horaire | [ ] |  | Number of calls allowed per hour. |
| `HOURLY_REMAINING` | `number` | Heures restantes | [ ] |  | Number of calls left of the current hour. |
| `HOURLY_RESET_DATE_UTC` | `datetime` | Date de réinitialisation horaire (UTC) | [ ] |  | Moment at which the number of calls allowed per hour is replenished. |
| `ID` | `varchar2(4000)` | ID | [ ] |  | Data container ID. |
| `IS_DEFAULT_FLAG` | `char` | Est-ce la valeur par défaut ? | [x] |  | Is the default provider? |
| `IS_SERVICE_PROVIDER_FLAG` | `char` | Est-ce que le fournisseur de services ? | [x] |  | Is the provider a service provider? |
| `LAST_MEASUREMENT_UTC` | `datetime` | Mesure UTC | [ ] |  | Moment the platform last stated its rate limit, without which the figures beside it can not be read. |
| `MINUTELY_LIMIT` | `number` | Limite par minute | [ ] |  | Number of calls allowed per minute. |
| `MINUTELY_REMAINING` | `number` | Minutes restantes | [ ] |  | Number of calls left of the current minute. |
| `MINUTELY_RESET_DATE_UTC` | `datetime` | Réinitialisation de la date UTC à la minute près | [ ] |  | Moment at which the number of calls allowed per minute is replenished. |
| `PARTITIONS_COUNT` | `int32` | Nombre de Partitions | [ ] |  | Number of partitions. |
| `PARTITIONS_SELECTED_COUNT` | `int32` | Nombre de partitions sélectionnées | [ ] |  | Number of selected partitions. |
| `PROVIDER_DATABASE_POOL_DESCRIPTION` | `varchar2(240)` | Description du pool de bases de données des fournisseurs | [ ] |  | Pool description of the database. |
| `PROVIDER_DATABASE_PRICING_TIER` | `varchar2(240)` | Niveau tarifaire de la base de données des fournisseurs | [ ] |  | Pricing tier of the database. |
| `PROVIDER_DATABASE_SERVICE_TIER` | `varchar2(240)` | Niveau de service de la base de données des fournisseurs | [ ] |  | Service tier of the database. |
| `PROVIDER_DATABASE_VERSION` | `varchar2(240)` | Version de la base de données des fournisseurs | [ ] |  | Version text of the database. |
| `PROVIDER_DATABASE_VERSION_NUMBER` | `varchar2(240)` | Numéro de version de la base de données des fournisseurs | [ ] |  | Version number of the database. |
| `PROVIDER_DESCRIPTION` | `varchar2(16000)` | Description du fournisseur | [ ] |  | Description of the provider. |
| `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] |  | Short name of the provider. |
| `SECONDLY_LIMIT` | `number` | Deuxièmement, la limite | [ ] |  | Number of calls allowed per second. |
| `SECONDLY_REMAINING` | `number` | Deuxièmement : ce qui reste | [ ] |  | Number of calls left of the current second. |
| `SECONDLY_RESET_DATE_UTC` | `datetime` | Deuxièmement, réinitialiser la date UTC | [ ] |  | Moment at which the number of calls allowed per second is replenished. |
| `SESSION_TIME_UTC_OFFSET_SECONDS` | `int32` | Décalage horaire de la session par rapport à l'UTC (en secondes) | [x] |  | UTC session offset (seconds). |
| `UI_LANGUAGE_CODE` | `varchar2(30)` | Code de langue de l'UI | [ ] |  | User interface language code. |
| `USER_COGNITO_USER_ID` | `varchar2(240)` | Identifiant utilisateur Cognito | [ ] |  | Identifier of the user in the Invantive Cloud user administration. |
| `USER_COMPANY_ADDRESS_LINE_1` | `varchar2(240)` | Adresse de l'entreprise de l'utilisateur – Ligne 1 | [ ] |  | Address line 1 of the company of the user. |
| `USER_COMPANY_ADDRESS_LINE_2` | `varchar2(240)` | Adresse de l'entreprise de l'utilisateur – Ligne 2 | [ ] |  | Address line 2 of the company of the user. |
| `USER_COMPANY_ADDRESS_LINE_3` | `varchar2(240)` | Adresse de l'entreprise de l'utilisateur – Ligne 3 | [ ] |  | Address line 3 of the company of the user. |
| `USER_COMPANY_BIC` | `varchar2(4000)` | Société BIC | [ ] |  | BIC of the company of the user. |
| `USER_COMPANY_CITY` | `varchar2(240)` | Utilisateur Entreprise Ville | [ ] |  | City of the company of the user. |
| `USER_COMPANY_COC_NUMBER` | `varchar2(240)` | Numéro CoC de l'entreprise utilisatrice | [ ] |  | CoC number of the company of the user. |
| `USER_COMPANY_COUNTRY` | `varchar2(4000)` | Pays de l'entreprise | [ ] |  | Country of the company of the user. |
| `USER_COMPANY_CURRENCY_CODE` | `varchar2(240)` | Code de devise de l'entreprise | [ ] |  | Currency code of the company of the user. |
| `USER_COMPANY_DATE_ESTABLISHED` | `date` | Entreprise de l'utilisateur Créée le | [ ] |  | Date established of the company of the user. |
| `USER_COMPANY_EMAIL_ADDRESS` | `varchar2(240)` | Adresse e-mail de l'entreprise de l'utilisateur | [ ] |  | Email address of the company of the user. |
| `USER_COMPANY_EMPLOYEES` | `int32` | Employés de l'entreprise utilisatrice | [ ] |  | Number of employees of the company of the user. |
| `USER_COMPANY_GLN_NUMBER` | `varchar2(240)` | Numéro GLN de l'entreprise | [ ] |  | GLN number of the company of the user. |
| `USER_COMPANY_IBAN` | `varchar2(4000)` | IBAN de l'entreprise | [ ] |  | IBAN of the company of the user. |
| `USER_COMPANY_ID` | `varchar2(4000)` | Identifiant de l'entreprise de l'utilisateur | [ ] |  | Unique ID of the company of the user. |
| `USER_COMPANY_LEGAL_STRUCTURE` | `varchar2(240)` | Structure juridique de l'entreprise utilisatrice | [ ] |  | Legal structure of the company of the user. |
| `USER_COMPANY_NAME` | `varchar2(4000)` | Nom de l'entreprise utilisateur | [ ] |  | Name of the company of the user. |
| `USER_COMPANY_PAYPAL_IDENTIFIER` | `varchar2(240)` | Identifiant PayPal de l'entreprise utilisatrice | [ ] |  | PayPal identifier of the company of the user. |
| `USER_COMPANY_PHONE` | `varchar2(4000)` | Utilisateur Entreprise Téléphone | [ ] |  | Phone of the company of the user. |
| `USER_COMPANY_POSTAL_CODE` | `varchar2(4000)` | Code postal de l'entreprise | [ ] |  | ZIP-code of the company of the user. |
| `USER_COMPANY_RSIN_NUMBER` | `varchar2(240)` | Numéro RSIN de l'entreprise utilisatrice | [ ] |  | RSIN number of the company of the user. |
| `USER_COMPANY_SIRET_NUMBER` | `varchar2(240)` | Entreprise de l'utilisateur - Numéro SIRET | [ ] |  | SIRET number of the company of the user. |
| `USER_COMPANY_STATE` | `varchar2(4000)` | Situation de l'entreprise | [ ] |  | State of the company of the user. |
| `USER_COMPANY_TRADENAMES` | `varchar2(240)` | Noms commerciaux des entreprises utilisatrices | [ ] |  | Tradenames of the company of the user. |
| `USER_COMPANY_VAT_NUMBER` | `varchar2(240)` | Numéro de TVA de l'entreprise utilisatrice | [ ] |  | VAT number of the company of the user. |
| `USER_COMPANY_WAGE_TAX_NUMBER` | `varchar2(240)` | Numéro d'identification fiscale de l'entreprise en matière de retenues à la source | [ ] |  | Wage tax number of the company of the user. |
| `USER_COMPANY_WEB_SITE` | `varchar2(4000)` | Site web de l'entreprise de l'utilisateur | [ ] |  | Web site of the company of the user. |
| `USER_EMAIL_ADDRESS` | `varchar2(240)` | Adresse e-mail de l'utilisateur | [ ] |  | User email address. |
| `USER_FIRST_NAME` | `varchar2(240)` | Prénom de l'utilisateur | [ ] |  | User first name. |
| `USER_GENDER` | `varchar2(30)` | Sexe de l'utilisateur | [ ] |  | User gender. |
| `USER_ID` | `varchar2(240)` | ID utilisateur | [ ] |  | User ID. |
| `USER_LANGUAGE` | `varchar2(240)` | Langue de l'utilisateur | [ ] |  | User language; the same value as the user language code. |
| `USER_LANGUAGE_CODE` | `varchar2(240)` | Code de langue de l'utilisateur | [ ] |  | User language code. |
| `USER_LAST_LOGON` | `datetime` | Dernière connexion de l'utilisateur | [ ] |  | User last logon. |
| `USER_LAST_NAME` | `varchar2(240)` | Nom de famille de l'utilisateur | [ ] |  | User last name. |
| `USER_LINKED_IN_ACCOUNT` | `varchar2(240)` | Compte LinkedIn de l'utilisateur | [ ] |  | User LinkedIn account URL. |
| `USER_LOG_ON_CODE` | `varchar2(240)` | Code de connexion utilisateur | [ ] |  | User log on code. |
| `USER_MIDDLE_NAME` | `varchar2(240)` | Deuxième prénom de l'utilisateur | [ ] |  | User middle name. |
| `USER_MOBILE_NUMBER` | `varchar2(240)` | Numéro de téléphone portable de l'utilisateur | [ ] |  | User mobile number. |
| `USER_NAME` | `varchar2(240)` | Nom d'Utilisateur | [ ] |  | User name. |
| `USER_NAME_AND_COMPANY` | `varchar2(240)` | Nom d'utilisateur et entreprise | [ ] |  | User name and company name. |
| `USER_NATIONALITY` | `varchar2(240)` | Nationalité de l'utilisateur | [ ] |  | User nationality. |
| `USER_PHONE_NUMBER` | `varchar2(240)` | Numéro de téléphone de l'utilisateur | [ ] |  | User phone number. |
| `USER_PICTURE_BLOB` | `blob` | Photo de profil (BLOB) | [ ] |  | User picture as BLOB. |
| `USER_PICTURE_MIME_TYPE` | `varchar2(240)` | Type MIME de l'image de profil | [ ] |  | User picture MIME type. |
| `USER_PICTURE_URL` | `varchar2(4000)` | Photo de profil (URL) | [ ] |  | User picture URL. |
| `USER_SKYPE_ACCOUNT` | `varchar2(240)` | Compte Skype de l'utilisateur | [ ] |  | User Skype account. |
| `USER_TITLE` | `varchar2(240)` | Titre de l'utilisateur | [ ] |  | User titlet. |
| `USER_TWITTER_ACCOUNT` | `varchar2(240)` | Compte Twitter de l'utilisateur | [ ] |  | User Twitter account. |
| `USER_WEBSITE_URL` | `varchar2(240)` | Site web de l'utilisateur | [ ] |  | User website URL. |

## Clés

| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
| `SYSTEMDATACONTAINERS_PROVIDER_NAME_SYSTEMPROVIDERS_fk` | `PROVIDER_NAME` | [SYSTEMPROVIDERS](DataDictionary.Invantive.SYSTEMPROVIDERS)`.NAME` | Key |  |

## Référencée

- [SESSIONIOS](DataDictionary.Invantive.SESSIONIOS) `PROVIDER_INSTANCE_UID` (Textual)
- [SESSIONROWSCHANGED](DataDictionary.Invantive.SESSIONROWSCHANGED) `PROVIDER_INSTANCE_UID` (Textual)
- [SYSTEMCATALOGS](DataDictionary.Invantive.SYSTEMCATALOGS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMDATACONTAINERATTRIBUTES](DataDictionary.Invantive.SYSTEMDATACONTAINERATTRIBUTES) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMDATACONTAINERHTTPCACHECONTENTS](DataDictionary.Invantive.SYSTEMDATACONTAINERHTTPCACHECONTENTS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMDATACONTAINERMESSAGES](DataDictionary.Invantive.SYSTEMDATACONTAINERMESSAGES) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMDATACONTAINERPROPERTIES](DataDictionary.Invantive.SYSTEMDATACONTAINERPROPERTIES) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMDATACONTAINERRESERVEDWORDS](DataDictionary.Invantive.SYSTEMDATACONTAINERRESERVEDWORDS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS](DataDictionary.Invantive.SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS](DataDictionary.Invantive.SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMDOMAINCODES](DataDictionary.Invantive.SYSTEMDOMAINCODES) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMDOMAINCODEVALUES](DataDictionary.Invantive.SYSTEMDOMAINCODEVALUES) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS](DataDictionary.Invantive.SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMLICENSES](DataDictionary.Invantive.SYSTEMLICENSES) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMOAUTHFLOWEVENTS](DataDictionary.Invantive.SYSTEMOAUTHFLOWEVENTS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMPACKAGEFUNCTIONARGUMENTS](DataDictionary.Invantive.SYSTEMPACKAGEFUNCTIONARGUMENTS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMPACKAGEFUNCTIONS](DataDictionary.Invantive.SYSTEMPACKAGEFUNCTIONS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMPACKAGES](DataDictionary.Invantive.SYSTEMPACKAGES) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMPARTITIONS](DataDictionary.Invantive.SYSTEMPARTITIONS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMPARTITIONSTATISTICS](DataDictionary.Invantive.SYSTEMPARTITIONSTATISTICS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMPARTITIONTAGS](DataDictionary.Invantive.SYSTEMPARTITIONTAGS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMPROVIDERSACTIVE](DataDictionary.Invantive.SYSTEMPROVIDERSACTIVE) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMSCHEMAS](DataDictionary.Invantive.SYSTEMSCHEMAS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMTABLECOLUMNS](DataDictionary.Invantive.SYSTEMTABLECOLUMNS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMTABLEFOREIGNKEYS](DataDictionary.Invantive.SYSTEMTABLEFOREIGNKEYS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMTABLEFUNCTIONPARAMETERS](DataDictionary.Invantive.SYSTEMTABLEFUNCTIONPARAMETERS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMTABLEKEYS](DataDictionary.Invantive.SYSTEMTABLEKEYS) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES) `PROVIDER_INSTANCE_UID` (Key)
- [SYSTEMVIEWS](DataDictionary.Invantive.SYSTEMVIEWS) `PROVIDER_INSTANCE_UID` (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)
