invantive documentation
Invantive Support ForumsLog In / Sign Up

AssetByGivenNumber: Fortnox Asset by Given Number

read only REST

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

Retrieve a single asset

Can only retrieve data.

API Source

  • Endpoint: /3/assets/{GivenNumber}
  • Operation: get /3/assets/{GivenNumber}

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Parameters

Name Data Type 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).

Table Columns

The columns of the table AssetByGivenNumber are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
Assets_AcquisitionDate varchar2 Assets Acquisition Date filters on the platform, writable, Assets.AcquisitionDate
Assets_AcquisitionStart varchar2 Assets Acquisition Start filters on the platform, writable, Assets.AcquisitionStart
Assets_AcquisitionValue int32 Assets Acquisition Value filters on the platform, writable, Assets.AcquisitionValue
Assets_Brand varchar2 Assets Brand filters on the platform, writable, Assets.Brand
Assets_CostCenter varchar2 Assets Cost Centre filters on the platform, writable, Assets.CostCenter
Assets_Department varchar2 Assets Department filters on the platform, writable, Assets.Department
Assets_DepreciateToResidualValue int32 Assets Depreciate to Residual Value filters on the platform, writable, Assets.DepreciateToResidualValue
Assets_DepreciatedTo varchar2 Assets Depreciated To filters on the platform, writable, Assets.DepreciatedTo
Assets_DepreciationFinal varchar2 Assets Depreciation Final filters on the platform, writable, Assets.DepreciationFinal
Assets_DepreciationMethod int32 Assets Depreciation Method filters on the platform, writable, Assets.DepreciationMethod
Assets_Description varchar2 Assets Description filters on the platform, writable, Assets.Description
Assets_Group varchar2 Assets Group filters on the platform, writable, Assets.Group
Assets_Id int32 Assets ID filters on the platform, writable, Assets.Id
Assets_InsuredNumber varchar2 Assets Insured Number filters on the platform, writable, Assets.InsuredNumber
Assets_InsuredWith varchar2 Assets Insured With filters on the platform, writable, Assets.InsuredWith
Assets_ManualOb int32 Assets Manual Opening Balance filters on the platform, writable, Assets.ManualOb
Assets_Notes varchar2 Assets Notes filters on the platform, writable, Assets.Notes
Assets_Number varchar2 Assets Number filters on the platform, writable, Assets.Number
Assets_Placement varchar2 Assets Placement filters on the platform, writable, Assets.Placement
Assets_Project varchar2 Assets Project filters on the platform, writable, Assets.Project
Assets_Reference varchar2 Assets Reference filters on the platform, writable, Assets.Reference
Assets_Room varchar2 Assets Room filters on the platform, writable, Assets.Room
Assets_Status varchar2 Status filters on the platform, writable, Assets.Status
Assets_StatusId varchar2 Assets Status ID filters on the platform, writable, Assets.StatusId
Assets_Type varchar2 Assets Type filters on the platform, writable, Assets.Type
Assets_TypeId int32 Assets Type ID filters on the platform, writable, Assets.TypeId
Assets__url varchar2 Assets URL filters on the platform, writable, Assets.@url

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: