NumberSequences2: Visma.net Financials Number Sequences |
Get a specific Numbering - ScreenId=CS201010
Catalog: VismaNet
Schema: NumberSequence
Label: Number Sequences
This is a read-only table. The Visma.net Financials API may not support changing the data or the Invantive UniversalSQL driver for Visma.net Financials does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma.net Financials API.
Table Columns
The columns of the table NumberSequences2 are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
branch_name |
string |
Branch Name |
☐ |
Click the magnifier. > The name. |
branch_number |
string |
Branch Number |
☐ |
Click the magnifier. > The identifier. |
COMPANY_CODE |
string(30) |
Company Code |
☑ |
Partition code, segmenting the data. |
COMPANY_NAME |
string(240) |
Company Name |
☑ |
Name of the partition. |
description |
string |
Description |
☐ |
Mandatory field: The top part > Description* > The description of the numbering series. |
endNbr |
string |
{res:itgen_vnet_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 |
string |
Last Number |
☐ |
Mandatory field: The table > Last number* > The most recent allocated number used for an object in this series. |
manualNumbering |
boolean |
Manual Numbering |
☐ |
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 |
{res:itgen_vnet_nbrstep} |
☐ |
Mandatory field: The table > Numbering step* > The increment this series uses to generate the next number. |
newNumberSymbol |
string |
New Number Symbol |
☐ |
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 |
string |
{res:itgen_vnet_nextnumber} |
☐ |
Next number that will be assigned |
numberingId_2 |
string |
{res:itgen_vnet_numberingid_2} |
☐ |
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 |
string |
Number Sequence ID |
☐ |
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 |
☐ |
Mandatory field: The table > Start dat*e > The date when this series will first be used. |
startNbr |
string |
{res:itgen_vnet_startnbr} |
☐ |
Mandatory field: The table > Start number* > The number to be used first in this numbering series or subsequence. |
warnNbr |
string |
{res:itgen_vnet_warnnbr} |
☐ |
Mandatory field: The table > Warning number* > The minimum number that triggers a warning that available numbers will be used up soon. |
23-06-2025 19:16 Version 24.1.116-BETA+5455