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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
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 | |
asset |
varchar2 |
itgen_vnet_assetid | filters on the platform, writable, asset |
The asset id this fixed asset transaction belongs to | |
batch |
varchar2 |
itgen_vnet_batchno | filters on the platform, writable, batch |
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 | |
branch |
varchar2 |
itgen_vnet_branchid | filters on the platform, writable, branch |
The branch id for this fixed asset transaction | |
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
last |
datetime |
Last Modified | filters on the platform, writable, last |
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_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
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_ |
datetime |
itgen_vnet_register_documentdate | filters on the platform, writable, register. |
The document date for this fixed asset transaction | |
register_ |
char |
itgen_vnet_register_hold | filters on the platform, writable, register. |
Indecates whether this fixed asset transaction is on hold or not | |
register_ |
varchar2 |
itgen_vnet_register_status | filters on the platform, writable, register. |
Status can be | |
transaction |
double |
itgen_vnet_transactionamount | filters on the platform, writable, transaction |
The amount of this fixed asset transaction | |
transaction |
datetime |
itgen_vnet_transactiondate | filters on the platform, writable, transaction |
The transaction date for this fixed asset transaction | |
transaction |
varchar2 |
itgen_vnet_transactiondescription | filters on the platform, writable, transaction |
The description of this fixed asset transaction | |
transaction |
varchar2 |
itgen_vnet_transactionperiodid | filters on the platform, writable, transaction |
The transaction period id for this fixed asset transaction | |
transaction |
varchar2 |
itgen_vnet_transactiontype | filters on the platform, writable, transaction |
Type can be |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: