invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Items: Exact Online Items

insert update delete per partition webhook REST

  • Catálogo: ExactOnlineREST
  • Esquema: Logistics
  • Llaves Primarias: ID
  • Label: Items

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

Permite recuperar y modificar datos utilizando insert, update y delete.

Los cambios llegan a través del tema de webhook Items.

Fuente de la API

  • Punto final: /api/v1/{division}/logistics/Items
  • Metadatos: /api/v1/{division}/logistics/$metadata

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 5
Número de filas escaneadas por minuto 7,200
Número de filas de queries puntuales por minuto 300
Escribir filas por minuto 300

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

Columnas de la Tabla

A continuación se muestran las columnas de la tabla Items. 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 filters on the platform, writable
AverageCost double Coste medio writable The current average cost price.
Barcode varchar2(20) Barcode filters on the platform, writable Barcode of the item (numeric string).
BatchQuantity double Cantidad de Lotes filters on the platform, writable
Class_01 varchar2 Clasificación 1 filters on the platform, writable Item class code referring to ItemClasses with ClassID 1.
Class_02 varchar2 Clasificación 2 filters on the platform, writable Item class code referring to ItemClasses with ClassID 2.
Class_03 varchar2 Clasificación 3 filters on the platform, writable Item class code referring to ItemClasses with ClassID 3.
Class_04 varchar2 Clasificación 4 filters on the platform, writable Item class code referring to ItemClasses with ClassID 4.
Class_05 varchar2 Clasificación 5 filters on the platform, writable Item class code referring to ItemClasses with ClassID 5.
Class_06 varchar2 Clasificación 6 filters on the platform, writable Item class code referring to ItemClasses with ClassID 6.
Class_07 varchar2 Clasificación 7 filters on the platform, writable Item class code referring to ItemClasses with ClassID 7.
Class_08 varchar2 Clasificación 8 filters on the platform, writable Item class code referring to ItemClasses with ClassID 8.
Class_09 varchar2 Clasificación 9 filters on the platform, writable Item class code referring to ItemClasses with ClassID 9.
Class_10 varchar2 Clasificación 10 filters on the platform, writable Item class code referring to ItemClasses with ClassID 10.
Code varchar2(30) Code filters on the platform, writable Item code.
CopyRemarks int16 Comentarios de la Copia writable Copy sales remarks to sales lines.
CostPriceCurrency varchar2(30) Moneda del precio de coste writable The currency of the current and proposed cost price.
CostPriceNew double Precio de coste (nuevo) filters on the platform, writable Proposed cost price.
CostPriceStandard double Precio de coste estándar writable The current standard cost price.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Creado writable Creation date in UTC.
Creator guid Creator writable User ID of creator.
CreatorFullName varchar2(240) Nombre Completo del Creador writable Name of creator.
CustomField varchar2 Campo personalizado filters on the platform, writable
Description varchar2(255) Description filters on the platform, writable Description of the item.
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Número de la Cámara de Comercio de la División writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Número IBAN de la división writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) División: Nombre de la empresa writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Número de la división RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Número de IVA de la división writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Número de identificación fiscal de la división en materia de impuestos sobre los salarios writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Etiqueta de división writable Label of the Exact Online division.
DivisionName varchar2(50) Nombre de la Adminisración writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Nombre del titular de la suscripción writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Número de titular de la suscripción writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Nombre abreviado de la división writable Short name of the Exact Online division.
EndDate datetime Fecha Final filters on the platform, writable Together with StartDate this determines if the item is active.
ExtraDescription varchar2(255) Descripción Extra filters on the platform, writable Extra description text, slightly longer than the regular description (255 instead of 60).
FreeBoolField_01 char Campo booleano libre n.º 1 filters on the platform, writable Free boolean field 1.
FreeBoolField_02 char Campo booleano libre n.º 2 filters on the platform, writable Free boolean field 2.
FreeBoolField_03 char Campo booleano libre n.º 3 filters on the platform, writable Free boolean field 3.
FreeBoolField_04 char Campo booleano libre n.º 4 filters on the platform, writable Free boolean field 4.
FreeBoolField_05 char Campo booleano libre n.º 5 filters on the platform, writable Free boolean field 5.
FreeDateField_01 datetime Campo de fecha libre n.º 1 filters on the platform, writable Free date field 1.
FreeDateField_02 datetime Campo de fecha libre n.º 2 filters on the platform, writable Free date field 2.
FreeDateField_03 datetime Campo de fecha libre n.º 3 filters on the platform, writable Free date field 3.
FreeDateField_04 datetime Campo de fecha libre n.º 4 filters on the platform, writable Free date field 4.
FreeDateField_05 datetime Campo de fecha libre n.º 5 filters on the platform, writable Free date field 5.
FreeNumberField_01 double Campo de número libre n.º 1 filters on the platform, writable Free numeric field 1.
FreeNumberField_02 double Campo de número libre n.º 2 filters on the platform, writable Free numeric field 2.
FreeNumberField_03 double Campo de número libre n.º 3 filters on the platform, writable Free numeric field 3.
FreeNumberField_04 double Campo de número libre n.º 4 filters on the platform, writable Free numeric field 4.
FreeNumberField_05 double Campo de número libre n.º 5 filters on the platform, writable Free numeric field 5.
FreeNumberField_06 double Campo de número libre n.º 6 filters on the platform, writable Free numeric field 6.
FreeNumberField_07 double Campo de número libre n.º 7 filters on the platform, writable Free numeric field 7.
FreeNumberField_08 double Campo de número libre n.º 8 filters on the platform, writable Free numeric field 8.
FreeTextField_01 varchar2 Campo de texto libre n.º 1 filters on the platform, writable Free text field 1.
FreeTextField_02 varchar2 Campo de texto libre n.º 2 filters on the platform, writable Free text field 2.
FreeTextField_03 varchar2 Campo de texto libre n.º 3 filters on the platform, writable Free text field 3.
FreeTextField_04 varchar2 Campo de texto libre n.º 4 filters on the platform, writable Free text field 4.
FreeTextField_05 varchar2 Campo de texto libre n.º 5 filters on the platform, writable Free text field 5.
FreeTextField_06 varchar2 Campo de texto libre n.º 6 filters on the platform, writable Free text field 6.
FreeTextField_07 varchar2 Campo de texto libre n.º 7 filters on the platform, writable Free text field 7.
FreeTextField_08 varchar2 Campo de texto libre n.º 8 filters on the platform, writable Free text field 8.
FreeTextField_09 varchar2 Campo de texto libre n.º 9 filters on the platform, writable Free text field 9.
FreeTextField_10 varchar2 Campo de texto libre n.º 10 filters on the platform, writable Free text field 10.
GLCosts guid Libro Mayor de Costos filters on the platform, writable 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 Costes por código de cuenta GL writable Code of GL account for costs.
GLCostsDescription varchar2 Descripción de la cuenta GL: Costes writable Description of GLCosts.
GLCostsWorkInProgress guid itgen_eol_glcostsworkinprogress filtros de la plataforma
GLCostsWorkInProgressCode varchar2 itgen_eol_glcostsworkinprogresscode filtros de la plataforma
GLCostsWorkInProgressDescription varchar2 itgen_eol_glcostsworkinprogressdescription filtros de la plataforma
GLRevenue guid Libro Mayor de Ingresos filters on the platform, writable 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 Código de cuenta GL: Ingresos writable Code of GLRevenue.
GLRevenueDescription varchar2 Descripción de la cuenta GL: Ingresos writable Description of GLRevenue.
GLRevenueWorkInProgress guid itgen_eol_glrevenueworkinprogress filtros de la plataforma
GLRevenueWorkInProgressCode varchar2 itgen_eol_glrevenueworkinprogresscode filtros de la plataforma
GLRevenueWorkInProgressDescription varchar2 itgen_eol_glrevenueworkinprogressdescription filtros de la plataforma
GLStock guid Existencias de la cuenta GL filters on the platform, writable 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 Código de cuenta GL: Existencias writable Code of GL account for stock.
GLStockDescription varchar2 Descripción de la cuenta GL: Existencias writable Description of GLStock.
GrossWeight double Peso bruto writable Gross weight for international goods shipments.
ID guid ID filters on the platform, writable Primary key.
IsBatchItem int16 ¿Es un artículo por lotes? filters on the platform, writable Indicates if batches are used for this item.
IsBatchNumberItem int16 ¿Es el número de lote del artículo? filters on the platform, writable This property is obsolete.Use property 'IsBatchItem' instead.
IsFractionAllowedItem char ¿Se permite introducir fracciones en el artículo? filters on the platform, writable Indicates if fractions (for example 0.35) are allowed for quantities of this item.
IsMakeItem int16 ¿Es «Crear objeto»? filters on the platform, writable Indicates that an Item is produced to Inventory, not purchased.
IsNewContract int16 Es Contrato Nuevo writable 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 writable Is On demand Item.
IsPackageItem char Es Elemento de Paquete writable Indicates if the item is a package item.Can only be created in the hosting administration.
IsPurchaseItem char ¿Es un artículo de compra? filters on the platform, writable Indicates if the item can be purchased.
IsRegistrationCodeItem int16 Es Elemento de Código de Registro filters on the platform, writable Indicated if the item is used in voucher functionality.
IsSalesItem char ¿Es un artículo en oferta? filters on the platform, writable Indicates if the item can be sold.
IsSerialItem char ¿Es un artículo en serie? filters on the platform, writable Indicates that serial numbers are used for this item.
IsSerialNumberItem char ¿Es un artículo con número de serie? writable This property is obsolete.Use property 'IsSerialItem' instead.
IsStockItem char ¿Está disponible en stock? filters on the platform, writable 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? filters on the platform, writable Indicates if the item is provided by an outside supplier.
IsTaxableItem int16 ¿Es un concepto sujeto a impuestos? writable Indicates if tax needs to be calculated for this item.
IsTime int16 ¿Es el tiempo? filters on the platform, writable 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? filters on the platform, writable Indicates if the item can be exported to a web shop.
ItemGroup guid ¿Es un grupo de artículos? filters on the platform, writable GUID of Item group of the item.
ItemGroupCode varchar2 Código de Grupo del Elemento filters on the platform, writable Code of ItemGroup.
ItemGroupDescription varchar2 Descripción de Grupo del Elemento writable Description of ItemGroup.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modificado (UTC) writable Last modified date in UTC.
Modifier guid Modifier writable User ID of modifier.
ModifierFullName varchar2(240) Nombre completo modificado writable Name of modifier.
NetWeight double Peso Neto writable Net weight for international goods shipments.
NetWeightUnit varchar2 Unidad de peso neto filters on the platform, writable Net Weight unit for international goods shipment, only available in manufacturing packages.
Notes varchar2 Notes writable Notes.
Picture blob Picture filters on the platform, writable
PictureName varchar2 Nombre de la imagen writable File name of picture.
PictureThumbnailUrl varchar2 Miniatura de la imagen (URL) writable Url where thumbnail picture can be retrieved.
PictureUrl varchar2 Imagen (URL) writable Url where picture can be retrieved.
SalesVatCode varchar2(3) Código VAT de Ventas filters on the platform, writable Code of SalesVat.
SalesVatCodeDescription varchar2(60) Descripción del Código VAT de Ventas writable Description of Sales VAT code.
SearchCode varchar2(15) Código que se ha de buscar filters on the platform, writable Search code of the item.
SecurityLevel int32 Nivel de Seguridad writable Security level (0 - 100).
StandardSalesPrice double Precio de venta estándar filters on the platform, writable
StartDate datetime Fecha Inicial filters on the platform, writable Together with EndDate this determines if the item is active.
StatisticalCode varchar2 Código estadístico filtros de la plataforma
StatisticalNetWeight double Peso neto estadístico filtros de la plataforma
StatisticalUnits double Unidades estadísticas filtros de la plataforma
StatisticalValue double Valor estadístico filtros de la plataforma
Stock double Stock writable Quantity that is in stock.
Unit varchar2(8) Unit filters on the platform, writable The standard unit of this item.
UnitDescription varchar2(60) Descripción de la Unidad writable Description of Unit.
UnitType varchar2(1) Tipo de Unidad writable Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight.
UseExplosion int16 itgen_eol_useexplosion filters on the platform, writable

Teclas

Key Column Se refiere a Kind Description
Items_Creator_Users_fk Creator Users.UserID Key
Items_GLCosts_GLAccounts_fk GLCosts GLAccounts.ID Key
Items_GLRevenue_GLAccounts_fk GLRevenue GLAccounts.ID Key
Items_GLStock_GLAccounts_fk GLStock GLAccounts.ID Key
Items_ItemGroup_ItemGroups_fk ItemGroup ItemGroups.ID Key
Items_Modifier_Users_fk Modifier Users.UserID Key
Items_Unit_Units_fk Unit Units.Code Key

Referenciado por

Notas de la Versión

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