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). | ||
from |
`` | 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). | ||
include |
`` | If the price of the non-invoiceable article registration is included, or not. | ||
include |
`` | If the article registration without project is included, or not. | ||
in |
`` | If the article registration is locked on an invoice basis, or not. | ||
internal |
`` | 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). | ||
non |
`` | 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 |
|---|---|---|---|---|---|
cost |
varchar2 |
Centre de coûts actif | filtres sur la plateforme, modifiables, cost |
||
cost |
varchar2 |
Identifiant du centre de coûts | filtres sur la plateforme, modifiables, cost |
||
cost |
varchar2 |
Nom du centre de coûts | filtres sur la plateforme, modifiables, cost |
||
created |
datetime |
Date de création | filtres sur la plateforme, modifiables, created |
||
customer_ |
varchar2 |
Responsable de compte client | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
char |
Client actif | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
varchar2 |
Identifiant de projet par défaut du client | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
char |
Client supprimé | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
varchar2 |
ID de cliente | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
varchar2 |
Ville de facturation du client | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
varchar2 |
Code postal figurant sur la facture du client | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
int32 |
Le client, c'est l'entreprise | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
varchar2 |
Nom du client | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
varchar2 |
Numéro de client | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
varchar2 |
Liste des tarifs clients | filtres sur la plateforme, modifiables, customer. |
||
customer_ |
varchar2 |
Désignation des biens du client | filtres sur la plateforme, modifiables, customer. |
||
id |
guid |
ID | filtres sur la plateforme, modifiables, id |
||
owner |
varchar2 |
ID du propriétaire | filtres sur la plateforme, modifiables, owner |
||
owner |
varchar2 |
itgen_fnx_ownername | filtres sur la plateforme, modifiables, owner |
||
project_ |
varchar2 |
Description du projet | filtres sur la plateforme, modifiables, project. |
||
project_ |
datetime |
Date de fin du projet | filtres sur la plateforme, modifiables, project. |
||
project_ |
varchar2 |
Identifiant du projet | filtres sur la plateforme, modifiables, project. |
||
project_ |
double |
Montant facturé du projet | filtres sur la plateforme, modifiables, project. |
||
project_ |
double |
Montant de la commande du projet | filtres sur la plateforme, modifiables, project. |
||
project_ |
double |
Durée du projet | filtres sur la plateforme, modifiables, project. |
||
project_ |
varchar2 |
Chef de projet | filtres sur la plateforme, modifiables, project. |
||
project_ |
datetime |
Date de début du projet | filtres sur la plateforme, modifiables, project. |
||
project_ |
int32 |
État du projet | filtres sur la plateforme, modifiables, project. |
||
project_ |
double |
Montant total des factures du projet | filtres sur la plateforme, modifiables, project. |
||
purchase |
datetime |
Date d'achat | filtres sur la plateforme, modifiables, purchase |
||
registered |
varchar2 |
Article enregistré créé par | filtres sur la plateforme, modifiables, registered |
||
registered |
datetime |
Article enregistré - Date de création | filtres sur la plateforme, modifiables, registered |
||
registered |
int64 |
Identifiant du document d'article enregistré | filtres sur la plateforme, modifiables, registered |
||
registered |
varchar2 |
Article enregistré - Type de document | filtres sur la plateforme, modifiables, registered |
||
registered |
guid |
Identifiant de l'article enregistré | filtres sur la plateforme, modifiables, registered |
||
registered |
int64 |
Référence de facture de l'article enregistré | filtres sur la plateforme, modifiables, registered |
||
registered |
varchar2 |
Texte de la facture d'article enregistré | filtres sur la plateforme, modifiables, registered |
||
registered |
char |
Article enregistré - Non facturable | filtres sur la plateforme, modifiables, registered |
||
registered |
varchar2 |
Note relative à un article publié | filtres sur la plateforme, modifiables, registered |
||
registered |
int32 |
Index des commandes d'articles enregistrés | filtres sur la plateforme, modifiables, registered |
||
registered |
varchar2 |
Identifiant du propriétaire de l'article enregistré | filtres sur la plateforme, modifiables, registered |
||
registered |
varchar2 |
itgen_fnx_registeredarticle_ownername | filtres sur la plateforme, modifiables, registered |
||
registered |
char |
Article enregistré – Accès restreint | filtres sur la plateforme, modifiables, registered |
||
registered |
decimal |
Quantité totale d'articles enregistrés | filtres sur la plateforme, modifiables, registered |
||
registered |
decimal |
Coût unitaire des articles enregistrés | filtres sur la plateforme, modifiables, registered |
||
registered |
decimal |
Prix unitaire des articles enregistrés | filtres sur la plateforme, modifiables, registered |
||
registration |
varchar2 |
Type d'inscription | filtres sur la plateforme, modifiables, registration |
||
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 :