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 |
|---|---|---|---|---|
account |
`` | View all transactions for this Account ID. | ||
asset |
`` | View all transactions connected to this Asset ID. | ||
bookID |
`` | View all transactions in this Book ID. | ||
from |
`` | View all transactions from and including this Period. Format: YYYYMM. | ||
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. | ||
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) | ||
sub |
`` | View all transactions for this Sub Account ID. | ||
to |
`` | View all transactions to and including this Period. Format: YYYYMM. | ||
transaction |
`` | View all transactions from and including this Transaction Date. Date format: YYYY-MM-DD. | ||
transaction |
`` | View all transactions to and including this Transaction Date inclusive. Date format: YYYY-MM-DD . | ||
transaction |
`` | 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_ |
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: