invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

TimeReportingRegistrations: Fortnox Time Reporting Registrations

read only REST

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

Solo puede recuperar datos.

Resumen

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

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

Notas de la Versión

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