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

StockCountLines: Exact Online Stock Count Lines

insert update delete per partition REST

  • Catálogo: ExactOnlineREST
  • Esquema: Inventory
  • Llaves Primarias: ID
  • Label: Stock Count Lines

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}/inventory/StockCountLines
  • Metadatos: /api/v1/{division}/inventory/$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 StockCountLines. 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
CostPrice double Precio de Costo filters on the platform, writable Cost price of the item that is used to create the stock count.
CountedBy guid itgen_eol_countedby filters on the platform, writable Counted by.
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.
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.
ID guid ID filters on the platform, writable Primary key.
Item guid Item filters on the platform, writable Reference to the item for which the stock is counted.
ItemBarcode varchar2 Código de barras del artículo filters on the platform, writable Item Barcode.
ItemCode varchar2(30) Código del Artículo filters on the platform, writable Item code.
ItemCostPrice double Artículo Precio de coste filters on the platform, writable Current standard/actual item cost price.
ItemDescription varchar2(255) Descripción del Elemento filters on the platform, writable Description of item.
ItemDivisable char Artículo divisible filters on the platform, writable Indicates if fractional quantities of the item can be used, for example quantity = 0.4.
LineNumber int32 Número de Línea filters on the platform, writable Line number.
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.
QuantityDifference double Diferencia de cantidad filters on the platform, writable The difference between the current quantity in stock and the new quantity in stock.For example specify -1 for this field to correct the quantity if one item in stock is broken.
QuantityInStock double Cantidad en stock filters on the platform, writable The current quantity available in stock.
QuantityNew double Cantidad: Nuevo filters on the platform, writable The new quantity in stock.Use this field to correct the quantity when the items in stock are physically counted.
ReasonCode varchar2 Código de Motivo filtros de la plataforma
ReasonCodeDescription varchar2 Código de motivo Descripción filtros de la plataforma
ReasonCodeID guid ID del código de motivo filters on the platform, writable
Source int16 Source filters on the platform, writable Source of stock count entry: 1-Manual entry, 2-Import, 3-Stock count, 4-Web service.
Status int16 Status filters on the platform, writable Stock count status: 12-Draft, 21-Processed.
StockCountID guid N.º de inventario filters on the platform, writable Identifies the stock count.All the lines of a stock count have the same StockCountID.
StockKeepingUnit varchar2 Unidad de gestión de existencias filters on the platform, writable Stock item's unit description.
StorageLocation guid Ubicación del Almacenamiento filters on the platform, writable This property is package specific (Stock count can have multiple lines for the same item only if it is for multiple storage locations).
StorageLocationCode varchar2 Código de ubicación de almacenamiento filters on the platform, writable Storage location code.
StorageLocationDescription varchar2 Descripción de la ubicación de almacenamiento filters on the platform, writable Storage location description.
StorageLocationSequenceNumber int32 itgen_eol_storagelocationsequencenumber filters on the platform, writable
Warehouse guid Warehouse filters on the platform, writable Warehouse.

Teclas

Key Column Se refiere a Kind Description
StockCountLines_CountedBy_Users_fk CountedBy Users.UserID Key
StockCountLines_Creator_Users_fk Creator Users.UserID Key
StockCountLines_Item_Items_fk Item Items.ID Key
StockCountLines_Modifier_Users_fk Modifier Users.UserID Key
StockCountLines_StockCountID_StockCounts_fk StockCountID StockCounts.StockCountID Key
StockCountLines_StorageLocation_StorageLocations_fk StorageLocation StorageLocations.ID Key
StockCountLines_Warehouse_Warehouses_fk Warehouse Warehouses.ID Key

Referenciado por

Notas de la Versión

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