itgendoc001X
xMsg javascript has not been loaded.
Visma.net Financials API Data ModelGet a specific Numbering - ScreenId=CS201010
Catalog: VismaNet
Schema: NumberSequence
Label: Number Sequences
The data in this table is partitioned per value of the COMPANY_CODE column.
This is a read-only table. The Visma.net Financials API may not support changing the data or the Invantive SQL 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.
Select Visma.net Financials API URL: /controller/api/v1/numberSequence
Insert Visma.net Financials API URL: /controller/api/v1/numberSequence
Update Visma.net Financials API URL: /controller/api/v1/numberSequence
Delete Visma.net Financials API URL: /controller/api/v1/numberSequence
Field Selection Method: NotRequired
Base Path: sequence[*]
Select Visma.net Financials API Operation: get /controller/api/v1/numberSequence
Table Columns
The columns of the table NumberSequences1 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 |
|
☐ |
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 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 |
|
☐ |
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. |
numberingId_1 |
string |
|
☐ |
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 |
|
☐ |
Mandatory field: The table > Start number* > The number to be used first in this numbering series or subsequence. |
warnNbr |
string |
|
☐ |
Mandatory field: The table > Warning number* > The minimum number that triggers a warning that available numbers will be used up soon. |
06-04-2021 14:55 Version 20.1.393-BETA+3152
