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

# TimeReportingRegistrationServiceSalesPrices: Fortnox Time Reporting Registration Service Sales Prices

`read only` `REST`

- Catálogo: `Fortnox`
- Esquema: `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".

Solo puede recuperar datos.

## Resumen

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

## Fuente de la API

- Punto final: `/api/time/registrations-v2`
- Operación: `get /api/time/registrations-v2`

## 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). |
| `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). |

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `TimeReportingRegistrationServiceSalesPrices`. 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 |
|---|---|---|:---:|---|---|
| `active` | `char` | Active | [ ] | editable, `::ancestor.active` |  |
| `chargeHours` | `double` | Horas de carga | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.chargeHours` |  |
| `childId` | `guid` | N.º de identificación del menor | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.childId` |  |
| `costCenter_active` | `varchar2` | Centro de Costo activo | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.costCenter.active` |  |
| `costCenter_id` | `varchar2(40)` | ID del Centro de Costo | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.costCenter.id` |  |
| `costCenter_name` | `varchar2(255)` | Nombre del Centro de Costo | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.costCenter.name` |  |
| `createdBy` | `varchar2` | Creado por | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.createdBy` |  |
| `createdTime` | `datetime` | Hora de creación | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.createdTime` |  |
| `customer_accountManager` | `varchar2` | Responsable de cuentas de clientes | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.accountManager` |  |
| `customer_active` | `char` | Cliente activo | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.active` |  |
| `customer_defaultProjectId` | `varchar2` | ID de proyecto predeterminado del cliente | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.defaultProjectId` |  |
| `customer_deleted` | `char` | Cliente eliminado | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.deleted` |  |
| `customer_id` | `varchar2(40)` | ID del Cliente | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.id` |  |
| `customer_invoiceCity` | `varchar2` | Ciudad de facturación del cliente | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.invoiceCity` |  |
| `customer_invoiceZipCode` | `varchar2` | Código postal de la factura del cliente | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.invoiceZipCode` |  |
| `customer_isBusiness` | `int32` | El cliente es el negocio | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.isBusiness` |  |
| `customer_name` | `varchar2(255)` | Nombre del Cliente | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.name` |  |
| `customer_number` | `varchar2(1024)` | Numero de cliente | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.number` |  |
| `customer_priceList` | `varchar2` | Lista de precios para clientes | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.priceList` |  |
| `customer_propertyDesignation` | `varchar2` | Designación de la propiedad del cliente | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.customer.propertyDesignation` |  |
| `description` | `varchar2(255)` | Description | [ ] | editable, `::ancestor.description` |  |
| `documentId` | `int64` | N.º de identificación del documento | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.documentId` |  |
| `documentType` | `varchar2` | Tipo del Documento | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.documentType` |  |
| `id` | `varchar2(40)` | ID | [ ] | editable, `::ancestor.id` |  |
| `id_2` | `guid` | ID | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.id` |  |
| `invoiceBasisId` | `int64` | Identificador de referencia de la factura | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.invoiceBasisId` |  |
| `invoiceText` | `varchar2(1000)` | Texto de la factura | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.invoiceText` |  |
| `isStock` | `char` | Es Stock | [ ] | editable, `::ancestor.isStock` |  |
| `nonInvoiceable` | `char` | No facturable | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.nonInvoiceable` |  |
| `note` | `varchar2(1000)` | Note | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.note` |  |
| `project_description` | `varchar2(50)` | Descripción del Proyecto | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.description` |  |
| `project_endDate` | `datetime` | Fecha de finalización del proyecto | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.endDate` |  |
| `project_id` | `varchar2(40)` | Identificación del Proyecto | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.id` |  |
| `project_invoicedAmount` | `double` | Importe facturado del proyecto | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.invoicedAmount` |  |
| `project_orderAmount` | `double` | Importe del pedido del proyecto | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.orderAmount` |  |
| `project_orderTime` | `double` | Plazo de ejecución del proyecto | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.orderTime` |  |
| `project_projectLeader` | `varchar2` | Responsable del proyecto | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.projectLeader` |  |
| `project_startDate` | `datetime` | Fecha de inicio del proyecto | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.startDate` |  |
| `project_status` | `int32` | Estado del Proyecto | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.status` |  |
| `project_totalAmountInInvoices` | `double` | Importe total del proyecto en facturas | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.project.totalAmountInInvoices` |  |
| `purchasePrice` | `decimal` | Precio de Compra | [ ] | editable, `::ancestor.purchasePrice` |  |
| `registrationCode_active` | `char` | Código de registro activo | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.registrationCode.active` |  |
| `registrationCode_code` | `varchar2(3)` | Código de registro | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.registrationCode.code` |  |
| `registrationCode_costMultiplier` | `double` | Multiplicador del coste del código de registro | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.registrationCode.costMultiplier` |  |
| `registrationCode_id` | `varchar2` | N.º de identificación del código de registro | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.registrationCode.id` |  |
| `registrationCode_name` | `varchar2` | Nombre del código de registro | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.registrationCode.name` |  |
| `registrationCode_priceMultiplier` | `double` | Código de registro, precio, multiplicador | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.registrationCode.priceMultiplier` |  |
| `registrationCode_type` | `varchar2` | Tipo de código de registro | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.registrationCode.type` |  |
| `startTime` | `datetime` | Hora de Inicio | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.startTime` |  |
| `stopTime` | `datetime` | Detener el tiempo | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.stopTime` |  |
| `type` | `varchar2` | Type | [ ] | editable, `::ancestor.type` |  |
| `unit` | `varchar2` | Unit | [ ] | editable, `::ancestor.unit` |  |
| `unitCost` | `decimal` | Coste unitario | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.unitCost` |  |
| `unitPrice` | `decimal` | Precio de la Unidad | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.unitPrice` |  |
| `updatedBy` | `varchar2` | Actualizado por | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.updatedBy` |  |
| `userId` | `varchar2` | Identificación de Usuario | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.userId` |  |
| `userName` | `varchar2` | Nombre de Usuario | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.userName` |  |
| `workedDate` | `datetime` | Fecha de trabajo | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.workedDate` |  |
| `workedHours` | `double` | Trabajado (horas) | [ ] | filtros en la plataforma, modificables, `::ancestor.::ancestor.workedHours` |  |


## Notas de la Versión

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

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