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

TimeReportingArticles: Fortnox Time Reporting Articles

read only REST

  • Catálogo: Fortnox
  • Esquema: TimeReportingArticles
  • Label: Time Reporting Articles

Get full article registrations that match filter

Response property descriptions:

     id - The unique id of a basic common combination of article registrations. (The basic common combination means "user/purchase date/customer/project/cost center", which leads to a dialog with several article registrations.)

     purchaseDate - The date on which the article is purchased or registered for charging.

     ownerId - The user ID who creates the basic common combination.

     version - The version of the basic common combination (article dialog) being updated, which is used for handling the concurrency issue.

     registrationType - It is always "ARTICLE" for article list endpoint.

     Sub-Class - ArticleRegistration:

         id - The unique id of an article registration.

         registrationId - The id of the basic common combination.

         orderIndex - the order index for the article registration in regard of the common combination.

         ownerId - The user ID who owns the article registration.

         totalQuantity - The quantity of the article.

         unitPrice - The unit price connected to the article registration, which might be locked on an invoice/order basis or for non-invoiceable.

         unitCost - The unit cost connected to the article registration, which might be locked on an invoice/order basis.

         invoiceBasisId - The ID of invoice/order basis which is used for creating an invoice/order.

         nonInvoiceable - If the article registration would be ignored for charging or not.

         note - The note on the article registration.

         documentId - The document ID which includes the article registration and is created in Invoicing application.

         documentType - The document type which could be "invoice" or "order".

Solo puede recuperar datos.

Resumen

Response property descriptions:
     id - The unique id of a basic common combination of article registrations. (The basic common combination means "user/purchase date/customer/project/cost center", which leads to a dialog with several article registrations.)
     purchaseDate - The date on which the article is purchased or registered for charging.
     ownerId - The user ID who creates the basic common combination.
     version - The version of the basic common combination (article dialog) being updated, which is used for handling the concurrency issue.
     registrationType - It is always "ARTICLE" for article list endpoint.
     Sub-Class - ArticleRegistration:
         id - The unique id of an article registration.
         registrationId - The id of the basic common combination.
         orderIndex - the order index for the article registration in regard of the common combination.
         ownerId - The user ID who owns the article registration.
         totalQuantity - The quantity of the article.
         unitPrice - The unit price connected to the article registration, which might be locked on an invoice/order basis or for non-invoiceable.
         unitCost - The unit cost connected to the article registration, which might be locked on an invoice/order basis.
         invoiceBasisId - The ID of invoice/order basis which is used for creating an invoice/order.
         nonInvoiceable - If the article registration would be ignored for charging or not.
         note - The note on the article registration.
         documentId - The document ID which includes the article registration and is created in Invoicing application.
         documentType - The document type which could be "invoice" or "order".

Fuente de la API

  • Punto final: /api/time/articles-v1
  • Operación: get /api/time/articles-v1

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 356
Número de filas escaneadas por minuto 85,000
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
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 `` The start date of the search span, the max of which should be 1 year to the end date ("toDate").Example: 2022-11-01
fromdate2 `` Defines a selection based on a start date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
includeNonInvoiceablePrice `` If the price of the non-invoiceable article registration is included, or not.
includeRegistrationsWithoutProject `` If the article registration without project is included, or not.
inInvoiceBasis `` If the article registration is locked on an invoice basis, or not.
internalArticles `` If the article registration is internal, which is registered on an internal customer, or not.
invoiced `` If a document is created with the article registration, or not.
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
nonInvoiceable `` If the article registration has been moved to non-invoiceable, or not.
toDate `` The end date of the search span, the max of which should be 1 year back to the start date ("fromDate").Example: 2022-11-30
todate2 `` Defines a selection based on an end date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).

Columnas de la Tabla

