TimeReportingRegistrationServiceSalesPrices: Fortnox Time Reporting Registration Service Sales Prices
read only REST
- Catalogue :
Fortnox - Schéma :
TimeReportingRegistrations - Label: Time Reporting Registration Service Sales Prices
Get time/absence registrations that match filter
Response property descriptions:
id - The unique id of the registration.
userId - The user ID who owns the registration.
workedDate - The date for which the registration is created.
workedHours - The time spent, or the time of absence.
startTime - The start of clock time.
stopTime - The end of clock time.
invoiceText - The text to be included in the invoice/order basis which would be used to create an invoice/order.
note - The note on the registration.
chargeHours - The time to be invoiced, or 0 for the absence, or locked for non-invoiceable.
childId - The child ID related to the absence registration of parental leave (FPE), which comes from Payroll application.
nonInvoiceable - If the registration would be ignored for charging or not.
invoiceBasisId - The ID of invoice/order basis which is used for creating an invoice/order.
documentId - The document ID which includes the registration and is created in Invoicing application.
documentType - The document type which could be "invoice" or "order".
unitCost - The unit cost from the registration owner who takes the work.
unitPrice - The unit price for the service on the registration, which comes in priority from "invoice/order basis", "price group" or "service".
Permet uniquement de récupérer des données.
Résumé
Response property descriptions:
id - The unique id of the registration.
userId - The user ID who owns the registration.
workedDate - The date for which the registration is created.
workedHours - The time spent, or the time of absence.
startTime - The start of clock time.
stopTime - The end of clock time.
invoiceText - The text to be included in the invoice/order basis which would be used to create an invoice/order.
note - The note on the registration.
chargeHours - The time to be invoiced, or 0 for the absence, or locked for non-invoiceable.
childId - The child ID related to the absence registration of parental leave (FPE), which comes from Payroll application.
nonInvoiceable - If the registration would be ignored for charging or not.
invoiceBasisId - The ID of invoice/order basis which is used for creating an invoice/order.
documentId - The document ID which includes the registration and is created in Invoicing application.
documentType - The document type which could be "invoice" or "order".
unitCost - The unit cost from the registration owner who takes the work.
unitPrice - The unit price for the service on the registration, which comes in priority from "invoice/order basis", "price group" or "service".
Source de l'API
- Point de terminaison :
/api/time/registrations-v2 - Opération :
get /api/time/registrations-v2
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 time/absence registration is included, or not. | ||
include |
`` | If the time/absence registration without project is included, or not. | ||
in |
`` | If the time/absence registration is locked on an invoice basis, or not. | ||
internal |
`` | If the time/absence registration is internal, which is registered on an internal customer, or not. | ||
invoiced |
`` | If a document is created with the time/absence registration, or not. | ||
lastmodified |
`` | Retrieves all records since the provided timestamp (does not work on every table). | ||
non |
`` | If the time/absence 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 TimeReportingRegistrationServiceSalesPrices 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 |
|---|---|---|---|---|---|
active |
char |
Active | modifiable, ::ancestor. |
||
charge |
double |
Heures de charge | filtres sur la plateforme, modifiables, ::ancestor. |
||
child |
guid |
Identifiant de l'enfant | filtres sur la plateforme, modifiables, ::ancestor. |
||
cost |
varchar2 |
Centre de coûts actif | filtres sur la plateforme, modifiables, ::ancestor. |
||
cost |
varchar2 |
Identifiant du centre de coûts | filtres sur la plateforme, modifiables, ::ancestor. |
||
cost |
varchar2 |
Nom du centre de coûts | filtres sur la plateforme, modifiables, ::ancestor. |
||
created |
varchar2 |
Crée par | filtres sur la plateforme, modifiables, ::ancestor. |
||
created |
datetime |
Date de création | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
varchar2 |
Responsable de compte client | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
char |
Client actif | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
varchar2 |
Identifiant de projet par défaut du client | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
char |
Client supprimé | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
varchar2 |
ID de cliente | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
varchar2 |
Ville de facturation du client | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
varchar2 |
Code postal figurant sur la facture du client | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
int32 |
Le client, c'est l'entreprise | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
varchar2 |
Nom du client | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
varchar2 |
Numéro de client | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
varchar2 |
Liste des tarifs clients | filtres sur la plateforme, modifiables, ::ancestor. |
||
customer_ |
varchar2 |
Désignation des biens du client | filtres sur la plateforme, modifiables, ::ancestor. |
||
description |
varchar2 |
Description | modifiable, ::ancestor. |
||
document |
int64 |
Document ID | filtres sur la plateforme, modifiables, ::ancestor. |
||
document |
varchar2 |
Type de document | filtres sur la plateforme, modifiables, ::ancestor. |
||
id |
varchar2 |
ID | modifiable, ::ancestor. |
||
id_2 |
guid |
ID | filtres sur la plateforme, modifiables, ::ancestor. |
||
invoice |
int64 |
Référence de la facture | filtres sur la plateforme, modifiables, ::ancestor. |
||
invoice |
varchar2 |
Texte de facture | filtres sur la plateforme, modifiables, ::ancestor. |
||
is |
char |
Est-ce en stock ? | modifiable, ::ancestor. |
||
non |
char |
Non facturable | filtres sur la plateforme, modifiables, ::ancestor. |
||
note |
varchar2 |
Note | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
varchar2 |
Description du projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
datetime |
Date de fin du projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
varchar2 |
Identifiant du projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
double |
Montant facturé du projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
double |
Montant de la commande du projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
double |
Durée du projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
varchar2 |
Chef de projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
datetime |
Date de début du projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
int32 |
État du projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
project_ |
double |
Montant total des factures du projet | filtres sur la plateforme, modifiables, ::ancestor. |
||
purchase |
decimal |
Prix d'achat | modifiable, ::ancestor. |
||
registration |
char |
Code d'enregistrement actif | filtres sur la plateforme, modifiables, ::ancestor. |
||
registration |
varchar2 |
Code d'enregistrement | filtres sur la plateforme, modifiables, ::ancestor. |
||
registration |
double |
Code d'enregistrement - Coût - Multiplicateur | filtres sur la plateforme, modifiables, ::ancestor. |
||
registration |
varchar2 |
Code d'enregistrement | filtres sur la plateforme, modifiables, ::ancestor. |
||
registration |
varchar2 |
Nom du code d'enregistrement | filtres sur la plateforme, modifiables, ::ancestor. |
||
registration |
double |
Code d'enregistrement - Multiplicateur de prix | filtres sur la plateforme, modifiables, ::ancestor. |
||
registration |
varchar2 |
Type de code d'enregistrement | filtres sur la plateforme, modifiables, ::ancestor. |
||
start |
datetime |
Heure de début | filtres sur la plateforme, modifiables, ::ancestor. |
||
stop |
datetime |
Arrêter le temps | filtres sur la plateforme, modifiables, ::ancestor. |
||
type |
varchar2 |
Type | modifiable, ::ancestor. |
||
unit |
varchar2 |
Unit | modifiable, ::ancestor. |
||
unit |
decimal |
Coût unitaire | filtres sur la plateforme, modifiables, ::ancestor. |
||
unit |
decimal |
Prix unitaire | filtres sur la plateforme, modifiables, ::ancestor. |
||
updated |
varchar2 |
Mise à jour par | filtres sur la plateforme, modifiables, ::ancestor. |
||
userId |
varchar2 |
ID utilisateur | filtres sur la plateforme, modifiables, ::ancestor. |
||
user |
varchar2 |
Nom d'Utilisateur | filtres sur la plateforme, modifiables, ::ancestor. |
||
worked |
datetime |
Date de travail | filtres sur la plateforme, modifiables, ::ancestor. |
||
worked |
double |
Heures travaillées | filtres sur la plateforme, modifiables, ::ancestor. |
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 :