invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

TimeReportingArticles: Fortnox Time Reporting Articles

read only REST

  • Catalogue : Fortnox
  • Schéma : 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".

Permet uniquement de récupérer des données.

Résumé

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".

Source de l'API

  • Point de terminaison : /api/time/articles-v1
  • Opération : get /api/time/articles-v1

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 356
Nombre de lignes par minute en mode de balayage complet 85,000
Nombre de lignes de requêtes ponctuelles par minute 168

Le résultat peut être mis en cache côté client.

Paramètres

Name Type de données 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).

Colonnes de table

Les colonnes de la table TimeReportingArticles sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
costCenter_active varchar2 Centre de coûts actif filtres sur la plateforme, modifiables, costCenter.active
costCenter_id varchar2(40) Identifiant du centre de coûts filtres sur la plateforme, modifiables, costCenter.id
costCenter_name varchar2(255) Nom du centre de coûts filtres sur la plateforme, modifiables, costCenter.name
createdTime datetime Date de création filtres sur la plateforme, modifiables, createdTime
customer_accountManager varchar2 Responsable de compte client filtres sur la plateforme, modifiables, customer.accountManager
customer_active char Client actif filtres sur la plateforme, modifiables, customer.active
customer_defaultProjectId varchar2 Identifiant de projet par défaut du client filtres sur la plateforme, modifiables, customer.defaultProjectId
customer_deleted char Client supprimé filtres sur la plateforme, modifiables, customer.deleted
customer_id varchar2(40) ID de cliente filtres sur la plateforme, modifiables, customer.id
customer_invoiceCity varchar2 Ville de facturation du client filtres sur la plateforme, modifiables, customer.invoiceCity
customer_invoiceZipCode varchar2 Code postal figurant sur la facture du client filtres sur la plateforme, modifiables, customer.invoiceZipCode
customer_isBusiness int32 Le client, c'est l'entreprise filtres sur la plateforme, modifiables, customer.isBusiness
customer_name varchar2(255) Nom du client filtres sur la plateforme, modifiables, customer.name
customer_number varchar2(1024) Numéro de client filtres sur la plateforme, modifiables, customer.number
customer_priceList varchar2 Liste des tarifs clients filtres sur la plateforme, modifiables, customer.priceList
customer_propertyDesignation varchar2 Désignation des biens du client filtres sur la plateforme, modifiables, customer.propertyDesignation
id guid ID filtres sur la plateforme, modifiables, id
ownerId varchar2 ID du propriétaire filtres sur la plateforme, modifiables, ownerId
ownerName varchar2 itgen_fnx_ownername filtres sur la plateforme, modifiables, ownerName
project_description varchar2(50) Description du projet filtres sur la plateforme, modifiables, project.description
project_endDate datetime Date de fin du projet filtres sur la plateforme, modifiables, project.endDate
project_id varchar2(40) Identifiant du projet filtres sur la plateforme, modifiables, project.id
project_invoicedAmount double Montant facturé du projet filtres sur la plateforme, modifiables, project.invoicedAmount
project_orderAmount double Montant de la commande du projet filtres sur la plateforme, modifiables, project.orderAmount
project_orderTime double Durée du projet filtres sur la plateforme, modifiables, project.orderTime
project_projectLeader varchar2 Chef de projet filtres sur la plateforme, modifiables, project.projectLeader
project_startDate datetime Date de début du projet filtres sur la plateforme, modifiables, project.startDate
project_status int32 État du projet filtres sur la plateforme, modifiables, project.status
project_totalAmountInInvoices double Montant total des factures du projet filtres sur la plateforme, modifiables, project.totalAmountInInvoices
purchaseDate datetime Date d'achat filtres sur la plateforme, modifiables, purchaseDate
registeredArticle_createdBy varchar2 Article enregistré créé par filtres sur la plateforme, modifiables, registeredArticle.createdBy
registeredArticle_createdTime datetime Article enregistré - Date de création filtres sur la plateforme, modifiables, registeredArticle.createdTime
registeredArticle_documentId int64 Identifiant du document d'article enregistré filtres sur la plateforme, modifiables, registeredArticle.documentId
registeredArticle_documentType varchar2 Article enregistré - Type de document filtres sur la plateforme, modifiables, registeredArticle.documentType
registeredArticle_id guid Identifiant de l'article enregistré filtres sur la plateforme, modifiables, registeredArticle.id
registeredArticle_invoiceBasisId int64 Référence de facture de l'article enregistré filtres sur la plateforme, modifiables, registeredArticle.invoiceBasisId
registeredArticle_invoiceText varchar2(1000) Texte de la facture d'article enregistré filtres sur la plateforme, modifiables, registeredArticle.invoiceText
registeredArticle_nonInvoiceable char Article enregistré - Non facturable filtres sur la plateforme, modifiables, registeredArticle.nonInvoiceable
registeredArticle_note varchar2(1000) Note relative à un article publié filtres sur la plateforme, modifiables, registeredArticle.note
registeredArticle_orderIndex int32 Index des commandes d'articles enregistrés filtres sur la plateforme, modifiables, registeredArticle.orderIndex
registeredArticle_ownerId varchar2 Identifiant du propriétaire de l'article enregistré filtres sur la plateforme, modifiables, registeredArticle.ownerId
registeredArticle_ownerName varchar2 itgen_fnx_registeredarticle_ownername filtres sur la plateforme, modifiables, registeredArticle.ownerName
registeredArticle_timeLocked char Article enregistré – Accès restreint filtres sur la plateforme, modifiables, registeredArticle.timeLocked
registeredArticle_totalQuantity decimal Quantité totale d'articles enregistrés filtres sur la plateforme, modifiables, registeredArticle.totalQuantity
registeredArticle_unitCost decimal Coût unitaire des articles enregistrés filtres sur la plateforme, modifiables, registeredArticle.unitCost
registeredArticle_unitPrice decimal Prix unitaire des articles enregistrés filtres sur la plateforme, modifiables, registeredArticle.unitPrice
registrationType varchar2 Type d'inscription filtres sur la plateforme, modifiables, registrationType
version int64 Version filtres sur la plateforme, modifiables, version

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :