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_ |
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 | Name of item/description | |
account_ |
varchar2 |
Account External Code 1 | filters on the platform, writable | ExternalCode1 is deprecated, please use ExternalCode1Info instead. | |
account_ |
varchar2 |
itgen_vnet_account_externalcode1info_description | filters on the platform, writable | Name of item/description | |
account_ |
varchar2 |
itgen_vnet_account_externalcode1info_number | filters on the platform, writable | Number of item | |
account_ |
varchar2 |
Account External Code 2 | filters on the platform, writable | ExternalCode2 is deprecated, please use ExternalCode2Info instead. | |
account_ |
varchar2 |
itgen_vnet_account_externalcode2info_description | filters on the platform, writable | Name of item/description | |
account_ |
varchar2 |
itgen_vnet_account_externalcode2info_number | filters on the platform, writable | Number of item | |
account_ |
varchar2 |
itgen_vnet_account_glconsolaccountcd | filters on the platform, writable | ||
account_ |
varchar2 |
Account Number | filters on the platform, writable | Number of item | |
account_ |
varchar2 |
Account Type | filters on the platform, writable | ||
balance |
varchar2 |
Balance Type | filters on the platform, writable | ||
beginning |
double |
itgen_vnet_beginningbalance | filters on the platform, writable | The total account balance at the start of the selected period. | |
beginning |
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_ |
varchar2 |
Branch Name | filters on the platform, writable | Click the magnifier. > The name. | |
branch_ |
varchar2 |
Branch Number | filters on the platform, writable | Click the magnifier. > The identifier. | |
currency |
varchar2 |
Currency ID | filters on the platform, writable | ||
error |
varchar2 |
Error Message | filters on the platform, writable | ||
last |
datetime |
Last Modified | filters on the platform, writable | ||
ledger_ |
varchar2 |
Ledger Description | filters on the platform, writable | Click on the magnifier. > The description. | |
ledger_ |
varchar2 |
Ledger ID | filters on the platform, writable | Click on the magnifier. > The identifier. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable | ||
metadata_ |
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. | |
period |
double |
itgen_vnet_periodtodatecredit | filters on the platform, writable | The total of all credit movements for the selected period. | |
period |
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. | |
period |
double |
itgen_vnet_periodtodatedebit | filters on the platform, writable | The total of all debit movements for the selected period. | |
period |
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. | |
sub |
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. | |
subaccount |
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_ |
int32 |
Sub Account ID | filters on the platform, writable | The internal SubID identifier of the subaccount. | |
subaccount_ |
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. | |
year |
char |
itgen_vnet_yearclosed | filters on the platform, writable | True when the last period of a financial year is closed in all modules. | |
year |
double |
itgen_vnet_yeartodatebalance | filters on the platform, writable | The total account balance at the end of the selected period. | |
year |
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: