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

ItemGroups: Exact Online Item Groups

popular insert update delete per partition REST

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

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.

Fuente de la API

  • Punto final: /api/v1/{division}/logistics/ItemGroups
  • 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 ItemGroups. 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
Code varchar2 Code filters on the platform, writable Code of the item group.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Creado writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Nombre Completo del Creador filters on the platform, writable Name of creator.
Description varchar2 Description filters on the platform, writable Description of the item group.
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.
GLCosts guid Libro Mayor de Costos filters on the platform, writable GL account on which the costs of items of this group will be booked.
GLCostsCode varchar2 Costes por código de cuenta GL filters on the platform, writable Code of GLCosts.
GLCostsDescription varchar2 Descripción de la cuenta GL: Costes filters on the platform, 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
GLPurchaseAccount guid itgen_eol_glpurchaseaccount filters on the platform, writable GL Purchase account for purchase invoicing according to (non-) perpetual inventory method.
GLPurchaseAccountCode varchar2 itgen_eol_glpurchaseaccountcode filters on the platform, writable Code of GLPurchase.
GLPurchaseAccountDescription varchar2 itgen_eol_glpurchaseaccountdescription filters on the platform, writable Description of GLPurchaseAccount.
GLPurchasePriceDifference guid itgen_eol_glpurchasepricedifference filters on the platform, writable GL account that will be used for the 'Standard cost price' valuation method to balance the difference between purchase price and cost price.
GLPurchasePriceDifferenceCode varchar2 itgen_eol_glpurchasepricedifferencecode filters on the platform, writable Code of GLPurchasePriceDifference.
GLPurchasePriceDifferenceDescr varchar2 itgen_eol_glpurchasepricedifferencedescr filters on the platform, writable Description of GLPurchasePriceDifference.
GLRevenue guid Libro Mayor de Ingresos filters on the platform, writable GL account on which the revenue for items of this group will be booked.
GLRevenueCode varchar2 Código de cuenta GL: Ingresos filters on the platform, writable Code of GLRevenue.
GLRevenueDescription varchar2 Descripción de la cuenta GL: Ingresos filters on the platform, 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 on which stock entries will be booked for items of this group.
GLStockCode varchar2 Código de cuenta GL: Existencias filters on the platform, writable Code of GLStock.
GLStockDescription varchar2 Descripción de la cuenta GL: Existencias filters on the platform, writable Description of GLStock.
GLStockVariance guid itgen_eol_glstockvariance filters on the platform, writable GL stock variance account for perpetual inventory.
GLStockVarianceCode varchar2 itgen_eol_glstockvariancecode filters on the platform, writable Code of GLStockVariance.
GLStockVarianceDescription varchar2 itgen_eol_glstockvariancedescription filters on the platform, writable Description of GLStockVariance.
ID guid ID filters on the platform, writable Primary key.
IsDefault int16 Es Predeterminado filters on the platform, writable Indicates if this is the default item group that will be assigned when a new item is created.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modificado (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Nombre completo modificado filters on the platform, writable Name of modifier.
Notes varchar2 Notes filters on the platform, writable Notes.

Teclas

Key Column Se refiere a Kind Description
ItemGroups_Creator_Users_fk Creator Users.UserID Key
ItemGroups_GLCosts_GLAccounts_fk GLCosts GLAccounts.ID Key
ItemGroups_GLPurchaseAccount_GLAccounts_fk GLPurchaseAccount GLAccounts.ID Key
ItemGroups_GLPurchasePriceDifference_GLAccounts_fk GLPurchasePriceDifference GLAccounts.ID Key
ItemGroups_GLRevenue_GLAccounts_fk GLRevenue GLAccounts.ID Key
ItemGroups_GLStockVariance_GLAccounts_fk GLStockVariance GLAccounts.ID Key
ItemGroups_GLStock_GLAccounts_fk GLStock GLAccounts.ID Key
ItemGroups_Modifier_Users_fk Modifier Users.UserID Key

Referenciado por

Notas de la Versión

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