invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

AssetByGivenNumber: Fortnox Asset by Given Number

read only REST

  • Catalogus: Fortnox
  • Schema: Assets
  • Label: Asset by Given Number

Retrieve a single asset

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /3/assets/{GivenNumber}
  • Operatie: get /3/assets/{GivenNumber}

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 356
Aantal rijen per minuut bij volledige scan 85,000
Aantal rijen per minuut in een Query 168

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype 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 `` Defines a selection based on a start date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
GivenNumber `` Asset number
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
todate `` Defines a selection based on an end date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).

Tabelkolommen

De kolommen van de tabel AssetByGivenNumber worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
Assets_AcquisitionDate varchar2 Activa Aankoopdatum filters on the platform, writable, Assets.AcquisitionDate
Assets_AcquisitionStart varchar2 Start van de verwerving van activa filters on the platform, writable, Assets.AcquisitionStart
Assets_AcquisitionValue int32 Aankoopwaarde van activa filters on the platform, writable, Assets.AcquisitionValue
Assets_Brand varchar2 Middelen Merk filters on the platform, writable, Assets.Brand
Assets_CostCenter varchar2 Kostenplaats Activa filters on the platform, writable, Assets.CostCenter
Assets_Department varchar2 Afdeling Activa filters on the platform, writable, Assets.Department
Assets_DepreciateToResidualValue int32 Activa worden afgeschreven tot de restwaarde filters on the platform, writable, Assets.DepreciateToResidualValue
Assets_DepreciatedTo varchar2 Afgeschreven activa tot filters on the platform, writable, Assets.DepreciatedTo
Assets_DepreciationFinal varchar2 Afschrijving van activa – definitief filters on the platform, writable, Assets.DepreciationFinal
Assets_DepreciationMethod int32 Afschrijvingsmethode voor activa filters on the platform, writable, Assets.DepreciationMethod
Assets_Description varchar2 Beschrijving van de activa filters on the platform, writable, Assets.Description
Assets_Group varchar2 Assets Group filters on the platform, writable, Assets.Group
Assets_Id int32 ID van activa filters on the platform, writable, Assets.Id
Assets_InsuredNumber varchar2 Aantal verzekerde activa filters on the platform, writable, Assets.InsuredNumber
Assets_InsuredWith varchar2 Verzekerde activa bij filters on the platform, writable, Assets.InsuredWith
Assets_ManualOb int32 Activa – Handboek voor het ingevoerde beginsaldo filters on the platform, writable, Assets.ManualOb
Assets_Notes varchar2 Toelichting bij de activa filters on the platform, writable, Assets.Notes
Assets_Number varchar2 Aantal activa filters on the platform, writable, Assets.Number
Assets_Placement varchar2 Plaatsing van activa filters on the platform, writable, Assets.Placement
Assets_Project varchar2 Project „Assets“ filters on the platform, writable, Assets.Project
Assets_Reference varchar2 Overzicht van activa filters on the platform, writable, Assets.Reference
Assets_Room varchar2 Kamer met waardevolle voorwerpen filters on the platform, writable, Assets.Room
Assets_Status varchar2 Status filters on the platform, writable, Assets.Status
Assets_StatusId varchar2 Status-ID van activa filters on the platform, writable, Assets.StatusId
Assets_Type varchar2 Soort activa filters on the platform, writable, Assets.Type
Assets_TypeId int32 ID van het activatype filters on the platform, writable, Assets.TypeId
Assets__url varchar2 URL van de middelen filters on the platform, writable, Assets.@url

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: