invantive documentation
Invantive Support ForumsLog In / Sign Up

CashAccountEntryTypesByAccountNumber: Visma.net Financials Cash Account Entry Types by Account Number

read only REST

  • Catalog: VismaNet
  • Schema: CashAccount
  • Label: Cash Account Entry Types by Account Number

Get a specific cash account

Can only retrieve data.

API Source

  • Endpoint: /v1/cashaccount/{accountNumber}
  • Operation: get /v1/cashaccount/{accountNumber}

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.

Parameters

Name Data Type Required Default Documentation
accountNumber `` Identifies the cash account

Table Columns

The columns of the table CashAccountEntryTypesByAccountNumber 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, ::ancestor.account.description Name of item/description
account_number varchar2 Account Number filters on the platform, writable, ::ancestor.account.number Number of item
account_type varchar2 Account Type filters on the platform, writable, ::ancestor.account.type
businessAccount_active char itgen_vnet_businessaccount_active writable, businessAccount.active
businessAccount_description varchar2 itgen_vnet_businessaccount_description writable, businessAccount.description Name of item/description
businessAccount_externalCode1 varchar2 itgen_vnet_businessaccount_externalcode1 writable, businessAccount.externalCode1 Account class > The identifier of the account class.
businessAccount_externalCode2 varchar2 itgen_vnet_businessaccount_externalcode2 writable, businessAccount.externalCode2 Account class > The name of the account class.
businessAccount_number varchar2 itgen_vnet_businessaccount_number writable, businessAccount.number Number of item
businessAccount_type varchar2 itgen_vnet_businessaccount_type writable, businessAccount.type Account > The account number.
currency varchar2 Currency filters on the platform, writable, ::ancestor.currency
defaultOffsetAccountBranch_name varchar2 itgen_vnet_defaultoffsetaccountbranch_name writable, defaultOffsetAccountBranch.name Click the magnifier. > The name.
defaultOffsetAccountBranch_number varchar2 itgen_vnet_defaultoffsetaccountbranch_number writable, defaultOffsetAccountBranch.number Click the magnifier. > The identifier.
defaultOffsetAccount_active char itgen_vnet_defaultoffsetaccount_active writable, defaultOffsetAccount.active
defaultOffsetAccount_description varchar2 itgen_vnet_defaultoffsetaccount_description writable, defaultOffsetAccount.description Name of item/description
defaultOffsetAccount_externalCode1 varchar2 itgen_vnet_defaultoffsetaccount_externalcode1 writable, defaultOffsetAccount.externalCode1 Account class > The identifier of the account class.
defaultOffsetAccount_externalCode2 varchar2 itgen_vnet_defaultoffsetaccount_externalcode2 writable, defaultOffsetAccount.externalCode2 Account class > The name of the account class.
defaultOffsetAccount_number varchar2 itgen_vnet_defaultoffsetaccount_number writable, defaultOffsetAccount.number Number of item
defaultOffsetAccount_type varchar2 itgen_vnet_defaultoffsetaccount_type writable, defaultOffsetAccount.type Account > The account number.
defaultOffsetSubaccount_active char itgen_vnet_defaultoffsetsubaccount_active writable, defaultOffsetSubaccount.active
defaultOffsetSubaccount_description varchar2 itgen_vnet_defaultoffsetsubaccount_description writable, defaultOffsetSubaccount.description Click on the magnifier. > The description.
defaultOffsetSubaccount_id varchar2 itgen_vnet_defaultoffsetsubaccount_id writable, defaultOffsetSubaccount.id Click on the magnifier. > The identifier.
description varchar2 Description writable, description Description > A detailed description of the entry type that is used as transaction description by default.
description_2 varchar2 Description 2 filters on the platform, writable, ::ancestor.description Name of item/description
disableReceipt varchar2 itgen_vnet_disablereceipt writable, disableReceipt Disb/receipt > The basic type of cash transaction designated by this entry type: Receipt or Disbursement.
entryTypeId varchar2 itgen_vnet_entrytypeid writable, entryTypeId Entry type ID* > The entry type, selected by its identifier.
lastModifiedDateTime datetime Last Modified writable, lastModifiedDateTime
lastModifiedDateTime_2 datetime Last Modified Date/Time 2 filters on the platform, writable, ::ancestor.lastModifiedDateTime A system generated date/time to indicate when the document was last changed.
module varchar2 Module writable, module Module > The way the entry type is used in the system.
number varchar2 Number filters on the platform, writable, ::ancestor.number Number of item
offsetAccountBranch_name varchar2 itgen_vnet_offsetaccountbranch_name writable, offsetAccountBranch.name Click the magnifier. > The name.
offsetAccountBranch_number varchar2 itgen_vnet_offsetaccountbranch_number writable, offsetAccountBranch.number Click the magnifier. > The identifier.
offsetAccountOverride_active char itgen_vnet_offsetaccountoverride_active writable, offsetAccountOverride.active
offsetAccountOverride_description varchar2 itgen_vnet_offsetaccountoverride_description writable, offsetAccountOverride.description Name of item/description
offsetAccountOverride_externalCode1 varchar2 itgen_vnet_offsetaccountoverride_externalcode1 writable, offsetAccountOverride.externalCode1 Account class > The identifier of the account class.
offsetAccountOverride_externalCode2 varchar2 itgen_vnet_offsetaccountoverride_externalcode2 writable, offsetAccountOverride.externalCode2 Account class > The name of the account class.
offsetAccountOverride_number varchar2 itgen_vnet_offsetaccountoverride_number writable, offsetAccountOverride.number Number of item
offsetAccountOverride_type varchar2 itgen_vnet_offsetaccountoverride_type writable, offsetAccountOverride.type Account > The account number.
offsetSubaccountOverride_active char itgen_vnet_offsetsubaccountoverride_active writable, offsetSubaccountOverride.active
offsetSubaccountOverride_description varchar2 itgen_vnet_offsetsubaccountoverride_description writable, offsetSubaccountOverride.description Click on the magnifier. > The description.
offsetSubaccountOverride_id varchar2 itgen_vnet_offsetsubaccountoverride_id writable, offsetSubaccountOverride.id Click on the magnifier. > The identifier.
reclasificationAccountOverride_active char itgen_vnet_reclasificationaccountoverride_active writable, reclasificationAccountOverride.active
reclasificationAccountOverride_description varchar2 itgen_vnet_reclasificationaccountoverride_description writable, reclasificationAccountOverride.description Name of item/description
reclasificationAccountOverride_externalCode1 varchar2 itgen_vnet_reclasificationaccountoverride_externalcode1 writable, reclasificationAccountOverride.externalCode1 Account class > The identifier of the account class.
reclasificationAccountOverride_externalCode2 varchar2 itgen_vnet_reclasificationaccountoverride_externalcode2 writable, reclasificationAccountOverride.externalCode2 Account class > The name of the account class.
reclasificationAccountOverride_number varchar2 itgen_vnet_reclasificationaccountoverride_number writable, reclasificationAccountOverride.number Number of item
reclasificationAccountOverride_type varchar2 itgen_vnet_reclasificationaccountoverride_type writable, reclasificationAccountOverride.type Account > The account number.
reclasificationAccount_active char itgen_vnet_reclasificationaccount_active writable, reclasificationAccount.active
reclasificationAccount_description varchar2 itgen_vnet_reclasificationaccount_description writable, reclasificationAccount.description Name of item/description
reclasificationAccount_externalCode1 varchar2 itgen_vnet_reclasificationaccount_externalcode1 writable, reclasificationAccount.externalCode1 Account class > The identifier of the account class.
reclasificationAccount_externalCode2 varchar2 itgen_vnet_reclasificationaccount_externalcode2 writable, reclasificationAccount.externalCode2 Account class > The name of the account class.
reclasificationAccount_number varchar2 itgen_vnet_reclasificationaccount_number writable, reclasificationAccount.number Number of item
reclasificationAccount_type varchar2 itgen_vnet_reclasificationaccount_type writable, reclasificationAccount.type Account > The account number.
subaccount_active char Sub Account Active 2 filters on the platform, writable, ::ancestor.subaccount.active Active > The status of the identifier.
subaccount_description varchar2 Subaccount Description filters on the platform, writable, ::ancestor.subaccount.description Description > The description of the identifier.
subaccount_errorInfo varchar2 Sub Account Error Message filters on the platform, writable, ::ancestor.subaccount.errorInfo
subaccount_lastModifiedDateTime datetime Sub Account Last Modified filters on the platform, writable, ::ancestor.subaccount.lastModifiedDateTime System generated information.
subaccount_metadata_maxPageSize int64 Sub Account Metadata Max Pagesize filters on the platform, writable, ::ancestor.subaccount.metadata.maxPageSize
subaccount_metadata_totalCount int64 Sub Account Metadata Total Count filters on the platform, writable, ::ancestor.subaccount.metadata.totalCount
subaccount_subaccountId int32 Sub Account ID filters on the platform, writable, ::ancestor.subaccount.subaccountId SubID > The identifier of the subaccount.
subaccount_subaccountNumber varchar2 Sub Account Number filters on the platform, writable, ::ancestor.subaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
subaccount_timeStamp blob itgen_vnet_subaccount_timestamp filters on the platform, writable, ::ancestor.subaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
taxCalculationMode varchar2 itgen_vnet_taxcalculationmode writable, taxCalculationMode Tax calculation mode > The tax calculation mode to be used by default with this entry type
useForPaymentsReclasification char itgen_vnet_useforpaymentsreclasification writable, useForPaymentsReclasification A check box that you select if this entry type is used to record unknown payments that need to be reclassified later.
vatZone_defaultTaxCategory_description varchar2 VAT Zone Default Tax Category Description writable, vatZone.defaultTaxCategory.description Name of item/description
vatZone_defaultTaxCategory_number varchar2 VAT Zone Default Tax Category Number writable, vatZone.defaultTaxCategory.number Number of item
vatZone_defaultVatCategory varchar2 VAT Zone Default VAT Category writable, vatZone.defaultVatCategory Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_description varchar2 VAT Zone Description writable, vatZone.description Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_errorInfo varchar2 itgen_vnet_vatzone_errorinfo writable, vatZone.errorInfo
vatZone_id varchar2 VAT Zone ID writable, vatZone.id Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_metadata_maxPageSize int64 itgen_vnet_vatzone_metadata_maxpagesize writable, vatZone.metadata.maxPageSize
vatZone_metadata_totalCount int64 itgen_vnet_vatzone_metadata_totalcount writable, vatZone.metadata.totalCount

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: