---
title: "TimeReportingRegistrationServiceSalesPrices (Fortnox)"
description: "Time Reporting Registration Service Sales Prices"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/fortnox/Fortnox.TimeReportingRegistrations.TimeReportingRegistrationServiceSalesPrices
original: https://documentation.invantive.eu/en/datamodels/fortnox/Fortnox.TimeReportingRegistrations.TimeReportingRegistrationServiceSalesPrices
updated: 2026-11-17T22:04:45Z
license: https://documentation.invantive.eu/nl/
---

# TimeReportingRegistrationServiceSalesPrices: Fortnox Time Reporting Registration Service Sales Prices

`read only` `REST`

- Catalogus: `Fortnox`
- Schema: `TimeReportingRegistrations`
- Label: Time Reporting Registration Service Sales Prices

Get time/absence registrations that match filter

Response property descriptions:

&nbsp;&nbsp;&nbsp;&nbsp;    id - The unique id of the registration.

&nbsp;&nbsp;&nbsp;&nbsp;    userId - The user ID who owns the registration.

&nbsp;&nbsp;&nbsp;&nbsp;    workedDate - The date for which the registration is created.

&nbsp;&nbsp;&nbsp;&nbsp;    workedHours - The time spent, or the time of absence.

&nbsp;&nbsp;&nbsp;&nbsp;    startTime - The start of clock time.

&nbsp;&nbsp;&nbsp;&nbsp;    stopTime - The end of clock time.

&nbsp;&nbsp;&nbsp;&nbsp;    invoiceText - The text to be included in the invoice/order basis which would be used to create an invoice/order.

&nbsp;&nbsp;&nbsp;&nbsp;    note - The note on the registration.

&nbsp;&nbsp;&nbsp;&nbsp;    chargeHours - The time to be invoiced, or 0 for the absence, or locked for non-invoiceable.

&nbsp;&nbsp;&nbsp;&nbsp;    childId - The child ID related to the absence registration of parental leave (FPE), which comes from Payroll application.

&nbsp;&nbsp;&nbsp;&nbsp;    nonInvoiceable - If the registration would be ignored for charging or not.

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

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

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

&nbsp;&nbsp;&nbsp;&nbsp;    unitCost - The unit cost from the registration owner who takes the work.

&nbsp;&nbsp;&nbsp;&nbsp;    unitPrice - The unit price for the service on the registration, which comes in priority from "invoice/order basis", "price group" or "service".

Kan alleen gegevens ophalen.

## Samenvatting

<p>
 <b>Response property descriptions:</b><br/>
&nbsp;&nbsp;&nbsp;&nbsp;    <b><i>id</i></b> - The unique id of the registration.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>userId</i></b> - The user ID who owns the registration.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>workedDate</i></b> - The date for which the registration is created.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>workedHours</i></b> - The time spent, or the time of absence.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>startTime</i></b> - The start of clock time.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>stopTime</i></b> - The end of clock time.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>invoiceText</i></b> - The text to be included in the invoice/order basis which would be used to create an invoice/order.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>note</i></b> - The note on the registration.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>chargeHours</i></b> - The time to be invoiced, or 0 for the absence, or locked for non-invoiceable.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>childId</i></b> - The child ID related to the absence registration of parental leave (FPE), which comes from Payroll application.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>nonInvoiceable</i></b> - If the registration would be ignored for charging or not.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>invoiceBasisId</i></b> - The ID of invoice/order basis which is used for creating an invoice/order.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>documentId</i></b> - The document ID which includes the registration and is created in Invoicing application.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>documentType</i></b> - The document type which could be "invoice" or "order".<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>unitCost</i></b> - The unit cost from the registration owner who takes the work.<br/> &nbsp;&nbsp;&nbsp;&nbsp;    <b><i>unitPrice</i></b> - The unit price for the service on the registration, which comes in priority from "invoice/order basis", "price group" or "service".
 <p>

## API-bron

- Eindpunt: `/api/time/registrations-v2`
- Operatie: `get /api/time/registrations-v2`

## Prestatiekenmerken

| Characteristic | Value |
|---|---:|
| Gemiddelde toegangsvertraging (ms) | 356 |
| Aantal rijen per minuut bij volledige scan | 85,000 |
| Aantal rijen per minuut in een Query | 168 |

Het resultaat kan op de client in de Cache worden opgeslagen.

## Parameters

| Name | Datatype | 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). |
| `includeNonInvoiceableChargeHours` | `` | [ ] |  | If the price of the non-invoiceable time/absence registration is included, or not. |
| `includeRegistrationsWithoutProject` | `` | [ ] |  | If the time/absence registration without project is included, or not. |
| `inInvoiceBasis` | `` | [ ] |  | If the time/absence registration is locked on an invoice basis, or not. |
| `internalTime` | `` | [ ] |  | 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). |
| `nonInvoiceable` | `` | [ ] |  | 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). |

## Tabelkolommen

