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

IncomingGoodDocuments: Fortnox Incoming Good Documents

insert update REST

  • Catálogo: Fortnox
  • Esquema: WarehouseIncomingGoods
  • Llaves Primarias: id
  • Label: Incoming Good Documents

List Incoming Goods Documents

 List incoming goods documents matching the given parameters.


 Sortable fields:
 id,
 has_delivery_note,
 delivery_note_id,
 supplier_number,
 date

Permite recuperar y modificar datos mediante insert y update.

Resumen

List incoming goods documents matching the given parameters.

Sortable fields: id, has_delivery_note, delivery_note_id, supplier_number, date

Fuente de la API

  • Punto final: /api/warehouse/incominggoods-v1
  • Operación: get /api/warehouse/incominggoods-v1

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 356
Número de filas escaneadas por minuto 51,500
Número de filas de queries puntuales por minuto 168

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

Parámetros

Name Tipo de Datos Required Default Documentation
completed `` true to include only completed documents. false to include only non-completed documents.
deliveryNote `` Include only documents where deliveryNote-field contains the given text (case-insensitive).
financialyear `` Selects what financial year that should be used (does not work on every table).
financialyeardate `` Selects by date, what financial year that should be used (does not work on every table).
fromdate `` Defines a selection based on a start date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
itemId `` Include only documents with the given itemId.
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
note `` Include only documents where note-field contains the given text (case-insensitive).
q `` Include only documents where id or deliveryNote-field contains the given text (case-insensitive).
released `` true to include only released documents. false to include only non-released documents.
supplierNumber `` Include only documents with the given supplierNumber.
todate `` Defines a selection based on an end date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
voided `` true to include only voided documents. false to include only non-voided documents.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla IncomingGoodDocuments. 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
completed char Completed filtros en la plataforma, modificables, completed
date datetime Date filtros en la plataforma, modificables, date
deliveryNoteId varchar2 N.º de albarán filtros en la plataforma, modificables, deliveryNoteId
hasDeliveryNote char Incluye albarán de entrega filtros en la plataforma, modificables, hasDeliveryNote
id int64 ID filtros en la plataforma, modificables, id
note varchar2 Note filtros en la plataforma, modificables, note
released char Released filtros en la plataforma, modificables, released
stockPointId guid N.º de referencia del artículo filtros en la plataforma, modificables, stockPointId
supplierName varchar2 Nombre del Proveedor filtros en la plataforma, modificables, supplierName
supplierNumber varchar2 Número de proveedor filtros en la plataforma, modificables, supplierNumber
unmatchedValue decimal Un valor inigualable filtros en la plataforma, modificables, unmatchedValue
voided char Voided filtros en la plataforma, modificables, voided

Notas de la Versión

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