GeneralLedgerBalancesV2: Visma.net Financials General Ledger Balances
popular read only REST
- Catalog:
VismaNet - Schema:
GeneralLedgerBalanceV2 - Label: General Ledger Balances
Get a range of General Ledger Balances. Complete documentation can be found under 8.21 release notes. Please use a page size lower or equal to the allowed max page size which is returned under metadata. If pagesize is greater than the max page size, it will be limited to max page size.
Can only retrieve data.
API Source
- Endpoint:
/v2/generalLedgerBalance - Operation:
get /v2/generalLedgerBalance
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 111 |
| Full scan rows per minute | 54,500 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
account |
`` | Account to retrieve balance for | ||
balance |
`` | Balance Type of the ledger to be exported (Values: Actual, Report, Statistical, Budget) | ||
branch |
`` | Branch to retrieve balance for | ||
exclude |
`` | |||
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. Mandatory if 'PeriodId' is not provided. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- |
||
ledger |
`` | Ledger to retrieve balance for | ||
period |
`` | Period to retrieve balance for. Mandatory if 'LastModifiedDateTime' not provided. Format: 'yyyyMM' | ||
subaccount |
`` | Subaccount to retrieve balance for | ||
toggle |
`` | Parameter can be used in order to change the balance sign for liability and income accounts |
Table Columns
The columns of the table GeneralLedgerBalancesV2 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_ |
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. |
ExternalCode1 is deprecated, please use ExternalCode1Info instead. | |
account_ |
varchar2 |
itgen_vnet_account_externalcode1info_description | filters on the platform, writable, account. |
Name of item/description | |
account_ |
varchar2 |
itgen_vnet_account_externalcode1info_number | filters on the platform, writable, account. |
Number of item | |
account_ |
varchar2 |
Account External Code 2 | filters on the platform, writable, account. |
ExternalCode2 is deprecated, please use ExternalCode2Info instead. | |
account_ |
varchar2 |
itgen_vnet_account_externalcode2info_description | filters on the platform, writable, account. |
Name of item/description | |
account_ |
varchar2 |
itgen_vnet_account_externalcode2info_number | filters on the platform, writable, account. |
Number of item | |
account_ |
varchar2 |
itgen_vnet_account_glconsolaccountcd | filters on the platform, writable, account. |
||
account_ |
varchar2 |
Account Number | filters on the platform, writable, account. |
Number of item | |
account_ |
varchar2 |
Account Type | filters on the platform, writable, account. |
||
balance |
varchar2 |
Balance Type | filters on the platform, writable, balance |
||
beginning |
double |
itgen_vnet_beginningbalance | filters on the platform, writable, beginning |
The total account balance at the start of the selected period. | |
beginning |
double |
itgen_vnet_beginningbalanceincurrency | filters on the platform, writable, beginning |
The total account balance in the currency of the selected account at the start of the selected period. | |
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. | |
currency |
varchar2 |
Currency ID | filters on the platform, writable, currency |
||
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
financial |
varchar2 |
Financial Period | filters on the platform, writable, financial |
The financial period to which the transactions recorded in the document should be posted. Format YYYYMM. | |
last |
datetime |
Last Modified | filters on the platform, writable, last |
||
ledger_ |
varchar2 |
Ledger Description | filters on the platform, writable, ledger. |
Click on the magnifier. > The description. | |
ledger_ |
varchar2 |
Ledger ID | filters on the platform, writable, ledger. |
Click on the magnifier. > The identifier. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
period |
double |
itgen_vnet_periodtodatecredit | filters on the platform, writable, period |
The total of all credit movements for the selected period. | |
period |
double |
itgen_vnet_periodtodatecreditincurrency | filters on the platform, writable, period |
The total of all credit movements in the currency of the selected account for the selected period. | |
period |
double |
itgen_vnet_periodtodatedebit | filters on the platform, writable, period |
The total of all debit movements for the selected period. | |
period |
double |
itgen_vnet_periodtodatedebitincurrency | filters on the platform, writable, period |
The total of all debit movements in the currency of the selected account for the selected period. | |
sub |
varchar2 |
itgen_vnet_subaccountcd | filters on the platform, writable, sub |
[This field has been deprecated and will be removed in future versions. Use 'subaccount.subaccountNumber' instead.] This field has been deprecated and will be removed in future versions. Use 'subaccount.subaccountNumber' instead. | |
subaccount |
varchar2 |
itgen_vnet_subaccountid | filters on the platform, writable, subaccount |
[This field has been deprecated and will be removed in future versions. Use 'subaccount.subaccountId' instead.] This field has been deprecated and will be removed in future versions. Use 'subaccount.subaccountId' instead. | |
subaccount_ |
int32 |
Sub Account ID | filters on the platform, writable, subaccount. |
The internal SubID identifier of the subaccount. | |
subaccount_ |
varchar2 |
Sub Account Number | filters on the platform, writable, subaccount. |
The subaccount number / code. Format 9-XX. | |
year |
char |
itgen_vnet_yearclosed | filters on the platform, writable, year |
True when the last period of a financial year is closed in all modules. | |
year |
double |
itgen_vnet_yeartodatebalance | filters on the platform, writable, year |
The total account balance at the end of the selected period. | |
year |
double |
itgen_vnet_yeartodatebalanceincurrency | filters on the platform, writable, year |
The total account balance in the currency of the selected account at the end of the selected period. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: