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

# ItemsIncremental: Exact Online Items (Incremental)

`popular` `read only` `per partition`

- Catálogo: `ExactOnlineREST`
- Esquema: `Incremental`
- Llaves Primarias: `ID`
- Label: Items (Incremental)

Los datos de esta tabla están divididos por el valor de la columna `Division`.

Solo puede recuperar datos.

## Características de rendimiento

| Characteristic | Value |
|---|---:|
| Latencia media de acceso (ms) | 424 |
| Número de filas escaneadas por minuto | 21,800 |
| Número de filas de queries puntuales por minuto | 138 |

El resultado se puede almacenar en la Caché del cliente.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `ItemsIncremental`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AssembledLeadDays` | `int32` | itgen_eol_assembledleaddays | [ ] |  |  |
| `AverageCost` | `double` | Coste medio | [ ] |  | The current average cost price. |
| `Barcode` | `varchar2` | Barcode | [ ] |  | Barcode of the item. |
| `BatchQuantity` | `double` | Cantidad de Lotes | [ ] |  |  |
| `Class_01` | `varchar2` | Clasificación 1 | [ ] |  | Item class code referring to item class with class ID 1. |
| `Class_02` | `varchar2` | Clasificación 2 | [ ] |  | Item class code referring to item class with class ID 2. |
| `Class_03` | `varchar2` | Clasificación 3 | [ ] |  | Item class code referring to item class with class ID 3. |
| `Class_04` | `varchar2` | Clasificación 4 | [ ] |  | Item class code referring to item class with class ID 4. |
| `Class_05` | `varchar2` | Clasificación 5 | [ ] |  | Item class code referring to item class with class ID 5. |
| `Class_06` | `varchar2` | Clasificación 6 | [ ] |  | Item class code referring to item class with class ID 6. |
| `Class_07` | `varchar2` | Clasificación 7 | [ ] |  | Item class code referring to item class with class ID 7. |
| `Class_08` | `varchar2` | Clasificación 8 | [ ] |  | Item class code referring to item class with class ID 8. |
| `Class_09` | `varchar2` | Clasificación 9 | [ ] |  | Item class code referring to item class with class ID 9. |
| `Class_10` | `varchar2` | Clasificación 10 | [ ] |  | Item class code referring to item class with class ID 10. |
| `Code` | `varchar2` | Code | [ ] |  | Item code. |
| `CopyRemarks` | `int16` | Comentarios de la Copia | [ ] |  | Copy sales remarks to sales lines. |
| `CostPriceCurrency` | `varchar2` | Moneda del precio de coste | [ ] |  | The currency of the current and proposed cost price. |
| `CostPriceNew` | `double` | Precio de coste (nuevo) | [ ] |  | Proposed cost price. |
| `CostPriceStandard` | `double` | Precio de coste estándar | [ ] |  | The current standard cost price. |
| `Created` | `datetime` | Created | [ ] |  | Creation date. |
| `Creator` | `guid` | Creator | [ ] |  | User ID of creator. |
| `CustomField` | `varchar2` | Campo personalizado | [ ] |  |  |
| `Description` | `varchar2` | Description | [ ] |  | Description of the item. |
| `Division` | `int32` | Division | [x] |  | Division code. |
| `EndDate` | `datetime` | Fecha Final | [ ] |  | Together with StartDate this determines if the item is active. |
| `ExtraDescription` | `varchar2` | Descripción Extra | [ ] |  | Extra description text, slightly longer than the regular description (255 instead of 60). |
| `FreeBoolField_01` | `char` | Campo booleano libre n.º 1 | [ ] |  | Free boolean field 1. |
| `FreeBoolField_02` | `char` | Campo booleano libre n.º 2 | [ ] |  | Free boolean field 2. |
| `FreeBoolField_03` | `char` | Campo booleano libre n.º 3 | [ ] |  | Free boolean field 3. |
| `FreeBoolField_04` | `char` | Campo booleano libre n.º 4 | [ ] |  | Free boolean field 4. |
| `FreeBoolField_05` | `char` | Campo booleano libre n.º 5 | [ ] |  | Free boolean field 5. |
| `FreeDateField_01` | `datetime` | Campo de fecha libre n.º 1 | [ ] |  | Free date field 1. |
| `FreeDateField_02` | `datetime` | Campo de fecha libre n.º 2 | [ ] |  | Free date field 2. |
| `FreeDateField_03` | `datetime` | Campo de fecha libre n.º 3 | [ ] |  | Free date field 3. |
| `FreeDateField_04` | `datetime` | Campo de fecha libre n.º 4 | [ ] |  | Free date field 4. |
| `FreeDateField_05` | `datetime` | Campo de fecha libre n.º 5 | [ ] |  | Free date field 5. |
| `FreeNumberField_01` | `double` | Campo de número libre n.º 1 | [ ] |  | Free numeric field 1. |
| `FreeNumberField_02` | `double` | Campo de número libre n.º 2 | [ ] |  | Free numeric field 2. |
| `FreeNumberField_03` | `double` | Campo de número libre n.º 3 | [ ] |  | Free numeric field 3. |
| `FreeNumberField_04` | `double` | Campo de número libre n.º 4 | [ ] |  | Free numeric field 4. |
| `FreeNumberField_05` | `double` | Campo de número libre n.º 5 | [ ] |  | Free numeric field 5. |
| `FreeNumberField_06` | `double` | Campo de número libre n.º 6 | [ ] |  | Free numeric field 6. |
| `FreeNumberField_07` | `double` | Campo de número libre n.º 7 | [ ] |  | Free numeric field 7. |
| `FreeNumberField_08` | `double` | Campo de número libre n.º 8 | [ ] |  | Free numeric field 8. |
| `FreeTextField_01` | `varchar2` | Campo de texto libre n.º 1 | [ ] |  | Free text field 1. |
| `FreeTextField_02` | `varchar2` | Campo de texto libre n.º 2 | [ ] |  | Free text field 2. |
| `FreeTextField_03` | `varchar2` | Campo de texto libre n.º 3 | [ ] |  | Free text field 3. |
| `FreeTextField_04` | `varchar2` | Campo de texto libre n.º 4 | [ ] |  | Free text field 4. |
| `FreeTextField_05` | `varchar2` | Campo de texto libre n.º 5 | [ ] |  | Free text field 5. |
| `FreeTextField_06` | `varchar2` | Campo de texto libre n.º 6 | [ ] |  | Free text field 6. |
| `FreeTextField_07` | `varchar2` | Campo de texto libre n.º 7 | [ ] |  | Free text field 7. |
| `FreeTextField_08` | `varchar2` | Campo de texto libre n.º 8 | [ ] |  | Free text field 8. |
| `FreeTextField_09` | `varchar2` | Campo de texto libre n.º 9 | [ ] |  | Free text field 9. |
| `FreeTextField_10` | `varchar2` | Campo de texto libre n.º 10 | [ ] |  | Free text field 10. |
| `GLCosts` | `guid` | Libro Mayor de Costos | [ ] |  | 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. |
| `GLRevenue` | `guid` | Libro Mayor de Ingresos | [ ] |  | 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. |
| `GLStock` | `guid` | Existencias de la cuenta GL | [ ] |  | 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. |
| `GrossWeight` | `double` | Peso bruto | [ ] |  | Gross weight for international goods shipments. |
| `ID` | `guid` | ID | [x] |  | A guid that is the unique identifier of the item. |
| `IsBatchItem` | `int16` | ¿Es un artículo por lotes? | [ ] |  | Indicates if batches are used for this item. |
| `IsFractionAllowedItem` | `char` | ¿Se permite introducir fracciones en el artículo? | [ ] |  | Indicates if fractions (for example 0.35) are allowed for quantities of this item. |
| `IsMakeItem` | `int16` | ¿Es «Crear objeto»? | [ ] |  | Indicates that an Item is produced to Inventory, not purchased. |
| `IsNewContract` | `int16` | Es Contrato Nuevo | [ ] |  | Only used for packages (IsPackageItem=1).To indicate if this package is a new contract type package. |
| `IsOnDemandItem` | `int16` | Es un artículo bajo demanda | [ ] |  | Is On demand Item. |
| `IsPackageItem` | `char` | Es Elemento de Paquete | [ ] |  | Indicates if the item is a package item.Can only be created in the hosting administration. |
| `IsPurchaseItem` | `char` | ¿Es un artículo de compra? | [ ] |  | Indicates if the item can be purchased. |
| `IsRegistrationCodeItem` | `int16` | Es Elemento de Código de Registro | [x] |  |  |
| `IsSalesItem` | `char` | ¿Es un artículo en oferta? | [ ] |  | Indicates if the item can be sold. |
| `IsSerialItem` | `char` | ¿Es un artículo en serie? | [ ] |  | Indicates that serial numbers are used for this item. |
| `IsStockItem` | `char` | ¿Está disponible en stock? | [ ] |  | 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` | ¿Es un artículo subcontratado? | [ ] |  | Indicates if the item is provided by an outside supplier. |
| `IsTaxableItem` | `int16` | ¿Es un concepto sujeto a impuestos? | [ ] |  | Indicates if tax needs to be calculated for this item. |
| `IsTime` | `int16` | ¿Es el tiempo? | [ ] |  | Indicates if the item is a time unit item (for example a labor hour item). |
| `IsWebshopItem` | `int16` | ¿Es un artículo de la tienda online? | [ ] |  | Indicates if the item can be exported to a web shop. |
| `ItemGroup` | `guid` | ¿Es un grupo de artículos? | [ ] |  | GUID of item group of the item. |
| `Modified` | `datetime` | Modified | [ ] |  | Last modified date. |
| `Modifier` | `guid` | Modifier | [ ] |  | User ID of modifier. |
| `NetWeight` | `double` | Peso Neto | [ ] |  | Net weight for international goods shipments. |
| `NetWeightUnit` | `varchar2` | Unidad de peso neto | [ ] |  | Net Weight unit for international goods shipment, only available in manufacturing packages. |
| `Notes` | `varchar2` | Notes | [ ] |  | Notes. |
| `Picture` | `blob` | Picture | [ ] |  |  |
| `PictureName` | `varchar2` | Nombre de la imagen | [ ] |  | File name of picture. |
| `PictureThumbnailUrl` | `varchar2` | Miniatura de la imagen (URL) | [ ] |  | URL where thumbnail picture can be retrieved. |
| `PictureUrl` | `varchar2` | Imagen (URL) | [ ] |  | URL where picture can be retrieved. |
| `SalesVatCode` | `varchar2` | Código VAT de Ventas | [ ] |  | Code of sales VAT. |
| `SearchCode` | `varchar2` | Código que se ha de buscar | [ ] |  | Search code of the item. |
| `SecurityLevel` | `int32` | Nivel de Seguridad | [ ] |  | Security level (0 - 100). |
| `StartDate` | `datetime` | Fecha Inicial | [ ] |  | Together with EndDate this determines if the item is active. |
| `StatisticalCode` | `varchar2` | Código estadístico | [ ] |  | Statistical code. |
| `StatisticalNetWeight` | `double` | Peso neto estadístico | [ ] |  | Netweight weight for statistical reporting. |
| `StatisticalUnits` | `double` | Unidades estadísticas | [ ] |  | Units for statistical reporting. |
| `StatisticalValue` | `double` | Valor estadístico | [ ] |  | Value for statistical reporting. |
| `Stock` | `double` | Stock | [ ] | filtros de la plataforma |  |
| `Timestamp` | `int64` | Timestamp | [x] |  | Timestamp. |
| `Unit` | `varchar2` | Unit | [ ] |  | The standard unit of this item. |
| `UnitType` | `varchar2` | Tipo de Unidad | [ ] |  | Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight. |
| `UseExplosion` | `int16` | itgen_eol_useexplosion | [ ] |  |  |


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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