De kolommen van de tabel `TimeReportingRegistrationServiceSalesPrices` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `active` | `char` | Active | [ ] | beschrijfbaar, `::ancestor.active` |  |
| `chargeHours` | `double` | Laaduren | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.chargeHours` |  |
| `childId` | `guid` | Kind-ID | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.childId` |  |
| `costCenter_active` | `varchar2` | Kostenplaats actief | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.costCenter.active` |  |
| `costCenter_id` | `varchar2(40)` | Kostenplaats ID | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.costCenter.id` |  |
| `costCenter_name` | `varchar2(255)` | Kostenplaatsnaam | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.costCenter.name` |  |
| `createdBy` | `varchar2` | Gemaakt door | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.createdBy` |  |
| `createdTime` | `datetime` | Aanmaakdatum | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.createdTime` |  |
| `customer_accountManager` | `varchar2` | Accountmanager voor klanten | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.accountManager` |  |
| `customer_active` | `char` | Klant actief | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.active` |  |
| `customer_defaultProjectId` | `varchar2` | Standaard project-ID voor klanten | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.defaultProjectId` |  |
| `customer_deleted` | `char` | Klant verwijderd | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.deleted` |  |
| `customer_id` | `varchar2(40)` | Klant ID | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.id` |  |
| `customer_invoiceCity` | `varchar2` | Klantfactuur Plaats | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.invoiceCity` |  |
| `customer_invoiceZipCode` | `varchar2` | Postcode op de factuur van de klant | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.invoiceZipCode` |  |
| `customer_isBusiness` | `int32` | De klant is koning | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.isBusiness` |  |
| `customer_name` | `varchar2(255)` | Naam Klant | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.name` |  |
| `customer_number` | `varchar2(1024)` | Klantnummer | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.number` |  |
| `customer_priceList` | `varchar2` | Prijslijst voor klanten | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.priceList` |  |
| `customer_propertyDesignation` | `varchar2` | Aanduiding van eigendom van de klant | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.customer.propertyDesignation` |  |
| `description` | `varchar2(255)` | Description | [ ] | beschrijfbaar, `::ancestor.description` |  |
| `documentId` | `int64` | Document ID | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.documentId` |  |
| `documentType` | `varchar2` | Documentsoort | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.documentType` |  |
| `id` | `varchar2(40)` | ID | [ ] | beschrijfbaar, `::ancestor.id` |  |
| `id_2` | `guid` | ID | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.id` |  |
| `invoiceBasisId` | `int64` | Factuurbasis ID | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.invoiceBasisId` |  |
| `invoiceText` | `varchar2(1000)` | Factuurtekst | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.invoiceText` |  |
| `isStock` | `char` | Is Voorraad | [ ] | beschrijfbaar, `::ancestor.isStock` |  |
| `nonInvoiceable` | `char` | Niet factureerbaar | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.nonInvoiceable` |  |
| `note` | `varchar2(1000)` | Note | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.note` |  |
| `project_description` | `varchar2(50)` | Projectomschrijving | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.description` |  |
| `project_endDate` | `datetime` | Project Einddatum | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.endDate` |  |
| `project_id` | `varchar2(40)` | Project ID | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.id` |  |
| `project_invoicedAmount` | `double` | Factuurbedrag van het project | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.invoicedAmount` |  |
| `project_orderAmount` | `double` | Bedrag van de projectopdracht | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.orderAmount` |  |
| `project_orderTime` | `double` | Projectopdrachttijd | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.orderTime` |  |
| `project_projectLeader` | `varchar2` | Projectleider | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.projectLeader` |  |
| `project_startDate` | `datetime` | Project Startdatum | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.startDate` |  |
| `project_status` | `int32` | Projectstatus | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.status` |  |
| `project_totalAmountInInvoices` | `double` | Totaalbedrag van de facturen voor het project | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.project.totalAmountInInvoices` |  |
| `purchasePrice` | `decimal` | Inkoopsprijs | [ ] | beschrijfbaar, `::ancestor.purchasePrice` |  |
| `registrationCode_active` | `char` | Registratiecode actief | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.registrationCode.active` |  |
| `registrationCode_code` | `varchar2(3)` | Registratiecode | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.registrationCode.code` |  |
| `registrationCode_costMultiplier` | `double` | Registratiecode Kostenvermenigvuldigingsfactor | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.registrationCode.costMultiplier` |  |
| `registrationCode_id` | `varchar2` | Registratiecode-ID | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.registrationCode.id` |  |
| `registrationCode_name` | `varchar2` | Registratiecode Naam | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.registrationCode.name` |  |
| `registrationCode_priceMultiplier` | `double` | Registratiecode Prijsvermenigvuldigingsfactor | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.registrationCode.priceMultiplier` |  |
| `registrationCode_type` | `varchar2` | Type registratiecode | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.registrationCode.type` |  |
| `startTime` | `datetime` | Starttijd | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.startTime` |  |
| `stopTime` | `datetime` | Tijd stilzetten | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.stopTime` |  |
| `type` | `varchar2` | Type | [ ] | beschrijfbaar, `::ancestor.type` |  |
| `unit` | `varchar2` | Unit | [ ] | beschrijfbaar, `::ancestor.unit` |  |
| `unitCost` | `decimal` | Kosten per Eenheid | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.unitCost` |  |
| `unitPrice` | `decimal` | Prijs per Eenheid | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.unitPrice` |  |
| `updatedBy` | `varchar2` | Bijgewerkt door | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.updatedBy` |  |
| `userId` | `varchar2` | Gebruikers-ID | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.userId` |  |
| `userName` | `varchar2` | Gebruikersnaam | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.userName` |  |
| `workedDate` | `datetime` | Datum van uitvoering | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.workedDate` |  |
| `workedHours` | `double` | Gewerkt (uren) | [ ] | filters op het platform, beschrijfbaar, `::ancestor.::ancestor.workedHours` |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

- [Fortnox](/nl/release-notes/drivers?driver=fortnox)
