---
title: "ItemsEx (Exact Online)"
description: "Items"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/exactonline/ExactOnlineXML.XML.ItemsEx
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineXML.XML.ItemsEx
updated: 2026-11-16T21:01:21Z
license: https://documentation.invantive.eu/fr/
---

# ItemsEx: Exact Online Items

`insert` `update` `per partition` `XML`

- Catalogue : `ExactOnlineXML`
- Schéma : `XML`
- Clés primaires : `code_attr`
- Label: Items

Les données de cette table sont partitionnées en fonction de la valeur de la colonne `Division`.

Permet de récupérer et de modifier des données à l'aide de `insert` et `update`.

## Résumé

The ExactOnlineXML table "Items" also contains the values of additional fields defined on Items in columns such as "ITEMEXTRAFIELDS_EXTRAFIELD1", which are also known as "Extra fields" or "Free fields". The REST API "ItemExtraField" is not supported since it requires one call for each Item which would quickly deplete the allowance of API requests. The REST API "Items" has no values for the free fields currently.

Additional where-clause columns supported:
- division
- downloadid
- code
- assortmentcode
- topselection
- itemstatus
- ispurchase
- isstock
- issales
- ismake
- isordercontroled
- istime
- iswebshop
- isserial
- isbatch

## Source de l'API

- Service XML : `Items`
- Rubrique XML : `Items`
- Chemin XML : `/`

## Paramètres

| Name | Type de données | Required | Default | Documentation |
|---|---|:---:|---|---|
| `division` | `int32` | [ ] |  | Company code. |
| `Params_AssortmentCode` | `varchar2` | [ ] |  | Code. |
| `Params_ClassName1` | `varchar2` | [ ] |  | Class code. |
| `Params_ClassName10` | `varchar2` | [ ] |  | Class code. |
| `Params_ClassName2` | `varchar2` | [ ] |  | Class code. |
| `Params_ClassName3` | `varchar2` | [ ] |  | Class code. |
| `Params_ClassName4` | `varchar2` | [ ] |  | Class code. |
| `Params_ClassName5` | `varchar2` | [ ] |  | Class code. |
| `Params_ClassName6` | `varchar2` | [ ] |  | Class code. |
| `Params_ClassName7` | `varchar2` | [ ] |  | Class code. |
| `Params_ClassName8` | `varchar2` | [ ] |  | Class code. |
| `Params_ClassName9` | `varchar2` | [ ] |  | Class code. |
| `Params_Code` | `varchar2` | [ ] |  | Assortment code. |
| `Params_DownloadID` | `varchar2` | [ ] |  | Data subscription token. |
| `Params_IsBatch` | `boolean` | [ ] |  | Property: batch. |
| `Params_IsMake` | `boolean` | [ ] |  | Property: make. |
| `Params_IsOrderControled` | `boolean` | [ ] |  | Property: order controlled. |
| `Params_IsPurchase` | `boolean` | [ ] |  | Property: purchase. |
| `Params_IsSales` | `boolean` | [ ] |  | Property: sales. |
| `Params_IsSerial` | `boolean` | [ ] |  | Property: serial number. |
| `Params_IsStock` | `boolean` | [ ] |  | Property: stock. |
| `Params_IsTime` | `boolean` | [ ] |  | Property: time. |
| `Params_IsWebshop` | `boolean` | [ ] |  | Property: web shop. |
| `Params_ItemStatus` | `varchar2` | [ ] |  | Multi-select; 1: active, 2: future, 4: inactive. |
| `Params_TopSelection` | `int32` | [ ] |  | Maximum number to retrieve. |

## Colonnes de table

Les colonnes de la table `ItemsEx` 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 |
|---|---|---|:---:|---|---|


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

- [Exact Online](/fr/release-notes/drivers?driver=exact-online)
