invantive documentation
Invantive Support ForumsLog In / Sign Up

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

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
chargeHours double Charge Hours filters on the platform, writable, chargeHours
childId guid Child ID filters on the platform, writable, childId
costCenter_active varchar2 Cost Centre Active filters on the platform, writable, costCenter.active
costCenter_id varchar2(40) Cost Centre ID filters on the platform, writable, costCenter.id
costCenter_name varchar2(255) Cost Centre Name filters on the platform, writable, costCenter.name
createdBy varchar2 Created by filters on the platform, writable, createdBy
createdTime datetime Created Time filters on the platform, writable, createdTime
customer_accountManager varchar2 Customer Account Manager filters on the platform, writable, customer.accountManager
customer_active char Customer Active filters on the platform, writable, customer.active
customer_defaultProjectId varchar2 Customer Default Projectid filters on the platform, writable, customer.defaultProjectId
customer_deleted char Customer Deleted filters on the platform, writable, customer.deleted
customer_id varchar2(40) Customer ID filters on the platform, writable, customer.id
customer_invoiceCity varchar2 Customer Invoice City filters on the platform, writable, customer.invoiceCity
customer_invoiceZipCode varchar2 Customer Invoice Zip Code filters on the platform, writable, customer.invoiceZipCode
customer_isBusiness int32 Customer Is Business filters on the platform, writable, customer.isBusiness
customer_name varchar2(255) Customer Name filters on the platform, writable, customer.name
customer_number varchar2(1024) Customer Number filters on the platform, writable, customer.number
customer_priceList varchar2 Customer Pricelist filters on the platform, writable, customer.priceList
customer_propertyDesignation varchar2 Customer Property Designation filters on the platform, writable, customer.propertyDesignation
documentId int64 Document ID filters on the platform, writable, documentId
documentType varchar2 Document Type filters on the platform, writable, documentType
id guid ID filters on the platform, writable, id
invoiceBasisId int64 Invoice Basis ID filters on the platform, writable, invoiceBasisId
invoiceText varchar2(1000) Invoice Text filters on the platform, writable, invoiceText
nonInvoiceable char Non Invoiceable filters on the platform, writable, nonInvoiceable
note varchar2(1000) Note filters on the platform, writable, note
project_description varchar2(50) Project Description filters on the platform, writable, project.description
project_endDate datetime Project End Date filters on the platform, writable, project.endDate
project_id varchar2(40) Project ID filters on the platform, writable, project.id
project_invoicedAmount double Project Invoiced Amount filters on the platform, writable, project.invoicedAmount
project_orderAmount double Project Order Amount filters on the platform, writable, project.orderAmount
project_orderTime double Project Order Time filters on the platform, writable, project.orderTime
project_projectLeader varchar2 Project Leader filters on the platform, writable, project.projectLeader
project_startDate datetime Project Start Date filters on the platform, writable, project.startDate
project_status int32 Project Status filters on the platform, writable, project.status
project_totalAmountInInvoices double Project Total Amount in Invoices filters on the platform, writable, project.totalAmountInInvoices
registrationCode_active char Registration Code Active filters on the platform, writable, registrationCode.active
registrationCode_code varchar2(3) Registration Code filters on the platform, writable, registrationCode.code
registrationCode_costMultiplier double Registration Code Cost Multiplier filters on the platform, writable, registrationCode.costMultiplier
registrationCode_id varchar2 Registration Code ID filters on the platform, writable, registrationCode.id
registrationCode_name varchar2 Registration Code Name filters on the platform, writable, registrationCode.name
registrationCode_priceMultiplier double Registration Code Price Multiplier filters on the platform, writable, registrationCode.priceMultiplier
registrationCode_type varchar2 Registration Code Type filters on the platform, writable, registrationCode.type
service_active char Service Active filters on the platform, writable, service.active
service_description varchar2(255) Service Description filters on the platform, writable, service.description
service_id varchar2(40) Service ID filters on the platform, writable, service.id
service_isStock char Service Is Stock filters on the platform, writable, service.isStock
service_purchasePrice decimal Service Purchase Price filters on the platform, writable, service.purchasePrice
service_type varchar2 Web Service Type filters on the platform, writable, service.type
service_unit varchar2 Service Unit filters on the platform, writable, service.unit
startTime datetime Start Time filters on the platform, writable, startTime
stopTime datetime Stop Time filters on the platform, writable, stopTime
unitCost decimal Unit Cost filters on the platform, writable, unitCost
unitPrice decimal Unit Price filters on the platform, writable, unitPrice
updatedBy varchar2 Updated by filters on the platform, writable, updatedBy
userId varchar2 User ID filters on the platform, writable, userId
userName varchar2 User Name filters on the platform, writable, userName
workedDate datetime Worked Date filters on the platform, writable, workedDate
workedHours double Worked (hours) filters on the platform, writable, workedHours

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: