invantive documentation
Invantive Support ForumsLog In / Sign Up

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
assetID `` Fixed Asset ID that identifies the asset.
classID `` View all fixed assets with this Fixed Asset Class ID.
expandAccounts `` Set to True to include accounts and subaccounts. Default value is False
fromDate `` From 'Placed in service date' inclusive. Date format: YYYY-MM-DD.
lastModifiedDateTime `` 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-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` 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_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
accounts_accountID varchar2 itgen_vnet_accounts_accountid filters on the platform, writable, accounts.accountID The fixed asset account for this fixed asset
accounts_accrualAccountID varchar2 itgen_vnet_accounts_accrualaccountid filters on the platform, writable, accounts.accrualAccountID The accrual account for this fixed asset
accounts_accrualSubAccountID varchar2 itgen_vnet_accounts_accrualsubaccountid filters on the platform, writable, accounts.accrualSubAccountID The accrual sub account for this fixed asset
accounts_accumulatedDepreciationAccountID varchar2 itgen_vnet_accounts_accumulateddepreciationaccountid filters on the platform, writable, accounts.accumulatedDepreciationAccountID The accumulated depreciation account for this fixed asset
accounts_accumulatedDepreciationSubAccountID varchar2 itgen_vnet_accounts_accumulateddepreciationsubaccountid filters on the platform, writable, accounts.accumulatedDepreciationSubAccountID The accumulated depreciation sub for this fixed asset
accounts_creditAccountID varchar2 itgen_vnet_accounts_creditaccountid filters on the platform, writable, accounts.creditAccountID The credit account
accounts_creditSubAccountID varchar2 itgen_vnet_accounts_creditsubaccountid filters on the platform, writable, accounts.creditSubAccountID The credit sub account
accounts_debitAccountID varchar2 itgen_vnet_accounts_debitaccountid filters on the platform, writable, accounts.debitAccountID The debit account
accounts_debitSubAccountID varchar2 itgen_vnet_accounts_debitsubaccountid filters on the platform, writable, accounts.debitSubAccountID The debit sub account
accounts_depreciatedExpenseAccountID varchar2 itgen_vnet_accounts_depreciatedexpenseaccountid filters on the platform, writable, accounts.depreciatedExpenseAccountID The depreciation expense account for this fixed asset
accounts_depreciatedExpenseSubAccountID varchar2 itgen_vnet_accounts_depreciatedexpensesubaccountid filters on the platform, writable, accounts.depreciatedExpenseSubAccountID The depreciation expense sub for this fixed asset
accounts_disposalAccountID varchar2 itgen_vnet_accounts_disposalaccountid filters on the platform, writable, accounts.disposalAccountID The proceeds account for this fixed asset
accounts_disposalSubAccountID varchar2 itgen_vnet_accounts_disposalsubaccountid filters on the platform, writable, accounts.disposalSubAccountID The proceeds sub for this fixed asset
accounts_gainAccountID varchar2 itgen_vnet_accounts_gainaccountid filters on the platform, writable, accounts.gainAccountID The gain account for this fixed asset
accounts_gainSubAccountID varchar2 itgen_vnet_accounts_gainsubaccountid filters on the platform, writable, accounts.gainSubAccountID The gain sub for this fixed asset
accounts_lossAccountID varchar2 itgen_vnet_accounts_lossaccountid filters on the platform, writable, accounts.lossAccountID The loss account for this fixed asset
accounts_lossSubAccountID varchar2 itgen_vnet_accounts_losssubaccountid filters on the platform, writable, accounts.lossSubAccountID The loss sub for this fixed asset
accounts_subAccountID varchar2 itgen_vnet_accounts_subaccountid filters on the platform, writable, accounts.subAccountID The sub account for this fixed asset
assetID varchar2 itgen_vnet_assetid filters on the platform, writable, assetID The id that identifies this fixed asset
bookBalance_acquisitionCost double itgen_vnet_bookbalance_acquisitioncost filters on the platform, writable, bookBalance.acquisitionCost The acquisition cost of this fixed asset
bookBalance_book_bookID varchar2 itgen_vnet_bookbalance_book_bookid filters on the platform, writable, bookBalance.book.bookID The book id of this fixed asset
bookBalance_book_description varchar2 itgen_vnet_bookbalance_book_description filters on the platform, writable, bookBalance.book.description The description of the book
bookBalance_depreciationFromDate datetime itgen_vnet_bookbalance_depreciationfromdate filters on the platform, writable, bookBalance.depreciationFromDate The date this asset is placed in service
bookBalance_depreciationFromPeriod varchar2 itgen_vnet_bookbalance_depreciationfromperiod filters on the platform, writable, bookBalance.depreciationFromPeriod The first period this fixed asset will start/has started depreciating
bookBalance_depreciationMethodID varchar2 itgen_vnet_bookbalance_depreciationmethodid filters on the platform, writable, bookBalance.depreciationMethodID The depreciation method id of this fixed asset
bookBalance_depreciationToPeriod varchar2 itgen_vnet_bookbalance_depreciationtoperiod filters on the platform, writable, bookBalance.depreciationToPeriod The last period this fixed asset will depreciate/ was depreciated
bookBalance_lastDepreciationPeriod varchar2 itgen_vnet_bookbalance_lastdepreciationperiod filters on the platform, writable, bookBalance.lastDepreciationPeriod The last period this asset has been depreciated
bookBalance_salvageAmount double itgen_vnet_bookbalance_salvageamount filters on the platform, writable, bookBalance.salvageAmount The salvage amount of this fixed asset
bookBalance_usefulLife double itgen_vnet_bookbalance_usefullife filters on the platform, writable, bookBalance.usefulLife The useful life of this fixed asset in years
classID varchar2 itgen_vnet_classid filters on the platform, writable, classID 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_acquisitionCost double itgen_vnet_details_acquisitioncost filters on the platform, writable, details.acquisitionCost The acquisition cost of this fixed asset
details_billNumber varchar2 itgen_vnet_details_billnumber filters on the platform, writable, details.billNumber The bill number of the fixed asset invoice
details_depreciateFromDate datetime itgen_vnet_details_depreciatefromdate filters on the platform, writable, details.depreciateFromDate The date this asset is placed in service
details_disposalDate datetime itgen_vnet_details_disposaldate filters on the platform, writable, details.disposalDate The date of the disposal of this fixed asset
details_disposalMethodID int32 itgen_vnet_details_disposalmethodid filters on the platform, writable, details.disposalMethodID The disposal method of this fixed asset
details_disposalMethod_description varchar2 itgen_vnet_details_disposalmethod_description filters on the platform, writable, details.disposalMethod.description The description of the disposal method
details_disposalPeriodID varchar2 itgen_vnet_details_disposalperiodid filters on the platform, writable, details.disposalPeriodID The period of the disposal of this fixed asset
details_leaseAndRentInfo_leaseNumber varchar2 itgen_vnet_details_leaseandrentinfo_leasenumber filters on the platform, writable, details.leaseAndRentInfo.leaseNumber
details_leaseAndRentInfo_leaseRentTerm int32 itgen_vnet_details_leaseandrentinfo_leaserentterm filters on the platform, writable, details.leaseAndRentInfo.leaseRentTerm
details_leaseAndRentInfo_lessorID varchar2 itgen_vnet_details_leaseandrentinfo_lessorid filters on the platform, writable, details.leaseAndRentInfo.lessorID
details_leaseAndRentInfo_lessorName varchar2 itgen_vnet_details_leaseandrentinfo_lessorname filters on the platform, writable, details.leaseAndRentInfo.lessorName
details_leaseAndRentInfo_manufacturingYear varchar2 itgen_vnet_details_leaseandrentinfo_manufacturingyear filters on the platform, writable, details.leaseAndRentInfo.manufacturingYear
details_leaseAndRentInfo_rentAmount double itgen_vnet_details_leaseandrentinfo_rentamount filters on the platform, writable, details.leaseAndRentInfo.rentAmount
details_leaseAndRentInfo_retailCost double itgen_vnet_details_leaseandrentinfo_retailcost filters on the platform, writable, details.leaseAndRentInfo.retailCost
details_propertyType varchar2 itgen_vnet_details_propertytype filters on the platform, writable, details.propertyType Type can be
details_receiptDate datetime itgen_vnet_details_receiptdate filters on the platform, writable, details.receiptDate The date of the receipt
details_saleAmount double itgen_vnet_details_saleamount filters on the platform, writable, details.saleAmount The disposal amount of this fixed asset
details_salvageAmount double itgen_vnet_details_salvageamount filters on the platform, writable, details.salvageAmount The salvage amount of this fixed asset
details_serialNumber varchar2 itgen_vnet_details_serialnumber filters on the platform, writable, details.serialNumber The serial number of this fixed asset
details_status varchar2 itgen_vnet_details_status filters on the platform, writable, details.status Status can be
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
isTangible char itgen_vnet_istangible filters on the platform, writable, isTangible Indicates whether this fixed asset is tangible or not
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime A system generated date/time that indicates the last change for this fixed asset
location_branchID varchar2 itgen_vnet_location_branchid filters on the platform, writable, location.branchID The current branch id of this fixed asset
location_departmentID varchar2 itgen_vnet_location_departmentid filters on the platform, writable, location.departmentID The current department id of this fixed asset
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, metadata.totalCount
parentAssetID varchar2 itgen_vnet_parentassetid filters on the platform, writable, parentAssetID The asset id of the parent of this fixed asset
propertyTax_description varchar2 itgen_vnet_propertytax_description filters on the platform, writable, propertyTax.description The description of the property tax group of this fixed asset
propertyTax_propertyTaxID varchar2 itgen_vnet_propertytax_propertytaxid filters on the platform, writable, propertyTax.propertyTaxID The property tax group id of this fixed asset
quantity double Quantity filters on the platform, writable, quantity The quantity of this fixed asset
recordType varchar2 itgen_vnet_recordtype filters on the platform, writable, recordType The type of the record. This value is 'A' for fixed assets
type_assetTypeID varchar2 itgen_vnet_type_assettypeid filters on the platform, writable, type.assetTypeID The type id of this fixed asset
type_description varchar2 itgen_vnet_type_description filters on the platform, writable, type.description The type description
usefulLife double itgen_vnet_usefullife filters on the platform, writable, usefulLife Useful life of this fixed asset in years

Release Notes

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