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:
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). | ||
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). |
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. |
||
charge |
double |
Horas de carga | filtros en la plataforma, modificables, ::ancestor. |
||
child |
guid |
N.º de identificación del menor | filtros en la plataforma, modificables, ::ancestor. |
||
cost |
varchar2 |
Centro de Costo activo | filtros en la plataforma, modificables, ::ancestor. |
||
cost |
varchar2 |
ID del Centro de Costo | filtros en la plataforma, modificables, ::ancestor. |
||
cost |
varchar2 |
Nombre del Centro de Costo | filtros en la plataforma, modificables, ::ancestor. |
||
created |
varchar2 |
Creado por | filtros en la plataforma, modificables, ::ancestor. |
||
created |
datetime |
Hora de creación | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
varchar2 |
Responsable de cuentas de clientes | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
char |
Cliente activo | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
varchar2 |
ID de proyecto predeterminado del cliente | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
char |
Cliente eliminado | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
varchar2 |
ID del Cliente | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
varchar2 |
Ciudad de facturación del cliente | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
varchar2 |
Código postal de la factura del cliente | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
int32 |
El cliente es el negocio | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
varchar2 |
Nombre del Cliente | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
varchar2 |
Numero de cliente | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
varchar2 |
Lista de precios para clientes | filtros en la plataforma, modificables, ::ancestor. |
||
customer_ |
varchar2 |
Designación de la propiedad del cliente | filtros en la plataforma, modificables, ::ancestor. |
||
description |
varchar2 |
Description | editable, ::ancestor. |
||
document |
int64 |
N.º de identificación del documento | filtros en la plataforma, modificables, ::ancestor. |
||
document |
varchar2 |
Tipo del Documento | filtros en la plataforma, modificables, ::ancestor. |
||
id |
varchar2 |
ID | editable, ::ancestor. |
||
id_2 |
guid |
ID | filtros en la plataforma, modificables, ::ancestor. |
||
invoice |
int64 |
Identificador de referencia de la factura | filtros en la plataforma, modificables, ::ancestor. |
||
invoice |
varchar2 |
Texto de la factura | filtros en la plataforma, modificables, ::ancestor. |
||
is |
char |
Es Stock | editable, ::ancestor. |
||
non |
char |
No facturable | filtros en la plataforma, modificables, ::ancestor. |
||
note |
varchar2 |
Note | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
varchar2 |
Descripción del Proyecto | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
datetime |
Fecha de finalización del proyecto | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
varchar2 |
Identificación del Proyecto | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
double |
Importe facturado del proyecto | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
double |
Importe del pedido del proyecto | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
double |
Plazo de ejecución del proyecto | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
varchar2 |
Responsable del proyecto | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
datetime |
Fecha de inicio del proyecto | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
int32 |
Estado del Proyecto | filtros en la plataforma, modificables, ::ancestor. |
||
project_ |
double |
Importe total del proyecto en facturas | filtros en la plataforma, modificables, ::ancestor. |
||
purchase |
decimal |
Precio de Compra | editable, ::ancestor. |
||
registration |
char |
Código de registro activo | filtros en la plataforma, modificables, ::ancestor. |
||
registration |
varchar2 |
Código de registro | filtros en la plataforma, modificables, ::ancestor. |
||
registration |
double |
Multiplicador del coste del código de registro | filtros en la plataforma, modificables, ::ancestor. |
||
registration |
varchar2 |
N.º de identificación del código de registro | filtros en la plataforma, modificables, ::ancestor. |
||
registration |
varchar2 |
Nombre del código de registro | filtros en la plataforma, modificables, ::ancestor. |
||
registration |
double |
Código de registro, precio, multiplicador | filtros en la plataforma, modificables, ::ancestor. |
||
registration |
varchar2 |
Tipo de código de registro | filtros en la plataforma, modificables, ::ancestor. |
||
start |
datetime |
Hora de Inicio | filtros en la plataforma, modificables, ::ancestor. |
||
stop |
datetime |
Detener el tiempo | filtros en la plataforma, modificables, ::ancestor. |
||
type |
varchar2 |
Type | editable, ::ancestor. |
||
unit |
varchar2 |
Unit | editable, ::ancestor. |
||
unit |
decimal |
Coste unitario | filtros en la plataforma, modificables, ::ancestor. |
||
unit |
decimal |
Precio de la Unidad | filtros en la plataforma, modificables, ::ancestor. |
||
updated |
varchar2 |
Actualizado por | filtros en la plataforma, modificables, ::ancestor. |
||
userId |
varchar2 |
Identificación de Usuario | filtros en la plataforma, modificables, ::ancestor. |
||
user |
varchar2 |
Nombre de Usuario | filtros en la plataforma, modificables, ::ancestor. |
||
worked |
datetime |
Fecha de trabajo | filtros en la plataforma, modificables, ::ancestor. |
||
worked |
double |
Trabajado (horas) | filtros en la plataforma, modificables, ::ancestor. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: