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 |
|---|---|---|---|---|
numbering |
`` | 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
branch_ |
varchar2 |
Branch Name | writable, branch. |
Click the magnifier. > The name. | |
branch_ |
varchar2 |
Branch Number | writable, branch. |
Click the magnifier. > The identifier. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
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. | |
last |
varchar2 |
Last Number | writable, last |
Mandatory field: The table > Last number* > The most recent allocated number used for an object in this series. | |
manual |
char |
Manual Numbering | filters on the platform, writable, ::ancestor. |
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. | |
nbr |
int32 |
itgen_vnet_nbrstep | writable, nbr |
Mandatory field: The table > Numbering step* > The increment this series uses to generate the next number. | |
new |
varchar2 |
New Number Symbol | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > New number symbol* > An alphanumeric string used to indicate that a new number for an object will be assigned. | |
next |
varchar2 |
itgen_vnet_nextnumber | writable, next |
Next number that will be assigned | |
numbering |
varchar2 |
Number Sequence ID | writable, numbering |
Mandatory field: The top part > Numbering ID > The unique ID of the numbering series, which is an alphanumeric string of up to 10 characters. | |
numbering |
varchar2 |
itgen_vnet_numberingid_2 | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Numbering ID > The unique ID of the numbering series, which is an alphanumeric string of up to 10 characters. | |
start |
datetime |
Start Date | writable, start |
Mandatory field: The table > Start dat*e > The date when this series will first be used. | |
start |
varchar2 |
itgen_vnet_startnbr | writable, start |
Mandatory field: The table > Start number* > The number to be used first in this numbering series or subsequence. | |
warn |
varchar2 |
itgen_vnet_warnnbr | writable, warn |
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: