---
title: "JSONRECORDTYPECOLUMNS (Data Dictionary)"
description: "JSON Record Type Columns"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/datadictionary/DataDictionary.Invantive.JSONRECORDTYPECOLUMNS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.JSONRECORDTYPECOLUMNS
updated: 2026-11-16T20:44:51Z
license: https://documentation.invantive.eu/fr/
---

# JSONRECORDTYPECOLUMNS: Data Dictionary JSON Record Type Columns

`read only`

- Catalogue : `DataDictionary`
- Schéma : `Invantive`
- Label: JSON Record Type Columns

The columns of the JSON record types of the products, one row per property of every type as its specification describes it.

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

## Colonnes de table

Les colonnes de la table `JSONRECORDTYPECOLUMNS` 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 |
|---|---|---|:---:|---|---|
| `CLR_PROPERTY` | `varchar2(240)` | Property | [ ] |  | Name of the .NET property, when it differs from the JSON name. |
| `CLR_TYPE` | `varchar2(240)` | Type | [ ] |  | Full name of the .NET type of the property. |
| `DESCRIPTION` | `clob` | Description | [ ] |  | What the value holds, as written in the specification. |
| `ENUM_VALUES` | `varchar2(4000)` | Valeurs d'énumération | [ ] |  | The members of an enumeration as written, separated by commas; empty for other values. |
| `EXAMPLE` | `varchar2(1024)` | Example | [ ] |  | An example value, as text. |
| `ID` | `number` | ID | [x] |  | Sequence number of the column over all record types. |
| `JSON_FORMAT` | `varchar2(60)` | Format JSON | [ ] |  | OpenAPI format of the value, such as date-time, uuid or int64, when the type alone does not say it. |
| `JSON_TYPE` | `varchar2(60)` | Type JSON | [x] |  | OpenAPI type of the value: string, integer, number, boolean, array or object. |
| `LABEL` | `varchar2(240)` | Label | [ ] |  | Label of the column, as a user interface shows it. |
| `NAME` | `varchar2(240)` | Name | [x] |  | Name of the column, which is the JSON name of the property. |
| `NULLABLE` | `boolean` | Nullable | [x] |  | Whether the value may be absent or null. |
| `POSITION` | `number` | Position | [x] |  | Position of the column, counted from 1 in the order the serializer writes the properties. |
| `RECORD_TYPE` | `varchar2(240)` | Type d'enregistrement | [x] |  | Full name of the .NET type whose instances are the records. |
| `TABLE_NAME` | `varchar2(240)` | Nom de la table | [x] |  | Name of the table the files are read as by the Big Data JSON driver. |

## Clés

| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
| `JSONRECORDTYPECOLUMNS_RECORD_TYPE_JSONRECORDTYPES_fk` | `RECORD_TYPE` | [JSONRECORDTYPES](DataDictionary.Invantive.JSONRECORDTYPES)`.RECORD_TYPE` | 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)