A continuación se muestran las columnas de la tabla TimeReportingArticles. 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
costCenter_active varchar2 Centro de Costo activo filtros en la plataforma, modificables, costCenter.active
costCenter_id varchar2(40) ID del Centro de Costo filtros en la plataforma, modificables, costCenter.id
costCenter_name varchar2(255) Nombre del Centro de Costo filtros en la plataforma, modificables, costCenter.name
createdTime datetime Hora de creación filtros en la plataforma, modificables, createdTime
customer_accountManager varchar2 Responsable de cuentas de clientes filtros en la plataforma, modificables, customer.accountManager
customer_active char Cliente activo filtros en la plataforma, modificables, customer.active
customer_defaultProjectId varchar2 ID de proyecto predeterminado del cliente filtros en la plataforma, modificables, customer.defaultProjectId
customer_deleted char Cliente eliminado filtros en la plataforma, modificables, customer.deleted
customer_id varchar2(40) ID del Cliente filtros en la plataforma, modificables, customer.id
customer_invoiceCity varchar2 Ciudad de facturación del cliente filtros en la plataforma, modificables, customer.invoiceCity
customer_invoiceZipCode varchar2 Código postal de la factura del cliente filtros en la plataforma, modificables, customer.invoiceZipCode
customer_isBusiness int32 El cliente es el negocio filtros en la plataforma, modificables, customer.isBusiness
customer_name varchar2(255) Nombre del Cliente filtros en la plataforma, modificables, customer.name
customer_number varchar2(1024) Numero de cliente filtros en la plataforma, modificables, customer.number
customer_priceList varchar2 Lista de precios para clientes filtros en la plataforma, modificables, customer.priceList
customer_propertyDesignation varchar2 Designación de la propiedad del cliente filtros en la plataforma, modificables, customer.propertyDesignation
id guid ID filtros en la plataforma, modificables, id
ownerId varchar2 ID de Propietario filtros en la plataforma, modificables, ownerId
ownerName varchar2 itgen_fnx_ownername filtros en la plataforma, modificables, ownerName
project_description varchar2(50) Descripción del Proyecto filtros en la plataforma, modificables, project.description
project_endDate datetime Fecha de finalización del proyecto filtros en la plataforma, modificables, project.endDate
project_id varchar2(40) Identificación del Proyecto filtros en la plataforma, modificables, project.id
project_invoicedAmount double Importe facturado del proyecto filtros en la plataforma, modificables, project.invoicedAmount
project_orderAmount double Importe del pedido del proyecto filtros en la plataforma, modificables, project.orderAmount
project_orderTime double Plazo de ejecución del proyecto filtros en la plataforma, modificables, project.orderTime
project_projectLeader varchar2 Responsable del proyecto filtros en la plataforma, modificables, project.projectLeader
project_startDate datetime Fecha de inicio del proyecto filtros en la plataforma, modificables, project.startDate
project_status int32 Estado del Proyecto filtros en la plataforma, modificables, project.status
project_totalAmountInInvoices double Importe total del proyecto en facturas filtros en la plataforma, modificables, project.totalAmountInInvoices
purchaseDate datetime Fecha de Compra filtros en la plataforma, modificables, purchaseDate
registeredArticle_createdBy varchar2 Artículo registrado creado por filtros en la plataforma, modificables, registeredArticle.createdBy
registeredArticle_createdTime datetime Artículo registrado. Hora de creación filtros en la plataforma, modificables, registeredArticle.createdTime
registeredArticle_documentId int64 ID del documento del artículo registrado filtros en la plataforma, modificables, registeredArticle.documentId
registeredArticle_documentType varchar2 Artículo registrado. Tipo de documento filtros en la plataforma, modificables, registeredArticle.documentType
registeredArticle_id guid ID del artículo registrado filtros en la plataforma, modificables, registeredArticle.id
registeredArticle_invoiceBasisId int64 N.º de identificación de la factura del artículo registrado filtros en la plataforma, modificables, registeredArticle.invoiceBasisId
registeredArticle_invoiceText varchar2(1000) Texto de la factura del artículo registrado filtros en la plataforma, modificables, registeredArticle.invoiceText
registeredArticle_nonInvoiceable char Artículo registrado no facturable filtros en la plataforma, modificables, registeredArticle.nonInvoiceable
registeredArticle_note varchar2(1000) Nota sobre el artículo registrado filtros en la plataforma, modificables, registeredArticle.note
registeredArticle_orderIndex int32 Indice de pedidos de artículos registrados filtros en la plataforma, modificables, registeredArticle.orderIndex
registeredArticle_ownerId varchar2 ID del titular del artículo registrado filtros en la plataforma, modificables, registeredArticle.ownerId
registeredArticle_ownerName varchar2 itgen_fnx_registeredarticle_ownername filtros en la plataforma, modificables, registeredArticle.ownerName
registeredArticle_timeLocked char Artículo registrado con restricción temporal filtros en la plataforma, modificables, registeredArticle.timeLocked
registeredArticle_totalQuantity decimal Artículo registrado: Cantidad total filtros en la plataforma, modificables, registeredArticle.totalQuantity
registeredArticle_unitCost decimal Coste unitario del artículo registrado filtros en la plataforma, modificables, registeredArticle.unitCost
registeredArticle_unitPrice decimal Precio unitario del artículo registrado filtros en la plataforma, modificables, registeredArticle.unitPrice
registrationType varchar2 Tipo de inscripción filtros en la plataforma, modificables, registrationType
version int64 Version filtros en la plataforma, modificables, version

Notas de la Versión

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