invantive documentation
Invantive Support ForumsLog In / Sign Up

FixedAssetTransaction: Visma.net Financials itgen_vnet_fixedassettransaction_plural

read only REST

  • Catalog: VismaNet
  • Schema: FixedAssetTransaction
  • Label: itgen_vnet_fixedassettransaction_plural

Get a range of transactions - Screen ID:FA301000

Can only retrieve data.

API Source

  • Endpoint: /v1/fixedAssetTransaction
  • Operation: get /v1/fixedAssetTransaction

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
accountID `` View all transactions for this Account ID.
assetID `` View all transactions connected to this Asset ID.
bookID `` View all transactions in this Book ID.
fromPeriod `` View all transactions from and including this Period. Format: YYYYMM.
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.
refNo `` View all transactions connected to this Reference number.
status `` View all transactions with this Status. Available statuses: Balanced, OnHold, Posted and UnPosted. (Values: Balanced, OnHold, Posted, Unposted)
subAccountID `` View all transactions for this Sub Account ID.
toPeriod `` View all transactions to and including this Period. Format: YYYYMM.
transactionFromDate `` View all transactions from and including this Transaction Date. Date format: YYYY-MM-DD.
transactionToDate `` View all transactions to and including this Transaction Date inclusive. Date format: YYYY-MM-DD .
transactionType `` View all transactions with this Transaction Type. Available types: PurchasingPlus, PurchasingMinus, DepreciationPlus, DepreciationMinus, CalculatedPlus, CalculatedMinu,SalePlus, SaleMinus,TransferPurchasing, TransferDepreciation, ReconciliationPlus, ReconciliationMinus, PurchasingDisposal, PurchasingReversal, AdjustingDeprPlus and AdjustingDeprMinus. (Values: PurchasingPlus, PurchasingMinus, DepreciationPlus, DepreciationMinus, CalculatedPlus, CalculatedMinus, SalePlus, SaleMinus, TransferPurchasing, TransferDepreciation, ReconciliationPlus, ReconciliationMinus, PurchasingDisposal, PurchasingReversal, AdjustingDeprPlus, AdjustingDeprMinus)

Table Columns

The columns of the table FixedAssetTransaction 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: