invantive documentation
Invantive Support ForumsLog In / Sign Up

NumberSequenceByNumberingIdSequence: Visma.net Financials Number Sequence by Numbering ID Sequence

read only REST

  • Catalog: VismaNet
  • Schema: NumberSequence
  • Label: Number Sequence by Numbering ID Sequence

Get a specific Numbering

Can only retrieve data.

API Source

  • Endpoint: /v1/numberSequence/{numberingId}
  • Operation: get /v1/numberSequence/{numberingId}

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
numberingId `` Identifies the Numbering

Table Columns

The columns of the table NumberSequenceByNumberingIdSequence 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.
branch_name varchar2 Branch Name writable, branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number writable, branch.number Click the magnifier. > The identifier.
description varchar2 Description filters on the platform, writable, ::ancestor.description Mandatory field: The top part > Description* > The description of the numbering series.
endNbr varchar2 itgen_vnet_endnbr writable, endNbr Mandatory field: The table > End number* > The number to be used at the end of this series. The end number cannot be less than the Start number.
lastNbr varchar2 Last Number writable, lastNbr Mandatory field: The table > Last number* > The most recent allocated number used for an object in this series.
manualNumbering char Manual Numbering filters on the platform, writable, ::ancestor.manualNumbering The top part > Manual numbering > A check box that indicates (if selected) that the system will not generate numbers for the series and users will need to specify document numbers manually.
nbrStep int32 itgen_vnet_nbrstep writable, nbrStep Mandatory field: The table > Numbering step* > The increment this series uses to generate the next number.
newNumberSymbol varchar2 New Number Symbol filters on the platform, writable, ::ancestor.newNumberSymbol Mandatory field: The top part > New number symbol* > An alphanumeric string used to indicate that a new number for an object will be assigned.
nextNumber varchar2 itgen_vnet_nextnumber writable, nextNumber Next number that will be assigned
numberingId varchar2 Number Sequence ID writable, numberingId Mandatory field: The top part > Numbering ID > The unique ID of the numbering series, which is an alphanumeric string of up to 10 characters.
numberingId_2 varchar2 itgen_vnet_numberingid_2 filters on the platform, writable, ::ancestor.numberingId Mandatory field: The top part > Numbering ID > The unique ID of the numbering series, which is an alphanumeric string of up to 10 characters.
startDate datetime Start Date writable, startDate Mandatory field: The table > Start dat*e > The date when this series will first be used.
startNbr varchar2 itgen_vnet_startnbr writable, startNbr Mandatory field: The table > Start number* > The number to be used first in this numbering series or subsequence.
warnNbr varchar2 itgen_vnet_warnnbr writable, warnNbr Mandatory field: The table > Warning number* > The minimum number that triggers a warning that available numbers will be used up soon.

Release Notes

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