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

# ItemsBulk: Exact Online Items

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

- Catalogus: `ExactOnlineREST`
- Schema: `Logistics`
- Primaire sleutels: `ID`
- Label: Items

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom `Division`.

Kan alleen gegevens ophalen.

Wijzigingen worden doorgegeven via het webhook-onderwerp `Items`.

## API-bron

- Eindpunt: `/api/v1/{division}/bulk/Logistics/Items`
- Metagegevens: `/api/v1/{division}/bulk/Logistics/$metadata`

## Prestatiekenmerken

| Characteristic | Value |
|---|---:|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 20,000 |
| Aantal rijen per minuut in een Query | 300 |
| Aantal rijen per minuut schrijven | 300 |

Het resultaat kan op de client in de Cache worden opgeslagen.

## Tabelkolommen

De kolommen van de tabel `ItemsBulk` 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 |
|---|---|---|:---:|---|---|
| `AssembledLeadDays` | `int32` | itgen_eol_assembledleaddays | [ ] | filters op het platform |  |
| `AverageCost` | `double` | Gemiddelde Kosten | [ ] | writable | The current average cost price. |
| `Barcode` | `varchar2` | Barcode | [ ] |  | Barcode of the item (numeric string). |
| `BatchQuantity` | `double` | Batchomvang | [ ] | filters op het platform |  |
| `Class_01` | `varchar2` | Classificatie 1 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 1. |
| `Class_02` | `varchar2` | Classificatie 2 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 2. |
| `Class_03` | `varchar2` | Classificatie 3 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 3. |
| `Class_04` | `varchar2` | Classificatie 4 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 4. |
| `Class_05` | `varchar2` | Classificatie 5 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 5. |
| `Class_06` | `varchar2` | Classificatie 6 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 6. |
| `Class_07` | `varchar2` | Classificatie 7 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 7. |
| `Class_08` | `varchar2` | Classificatie 8 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 8. |
| `Class_09` | `varchar2` | Classificatie 9 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 9. |
| `Class_10` | `varchar2` | Classificatie 10 | [ ] | filters op het platform | Item class code referring to ItemClasses with ClassID 10. |
| `Code` | `varchar2` | Code | [ ] | filters op het platform | Item code. |
| `CopyRemarks` | `int16` | Kopie Opmerkingen | [x] |  | Copy sales remarks to sales lines. |
| `CostPriceCurrency` | `varchar2` | Kostprijsvaluta | [ ] |  | The currency of the current and proposed cost price. |
| `CostPriceNew` | `double` | Kostprijs Nieuw | [ ] | filters op het platform | Proposed cost price. |
| `CostPriceStandard` | `double` | Standaard Kostprijs | [ ] |  | The current standard cost price. |
| `Created` | `datetime` | Created | [ ] |  | Creation date. |
| `CreatedUtc` | `datetime` | Aangemaakt (UTC) | [ ] | writable | Creation date in UTC. |
| `Creator` | `guid` | Creator | [ ] |  | User ID of creator. |
| `CreatorFullName` | `varchar2` | Aanmaker Volledige Naam | [ ] |  | Name of creator. |
| `CustomField` | `varchar2` | Aangepast Veld | [ ] |  |  |
| `Description` | `varchar2` | Description | [ ] |  | Description of the item. |
| `Division` | `int32` | Divisie ID | [x] |  | Unique number of the Exact Online division. |
| `DivisionCompanyCoCNumber` | `varchar2(60)` | Divisie Kamer van Koophandel Nummer | [ ] | writable | Chamber of commerce number of the Exact Online division. |
| `DivisionCompanyIBANNumber` | `varchar2(50)` | Divisie IBAN Nummer | [ ] | writable | IBAN number of the Exact Online division. |
| `DivisionCompanyName` | `varchar2(50)` | Divisie Bedrijfsnaam | [x] | writable | Company name of the Exact Online division. |
| `DivisionCompanyRSINNumber` | `varchar2(9)` | Divisie RSIN Nummer | [ ] | writable | RSIN number of the Exact Online division. |
| `DivisionCompanyVATNumber` | `varchar2(35)` | Divisie BTW Nummer | [ ] | writable | VAT number of the Exact Online division. |
| `DivisionCompanyWageTaxNumber` | `varchar2(60)` | Divisie Loonbelastingnummer | [ ] | writable | Wage tax number of the Exact Online division. |
| `DivisionLabel` | `varchar2(128)` | Divisie Label | [x] | writable | Label of the Exact Online division. |
| `DivisionName` | `varchar2(50)` | Administratie Naam | [x] | writable | Name of the Exact Online division. |
| `DivisionOwnerCompanyName` | `varchar2(50)` | Naam Abonnementhouder | [x] | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionOwnerCompanyNumber` | `varchar2(18)` | Abonnementhoudernummer | [x] | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionShortName` | `int64` | Divisie Korte Naam | [x] | writable | Short name of the Exact Online division. |
| `EndDate` | `datetime` | Einddatum | [ ] | filters op het platform | Together with StartDate this determines if the item is active. |
| `ExtraDescription` | `varchar2` | Extra Omschrijving | [ ] |  | Extra description text, slightly longer than the regular description (255 instead of 60). |
| `FreeBoolField_01` | `char` | Vrij Booleaans Veld #1 | [ ] |  | Free boolean field 1. |
| `FreeBoolField_02` | `char` | Vrij Booleaans Veld #2 | [ ] |  | Free boolean field 2. |
| `FreeBoolField_03` | `char` | Vrij Booleaans Veld #3 | [ ] |  | Free boolean field 3. |
| `FreeBoolField_04` | `char` | Vrij Booleaans Veld #4 | [ ] |  | Free boolean field 4. |
| `FreeBoolField_05` | `char` | Vrij Booleaans Veld #5 | [ ] |  | Free boolean field 5. |
| `FreeDateField_01` | `datetime` | Vrij Datumveld #1 | [ ] |  | Free date field 1. |
| `FreeDateField_02` | `datetime` | Vrij Datumveld #2 | [ ] |  | Free date field 2. |
| `FreeDateField_03` | `datetime` | Vrij Datumveld #3 | [ ] |  | Free date field 3. |
| `FreeDateField_04` | `datetime` | Vrij Datumveld #4 | [ ] |  | Free date field 4. |
| `FreeDateField_05` | `datetime` | Vrij Datumveld #5 | [ ] |  | Free date field 5. |
| `FreeNumberField_01` | `double` | Vrij Numeriek Veld #1 | [ ] |  | Free numeric field 1. |
| `FreeNumberField_02` | `double` | Vrij Numeriek Veld #2 | [ ] |  | Free numeric field 2. |
| `FreeNumberField_03` | `double` | Vrij Numeriek Veld #3 | [ ] |  | Free numeric field 3. |
| `FreeNumberField_04` | `double` | Vrij Numeriek Veld #4 | [ ] |  | Free numeric field 4. |
| `FreeNumberField_05` | `double` | Vrij Numeriek Veld #5 | [ ] |  | Free numeric field 5. |
| `FreeNumberField_06` | `double` | Vrij Numeriek Veld #6 | [ ] |  | Free numeric field 6. |
| `FreeNumberField_07` | `double` | Vrij Numeriek Veld #7 | [ ] |  | Free numeric field 7. |
| `FreeNumberField_08` | `double` | Vrij Numeriek Veld #8 | [ ] |  | Free numeric field 8. |
| `FreeTextField_01` | `varchar2` | Vrij Tekstveld #1 | [ ] |  | Free text field 1. |
| `FreeTextField_02` | `varchar2` | Vrij Tekstveld #2 | [ ] |  | Free text field 2. |
| `FreeTextField_03` | `varchar2` | Vrij Tekstveld #3 | [ ] |  | Free text field 3. |
| `FreeTextField_04` | `varchar2` | Vrij Tekstveld #4 | [ ] |  | Free text field 4. |
| `FreeTextField_05` | `varchar2` | Vrij Tekstveld #5 | [ ] |  | Free text field 5. |
| `FreeTextField_06` | `varchar2` | Vrij Tekstveld #6 | [ ] |  | Free text field 6. |
| `FreeTextField_07` | `varchar2` | Vrij Tekstveld #7 | [ ] |  | Free text field 7. |
| `FreeTextField_08` | `varchar2` | Vrij Tekstveld #8 | [ ] |  | Free text field 8. |
| `FreeTextField_09` | `varchar2` | Vrij Tekstveld #9 | [ ] |  | Free text field 9. |
| `FreeTextField_10` | `varchar2` | Vrij Tekstveld #10 | [ ] |  | Free text field 10. |
| `GLCosts` | `guid` | Grootboek Kosten | [ ] | filters op het platform | 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` | Grootboekrekening Kosten | [ ] |  | Code of GL account for costs. |
| `GLCostsDescription` | `varchar2` | Grootboekrekening Omschrijving Kosten | [ ] |  | Description of GLCosts. |
| `GLCostsWorkInProgress` | `guid` | itgen_eol_glcostsworkinprogress | [ ] | filters op het platform |  |
| `GLCostsWorkInProgressCode` | `varchar2` | itgen_eol_glcostsworkinprogresscode | [ ] | filters op het platform |  |
| `GLCostsWorkInProgressDescription` | `varchar2` | itgen_eol_glcostsworkinprogressdescription | [ ] | filters op het platform |  |
| `GLRevenue` | `guid` | Grootboek Omzet | [ ] | filters op het platform | 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` | Grootboekrekening Code Opbrengst. | [ ] |  | Code of GLRevenue. |
| `GLRevenueDescription` | `varchar2` | Grootboekrekening Omschrijving Opbrengst | [ ] |  | Description of GLRevenue. |
| `GLRevenueWorkInProgress` | `guid` | itgen_eol_glrevenueworkinprogress | [ ] | filters op het platform |  |
| `GLRevenueWorkInProgressCode` | `varchar2` | itgen_eol_glrevenueworkinprogresscode | [ ] | filters op het platform |  |
| `GLRevenueWorkInProgressDescription` | `varchar2` | itgen_eol_glrevenueworkinprogressdescription | [ ] | filters op het platform |  |
| `GLStock` | `guid` | Grootboekrekening Voorraad | [ ] | filters op het platform | 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` | Grootboekrekeningcode Voorraad | [ ] |  | Code of GL account for stock. |
| `GLStockDescription` | `varchar2` | Grootboekrekeningomschrijving Voorraad | [ ] |  | Description of GLStock. |
| `GrossWeight` | `double` | Brutogewicht | [ ] |  | Gross weight for international goods shipments. |
| `ID` | `guid` | ID | [x] | filters op het platform | Primary key. |
| `IsBatchItem` | `int16` | Is Batchartikel | [x] |  | Indicates if batches are used for this item. |
| `IsBatchNumberItem` | `int16` | Is Batch-Nummer Item | [ ] |  | This property is obsolete.Use property 'IsBatchItem' instead. |
| `IsFractionAllowedItem` | `char` | Is Fraction Toegestaan op Artikel | [ ] |  | Indicates if fractions (for example 0.35) are allowed for quantities of this item. |
| `IsMakeItem` | `int16` | Is Maakartikel | [x] | filters op het platform | Indicates that an Item is produced to Inventory, not purchased. |
| `IsNewContract` | `int16` | Is Nieuw Contract | [x] |  | Only used for packages (IsPackageItem=1).To indicate if this package is a new contract type package. |
| `IsOnDemandItem` | `int16` | Is Artikel op Aanvraag | [x] |  | Is On demand Item. |
| `IsPackageItem` | `char` | Is Pakket Item | [ ] |  | Indicates if the item is a package item.Can only be created in the hosting administration. |
| `IsPurchaseItem` | `char` | Is Aankoopitem | [ ] | filters op het platform | Indicates if the item can be purchased. |
| `IsRegistrationCodeItem` | `int16` | Is Registratie Code Item | [x] |  | Indicated if the item is used in voucher functionality. |
| `IsSalesItem` | `char` | Is verkoopartikel | [ ] | filters op het platform | Indicates if the item can be sold. |
| `IsSerialItem` | `char` | Is Serienummer Artikel | [ ] |  | Indicates that serial numbers are used for this item. |
| `IsSerialNumberItem` | `char` | Is Serienummer Artikel | [ ] |  | This property is obsolete.Use property 'IsSerialItem' instead. |
| `IsStockItem` | `char` | Is Voorraadartikel | [ ] | filters op het platform | 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` | Is Uitbesteed Item | [ ] | filters op het platform | Indicates if the item is provided by an outside supplier. |
| `IsTaxableItem` | `int16` | Is Belastbaar Artikel | [ ] |  | Indicates if tax needs to be calculated for this item. |
| `IsTime` | `int16` | Is Tijd | [x] |  | Indicates if the item is a time unit item (for example a labor hour item). |
| `IsWebshopItem` | `int16` | Is Webshopartikel | [x] |  | Indicates if the item can be exported to a web shop. |
| `ItemGroup` | `guid` | Is Artikelgroep | [ ] | filters op het platform | GUID of Item group of the item. |
| `ItemGroupCode` | `varchar2` | Artikelgroep Code | [ ] |  | Code of ItemGroup. |
| `ItemGroupDescription` | `varchar2` | Artikelgroep Omschrijving | [ ] |  | Description of ItemGroup. |
| `Modified` | `datetime` | Modified | [ ] |  | Last modified date. |
| `ModifiedUtc` | `datetime` | Gewijzigd (UTC) | [ ] | writable | Last modified date in UTC. |
| `Modifier` | `guid` | Modifier | [ ] |  | User ID of modifier. |
| `ModifierFullName` | `varchar2` | Gewijzigd Volledige Naam | [ ] |  | Name of modifier. |
| `NetWeight` | `double` | Netto Gewicht | [ ] |  | Net weight for international goods shipments. |
| `NetWeightUnit` | `varchar2` | Netto Gewichtseenheid | [ ] | filters op het platform | Net Weight unit for international goods shipment, only available in manufacturing packages. |
| `Notes` | `varchar2` | Notes | [ ] |  | Notes. |
| `Picture` | `blob` | Picture | [ ] | filters op het platform |  |
| `PictureName` | `varchar2` | Naam Afbeelding | [ ] |  | File name of picture. |
| `PictureThumbnailUrl` | `varchar2` | Miniatuurafbeelding (URL) | [ ] |  | Url where thumbnail picture can be retrieved. |
| `PictureUrl` | `varchar2` | Afbeelding (URL) | [ ] |  | Url where picture can be retrieved. |
| `SalesVatCode` | `varchar2` | Verkoop BTW Code | [ ] |  | Code of SalesVat. |
| `SalesVatCodeDescription` | `varchar2` | Verkoop BTW Code Omschrijving | [ ] |  | Description of SalesVatCode. |
| `SearchCode` | `varchar2` | Zoekcode | [ ] | filters op het platform | Search code of the item. |
| `SecurityLevel` | `int32` | Beveiligingsniveau | [ ] |  | Security level (0 - 100). |
| `StandardSalesPrice` | `double` | Standaard Verkoopprijs | [ ] |  |  |
| `StartDate` | `datetime` | Startdatum | [ ] | filters op het platform | Together with EndDate this determines if the item is active. |
| `StatisticalCode` | `varchar2` | Statistische Code | [ ] |  |  |
| `StatisticalNetWeight` | `double` | Statistisch Nettogewicht | [ ] |  |  |
| `StatisticalUnits` | `double` | Statistische Eenheden | [ ] |  |  |
| `StatisticalValue` | `double` | Statistische Waarde | [ ] |  |  |
| `Stock` | `double` | Stock | [ ] |  | Quantity that is in stock. |
| `Unit` | `varchar2` | Unit | [ ] | filters op het platform | The standard unit of this item. |
| `UnitDescription` | `varchar2` | Omschrijving Unit | [ ] |  | Description of Unit. |
| `UnitType` | `varchar2` | Unitsoort | [ ] |  | Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight. |
| `UseExplosion` | `int16` | itgen_eol_useexplosion | [ ] | filters op het platform |  |

## Toetsen

| Key | Column | Verwijst naar | 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 |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

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