System information
This table contains a single row with information about the licensee including system settings.
| Property | Value | Description |
|---|---|---|
| Database | System | This table is in the system (vbsys) database. |
| SQL name | SysData | The table name in the database. |
| API identifier | systemInformation | The API identifier used in GraphQL. |
| Table no. | 174 | The table number in the data model. |
The following fields exist in this table:
Address line 1
The licensee's address.
The street or PO box address is usually entered in the Address line 1 field. If the field is already used for attention or c/o then the Address line 2 field can be used instead.
You can edit the information in forms using the @System macro. The information is also used for export in special format to annual accounts packages.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| SQL name | Ad1 | The database field name. |
| API identifier | addressLine1 | The API identifier used in GraphQL. |
| Number | 5601 |
Address line 2
The licensee's address.
The street or PO box address is usually entered in the Address line 1 field. If the field is already used for attention or c/o then the Address line 2 field can be used instead.
You can edit the information in forms using the @System macro. The information is also used for export in special format to annual accounts packages.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| SQL name | Ad2 | The database field name. |
| API identifier | addressLine2 | The API identifier used in GraphQL. |
| Number | 5602 |
Address line 3
The licensee's address.
The street or PO box address is usually entered in the Address line 1 field. If the field is already used for attention or c/o then the Address line 2 field can be used instead.
You can edit the information in forms using the @System macro. The information is also used for export in special format to annual accounts packages.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| SQL name | Ad3 | The database field name. |
| API identifier | addressLine3 | The API identifier used in GraphQL. |
| Number | 5603 |
Address line 4
The licensee's address.
The street or PO box address is usually entered in the Address line 1 field. If the field is already used for attention or c/o then the Address line 2 field can be used instead.
You can edit the information in forms using the @System macro. The information is also used for export in special format to annual accounts packages.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| SQL name | Ad4 | The database field name. |
| API identifier | addressLine4 | The API identifier used in GraphQL. |
| Number | 5604 |
Agriculture dataflow company UUID
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | GUID | Text (40) |
| SQL name | LDCompId | The database field name. |
| API identifier | agricultureDataflowCompanyUUID | The API identifier used in GraphQL. |
| Number | 17976 |
AI permission
Configure how AI features are permitted to interact with your data.
GAiA
GAiA is the AI assistant built into Business NXT and managed by Visma.
- Read
- Allow GAiA to read data.
- Write
- Allow GAiA to make changes on your behalf. Requires Read permission.
- Use specific access groups only
AI Connect
The MCP server exposes Business NXT data to third-party AI agents through the Model Context Protocol.
- Read
- Allow third-party AI agents to read data.
- Write
- Allow third-party AI agents to make changes on your behalf. Requires Read permission.
- Use specific access groups only
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | AI permission | Integer |
| Write Access | System supervisor user | Only users who are marked as System supervisor in the User table are allowed to modify the value in this field. |
| SQL name | AIPerm | The database field name. |
| API identifier | aIPermission | The API identifier used in GraphQL. |
| Number | 20878 |
Bank account
The licensee's bank account number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | BGiro | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 5610 |
Change log path
The directory where you want to store the change log files.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Log filename | Text (260) |
| SQL name | LogPath | The database field name. |
| API identifier | changeLogPath | The API identifier used in GraphQL. |
| Number | 14899 |
CRM system
The CRM system with which an integration is created.
You must install the integration programs in order to run against these programs.
- 1 - Visma CRM
- 2 - SuperOffice (not supported)
- Note:Business NXT 5.0.0 does not support SuperOffice. You can use SuperOffice in previous versions of Business NXT
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | CRM system | Integer |
| SQL name | CRMSys | The database field name. |
| API identifier | crmSystem | The API identifier used in GraphQL. |
| Number | 10503 |
EDI folders
The EDI files will be placed in different folders depending on the document type and the EDI path. The path is found in the EDI path field in the System information table.
If not specified, the EDI files will automatically be given unique names. The folders are named according to the message, using a letter code denoting whether the folder is used for outgoing messages (W for Write) or incoming messages (R for Read). Example of a folder name: INVOICW for outgoing invoices.
| Folder name | Document type |
|---|---|
| CREAPPR | Not in use (Activities in) |
| DESADVW | Packing slips in |
| DIRDEBR | Batches in (EDI format) |
| IMPORTS | Standard import files in |
| INVOICR | Invoices in to batch |
| INVOICW | Invoices out |
| ORDCHGR | Order changes in |
| ORDERSR | New orders in |
| ORDERSW | Order confirmation out |
| ORDRSPR | Order confirmation in |
| ORDRSPW | Orders and inquiries out |
| PARTINR | Not in use (Associates in) |
| QUOTESR | Quotes in |
| QUOTESW | Quotes out |
When the EDI clock takes into account the selection in the EDI folders field in the System information table, the folders will be processed in the following sequence: ORDERSR, ORDCHGR, INVOICR, QUOTESR, PARTINR, DIRDEBR, CREAGRR, IMPORTS.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | EDIFldr | The database field name. |
| API identifier | ediFolders | The API identifier used in GraphQL. |
| Number | 7046 |
EDI layout no.
Which setup is to be used in connection with the production of order confirmations for EDI.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | EDIWin | The database field name. |
| API identifier | ediLayoutNo | The API identifier used in GraphQL. |
| Number | 6139 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Window | EdiLayout |
|
EDI log file
The name and path of the EDI log file that will contain information about wrongly imported orders/invoices.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Log directory | Text (260) |
| SQL name | EDILog | The database field name. |
| API identifier | ediLogFileName | The API identifier used in GraphQL. |
| Number | 6146 |
EDI path
The directory in which Business NXT should read/write the EDI import and export files.
If the field is empty, EDI_PATH in Registry will be used. If you do not have a value in Registry either, Business NXT's program path in addition to folders for each company F0001, F0002, etc. will be used.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Data directory | Text (260) |
| SQL name | EdiPath | The database field name. |
| API identifier | ediPath | The API identifier used in GraphQL. |
| Number | 14897 |
EDI-error message level
A selection of what type of information is logged in the EDI error message table.
The level of reported errors. All actual errors will be written to the error log. The log is written to the EDI error message table. You cannot make changes in this table, but the system supervisor can delete rows. All logging in this table is valid for companies in Business NXT.
- Error level NORMAL
- Messages of the type
Order input started
, etc. is logged. - Error level WARNING
- Logs errors that are not critical for the process. For example
There is no product number
. - Error level ERROR
- File dump level NORMAL
- File dump level WARNING
- File dump level ERROR
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | EDI-error message level | Integer |
| SQL name | EDIFmt | The database field name. |
| API identifier | ediErrorMessageLevel | The API identifier used in GraphQL. |
| Number | 6599 |
E-mail address
The licensee's e-mail address.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | E-mail address | Text (60) |
| SQL name | MailAd | The database field name. |
| API identifier | emailAddress | The API identifier used in GraphQL. |
| Number | 5607 |
Excel template path
The directory where you would like to save the Excel templates
The Excel templates are created with the menu choice.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Data directory | Text (260) |
| SQL name | XltPath | The database field name. |
| API identifier | excelTemplatePath | The API identifier used in GraphQL. |
| Number | 16131 |
External app. Company no.
Used in connection with the processings in the Associate and Appointment tables to transfer data to and from external applications.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Company no. | Integer |
| SQL name | ExtFrmNo | The database field name. |
| API identifier | externalApplicationCompanyNo | The API identifier used in GraphQL. |
| Number | 6505 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Company | ExternalApplicationCompany |
|
Fax
The licensee's fax number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Phone | Text (20) |
| SQL name | Fax | The database field name. |
| API identifier | fax | The API identifier used in GraphQL. |
| Number | 5609 |
Fax and e-mail route
The directory where you want to save the fax and e-mail files.
If the field is not filled in, the Registry parameter FAX_MAIL_PATH will be used.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Data directory | Text (260) |
| SQL name | FMPath | The database field name. |
| API identifier | faxAndEmailPath | The API identifier used in GraphQL. |
| Number | 8226 |
Font
The default font of tables in existing layouts where the font is not defined.
The field shows the font family, style and size within square brackets. In the database there are three separate fields for font family, font style and font size. The field shown on the screen keeps the font size in the database.
Is normally set with the Font command (in the Design group in the Home tab).
The font size may be set as a percentage (e.g. 120) of the normal font size, cf. the Relative option in the Type drop-down list in the dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Font | Integer |
| SQL name | FSz | The database field name. |
| API identifier | fontSize | The API identifier used in GraphQL. |
| Number | 14906 |
Latest VUD change for companies
If Visma User Directory (VUD) is activated, this field will show the last changes being done to the companies from VUD.
This functionality is not supported in Business NXT.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VUD Cookie | Unlimited text |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VudFrmCki | The database field name. |
| API identifier | latestVudChangeCompanies | The API identifier used in GraphQL. |
| Number | 16488 |
Latest VUD change for company groups
If Visma User Directory (VUD) is activated, this field will show the last changes being done to the company groups from VUD.
This functionality is not supported in Business NXT.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VUD Cookie | Unlimited text |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VudFrGrCki | The database field name. |
| API identifier | latestVudChangeCompanyGroups | The API identifier used in GraphQL. |
| Number | 17871 |
Latest VUD change for user groups
If Visma User Directory (VUD) is activated, this field will show the last changes being done to the user groups from VUD.
This functionality is not supported in Business NXT.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VUD Cookie | Unlimited text |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VudUsrGrCki | The database field name. |
| API identifier | latestVudChangeUserGroups | The API identifier used in GraphQL. |
| Number | 18505 |
Latest VUD change for users
If Visma User Directory (VUD) is activated, this field will show the last changes being done to the users from VUD.
This functionality is not supported in Business NXT.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VUD Cookie | Unlimited text |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VudUsrCki | The database field name. |
| API identifier | latestVudChangeUsers | The API identifier used in GraphQL. |
| Number | 16484 |
Latest VUD changes for access groups
If Visma User Directory (VUD) is activated, this field will show the last changes being done to the access groups from VUD.
This functionality is not supported in Business NXT.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VUD Cookie | Unlimited text |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VudAcGrCki | The database field name. |
| API identifier | latestVudChangeAccessGroups | The API identifier used in GraphQL. |
| Number | 16489 |
Layout path
The directory where you want to store the layout files.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Directory | Text (260) |
| SQL name | LayPath | The database field name. |
| API identifier | layoutPath | The API identifier used in GraphQL. |
| Number | 14894 |
Licence web service address
Alternative web service address for the licensing service.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | LicWsAdr | The database field name. |
| API identifier | licenceWebServiceAddress | The API identifier used in GraphQL. |
| Number | 16333 |
Memo path
The directory where you want to store the memo files.
If this field is not filled out, the files are stored in the default location (like "C:\Users[User]\Documents\F[nnnn]"). To check the location of stored memos, the Memo file name can be unhided for an entry where a memo has been added.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Data directory | Text (260) |
| SQL name | MemoPath | The database field name. |
| API identifier | memoPath | The API identifier used in GraphQL. |
| Number | 14895 |
Min. no. of rows
The smallest number of rows which will be shown on the screen.
If empty the default value is a 1000 rows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | RowsToR | The database field name. |
| API identifier | minNoOfRows | The API identifier used in GraphQL. |
| Number | 14903 |
Name
The name of the licensee and is taken from the installation file.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | name | The API identifier used in GraphQL. |
| Number | 5600 |
Need BIG to start
Visualises the Need BIG to start option under the System information processing field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | needBigToStart | The API identifier used in GraphQL. |
| Number | 12037 |
Organisation no.
The company number in the register of business enterprises.
Every company has to be listed in the corresponding register for each country and the number is a unique one.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| SQL name | BsNo | The database field name. |
| API identifier | companyNo | The API identifier used in GraphQL. |
| Number | 5612 |
Phone
The licensee's phone number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Phone | Text (20) |
| SQL name | Phone | The database field name. |
| API identifier | phone | The API identifier used in GraphQL. |
| Number | 5608 |
Post code
The licensee's post code.
You can edit the information in forms using the @System macro. The information is also used for export in special format to annual accounts packages.
If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Post code | Text (40) |
| SQL name | PNo | The database field name. |
| API identifier | postCode | The API identifier used in GraphQL. |
| Number | 5605 |
Postal area
The licensee's postal area.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| SQL name | PArea | The database field name. |
| API identifier | postalArea | The API identifier used in GraphQL. |
| Number | 5606 |
Postal giro
The licensee's postal giro number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | PGiro | The database field name. |
| API identifier | postalGiro | The API identifier used in GraphQL. |
| Number | 5611 |
Primary key
A unique number identifying the System information row.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Primary key |
| SQL name | PK | The database field name. |
| API identifier | primaryKey | The API identifier used in GraphQL. |
| Number | 5599 |
Regional format
Setup for regional formats, used both in the user interface and on printouts.
These settings are used for printouts, when the regional format is not defined for the relevant language in the Language table.
Different formatting rules for date, time and number fields in the user interface and on printouts can be set for different languages.
- The Regional format in the Language table, from row with the actual Language no. from the document.
- The Regional format in the Language table, from row with the actual Language no. from Company information table.
- The Regional format in the System information table.
- Values returned from the operating system on the machine producing the report (the "Region" format, taken e.g. from HKEY_CURRENT_USER\Control Panel\International).
- The default values (indicated by "(default)" in the description below).
Date
Date format
- Undefined
- Value is not set.
- Day Month Year
- Date format ddmmyyyy (default).
- Year Month Day
- Date format yyyymmdd.
- Month Day Year
- Date format mmddyyyy.
Date separator
- Undefined
- Value is not set.
- Period (.)
- Period as date separator, like format dd.mm.yyyy (default).
- Hyphen (-)
- Hyphen as date separator, like format dd-mm-yyyy.
- Slash (/)
- Slash as date separator, like format dd/mm/yyyy.
Leading zero for single digit day
- Undefined
- Value is not set.
- Yes
- Date format like 01.mm.yyyy.
- No
- Date format like 1.mm.yyyy.
Leading zero for single digit month
- Undefined
- Value is not set.
- Yes
- Date format like dd.01.yyyy.
- No
- Date format like dd.1.yyyy.
Include century in year
- Undefined
- Value is not set.
- Yes
- Date format like dd.mm.yyyy (default).
- No
- Date format like dd.mm.yy.
Time
Time format
- Undefined
- Value is not set.
- 24-hour clock
- 24 hours clock (default).
- 12-hour clock
- 12 hours clock, should be used in connection with Before noon designator and After noon designator.
Time separator
- Undefined
- Value is not set.
- Colon (:)
- Time format mm:hh (default).
- Period (.)
- Time format mm.hh.
Before noon designator
- Undefined
- Value is not set.
- a.m.
- Time format like 11:45 a.m. (default).
- am
- Time format like 11:45 am.
- AM
- Time format like 11:45 AM.
After noon designator
- Undefined
- Value is not set.
- p.m.
- Time format like 11:45 p.m. (default).
- pm
- Time format like 11:45 pm.
- PM
- Time format like 11:45 PM.
Leading zero for hours
- Undefined
- Value is not set.
- Yes
- Time format like 09:45 (default).
- No
- Time format like 9:45.
Number
Decimal separator
- Undefined
- Value is not set.
- Comma (,)
- Number format like 100,25 (default).
- Period (.)
- Number format like 100.25.
Thousands separator
Selected Thousands separator must be different than Decimal separator (when "Period" or "Comma" selected).
- Undefined
- Value is not set.
- Space ( )
- Number format like 10 000,00 (default).
- Period (.)
- Number format like 10.000,00.
- Comma (,)
- Number format like 10,000.00 (Decimal separator must be set to Period (.)).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Regional format | Integer |
| SQL name | RgnFmt | The database field name. |
| API identifier | regionalFormat | The API identifier used in GraphQL. |
| Number | 19166 |
Report path
The directory where you want to store the report files.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Directory | Text (260) |
| SQL name | RepPath | The database field name. |
| API identifier | reportPath | The API identifier used in GraphQL. |
| Number | 14900 |
Round 5 down
5 is rounded down instead of up.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | Round5Pn | The database field name. |
| API identifier | round5Down | The API identifier used in GraphQL. |
| Number | 7099 |
SAF-T path
The directory where the SAF-T files are stored.
If the field is empty, the files will be stored under C:\ProgramData.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Data directory | Text (260) |
| SQL name | AltPath | The database field name. |
| API identifier | saftPath | The API identifier used in GraphQL. |
| Number | 17662 |
Shading on print
Shading on the printouts.
- 1 - None
- Draws the background with the actual colour
- 2 - Normal
- Uses the hard coded RGB-value (236, 233, 216)
- 3 - Special
- Does not draw any background
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Shading on print | Integer |
| SQL name | RstOnPrn | The database field name. |
| API identifier | rasterOnPrint | The API identifier used in GraphQL. |
| Number | 14901 |
SIE path
The directory where you want to save the SIE files.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Data directory | Text (260) |
| SQL name | SiePath | The database field name. |
| API identifier | siePath | The API identifier used in GraphQL. |
| Number | 14898 |
SIE template path
The SIE template path field in System information table is used for specifying the folder where the user wants to save SIE templates. If the field is empty, the SIE templates will be saved in C:\ProgramData.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Data directory | Text (260) |
| SQL name | SieTPath | The database field name. |
| API identifier | sieTemplatePath | The API identifier used in GraphQL. |
| Number | 17974 |
Sort addition
You can use these selections to optimise SQL server's sorting and retrieval of data.
This requires a review of all the layouts.
You can use the selections "2. Standard" and "3. Never" to optimise SQL server's sorting and retrieval of data. This requires a review of the sorting in all the layouts, because the sorting in SQL server is different from the sorting in the layouts.
- 1 - Always
- If you have selected the sort addition "Always", primary keys and sequence numbers will always be included in the sort even if other sorts have been entered in the layouts.
- 2 - Standard
- If you have selected the sort addition "Standard", primary keys and sequence numbers will not be included in the sort if there is a different type of sort in the layouts.
- 3 - Never
- If you have selected the sort addition "Never", the data will be retrieved directly from the tables in which they have been saved. The sort you require must then be present in the layouts.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sort addition | Integer |
| SQL name | SrtAdd | The database field name. |
| API identifier | sortAddition | The API identifier used in GraphQL. |
| Number | 14904 |
Sort companies on name
Visualises the Sort companies on name option under the System information processing field.
The companies will be displayed, sorted by the Sort field in the Company table. Either Company no. or Name will be sorted, depending on whether Sort companies on name has been selected under the System information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sortCompaniesOnName | The API identifier used in GraphQL. |
| Number | 10886 |
SyncEngine UUID
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | GUID | Text (40) |
| SQL name | SEUuid | The database field name. |
| API identifier | syncEngineUUID | The API identifier used in GraphQL. |
| Number | 18057 |
System information processing
System information management.
Miscellaneous
- Windows login
- You must type a password in order to change the password. You can log in without a password if you do not have one, but you cannot create a blank password when you change it.
- Windows login only
- The Windows login only is greyed out if you have not selected the Windows login. If you have selected both options, you cannot log in with users other than the
active Windows user.Note:If you are unsure whether you are using Windows log in, just select the Windows login only option and try to log in. If this works, you can use the Windows login only option.The Windows user must be created in the User table in order to be able to log in. If not, you receive an error message.
- VUD login
-
This functionality is not supported in Business NXT.
- Aggregated access when using VUD (instead of intersection)
-
This functionality is not supported in Business NXT.
- Sort companies on name
- The companies are sorted by name and not by company number.
- Need BIG to start
- You must have a BIG licence and a BIG application in order to start Business NXT.
- Set EOF in file after import
- EOF (end of file) will be written to the file after import. This means you cannot import the file again. Ctrl-Z will be written as the first character in the file. However, to import the file again, enter the character that was there before the import, usually @.
- Do not allow blank password
- You cannot enter a blank password in the New password field when you select the Change password processing in the User table.
- Prevent editing of form with document copies
- You will not be able to change a form that has previously been used in an order document copy. To see which form lines are linked to the order document, you can link the Order document formula table to the Order document table. The Order document formula table contains a reference to line number in the Form element table. If form elements for the form are altered after the order document has been created, information may be omitted when the copy is printed.
- Log for changing of access groups
- Two log files are created when you make changes in Table access, Column access,
Function access and Copy access in the
Access group table. One
log file with values before the change, and one with values after the change. The
files are placed in the My Documents directory and are given the
file name Vbsysnavn+Access group
name+sequence number+ B (before change) and A (after
change). Note:If you want a different default directory, you can enter it in the Registry under HKEY_CURRENT_USER\Software\VISMA\VISMA BUSINESS\CurrenVersion\Database\Access_log_path. A row is also created in the System change log table, where the following fields are updated:You can change the sequence number using the processing Change counters in the System information table.
- Line no.:
- Log type: Has log type 6 - Access control.
- Table no.: Has Table number 160 - Access group.
- Processing no.: Has a processing number between 70 and 73. 70 - Table access 71 - Column access 72 - Function access 73 - Copy access.
- Primary key:
- Name: Has the name of the access group.
- Inf.: Has the file location and the file name.
- New value: Has a new value with a sequence number.
- Citrix Universal Print driver fix
- If printouts on a local printer is incorrect during a Citrix session, you can select this option in order to swap Y coordinates on paper.
- Large pages in matrix printer
- If you have large sheets in the matrix printer, you must select this option. If you do not select this option, the Registry parameter "LOW_METRIC" will be used.
- Allow asynchronous database access
- You can also select Allow asynchronous database access per company. This is done in the dialog box under the Common processing field in the Company information table. The Allow asynchronous database access option in Company information will be greyed out, if you have selected the same option in the System information table. If you do not select this option, the Registry parameter "ASYNC_SELECT" will be used.
- AutoInvoice test
- Visma AutoInvoice has one portal for testing and one for operation. If you select this option you will be running against the test portal.
- Test content
- When selected, the invoice XML content is sent through validation
prior to sending to Visma.net AutoInvoice. If errors are found, these are written with details to the EDI error message table, and the
AutoInvoice status is
set to 5 - Validation failed.Note:Even though the invoice fails validation, it is still sent to Visma.net AutoInvoice.
- Dataflyt activated
- Do not use Outlook (classic) if SMTP is failing
- If SMTP sending fails when printing to Document delivery method 1 E-mail,
Outlook is not started as a fallback solution. This setting applies also to print
destination 6 - Send e-mail as well
as the processing Send e-mail in tables
Address, Associate, Document link, Participant. Note:If SMTP settings are not set at all, Outlook is used instead regardless of this setting.
- AutoCollect test
- When selected, data sent to Visma AutoCollect will be sent to their test portal.
- Use Internet Explorer as embedded browser
- Option will change the embedded browser from Microsoft Edge to Microsoft Internet Explorer for all users.
- Clear the cache for each VBS request
- When selected, the cache is cleared for each VBS
request.
This option can be used for those who have experienced issues where old data is retrieved in integrations, and a restart of the Visma Business Services host is needed in order to get the latest data (has e.g. been reported for currency rates in the Visma Document Center integration).
There can be a slight decrease in performance when using this option.
- Turn off parameterised SQL queries
- When selected, the earlier behaviour of SQL queries generated by Business NXT is restored, and in some cases, the database performance will be improved.
- Use a third-party email provider
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | System information processing | Integer |
| SQL name | SDPro | The database field name. |
| API identifier | systemInformationProcessing | The API identifier used in GraphQL. |
| Number | 8399 |
Visma Business application instance URI in VUD
The Visma Business application instance uniform resource identifier (URI) in Visma User Directory (VUD).
Used when connecting to VUD to authenticate the user logging into Visma Business.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VUD application instance URI | Text (260) |
| SQL name | VBusUri | The database field name. |
| API identifier | vismaBusinessApplicatonInstanceUriInVud | The API identifier used in GraphQL. |
| Number | 16335 |
Visma Business application type in VUD
The Visma Business application type in Visma User Directory (VUD).
Used when connecting to VUD to authenticate the user logging into Visma Business.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VUD application type | Text (260) |
| SQL name | VBusApTy | The database field name. |
| API identifier | vismaBusinessApplicatonTypeInVud | The API identifier used in GraphQL. |
| Number | 16334 |
Visma Certificate Authority Address
The certificate authority address for Visma User Directory (VUD).
This functionality is not supported in Business NXT.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | CertAuth | The database field name. |
| API identifier | vismaCertificateAuthorityAddress | The API identifier used in GraphQL. |
| Number | 16354 |
Visma Cloud Gateway address
This is the URL for Visma Cloud Gateway (previously Visma On Premises Gateway).
This functionality is not supported in Business NXT.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | OpgAddr | The database field name. |
| API identifier | onPremisesGatewayAddress | The API identifier used in GraphQL. |
| Number | 17618 |
Visma.net AutoPay data path
Location of log files from Visma.net AutoPay integration.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Data directory | Text (260) |
| SQL name | VNAPPath | The database field name. |
| API identifier | vismaNetAutopayDataPath | The API identifier used in GraphQL. |
| Number | 18398 |
VUD client modules Path
The path to the client modules folder.
This functionality is not supported in Business NXT.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Directory | Text (260) |
| SQL name | VudClMod | The database field name. |
| API identifier | vudClientModulesPath | The API identifier used in GraphQL. |
| Number | 16319 |
VUD management service address
The Visma User Directory (VUD) management service address.
This functionality is not supported in Business NXT.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | VudMgSvc | The database field name. |
| API identifier | vudManagementServiceAddress | The API identifier used in GraphQL. |
| Number | 16320 |
VUD single sign on address
The Visma User Directory (VUD) single sign on address.
This functionality is not supported in Business NXT.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | VudSSO | The database field name. |
| API identifier | vudSingleSignOnAddress | The API identifier used in GraphQL. |
| Number | 16318 |
VUD System User
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| SQL name | VudSysUsr | The database field name. |
| API identifier | vudSystemUser | The API identifier used in GraphQL. |
| Number | 16496 |
Web page file type
Which file type you want for a web page, memo file or other document.
If empty the default file type will be .doc.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 8 | Text (8) |
| SQL name | MemoExt | The database field name. |
| API identifier | webPageFileType | The API identifier used in GraphQL. |
| Number | 8757 |
Web-site path
The path to the files you want to visualise in the Web page viewer.
The path is used when you want to set a start-up directory to where the files are located.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Directory | Text (260) |
| SQL name | WebPath | The database field name. |
| API identifier | webSitePath | The API identifier used in GraphQL. |
| Number | 14896 |
Windows login
Visualises the Windows login option under the System information processing field.
When this option is selected, Business NXT will check on start up if there is a row in the User table with a corresponding user name and password to which the user has logged onto Windows. If this is the case, Business NXT will start up without requiring a user name and password.
The test is carried out after the program has analysed the command line parameters for user name (/U) and password (/P), which continue to have the highest priority. If none of them are found, the login window will appear.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | windowsLogin | The API identifier used in GraphQL. |
| Number | 10483 |
Windows Message Queue Address
Name of Windows message queue used for Visma.net integrations.
At start-up of the Visma Business Host for OD MessageQueue service, the Windows message queue name is automatically generated and stored in the this field. The corresponding queue is created under Computer Management > Services and Applications > Message Queuing > Private Queues.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | MsgQueue | The database field name. |
| API identifier | messageQueueNameAddress | The API identifier used in GraphQL. |
| Number | 17870 |
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |