invantive documentation
Invantive Support ForumsLog In / Sign Up

GeneralLedgerBalancesAll: Visma.net Financials General Ledger Balances

read only

  • Catalog: VismaNet
  • Schema: Views
  • Label: General Ledger Balances

Can only retrieve data.

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.

Table Columns

The columns of the table GeneralLedgerBalancesAll 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_description varchar2 Account Description filters on the platform, writable Name of item/description
account_externalCode1 varchar2 Account External Code 1 filters on the platform, writable ExternalCode1 is deprecated, please use ExternalCode1Info instead.
account_externalCode1Info_description varchar2 itgen_vnet_account_externalcode1info_description filters on the platform, writable Name of item/description
account_externalCode1Info_number varchar2 itgen_vnet_account_externalcode1info_number filters on the platform, writable Number of item
account_externalCode2 varchar2 Account External Code 2 filters on the platform, writable ExternalCode2 is deprecated, please use ExternalCode2Info instead.
account_externalCode2Info_description varchar2 itgen_vnet_account_externalcode2info_description filters on the platform, writable Name of item/description
account_externalCode2Info_number varchar2 itgen_vnet_account_externalcode2info_number filters on the platform, writable Number of item
account_glConsolAccountCD varchar2 itgen_vnet_account_glconsolaccountcd filters on the platform, writable
account_number varchar2 Account Number filters on the platform, writable Number of item
account_type varchar2 Account Type filters on the platform, writable
balanceType varchar2 Balance Type filters on the platform, writable
beginningBalance double itgen_vnet_beginningbalance filters on the platform, writable The total account balance at the start of the selected period.
beginningBalanceInCurrency double itgen_vnet_beginningbalanceincurrency filters on the platform, writable The total account balance in the currency of the selected account at the start of the selected period.
branch_name varchar2 Branch Name filters on the platform, writable Click the magnifier. > The name.
branch_number varchar2 Branch Number filters on the platform, writable Click the magnifier. > The identifier.
currencyId varchar2 Currency ID filters on the platform, writable
errorInfo varchar2 Error Message filters on the platform, writable
lastModifiedDateTime datetime Last Modified filters on the platform, writable
ledger_description varchar2 Ledger Description filters on the platform, writable Click on the magnifier. > The description.
ledger_id varchar2 Ledger ID filters on the platform, writable Click on the magnifier. > The identifier.
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable
metadata_totalCount int64 Total Count filters on the platform, writable
period varchar2 Period filters on the platform, writable The table > Period > The period no and the year.
periodToDateCredit double itgen_vnet_periodtodatecredit filters on the platform, writable The total of all credit movements for the selected period.
periodToDateCreditInCurrency double itgen_vnet_periodtodatecreditincurrency filters on the platform, writable The total of all credit movements in the currency of the selected account for the selected period.
periodToDateDebit double itgen_vnet_periodtodatedebit filters on the platform, writable The total of all debit movements for the selected period.
periodToDateDebitInCurrency double itgen_vnet_periodtodatedebitincurrency filters on the platform, writable The total of all debit movements in the currency of the selected account for the selected period.
subAccountCd varchar2 itgen_vnet_subaccountcd filters on the platform, writable [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.
subaccountId varchar2 itgen_vnet_subaccountid filters on the platform, writable [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_subaccountId int32 Sub Account ID filters on the platform, writable The internal SubID identifier of the subaccount.
subaccount_subaccountNumber varchar2 Sub Account Number filters on the platform, writable The subaccount number / code. Format 9-XX.
year int32 Year filters on the platform, writable Mandatory field: The top part > Financial year* > The financial year.
yearClosed char itgen_vnet_yearclosed filters on the platform, writable True when the last period of a financial year is closed in all modules.
yearToDateBalance double itgen_vnet_yeartodatebalance filters on the platform, writable The total account balance at the end of the selected period.
yearToDateBalanceInCurrency double itgen_vnet_yeartodatebalanceincurrency filters on the platform, writable 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: