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. | ||
financial |
`` | The budgets financial year. | ||
greater |
`` | Filter by from date. | ||
is |
`` | True to get released budgets. | ||
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. | ||
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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
account_ |
char |
Account Active | filters on the platform, writable, account. |
||
account_ |
varchar2 |
Account Description | filters on the platform, writable, account. |
Name of item/description | |
account_ |
varchar2 |
Account External Code 1 | filters on the platform, writable, account. |
Account class > The identifier of the account class. | |
account_ |
varchar2 |
Account External Code 2 | filters on the platform, writable, account. |
Account class > The name of the account class. | |
account_ |
varchar2 |
Account Number | filters on the platform, writable, account. |
Number of item | |
account_ |
varchar2 |
Account Type | filters on the platform, writable, account. |
Account > The account number. | |
amount |
double |
Amount | filters on the platform, writable, amount |
The budget area > The budget articles pane > Amount > The article amount. | |
branch |
varchar2 |
Branch Name | filters on the platform, writable, branch |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number | filters on the platform, writable, branch |
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. | |
distributed |
double |
Distributed Amount | filters on the platform, writable, distributed |
The budget area The budget articles pane > Distributed amount > The amount distributed over the periods. | |
financial |
varchar2 |
Financial Year | filters on the platform, writable, financial |
Mandatory field: The top part > Financial year* > The financial year of the budget. | |
last |
datetime |
Last Modified | filters on the platform, writable, last |
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. | |
released |
double |
Released Amount | filters on the platform, writable, released |
The budget area > The budget articles pane > Released amount > The amount that has been released for this article. | |
subaccount_ |
char |
Sub Account Active 2 | filters on the platform, writable, subaccount. |
||
subaccount_ |
varchar2 |
Subaccount Description | filters on the platform, writable, subaccount. |
Click on the magnifier. > The description. | |
subaccount_ |
varchar2 |
Subaccount ID | filters on the platform, writable, subaccount. |
Click on the magnifier. > The identifier. | |
time |
blob |
Timestamp | filters on the platform, writable, time |
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: