invantive documentation
Invantive Support ForumsLog In / Sign Up

Budgets: Visma.net Financials Budgets

read only REST

  • Catalog: VismaNet
  • Schema: Budget
  • Label: Budgets

Get a range of General Ledger Budget Figures - ScreenId=GL302010

Can only retrieve data.

API Source

  • Endpoint: /v1/budget
  • Operation: get /v1/budget

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
branch `` Mandatory. Filter by budgets Branch.
financialYear `` The budgets financial year.
greaterThanValue `` Filter by from date.
isReleased `` True to get released budgets.
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.
ledger `` Mandatory. The budgets Ledger
subaccount `` The Subaccount of the budget article.

Table Columns

The columns of the table Budgets 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.
account_active char Account Active filters on the platform, writable, account.active
account_description varchar2 Account Description filters on the platform, writable, account.description Name of item/description
account_externalCode1 varchar2 Account External Code 1 filters on the platform, writable, account.externalCode1 Account class > The identifier of the account class.
account_externalCode2 varchar2 Account External Code 2 filters on the platform, writable, account.externalCode2 Account class > The name of the account class.
account_number varchar2 Account Number filters on the platform, writable, account.number Number of item
account_type varchar2 Account Type filters on the platform, writable, account.type Account > The account number.
amount double Amount filters on the platform, writable, amount The budget area > The budget articles pane > Amount > The article amount.
branchNumber_name varchar2 Branch Name filters on the platform, writable, branchNumber.name Click the magnifier. > The name.
branchNumber_number varchar2 Branch Number filters on the platform, writable, branchNumber.number Click the magnifier. > The identifier.
description varchar2 Description filters on the platform, writable, description Mandatory field: The budget area > The budget articles pane > Description* > A description of the budget article.By default, this column displays the account description.
distributedAmount double Distributed Amount filters on the platform, writable, distributedAmount The budget area The budget articles pane > Distributed amount > The amount distributed over the periods.
financialYear varchar2 Financial Year filters on the platform, writable, financialYear Mandatory field: The top part > Financial year* > The financial year of the budget.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime A system generated date/time not visible in the window.
released char Released filters on the platform, writable, released The budget area > The budget articles pane > Released > A check box that indicates (if selected) that the budget article has been released.
releasedAmount double Released Amount filters on the platform, writable, releasedAmount The budget area > The budget articles pane > Released amount > The amount that has been released for this article.
subaccount_active char Sub Account Active 2 filters on the platform, writable, subaccount.active
subaccount_description varchar2 Subaccount Description filters on the platform, writable, subaccount.description Click on the magnifier. > The description.
subaccount_id varchar2 Subaccount ID filters on the platform, writable, subaccount.id Click on the magnifier. > The identifier.
timeStamp blob Timestamp filters on the platform, writable, timeStamp The timestamp of the budget article, used for concurrency control.

Release Notes

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