FixedAsset: Visma.net Financials Fixed Asset
read only REST
- Catalog:
VismaNet - Schema:
FixedAsset - Label: Fixed Asset
Get a range of Fixed Assets - Screen ID:FA303000
Can only retrieve data.
API Source
- Endpoint:
/v1/fixedAsset - Operation:
get /v1/fixedAsset
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 |
|---|---|---|---|---|
asset |
`` | Fixed Asset ID that identifies the asset. | ||
class |
`` | View all fixed assets with this Fixed Asset Class ID. | ||
expand |
`` | Set to True to include accounts and subaccounts. Default value is False | ||
from |
`` | From 'Placed in service date' inclusive. Date format: YYYY-MM-DD. | ||
last |
`` | This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. |
||
last |
`` | This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. | ||
status |
`` | View all fixed assets with this Status. Available statuses are: Active, Disposed, FullyDepriciated, Hold, Reversed, Suspended. (Values: Active, Disposed, FullyDepreciated, Hold, Reversed, Suspended) | ||
toDate |
`` | To 'Placed in service date' inclusive. Date format: YYYY-MM-DD. |
Table Columns
The columns of the table FixedAsset 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: