TimeReportingRegistrations: Fortnox Time Reporting Registrations
read only REST
- Catalog:
Fortnox - Schema:
TimeReportingRegistrations - Label: 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".
Can only retrieve data.
Summary
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".
API Source
- Endpoint:
/api/time/registrations-v2 - Operation:
get /api/time/registrations-v2
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 356 |
| Full scan rows per minute | 85,000 |
| Point query rows per minute | 168 |
The result can be cached on the client.
Parameters
| Name | Data Type | 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). |
Table Columns
The columns of the table TimeReportingRegistrations are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
charge |
double |
Charge Hours | filters on the platform, writable, charge |
||
child |
guid |
Child ID | filters on the platform, writable, child |
||
cost |
varchar2 |
Cost Centre Active | filters on the platform, writable, cost |
||
cost |
varchar2 |
Cost Centre ID | filters on the platform, writable, cost |
||
cost |
varchar2 |
Cost Centre Name | filters on the platform, writable, cost |
||
created |
varchar2 |
Created by | filters on the platform, writable, created |
||
created |
datetime |
Created Time | filters on the platform, writable, created |
||
customer_ |
varchar2 |
Customer Account Manager | filters on the platform, writable, customer. |
||
customer_ |
char |
Customer Active | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Default Projectid | filters on the platform, writable, customer. |
||
customer_ |
char |
Customer Deleted | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer ID | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Invoice City | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Invoice Zip Code | filters on the platform, writable, customer. |
||
customer_ |
int32 |
Customer Is Business | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Name | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Number | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Pricelist | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Property Designation | filters on the platform, writable, customer. |
||
document |
int64 |
Document ID | filters on the platform, writable, document |
||
document |
varchar2 |
Document Type | filters on the platform, writable, document |
||
id |
guid |
ID | filters on the platform, writable, id |
||
invoice |
int64 |
Invoice Basis ID | filters on the platform, writable, invoice |
||
invoice |
varchar2 |
Invoice Text | filters on the platform, writable, invoice |
||
non |
char |
Non Invoiceable | filters on the platform, writable, non |
||
note |
varchar2 |
Note | filters on the platform, writable, note |
||
project_ |
varchar2 |
Project Description | filters on the platform, writable, project. |
||
project_ |
datetime |
Project End Date | filters on the platform, writable, project. |
||
project_ |
varchar2 |
Project ID | filters on the platform, writable, project. |
||
project_ |
double |
Project Invoiced Amount | filters on the platform, writable, project. |
||
project_ |
double |
Project Order Amount | filters on the platform, writable, project. |
||
project_ |
double |
Project Order Time | filters on the platform, writable, project. |
||
project_ |
varchar2 |
Project Leader | filters on the platform, writable, project. |
||
project_ |
datetime |
Project Start Date | filters on the platform, writable, project. |
||
project_ |
int32 |
Project Status | filters on the platform, writable, project. |
||
project_ |
double |
Project Total Amount in Invoices | filters on the platform, writable, project. |
||
registration |
char |
Registration Code Active | filters on the platform, writable, registration |
||
registration |
varchar2 |
Registration Code | filters on the platform, writable, registration |
||
registration |
double |
Registration Code Cost Multiplier | filters on the platform, writable, registration |
||
registration |
varchar2 |
Registration Code ID | filters on the platform, writable, registration |
||
registration |
varchar2 |
Registration Code Name | filters on the platform, writable, registration |
||
registration |
double |
Registration Code Price Multiplier | filters on the platform, writable, registration |
||
registration |
varchar2 |
Registration Code Type | filters on the platform, writable, registration |
||
service_ |
char |
Service Active | filters on the platform, writable, service. |
||
service_ |
varchar2 |
Service Description | filters on the platform, writable, service. |
||
service_ |
varchar2 |
Service ID | filters on the platform, writable, service. |
||
service_ |
char |
Service Is Stock | filters on the platform, writable, service. |
||
service_ |
decimal |
Service Purchase Price | filters on the platform, writable, service. |
||
service_ |
varchar2 |
Web Service Type | filters on the platform, writable, service. |
||
service_ |
varchar2 |
Service Unit | filters on the platform, writable, service. |
||
start |
datetime |
Start Time | filters on the platform, writable, start |
||
stop |
datetime |
Stop Time | filters on the platform, writable, stop |
||
unit |
decimal |
Unit Cost | filters on the platform, writable, unit |
||
unit |
decimal |
Unit Price | filters on the platform, writable, unit |
||
updated |
varchar2 |
Updated by | filters on the platform, writable, updated |
||
userId |
varchar2 |
User ID | filters on the platform, writable, userId |
||
user |
varchar2 |
User Name | filters on the platform, writable, user |
||
worked |
datetime |
Worked Date | filters on the platform, writable, worked |
||
worked |
double |
Worked (hours) | filters on the platform, writable, worked |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: