FixedAssetById: Visma.net Financials Fixed Asset by ID
read only REST
- Catalog:
VismaNet - Schema:
FixedAsset - Label: Fixed Asset by ID
Get a specific Fixed Asset - Screen ID:FA303000
Can only retrieve data.
API Source
- Endpoint:
/v1/fixedAsset/{FixedAssetID} - Operation:
get /v1/fixedAsset/{FixedAssetID}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
Expand |
`` | Set to True to include accounts and subaccounts. Default value is False | ||
Fixed |
`` | Identifies the fixed asset |
Table Columns
The columns of the table FixedAssetById 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 |
|---|---|---|---|---|---|
COMPANY_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
accounts_ |
varchar2 |
itgen_vnet_accounts_accountid | filters on the platform, writable, accounts. |
The fixed asset account for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_accrualaccountid | filters on the platform, writable, accounts. |
The accrual account for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_accrualsubaccountid | filters on the platform, writable, accounts. |
The accrual sub account for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_accumulateddepreciationaccountid | filters on the platform, writable, accounts. |
The accumulated depreciation account for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_accumulateddepreciationsubaccountid | filters on the platform, writable, accounts. |
The accumulated depreciation sub for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_creditaccountid | filters on the platform, writable, accounts. |
The credit account | |
accounts_ |
varchar2 |
itgen_vnet_accounts_creditsubaccountid | filters on the platform, writable, accounts. |
The credit sub account | |
accounts_ |
varchar2 |
itgen_vnet_accounts_debitaccountid | filters on the platform, writable, accounts. |
The debit account | |
accounts_ |
varchar2 |
itgen_vnet_accounts_debitsubaccountid | filters on the platform, writable, accounts. |
The debit sub account | |
accounts_ |
varchar2 |
itgen_vnet_accounts_depreciatedexpenseaccountid | filters on the platform, writable, accounts. |
The depreciation expense account for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_depreciatedexpensesubaccountid | filters on the platform, writable, accounts. |
The depreciation expense sub for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_disposalaccountid | filters on the platform, writable, accounts. |
The proceeds account for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_disposalsubaccountid | filters on the platform, writable, accounts. |
The proceeds sub for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_gainaccountid | filters on the platform, writable, accounts. |
The gain account for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_gainsubaccountid | filters on the platform, writable, accounts. |
The gain sub for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_lossaccountid | filters on the platform, writable, accounts. |
The loss account for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_losssubaccountid | filters on the platform, writable, accounts. |
The loss sub for this fixed asset | |
accounts_ |
varchar2 |
itgen_vnet_accounts_subaccountid | filters on the platform, writable, accounts. |
The sub account for this fixed asset | |
asset |
varchar2 |
itgen_vnet_assetid | filters on the platform, writable, asset |
The id that identifies this fixed asset | |
book |
double |
itgen_vnet_bookbalance_acquisitioncost | filters on the platform, writable, book |
The acquisition cost of this fixed asset | |
book |
varchar2 |
itgen_vnet_bookbalance_book_bookid | filters on the platform, writable, book |
The book id of this fixed asset | |
book |
varchar2 |
itgen_vnet_bookbalance_book_description | filters on the platform, writable, book |
The description of the book | |
book |
datetime |
itgen_vnet_bookbalance_depreciationfromdate | filters on the platform, writable, book |
The date this asset is placed in service | |
book |
varchar2 |
itgen_vnet_bookbalance_depreciationfromperiod | filters on the platform, writable, book |
The first period this fixed asset will start/has started depreciating | |
book |
varchar2 |
itgen_vnet_bookbalance_depreciationmethodid | filters on the platform, writable, book |
The depreciation method id of this fixed asset | |
book |
varchar2 |
itgen_vnet_bookbalance_depreciationtoperiod | filters on the platform, writable, book |
The last period this fixed asset will depreciate/ was depreciated | |
book |
varchar2 |
itgen_vnet_bookbalance_lastdepreciationperiod | filters on the platform, writable, book |
The last period this asset has been depreciated | |
book |
double |
itgen_vnet_bookbalance_salvageamount | filters on the platform, writable, book |
The salvage amount of this fixed asset | |
book |
double |
itgen_vnet_bookbalance_usefullife | filters on the platform, writable, book |
The useful life of this fixed asset in years | |
class |
varchar2 |
itgen_vnet_classid | filters on the platform, writable, class |
The class id of this fixed asset | |
depreciable |
char |
itgen_vnet_depreciable | filters on the platform, writable, depreciable |
Indicates if this fixed asset can be depreciated or not | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The description of this fixed asset | |
details_ |
double |
itgen_vnet_details_acquisitioncost | filters on the platform, writable, details. |
The acquisition cost of this fixed asset | |
details_ |
varchar2 |
itgen_vnet_details_billnumber | filters on the platform, writable, details. |
The bill number of the fixed asset invoice | |
details_ |
datetime |
itgen_vnet_details_depreciatefromdate | filters on the platform, writable, details. |
The date this asset is placed in service | |
details_ |
datetime |
itgen_vnet_details_disposaldate | filters on the platform, writable, details. |
The date of the disposal of this fixed asset | |
details_ |
int32 |
itgen_vnet_details_disposalmethodid | filters on the platform, writable, details. |
The disposal method of this fixed asset | |
details_ |
varchar2 |
itgen_vnet_details_disposalmethod_description | filters on the platform, writable, details. |
The description of the disposal method | |
details_ |
varchar2 |
itgen_vnet_details_disposalperiodid | filters on the platform, writable, details. |
The period of the disposal of this fixed asset | |
details_ |
varchar2 |
itgen_vnet_details_leaseandrentinfo_leasenumber | filters on the platform, writable, details. |
||
details_ |
int32 |
itgen_vnet_details_leaseandrentinfo_leaserentterm | filters on the platform, writable, details. |
||
details_ |
varchar2 |
itgen_vnet_details_leaseandrentinfo_lessorid | filters on the platform, writable, details. |
||
details_ |
varchar2 |
itgen_vnet_details_leaseandrentinfo_lessorname | filters on the platform, writable, details. |
||
details_ |
varchar2 |
itgen_vnet_details_leaseandrentinfo_manufacturingyear | filters on the platform, writable, details. |
||
details_ |
double |
itgen_vnet_details_leaseandrentinfo_rentamount | filters on the platform, writable, details. |
||
details_ |
double |
itgen_vnet_details_leaseandrentinfo_retailcost | filters on the platform, writable, details. |
||
details_ |
varchar2 |
itgen_vnet_details_propertytype | filters on the platform, writable, details. |
Type can be | |
details_ |
datetime |
itgen_vnet_details_receiptdate | filters on the platform, writable, details. |
The date of the receipt | |
details_ |
double |
itgen_vnet_details_saleamount | filters on the platform, writable, details. |
The disposal amount of this fixed asset | |
details_ |
double |
itgen_vnet_details_salvageamount | filters on the platform, writable, details. |
The salvage amount of this fixed asset | |
details_ |
varchar2 |
itgen_vnet_details_serialnumber | filters on the platform, writable, details. |
The serial number of this fixed asset | |
details_ |
varchar2 |
itgen_vnet_details_status | filters on the platform, writable, details. |
Status can be | |
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
is |
char |
itgen_vnet_istangible | filters on the platform, writable, is |
Indicates whether this fixed asset is tangible or not | |
last |
datetime |
Last Modified | filters on the platform, writable, last |
A system generated date/time that indicates the last change for this fixed asset | |
location_ |
varchar2 |
itgen_vnet_location_branchid | filters on the platform, writable, location. |
The current branch id of this fixed asset | |
location_ |
varchar2 |
itgen_vnet_location_departmentid | filters on the platform, writable, location. |
The current department id of this fixed asset | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
parent |
varchar2 |
itgen_vnet_parentassetid | filters on the platform, writable, parent |
The asset id of the parent of this fixed asset | |
property |
varchar2 |
itgen_vnet_propertytax_description | filters on the platform, writable, property |
The description of the property tax group of this fixed asset | |
property |
varchar2 |
itgen_vnet_propertytax_propertytaxid | filters on the platform, writable, property |
The property tax group id of this fixed asset | |
quantity |
double |
Quantity | filters on the platform, writable, quantity |
The quantity of this fixed asset | |
record |
varchar2 |
itgen_vnet_recordtype | filters on the platform, writable, record |
The type of the record. This value is 'A' for fixed assets | |
type_ |
varchar2 |
itgen_vnet_type_assettypeid | filters on the platform, writable, type. |
The type id of this fixed asset | |
type_ |
varchar2 |
itgen_vnet_type_description | filters on the platform, writable, type. |
The type description | |
useful |
double |
itgen_vnet_usefullife | filters on the platform, writable, useful |
Useful life of this fixed asset in years |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: