invantive documentation
Forum di supporto InvantiveAccedi / Registrati

TimeReportingArticleRegistrationSalesPrices: Fortnox Time Reporting Article Registration Sales Prices

read only REST

  • Catalogo: Fortnox
  • Schema: TimeReportingArticles
  • Label: Time Reporting Article Registration Sales Prices

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

È possibile solo recuperare i dati.

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

Codice sorgente dell'API

  • Punto finale: /api/time/articles-v1
  • Operazione: get /api/time/articles-v1

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 356
Righe di scansione completa al minuto 85,000
Numero di righe di Query al minuto 168

Il risultato può essere memorizzato nella memoria cache sul client.

Parametri

Name Tipo di dati 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).
includeNonInvoiceablePrice `` If the price of the non-invoiceable article registration is included, or not.
includeRegistrationsWithoutProject `` If the article registration without project is included, or not.
inInvoiceBasis `` If the article registration is locked on an invoice basis, or not.
internalArticles `` 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).
nonInvoiceable `` 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).

Colonne della tabella

Di seguito sono riportate le colonne della tabella TimeReportingArticleRegistrationSalesPrices. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
costCenter_active varchar2 Centro di costo attivo filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.costCenter.active
costCenter_id varchar2(40) ID centro di costo filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.costCenter.id
costCenter_name varchar2(255) Nome del centro di costo filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.costCenter.name
createdBy varchar2 Creato da scrivibile, ::ancestor.::ancestor.createdBy
createdTime datetime Ora di creazione scrivibile, ::ancestor.::ancestor.createdTime
createdTime_2 datetime Ora di creazione 2 filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.createdTime
customer_accountManager varchar2 Responsabile dei rapporti con i clienti filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.accountManager
customer_active char Cliente attivo filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.active
customer_defaultProjectId varchar2 ID progetto predefinito del cliente filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.defaultProjectId
customer_deleted char Cliente eliminato filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.deleted
customer_id varchar2(40) ID cliente filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.id
customer_invoiceCity varchar2 Città di fatturazione del cliente filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.invoiceCity
customer_invoiceZipCode varchar2 Codice postale della fattura del cliente filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.invoiceZipCode
customer_isBusiness int32 Il cliente è il cuore dell'azienda filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.isBusiness
customer_name varchar2(255) Nome del cliente filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.name
customer_number varchar2(1024) Numero del cliente filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.number
customer_priceList varchar2 Listino prezzi per i clienti filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.priceList
customer_propertyDesignation varchar2 Designazione della proprietà del cliente filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.customer.propertyDesignation
documentId int64 ID del documento scrivibile, ::ancestor.::ancestor.documentId
documentType varchar2 Tipo di documento scrivibile, ::ancestor.::ancestor.documentType
id guid ID scrivibile, ::ancestor.::ancestor.id
id_2 guid ID filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.id
invoiceBasisId int64 ID base della fattura scrivibile, ::ancestor.::ancestor.invoiceBasisId
invoiceText varchar2(1000) Testo della fattura scrivibile, ::ancestor.::ancestor.invoiceText
nonInvoiceable char Non fatturabile scrivibile, ::ancestor.::ancestor.nonInvoiceable
note varchar2(1000) Note scrivibile, ::ancestor.::ancestor.note
orderIndex int32 Indice degli ordini scrivibile, ::ancestor.::ancestor.orderIndex
ownerId varchar2 ID del proprietario scrivibile, ::ancestor.::ancestor.ownerId
ownerId_2 varchar2 ID proprietario 2 filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.ownerId
ownerName varchar2 itgen_fnx_ownername scrivibile, ::ancestor.::ancestor.ownerName
ownerName_2 varchar2 itgen_fnx_ownername_2 filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.ownerName
project_description varchar2(50) Descrizione del progetto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.description
project_endDate datetime Data di conclusione del progetto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.endDate
project_id varchar2(40) Identificatore del progetto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.id
project_invoicedAmount double Importo fatturato del progetto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.invoicedAmount
project_orderAmount double Importo dell'ordine di progetto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.orderAmount
project_orderTime double Tempo di evasione dell'ordine del progetto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.orderTime
project_projectLeader varchar2 Responsabile del progetto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.projectLeader
project_startDate datetime Data di inizio del progetto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.startDate
project_status int32 Stato del progetto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.status
project_totalAmountInInvoices double Importo totale del progetto indicato nelle fatture filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.project.totalAmountInInvoices
purchaseDate datetime Data di acquisto filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.purchaseDate
registeredArticle_createdBy varchar2 Articolo registrato creato da filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.createdBy
registeredArticle_createdTime datetime Articolo registrato - Ora di creazione filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.createdTime
registeredArticle_documentId int64 ID documento dell'articolo registrato filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.documentId
registeredArticle_documentType varchar2 Articolo registrato - Tipo di documento filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.documentType
registeredArticle_id guid ID articolo registrato filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.id
registeredArticle_invoiceBasisId int64 ID della fattura relativa all'articolo registrato filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.invoiceBasisId
registeredArticle_invoiceText varchar2(1000) Testo della fattura per articoli registrati filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.invoiceText
registeredArticle_nonInvoiceable char Articolo registrato non fatturabile filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.nonInvoiceable
registeredArticle_note varchar2(1000) Nota relativa all'articolo registrato filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.note
registeredArticle_orderIndex int32 Indice degli articoli registrati filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.orderIndex
registeredArticle_ownerId varchar2 ID del titolare dell'articolo registrato filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.ownerId
registeredArticle_ownerName varchar2 itgen_fnx_registeredarticle_ownername filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.ownerName
registeredArticle_timeLocked char Articolo registrato con blocco temporale filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.timeLocked
registeredArticle_totalQuantity decimal Articolo registrato - Quantità totale filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.totalQuantity
registeredArticle_unitCost decimal Costo unitario degli articoli registrati filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.unitCost
registeredArticle_unitPrice decimal Prezzo unitario dell'articolo registrato filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registeredArticle.unitPrice
registrationType varchar2 Tipo di registrazione filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.registrationType
timeLocked char Bloccato per un determinato periodo di tempo scrivibile, ::ancestor.::ancestor.timeLocked
totalQuantity decimal Quantità totale scrivibile, ::ancestor.::ancestor.totalQuantity
unitCost decimal Costo unitario scrivibile, ::ancestor.::ancestor.unitCost
unitPrice decimal Prezzo unitario scrivibile, ::ancestor.::ancestor.unitPrice
version int64 Version filtri sulla piattaforma, modificabili, ::ancestor.::ancestor.::ancestor.version

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: