GeneralLedgerTransactions: Visma.net Financials General Ledger Transactions
read only
- Catalog:
VismaNet - Schema:
Views - Label: General Ledger Transactions
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 GeneralLedgerTransactions 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 | ||
batch |
varchar2 |
Batch Number | filters on the platform, writable | Batch number > The reference number of the batch (generated for the transaction) that updated the balance of the selected account. | |
beg |
double |
Begin Balance | filters on the platform, writable | Beg. balance > The running total of the account's beginning balance calculated in the order of transactions displayed in the table. | |
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. | |
credit |
double |
Credit Amount | filters on the platform, writable | Credit amount > The transaction credit amount charged to the account during the selected financial period. | |
curr |
double |
itgen_vnet_currbegbalance | filters on the platform, writable | Beg. balance (currency) > The account balance in the selected currency at the start of the selected period. | |
curr |
double |
itgen_vnet_currcreditamount | filters on the platform, writable | Credit amount (currency) > The credit amount in the selected currency for the specified account over the selected period. | |
curr |
double |
itgen_vnet_currdebitamount | filters on the platform, writable | Debit amount (currency) > The debit amount in the selected currency for the specified account over the selected period. | |
curr |
double |
itgen_vnet_currendingbalance | filters on the platform, writable | Ending balance (currency) > The account balance in the selected currency at the start of the selected period. | |
currency |
varchar2 |
Currency | filters on the platform, writable | Click the Show currency details check box to view the below fields in the window. Currency > The currency of transactions in the account. If it is not specified, the balance is in the base currency. | |
debit |
double |
Debit Amount | filters on the platform, writable | Debit amount > The transaction debit amount charged to the account during the selected financial period. | |
description |
varchar2 |
Description | filters on the platform, writable | Description > The user-defined description of the transaction. | |
ending |
double |
End Balance | filters on the platform, writable | Ending balance > The running total of the account's ending balance calculated in the order of transactions displayed in the table. | |
error |
varchar2 |
Error Message | filters on the platform, writable | ||
last |
datetime |
Last Modified | filters on the platform, writable | System generated information reflecting when the last change was done. | |
ledger_ |
varchar2 |
Description | filters on the platform, writable, ledger_ |
The top part > Description > A detailed ledger description. | |
ledger_ |
varchar2 |
Number | filters on the platform, writable, ledger_ |
Mandatory field: The top part > Ledger ID* > An alphanumeric string of up to 10 characters used to identify the ledger. | |
line |
int32 |
Line Number | filters on the platform, writable | ||
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable | ||
metadata_ |
int64 |
Total Count | filters on the platform, writable | ||
module |
varchar2 |
Module | filters on the platform, writable | Workspace > The workspace where the transaction originated. | |
period |
varchar2 |
Period | filters on the platform, writable | The table > Period > The period no and the year. | |
ref |
varchar2 |
Reference Number | filters on the platform, writable | Ref. number > The reference number of the external document on which this transaction is based. | |
subaccount |
varchar2 |
Sub Account | filters on the platform, writable | Subaccount > The subaccount used in the batch. | |
tran |
datetime |
Transaction Date | filters on the platform, writable | Trans date > The date of the transaction. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: