---
title: "ItemsBulk (Exact Online)"
description: "Items"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/exactonline/ExactOnlineREST.Logistics.ItemsBulk
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.Logistics.ItemsBulk
updated: 2026-11-16T20:55:33Z
license: https://documentation.invantive.eu/de/
---

# ItemsBulk: Exact Online Items

`read only` `per partition` `webhook` `REST`

- Katalog: `ExactOnlineREST`
- Schema: `Logistics`
- Primärschlüssel: `ID`
- Label: Items

Die Daten in dieser Tabelle sind nach dem Wert der Spalte `Division` aufgeteilt.

Es können nur Daten abgerufen werden.

Änderungen werden über das Webhook-Thema `Items` übermittelt.

## API-Quelle

- Endpunkt: `/api/v1/{division}/bulk/Logistics/Items`
- Metadaten: `/api/v1/{division}/bulk/Logistics/$metadata`

## Leistungsmerkmale

| Characteristic | Value |
|---|---:|
| Durchschnittliche Zugriffsverzögerung (ms) | 5 |
| Anzahl der Vollscan-Zeilen pro Minute | 20,000 |
| Anzahl der Query-Zeilen pro Minute | 300 |
| Zeilen pro Minute schreiben | 300 |

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

## Tabellenspalten

Die Spalten der Tabelle `ItemsBulk` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AssembledLeadDays` | `int32` | itgen_eol_assembledleaddays | [ ] | Filter auf der Plattform |  |
| `AverageCost` | `double` | Durchschnittskosten | [ ] | writable | The current average cost price. |
| `Barcode` | `varchar2` | Barcode | [ ] |  | Barcode of the item (numeric string). |
| `BatchQuantity` | `double` | Chargenmenge | [ ] | Filter auf der Plattform |  |
| `Class_01` | `varchar2` | Klassifikation 1 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 1. |
| `Class_02` | `varchar2` | Klassifikation 2 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 2. |
| `Class_03` | `varchar2` | Klassifikation 3 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 3. |
| `Class_04` | `varchar2` | Klassifikation 4 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 4. |
| `Class_05` | `varchar2` | Klassifikation 5 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 5. |
| `Class_06` | `varchar2` | Klassifikation 6 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 6. |
| `Class_07` | `varchar2` | Klassifikation 7 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 7. |
| `Class_08` | `varchar2` | Klassifikation 8 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 8. |
| `Class_09` | `varchar2` | Klassifikation 9 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 9. |
| `Class_10` | `varchar2` | Klassifikation 10 | [ ] | Filter auf der Plattform | Item class code referring to ItemClasses with ClassID 10. |
| `Code` | `varchar2` | Code | [ ] | Filter auf der Plattform | Item code. |
| `CopyRemarks` | `int16` | Bemerkungen kopieren | [x] |  | Copy sales remarks to sales lines. |
| `CostPriceCurrency` | `varchar2` | Einkaufspreis-Währung | [ ] |  | The currency of the current and proposed cost price. |
| `CostPriceNew` | `double` | Neupreis | [ ] | Filter auf der Plattform | Proposed cost price. |
| `CostPriceStandard` | `double` | Selbstkostenpreis-Standard | [ ] |  | The current standard cost price. |
| `Created` | `datetime` | Created | [ ] |  | Creation date. |
| `CreatedUtc` | `datetime` | Angelegt | [ ] | writable | Creation date in UTC. |
| `Creator` | `guid` | Creator | [ ] |  | User ID of creator. |
| `CreatorFullName` | `varchar2` | Ersteller vollständiger Name | [ ] |  | Name of creator. |
| `CustomField` | `varchar2` | Benutzerdefiniertes Feld | [ ] |  |  |
| `Description` | `varchar2` | Description | [ ] |  | Description of the item. |
| `Division` | `int32` | Abteilung ID | [x] |  | Unique number of the Exact Online division. |
| `DivisionCompanyCoCNumber` | `varchar2(60)` | Nummer der Handelskammer des Bezirks | [ ] | writable | Chamber of commerce number of the Exact Online division. |
| `DivisionCompanyIBANNumber` | `varchar2(50)` | Abteilung IBAN-Nummer | [ ] | writable | IBAN number of the Exact Online division. |
| `DivisionCompanyName` | `varchar2(50)` | Geschäftsbereich Firmenname | [x] | writable | Company name of the Exact Online division. |
| `DivisionCompanyRSINNumber` | `varchar2(9)` | Abteilung RSIN-Nummer | [ ] | writable | RSIN number of the Exact Online division. |
| `DivisionCompanyVATNumber` | `varchar2(35)` | Umsatzsteuer-Identifikationsnummer der Abteilung | [ ] | writable | VAT number of the Exact Online division. |
| `DivisionCompanyWageTaxNumber` | `varchar2(60)` | Nummer der Lohnsteuerabteilung | [ ] | writable | Wage tax number of the Exact Online division. |
| `DivisionLabel` | `varchar2(128)` | Abteilungsbezeichnung | [x] | writable | Label of the Exact Online division. |
| `DivisionName` | `varchar2(50)` | Verwaltung Name | [x] | writable | Name of the Exact Online division. |
| `DivisionOwnerCompanyName` | `varchar2(50)` | Name des Abonnenten | [x] | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionOwnerCompanyNumber` | `varchar2(18)` | Abonnentennummer | [x] | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionShortName` | `int64` | Kurzbezeichnung der Abteilung | [x] | writable | Short name of the Exact Online division. |
| `EndDate` | `datetime` | Enddatum | [ ] | Filter auf der Plattform | Together with StartDate this determines if the item is active. |
| `ExtraDescription` | `varchar2` | Extra Beschreibung | [ ] |  | Extra description text, slightly longer than the regular description (255 instead of 60). |
| `FreeBoolField_01` | `char` | Freies Boolesches Feld Nr. 1 | [ ] |  | Free boolean field 1. |
| `FreeBoolField_02` | `char` | Freies Boolesches Feld Nr. 2 | [ ] |  | Free boolean field 2. |
| `FreeBoolField_03` | `char` | Freies Boolesches Feld Nr. 3 | [ ] |  | Free boolean field 3. |
| `FreeBoolField_04` | `char` | Freies Boolesches Feld Nr. 4 | [ ] |  | Free boolean field 4. |
| `FreeBoolField_05` | `char` | Freies Boolesches Feld Nr. 5 | [ ] |  | Free boolean field 5. |
| `FreeDateField_01` | `datetime` | Freies Datumsfeld Nr. 1 | [ ] |  | Free date field 1. |
| `FreeDateField_02` | `datetime` | Freies Datumsfeld Nr. 2 | [ ] |  | Free date field 2. |
| `FreeDateField_03` | `datetime` | Freies Datumsfeld Nr. 3 | [ ] |  | Free date field 3. |
| `FreeDateField_04` | `datetime` | Freies Datumsfeld Nr. 4 | [ ] |  | Free date field 4. |
| `FreeDateField_05` | `datetime` | Freies Datumsfeld Nr. 5 | [ ] |  | Free date field 5. |
| `FreeNumberField_01` | `double` | Freies Zahlenfeld Nr. 1 | [ ] |  | Free numeric field 1. |
| `FreeNumberField_02` | `double` | Freies Zahlenfeld Nr. 2 | [ ] |  | Free numeric field 2. |
| `FreeNumberField_03` | `double` | Freies Zahlenfeld Nr. 3 | [ ] |  | Free numeric field 3. |
| `FreeNumberField_04` | `double` | Freies Zahlenfeld Nr. 4 | [ ] |  | Free numeric field 4. |
| `FreeNumberField_05` | `double` | Freies Zahlenfeld Nr. 5 | [ ] |  | Free numeric field 5. |
| `FreeNumberField_06` | `double` | Freies Zahlenfeld Nr. 6 | [ ] |  | Free numeric field 6. |
| `FreeNumberField_07` | `double` | Freies Zahlenfeld Nr. 7 | [ ] |  | Free numeric field 7. |
| `FreeNumberField_08` | `double` | Freies Zahlenfeld Nr. 8 | [ ] |  | Free numeric field 8. |
| `FreeTextField_01` | `varchar2` | Freitextfeld Nr. 1 | [ ] |  | Free text field 1. |
| `FreeTextField_02` | `varchar2` | Freitextfeld Nr. 2 | [ ] |  | Free text field 2. |
| `FreeTextField_03` | `varchar2` | Freitextfeld Nr. 3 | [ ] |  | Free text field 3. |
| `FreeTextField_04` | `varchar2` | Freitextfeld Nr. 4 | [ ] |  | Free text field 4. |
| `FreeTextField_05` | `varchar2` | Freitextfeld Nr. 5 | [ ] |  | Free text field 5. |
| `FreeTextField_06` | `varchar2` | Freitextfeld Nr. 6 | [ ] |  | Free text field 6. |
| `FreeTextField_07` | `varchar2` | Freitextfeld Nr. 7 | [ ] |  | Free text field 7. |
| `FreeTextField_08` | `varchar2` | Freitextfeld Nr. 8 | [ ] |  | Free text field 8. |
| `FreeTextField_09` | `varchar2` | Freitextfeld Nr. 9 | [ ] |  | Free text field 9. |
| `FreeTextField_10` | `varchar2` | Freitextfeld Nr. 10 | [ ] |  | Free text field 10. |
| `GLCosts` | `guid` | Hauptbuch Kosten | [ ] | Filter auf der Plattform | GL account the cost entries will be booked on.This overrules the GL account from the item group.If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. |
| `GLCostsCode` | `varchar2` | Kosten nach GL-Kontencode | [ ] |  | Code of GL account for costs. |
| `GLCostsDescription` | `varchar2` | GL-Kontobezeichnung Kosten | [ ] |  | Description of GLCosts. |
| `GLCostsWorkInProgress` | `guid` | itgen_eol_glcostsworkinprogress | [ ] | Filter auf der Plattform |  |
| `GLCostsWorkInProgressCode` | `varchar2` | itgen_eol_glcostsworkinprogresscode | [ ] | Filter auf der Plattform |  |
| `GLCostsWorkInProgressDescription` | `varchar2` | itgen_eol_glcostsworkinprogressdescription | [ ] | Filter auf der Plattform |  |
| `GLRevenue` | `guid` | Hauptbuch Einnahmen | [ ] | Filter auf der Plattform | GL account the revenue will be booked on.This overrules the GL account from the item group.If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. |
| `GLRevenueCode` | `varchar2` | GL-Kontocode: Umsatz | [ ] |  | Code of GLRevenue. |
| `GLRevenueDescription` | `varchar2` | GL-Kontobezeichnung: Umsatz | [ ] |  | Description of GLRevenue. |
| `GLRevenueWorkInProgress` | `guid` | itgen_eol_glrevenueworkinprogress | [ ] | Filter auf der Plattform |  |
| `GLRevenueWorkInProgressCode` | `varchar2` | itgen_eol_glrevenueworkinprogresscode | [ ] | Filter auf der Plattform |  |
| `GLRevenueWorkInProgressDescription` | `varchar2` | itgen_eol_glrevenueworkinprogressdescription | [ ] | Filter auf der Plattform |  |
| `GLStock` | `guid` | GL-Kontobestand | [ ] | Filter auf der Plattform | GL account the stock entries will be booked on.This overrules the GL account from the item group.If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. |
| `GLStockCode` | `varchar2` | GL-Kontencode Bestand | [ ] |  | Code of GL account for stock. |
| `GLStockDescription` | `varchar2` | GL-Kontobezeichnung: Lagerbestand | [ ] |  | Description of GLStock. |
| `GrossWeight` | `double` | Bruttogewicht | [ ] |  | Gross weight for international goods shipments. |
| `ID` | `guid` | ID | [x] | Filter auf der Plattform | Primary key. |
| `IsBatchItem` | `int16` | Ist es ein Chargenartikel? | [x] |  | Indicates if batches are used for this item. |
| `IsBatchNumberItem` | `int16` | Ist die Chargennummer vorhanden? | [ ] |  | This property is obsolete.Use property 'IsBatchItem' instead. |
| `IsFractionAllowedItem` | `char` | Sind Brüche bei diesem Artikel zulässig? | [ ] |  | Indicates if fractions (for example 0.35) are allowed for quantities of this item. |
| `IsMakeItem` | `int16` | Ist „Make Item“ | [x] | Filter auf der Plattform | Indicates that an Item is produced to Inventory, not purchased. |
| `IsNewContract` | `int16` | Ist neuer Vertrag | [x] |  | Only used for packages (IsPackageItem=1).To indicate if this package is a new contract type package. |
| `IsOnDemandItem` | `int16` | Ist ein Artikel auf Anfrage | [x] |  | Is On demand Item. |
| `IsPackageItem` | `char` | Ist Paketartikel | [ ] |  | Indicates if the item is a package item.Can only be created in the hosting administration. |
| `IsPurchaseItem` | `char` | Ist es ein Kaufartikel? | [ ] | Filter auf der Plattform | Indicates if the item can be purchased. |
| `IsRegistrationCodeItem` | `int16` | Ist ein Registrierungscode-Element | [x] |  | Indicated if the item is used in voucher functionality. |
| `IsSalesItem` | `char` | Ist ein Verkaufsartikel? | [ ] | Filter auf der Plattform | Indicates if the item can be sold. |
| `IsSerialItem` | `char` | Ist Serienartikel | [ ] |  | Indicates that serial numbers are used for this item. |
| `IsSerialNumberItem` | `char` | Ist die Seriennummer vorhanden? | [ ] |  | This property is obsolete.Use property 'IsSerialItem' instead. |
| `IsStockItem` | `char` | Ist Lagerware? | [ ] | Filter auf der Plattform | If you have the Trade or Manufacturing license and you check this property the item will be shown in the stock positions overview, stock counts and transaction lists.If you have the Invoice module and you check this property you will get a general journal entry based on the Stock and Costs G/L accounts of the item group.If you don't want the general journal entry to be created you should change the Stock/Costs G/L account on the Item group page to the type Costs instead of Inventory. |
| `IsSubcontractedItem` | `char` | Ist es ein untervergebenes Produkt? | [ ] | Filter auf der Plattform | Indicates if the item is provided by an outside supplier. |
| `IsTaxableItem` | `int16` | Ist steuerpflichtig | [ ] |  | Indicates if tax needs to be calculated for this item. |
| `IsTime` | `int16` | Ist Zeit | [x] |  | Indicates if the item is a time unit item (for example a labor hour item). |
| `IsWebshopItem` | `int16` | Ist ein Artikel im Webshop? | [x] |  | Indicates if the item can be exported to a web shop. |
| `ItemGroup` | `guid` | Ist Artikelgruppe | [ ] | Filter auf der Plattform | GUID of Item group of the item. |
| `ItemGroupCode` | `varchar2` | Artikel Gruppencode | [ ] |  | Code of ItemGroup. |
| `ItemGroupDescription` | `varchar2` | Artikel Gruppenbeschreibung | [ ] |  | Description of ItemGroup. |
| `Modified` | `datetime` | Modified | [ ] |  | Last modified date. |
| `ModifiedUtc` | `datetime` | Geändert (UTC) | [ ] | writable | Last modified date in UTC. |
| `Modifier` | `guid` | Modifier | [ ] |  | User ID of modifier. |
| `ModifierFullName` | `varchar2` | Geänderter vollständiger Name | [ ] |  | Name of modifier. |
| `NetWeight` | `double` | Nettogewicht | [ ] |  | Net weight for international goods shipments. |
| `NetWeightUnit` | `varchar2` | Nettogewichtseinheit | [ ] | Filter auf der Plattform | Net Weight unit for international goods shipment, only available in manufacturing packages. |
| `Notes` | `varchar2` | Notes | [ ] |  | Notes. |
| `Picture` | `blob` | Picture | [ ] | Filter auf der Plattform |  |
| `PictureName` | `varchar2` | Bildname | [ ] |  | File name of picture. |
| `PictureThumbnailUrl` | `varchar2` | Bild-Miniaturansicht (URL) | [ ] |  | Url where thumbnail picture can be retrieved. |
| `PictureUrl` | `varchar2` | Bild (URL) | [ ] |  | Url where picture can be retrieved. |
| `SalesVatCode` | `varchar2` | Verkauf USt.-Code | [ ] |  | Code of SalesVat. |
| `SalesVatCodeDescription` | `varchar2` | Vertrieb USt. Code Beschreibung | [ ] |  | Description of SalesVatCode. |
| `SearchCode` | `varchar2` | Suche Code | [ ] | Filter auf der Plattform | Search code of the item. |
| `SecurityLevel` | `int32` | Sicherheitsstufe | [ ] |  | Security level (0 - 100). |
| `StandardSalesPrice` | `double` | Standardverkaufspreis | [ ] |  |  |
| `StartDate` | `datetime` | Anfangsdatum | [ ] | Filter auf der Plattform | Together with EndDate this determines if the item is active. |
| `StatisticalCode` | `varchar2` | Statistischer Code | [ ] |  |  |
| `StatisticalNetWeight` | `double` | Statistisches Nettogewicht | [ ] |  |  |
| `StatisticalUnits` | `double` | Statistische Einheiten | [ ] |  |  |
| `StatisticalValue` | `double` | Statistischer Wert | [ ] |  |  |
| `Stock` | `double` | Stock | [ ] |  | Quantity that is in stock. |
| `Unit` | `varchar2` | Unit | [ ] | Filter auf der Plattform | The standard unit of this item. |
| `UnitDescription` | `varchar2` | Maßeinheit Beschreibung | [ ] |  | Description of Unit. |
| `UnitType` | `varchar2` | Einheitstyp | [ ] |  | Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight. |
| `UseExplosion` | `int16` | itgen_eol_useexplosion | [ ] | Filter auf der Plattform |  |

## Tasten

| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
| `ItemsBulk_Creator_Users_fk` | `Creator` | [Users](ExactOnlineREST.Users.Users)`.UserID` | Key |  |
| `ItemsBulk_GLCosts_GLAccounts_fk` | `GLCosts` | [GLAccounts](ExactOnlineREST.Financial.GLAccounts)`.ID` | Key |  |
| `ItemsBulk_GLRevenue_GLAccounts_fk` | `GLRevenue` | [GLAccounts](ExactOnlineREST.Financial.GLAccounts)`.ID` | Key |  |
| `ItemsBulk_GLStock_GLAccounts_fk` | `GLStock` | [GLAccounts](ExactOnlineREST.Financial.GLAccounts)`.ID` | Key |  |
| `ItemsBulk_ItemGroup_ItemGroups_fk` | `ItemGroup` | [ItemGroups](ExactOnlineREST.Logistics.ItemGroups)`.ID` | Key |  |
| `ItemsBulk_Modifier_Users_fk` | `Modifier` | [Users](ExactOnlineREST.Users.Users)`.UserID` | Key |  |
| `ItemsBulk_Unit_Units_fk` | `Unit` | [Units](ExactOnlineREST.Logistics.Units)`.Code` | Key |  |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

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