invantive documentation
Invantive Support ForumsLog In / Sign Up

FixedAssetTransactionByRefNo: Visma.net Financials itgen_vnet_fixedassettransactionbyrefno_plural

read only REST

  • Catalog: VismaNet
  • Schema: FixedAssetTransaction
  • Label: itgen_vnet_fixedassettransactionbyrefno_plural

Get transactions for a specific Asset - Screen ID:FA301000

Can only retrieve data.

API Source

  • Endpoint: /v1/fixedAssetTransaction/{RefNo}
  • Operation: get /v1/fixedAssetTransaction/{RefNo}

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
RefNo `` Identifies the fixed asset by reference number

Table Columns

The columns of the table FixedAssetTransactionByRefNo 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_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
assetID varchar2 itgen_vnet_assetid filters on the platform, writable, assetID The asset id this fixed asset transaction belongs to
batchNo varchar2 itgen_vnet_batchno filters on the platform, writable, batchNo The batch number of the general ledger transaction for this fixed asset transaction
bookID varchar2 itgen_vnet_bookid filters on the platform, writable, bookID The book id for this fixed asset transaction
branchID varchar2 itgen_vnet_branchid filters on the platform, writable, branchID The branch id for this fixed asset transaction
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime A system generated date/time that indicates the last change for this fixed asset transaction
lineNo int32 itgen_vnet_lineno filters on the platform, writable, lineNo The line number of this fixed asset transaction
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
origin varchar2 itgen_vnet_origin filters on the platform, writable, origin The origin of this fixed asset transaction. Origin can be
refNo varchar2 itgen_vnet_refno filters on the platform, writable, refNo The referance number for this fixed asset transaction
register_documentDate datetime itgen_vnet_register_documentdate filters on the platform, writable, register.documentDate The document date for this fixed asset transaction
register_hold char itgen_vnet_register_hold filters on the platform, writable, register.hold Indecates whether this fixed asset transaction is on hold or not
register_status varchar2 itgen_vnet_register_status filters on the platform, writable, register.status Status can be
transactionAmount double itgen_vnet_transactionamount filters on the platform, writable, transactionAmount The amount of this fixed asset transaction
transactionDate datetime itgen_vnet_transactiondate filters on the platform, writable, transactionDate The transaction date for this fixed asset transaction
transactionDescription varchar2 itgen_vnet_transactiondescription filters on the platform, writable, transactionDescription The description of this fixed asset transaction
transactionPeriodID varchar2 itgen_vnet_transactionperiodid filters on the platform, writable, transactionPeriodID The transaction period id for this fixed asset transaction
transactionType varchar2 itgen_vnet_transactiontype filters on the platform, writable, transactionType Type can be

Release Notes

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