TimeReportingArticleRegistrations: Fortnox Time Reporting Article Registrations
read only REST
- Catálogo:
Fortnox - Esquema:
TimeReportingArticles - Label: Time Reporting Article Registrations
Get full article registrations that match filter
Response property descriptions:
id - The unique id of a basic common combination of article registrations. (The basic common combination means "user/purchase date/customer/project/cost center", which leads to a dialog with several article registrations.)
purchaseDate - The date on which the article is purchased or registered for charging.
ownerId - The user ID who creates the basic common combination.
version - The version of the basic common combination (article dialog) being updated, which is used for handling the concurrency issue.
registrationType - It is always "ARTICLE" for article list endpoint.
Sub-Class - ArticleRegistration:
id - The unique id of an article registration.
registrationId - The id of the basic common combination.
orderIndex - the order index for the article registration in regard of the common combination.
ownerId - The user ID who owns the article registration.
totalQuantity - The quantity of the article.
unitPrice - The unit price connected to the article registration, which might be locked on an invoice/order basis or for non-invoiceable.
unitCost - The unit cost connected to the article registration, which might be locked on an invoice/order basis.
invoiceBasisId - The ID of invoice/order basis which is used for creating an invoice/order.
nonInvoiceable - If the article registration would be ignored for charging or not.
note - The note on the article registration.
documentId - The document ID which includes the article registration and is created in Invoicing application.
documentType - The document type which could be "invoice" or "order".
Solo puede recuperar datos.
Resumen
Response property descriptions:
id - The unique id of a basic common combination of article registrations. (The basic common combination means "user/purchase date/customer/project/cost center", which leads to a dialog with several article registrations.)
purchaseDate - The date on which the article is purchased or registered for charging.
ownerId - The user ID who creates the basic common combination.
version - The version of the basic common combination (article dialog) being updated, which is used for handling the concurrency issue.
registrationType - It is always "ARTICLE" for article list endpoint.
Sub-Class - ArticleRegistration:
id - The unique id of an article registration.
registrationId - The id of the basic common combination.
orderIndex - the order index for the article registration in regard of the common combination.
ownerId - The user ID who owns the article registration.
totalQuantity - The quantity of the article.
unitPrice - The unit price connected to the article registration, which might be locked on an invoice/order basis or for non-invoiceable.
unitCost - The unit cost connected to the article registration, which might be locked on an invoice/order basis.
invoiceBasisId - The ID of invoice/order basis which is used for creating an invoice/order.
nonInvoiceable - If the article registration would be ignored for charging or not.
note - The note on the article registration.
documentId - The document ID which includes the article registration and is created in Invoicing application.
documentType - The document type which could be "invoice" or "order".
Fuente de la API
- Punto final:
/api/time/articles-v1 - Operación:
get /api/time/articles-v1
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 article registration is included, or not. | ||
include |
`` | If the article registration without project is included, or not. | ||
in |
`` | If the article registration is locked on an invoice basis, or not. | ||
internal |
`` | If the article registration is internal, which is registered on an internal customer, or not. | ||
invoiced |
`` | If a document is created with the article registration, or not. | ||
lastmodified |
`` | Retrieves all records since the provided timestamp (does not work on every table). | ||
non |
`` | If the article 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 TimeReportingArticleRegistrations. 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 |
|---|---|---|---|---|---|
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 | editable, created |
||
created |
datetime |
Hora de creación | editable, created |
||
created |
datetime |
Hora de creación 2 | 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. |
||
document |
int64 |
N.º de identificación del documento | editable, document |
||
document |
varchar2 |
Tipo del Documento | editable, document |
||
id |
guid |
ID | editable, id |
||
id_2 |
guid |
ID | filtros en la plataforma, modificables, ::ancestor. |
||
invoice |
int64 |
Identificador de referencia de la factura | editable, invoice |
||
invoice |
varchar2 |
Texto de la factura | editable, invoice |
||
non |
char |
No facturable | editable, non |
||
note |
varchar2 |
Note | editable, note |
||
order |
int32 |
Índice de pedidos | editable, order |
||
owner |
varchar2 |
ID de Propietario | editable, owner |
||
owner |
varchar2 |
ID de propietario 2 | filtros en la plataforma, modificables, ::ancestor. |
||
owner |
varchar2 |
itgen_fnx_ownername | editable, owner |
||
owner |
varchar2 |
itgen_fnx_ownername_2 | 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 |
datetime |
Fecha de Compra | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
varchar2 |
Artículo registrado creado por | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
datetime |
Artículo registrado. Hora de creación | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
int64 |
ID del documento del artículo registrado | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
varchar2 |
Artículo registrado. Tipo de documento | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
guid |
ID del artículo registrado | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
int64 |
N.º de identificación de la factura del artículo registrado | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
varchar2 |
Texto de la factura del artículo registrado | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
char |
Artículo registrado no facturable | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
varchar2 |
Nota sobre el artículo registrado | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
int32 |
Indice de pedidos de artículos registrados | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
varchar2 |
ID del titular del artículo registrado | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
varchar2 |
itgen_fnx_registeredarticle_ownername | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
char |
Artículo registrado con restricción temporal | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
decimal |
Artículo registrado: Cantidad total | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
decimal |
Coste unitario del artículo registrado | filtros en la plataforma, modificables, ::ancestor. |
||
registered |
decimal |
Precio unitario del artículo registrado | filtros en la plataforma, modificables, ::ancestor. |
||
registration |
varchar2 |
Tipo de inscripción | filtros en la plataforma, modificables, ::ancestor. |
||
time |
char |
Con restricción horaria | editable, time |
||
total |
decimal |
Cantidad total | editable, total |
||
unit |
decimal |
Coste unitario | editable, unit |
||
unit |
decimal |
Precio de la Unidad | editable, unit |
||
version |
int64 |
Version | 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: