Accounts: Visma.net Financials General Ledger Accounts
popular insert update REST
- Catalog:
VismaNet - Schema:
Account - Primary Keys:
accountCd - Label: General Ledger Accounts
Get a range of General ledger accounts - ScreenId=GL202500 Data for Account
Can retrieve data and change data using insert and update.
Summary
Data for Account
API Source
- Endpoint:
/v1/account - Operation:
get /v1/account
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 241 |
| Full scan rows per minute | 20,700 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
active |
`` | Set to True to select active accounts. | ||
analysis |
`` | Filter by Analysis code (field used for sorting and inquiries.) | ||
external |
`` | Filter by External code 1 (field used for sorting and inquiries.) | ||
external |
`` | Filter by External code 2 (field used for sorting and inquiries.) | ||
greater |
`` | Enter the from-value for Account no. | ||
include |
`` | Set to True to include AccountClass description. | ||
include |
`` | Optional. If set to true, each account in the response includes its subaccount (subaccount). Default false. | ||
include |
`` | Optional. Default false. If set to true, the response includes each account's subaccount together with its segments (segments), even if includeSubaccount is not set. Loading segments requires additional queries, so this option is disabled by default. | ||
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. | ||
public |
`` | Filter by the Public code 1, authorities mapped code to the account. |
Table Columns
The columns of the table Accounts 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 Code | filters on the platform, writable, account |
Mandatory field: The table > Account* > The unique identifier of the general ledger account in the system. | |
account |
varchar2 |
Account Class | filters on the platform, writable, account |
The table > Account class > Optional. The account class to which the account is assigned. | |
account |
varchar2 |
itgen_vnet_accountclassdescription | filters on the platform, writable, account |
The table > Desc > An alphanumeric string of up to 30 characters that describes the AccountClass. | |
account |
varchar2 |
Account Group Code | filters on the platform, writable, account |
The table > Account group > The account group (used in project management if the Projects module has been activated) that includes this account. | |
account |
int32 |
Account ID | filters on the platform, writable, account |
The table > AccountID > The Account ID is the actual ID that the account have in the database and are used in other tables as the relation between the Chart of accounts table and other tables. | |
active |
char |
Active | filters on the platform, writable, active |
The table > Active > A check box that indicates that the account is active. | |
allow |
char |
itgen_vnet_allowmanualentry | filters on the platform, writable, allow |
||
analisys |
varchar2 |
itgen_vnet_analisyscodeinfo_description | filters on the platform, writable, analisys |
Name of item/description | |
analisys |
varchar2 |
itgen_vnet_analisyscodeinfo_number | filters on the platform, writable, analisys |
Number of item | |
cash |
char |
Cash Account | filters on the platform, writable, cash |
The table > Cash account > A check box that indicates (if selected) that the account has a cash account or multiple cash accounts linked to it. | |
control |
varchar2 |
itgen_vnet_controlaccountmodule | filters on the platform, writable, control |
||
currency |
varchar2 |
Currency | filters on the platform, writable, currency |
The table > Currency > Optional: This column appears only if support for multiple currencies has been activated for the system. | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The table > Description > An alphanumeric string of up to 30 characters that describes the account. | |
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
external |
varchar2 |
itgen_vnet_externalcode1info_description | filters on the platform, writable, external |
Name of item/description | |
external |
varchar2 |
itgen_vnet_externalcode1info_number | filters on the platform, writable, external |
Number of item | |
external |
varchar2 |
itgen_vnet_externalcode2info_description | filters on the platform, writable, external |
Name of item/description | |
external |
varchar2 |
itgen_vnet_externalcode2info_number | filters on the platform, writable, external |
Number of item | |
last |
datetime |
Last Modified | filters on the platform, writable, last |
This information is not visible in the window. It is collected from the system. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
post |
varchar2 |
Post Option | filters on the platform, writable, post |
The table > Post option > An option that defines how transactions created in other workspaces are posted to this account. Summary (default) or Detail. | |
public |
varchar2 |
Public Code 1 | filters on the platform, writable, public |
The table > Public code 1 > The authorities valid code mapped to the account. Used for example in SAF-T and in some nationals reporting to the authorities. | |
subaccount_ |
char |
Sub Account Active 2 | filters on the platform, writable, subaccount. |
Active > The status of the identifier. | |
subaccount_ |
varchar2 |
Subaccount Description | filters on the platform, writable, subaccount. |
Description > The description of the identifier. | |
subaccount_ |
varchar2 |
Sub Account Error Message | filters on the platform, writable, subaccount. |
||
subaccount_ |
datetime |
Sub Account Last Modified | filters on the platform, writable, subaccount. |
System generated information. | |
subaccount_ |
int64 |
Sub Account Metadata Max Pagesize | filters on the platform, writable, subaccount. |
||
subaccount_ |
int64 |
Sub Account Metadata Total Count | filters on the platform, writable, subaccount. |
||
subaccount_ |
int32 |
Sub Account ID | filters on the platform, writable, subaccount. |
SubID > The identifier of the subaccount. | |
subaccount_ |
varchar2 |
Sub Account Number | filters on the platform, writable, subaccount. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
subaccount_ |
blob |
itgen_vnet_subaccount_timestamp | filters on the platform, writable, subaccount. |
The timestamp of the subaccount, used for concurrency control. | |
tax |
varchar2 |
Tax Category | filters on the platform, writable, tax |
The table > VAT category > A tax category that you define for the selected account. When you create a journal transaction manually in the GL301000 window, based on this VAT category, the taxable amount will be calculated for the journal entry. | |
time |
blob |
Timestamp | filters on the platform, writable, time |
||
type |
varchar2 |
Type | filters on the platform, writable, type |
The table > Type > The type of account: Asset, Liability, Income, or Expense. | |
use |
char |
itgen_vnet_usedefaultsub | filters on the platform, writable, use |
The table > Use default sub > A check box that causes the system (if selected) to set the default subaccount as the Subaccount if the account is selected. |
Referenced By
- CashAccountEntryTypes
account_number(Key) - CashAccountEntryTypes
defaultOffsetAccount_number(Key) - CashAccountEntryTypes
reclasificationAccount_number(Key) - CashAccountSubAccountSegments
account_number(Key) - CashAccounts
account_number(Key) - CashSaleApplications
account_number(Key) - CashSaleLines
account_number(Key) - CashSales
account_number(Key) - CashTransactionDetails
cashAccount_number(Key) - CashTransactionDetails
offsetAccount_number(Key) - CashTransactionDetails
offsetCashAccount_number(Key) - CashTransactionTaxDetails
cashAccount_number(Key) - CashTransactions
cashAccount_number(Key) - CustomerCreditNoteApplications
account_number(Key) - CustomerCreditNoteLines
account_number(Key) - CustomerCreditNoteTaxDetails
account_number(Key) - CustomerCreditNotes
account_number(Key) - CustomerCreditWriteOffs
account_number(Key) - CustomerDebitNoteApplications
account_number(Key) - CustomerDebitNoteLines
account_number(Key) - CustomerDebitNoteTaxDetails
account_number(Key) - CustomerDebitNotes
account_number(Key) - CustomerDocumentSubaccountSegments
account_number(Key) - CustomerDocuments
account_number(Key) - CustomerInvoiceApplications
account_number(Key) - CustomerInvoiceLineSubaccountSegments
account_number(Key) - CustomerInvoiceLines
account_number(Key) - CustomerInvoiceSubaccountSegments
account_number(Key) - CustomerInvoiceTaxDetails
account_number(Key) - CustomerInvoices
account_number(Key) - CustomerOverdueChargeApplications
account_number(Key) - CustomerOverdueChargeLines
account_number(Key) - CustomerOverdueChargeSubAccountSegmentLines
account_number(Key) - CustomerOverdueChargeTaxDetails
account_number(Key) - CustomerOverdueCharges
account_number(Key) - ExpenseClaimDetails
expenseAccount_number(Key) - ExpenseClaimDetails
salesAccount_number(Key) - ExpenseReceiptClaimsByWorkGroupDescription
expenseAccount_number(Key) - ExpenseReceiptClaimsByWorkGroupDescription
salesAccount_number(Key) - ExpenseReceipts
expenseAccount_number(Key) - ExpenseReceipts
salesAccount_number(Key) - ProjectAttributes
defAccount_number(Key) - ProjectAttributes
defAccrualAccount_number(Key) - ProjectEmployees
defAccount_number(Key) - ProjectEmployees
defAccrualAccount_number(Key) - ProjectTaskAttributes
defAccount_number(Key) - ProjectTaskAttributes
defAccrualAccount_number(Key) - ProjectTaskEmployees
defAccount_number(Key) - ProjectTaskEmployees
defAccrualAccount_number(Key) - ProjectTasks
defAccount_number(Key) - ProjectTasks
defAccrualAccount_number(Key) - Projects
defAccount_number(Key) - Projects
defAccrualAccount_number(Key) - PurchaseOrderLineSubsegments
account_number(Key) - PurchaseOrderLines
account_number(Key) - BasicPurchaseOrderLines
account_number(Key) - PurchaseOrderLinesSubsegments
account_number(Key) - SupplierDocuments
account_number(Key) - SupplierInvoiceLines
account_number(Key) - SupplierInvoiceLines
prebookAccount_number(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: