# TimeReportingRegistrations: Fortnox Time Reporting Registrations
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".
## Documentation
<p>
<b>Response property descriptions:</b><br/>
<b><i>id</i></b> - The unique id of the registration.<br/>
<b><i>userId</i></b> - The user ID who owns the registration.<br/>
<b><i>workedDate</i></b> - The date for which the registration is created.<br/>
<b><i>workedHours</i></b> - The time spent, or the time of absence.<br/>
<b><i>startTime</i></b> - The start of clock time.<br/>
<b><i>stopTime</i></b> - The end of clock time.<br/>
<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/>
<b><i>note</i></b> - The note on the registration.<br/>
<b><i>chargeHours</i></b> - The time to be invoiced, or 0 for the absence, or locked for non-invoiceable.<br/>
<b><i>childId</i></b> - The child ID related to the absence registration of parental leave (FPE), which comes from Payroll application.<br/>
<b><i>nonInvoiceable</i></b> - If the registration would be ignored for charging or not.<br/>
<b><i>invoiceBasisId</i></b> - The ID of invoice/order basis which is used for creating an invoice/order.<br/>
<b><i>documentId</i></b> - The document ID which includes the registration and is created in Invoicing application.<br/>
<b><i>documentType</i></b> - The document type which could be "invoice" or "order".<br/>
<b><i>unitCost</i></b> - The unit cost from the registration owner who takes the work.<br/>
<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>
- Catalog: `Fortnox`
- Schema: `TimeReportingRegistrations`
- Label: Time Reporting Registrations
This is a read-only table function. The Fortnox API may not support changing the data or the Invantive UniversalSQL driver for Fortnox does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Fortnox API.
## Parameters of Table Function
The following parameters can be used to control the behaviour of the table function `TimeReportingRegistrations`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
| Name | Data Type | Required | Default Value | 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). |
| `inInvoiceBasis` | `` | ☐ | | If the time/absence registration is locked on an invoice basis, or not. |
| `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. |
| `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). |
## Columns of Table Function
The columns of the table function `TimeReportingRegistrations` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `chargeHours` | `double` | Charge Hours | ☐ | |
| `childId` | `guid` | Child ID | ☐ | |
| `costCenter_active` | `varchar2` | Cost Centre Active | ☐ | |
| `costCenter_id` | `varchar2(40)` | Cost Centre ID | ☐ | |
| `costCenter_name` | `varchar2(255)` | Cost Centre Name | ☐ | |
| `createdBy` | `varchar2` | Created by | ☐ | |
| `createdTime` | `datetime` | Created Time | ☐ | |
| `customer_accountManager` | `varchar2` | Customer Account Manager | ☐ | |
| `customer_active` | `char` | Customer Active | ☐ | |
| `customer_defaultProjectId` | `varchar2` | Customer Default Projectid | ☐ | |
| `customer_deleted` | `char` | Customer Deleted | ☐ | |
| `customer_id` | `varchar2(40)` | Customer ID | ☐ | |
| `customer_invoiceCity` | `varchar2` | Customer Invoice City | ☐ | |
| `customer_invoiceZipCode` | `varchar2` | Customer Invoice Zip Code | ☐ | |
| `customer_isBusiness` | `int32` | Customer Is Business | ☐ | |
| `customer_name` | `varchar2(255)` | Customer Name | ☐ | |
| `customer_number` | `varchar2(1024)` | Customer Number | ☐ | |
| `customer_priceList` | `varchar2` | Customer Pricelist | ☐ | |
| `customer_propertyDesignation` | `varchar2` | Customer Property Designation | ☐ | |
| `documentId` | `int64` | Document ID | ☐ | |
| `documentType` | `varchar2` | Document Type | ☐ | |
| `id` | `guid` | ID | ☐ | |
| `invoiceBasisId` | `int64` | Invoice Basis ID | ☐ | |
| `invoiceText` | `varchar2(1000)` | Invoice Text | ☐ | |
| `nonInvoiceable` | `char` | Non Invoiceable | ☐ | |
| `note` | `varchar2(1000)` | Note | ☐ | |
| `project_description` | `varchar2(50)` | Project Description | ☐ | |
| `project_endDate` | `datetime` | Project End Date | ☐ | |
| `project_id` | `varchar2(40)` | Project ID | ☐ | |
| `project_invoicedAmount` | `double` | Project Invoiced Amount | ☐ | |
| `project_orderAmount` | `double` | Project Order Amount | ☐ | |
| `project_orderTime` | `double` | Project Order Time | ☐ | |
| `project_projectLeader` | `varchar2` | Project Leader | ☐ | |
| `project_startDate` | `datetime` | Project Start Date | ☐ | |
| `project_status` | `int32` | Project Status | ☐ | |
| `project_totalAmountInInvoices` | `double` | Project Total Amount in Invoices | ☐ | |
| `registrationCode_active` | `char` | Registration Code Active | ☐ | |
| `registrationCode_code` | `varchar2(3)` | Registration Code | ☐ | |
| `registrationCode_costMultiplier` | `double` | Registration Code Cost Multiplier | ☐ | |
| `registrationCode_id` | `varchar2` | Registration Code ID | ☐ | |
| `registrationCode_name` | `varchar2` | Registration Code Name | ☐ | |
| `registrationCode_priceMultiplier` | `double` | Registration Code Price Multiplier | ☐ | |
| `registrationCode_type` | `varchar2` | Registration Code Type | ☐ | |
| `service_active` | `char` | Service Active | ☐ | |
| `service_description` | `varchar2(255)` | Service Description | ☐ | |
| `service_id` | `varchar2(40)` | Service ID | ☐ | |
| `service_isStock` | `char` | Service Is Stock | ☐ | |
| `service_purchasePrice` | `decimal` | Service Purchase Price | ☐ | |
| `service_type` | `varchar2` | Web Service Type | ☐ | |
| `service_unit` | `varchar2` | Service Unit | ☐ | |
| `startTime` | `datetime` | Start Time | ☐ | |
| `stopTime` | `datetime` | Stop Time | ☐ | |
| `unitCost` | `decimal` | Unit Cost | ☐ | |
| `unitPrice` | `decimal` | Unit Price | ☐ | |
| `updatedBy` | `varchar2` | Updated by | ☐ | |
| `userId` | `varchar2` | User ID | ☐ | |
| `userName` | `varchar2` | User Name | ☐ | |
| `workedDate` | `datetime` | Worked Date | ☐ | |
| `workedHours` | `double` | Worked (hours) | ☐ | |