AssetHistoryByGivenAssetNumber: Fortnox Asset History by Given Asset Number
read only REST
- Catalog:
Fortnox - Schema:
Assets - Label: Asset History by Given Asset 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). | ||
Given |
`` | 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 AssetHistoryByGivenAssetNumber 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 |
|---|---|---|---|---|---|
Acquisition |
varchar2 |
Acquisition Date | writable, ::ancestor. |
||
Acquisition |
varchar2 |
Acquisition Start | writable, ::ancestor. |
||
Acquisition |
int32 |
Acquisition Value | writable, ::ancestor. |
||
Amount |
varchar2 |
Amount | writable, Amount |
||
Brand |
varchar2 |
Brand | writable, ::ancestor. |
||
Cost |
varchar2 |
Cost Centre | writable, ::ancestor. |
||
Date |
varchar2 |
Date | writable, Date |
||
Department |
varchar2 |
Department | writable, ::ancestor. |
||
Depreciate |
int32 |
Depreciate to Residual Value | writable, ::ancestor. |
||
Depreciated |
varchar2 |
Depreciated To | writable, ::ancestor. |
||
Depreciation |
varchar2 |
Depreciation Final | writable, ::ancestor. |
||
Depreciation |
int32 |
Depreciation Method | writable, ::ancestor. |
||
Description |
varchar2 |
Description | writable, ::ancestor. |
||
Event |
int32 |
Event ID | writable, Event |
||
Group |
varchar2 |
Group | writable, ::ancestor. |
||
Id |
int32 |
ID | writable, Id |
||
Id_2 |
int32 |
ID | writable, ::ancestor. |
||
Insured |
varchar2 |
Insured Number | writable, ::ancestor. |
||
Insured |
varchar2 |
Insured With | writable, ::ancestor. |
||
Manual |
int32 |
Manual Opening Balance | writable, ::ancestor. |
||
Notes |
varchar2 |
Notes | writable, Notes |
||
Notes_ |
varchar2 |
Notes 2 | writable, ::ancestor. |
||
Number |
varchar2 |
Number | writable, ::ancestor. |
||
Placement |
varchar2 |
Placement | writable, ::ancestor. |
||
Project |
varchar2 |
Project | writable, ::ancestor. |
||
Reference |
varchar2 |
Reference | writable, ::ancestor. |
||
Room |
varchar2 |
Room | writable, ::ancestor. |
||
Status |
varchar2 |
Status | writable, ::ancestor. |
||
Status |
varchar2 |
Status ID | writable, ::ancestor. |
||
Supplier |
int32 |
Supplier Invoice | writable, Supplier |
||
Type |
varchar2 |
Type | writable, ::ancestor. |
||
TypeId |
int32 |
Type ID | writable, ::ancestor. |
||
UserId |
int32 |
User ID | writable, UserId |
||
User |
varchar2 |
User Name | writable, User |
||
Voucher |
int32 |
Voucher Number | writable, Voucher |
||
Voucher |
varchar2 |
Voucher Series | writable, Voucher |
||
Voucher |
int32 |
Voucher Year | writable, Voucher |
||
c_url |
varchar2 |
Call URL | writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: