Business NXT documentation

Home
System administration
This is where you find important information about configuring and monitoring Business NXT, for example about setting up user permissions and roles, and about the system logs.
Variables
Integer system variable
This table contains one row for each system-dependent integer variable.

System administration
This is where you find important information about configuring and monitoring Business NXT, for example about setting up user permissions and roles, and about the system logs.
- Access management
  You create access groups and manage access, based on access groups, from the Access management page.
- Users
  User permissions in Business NXT are managed using roles and access groups.
- Companies
  You manage companies in Business NXT Admin.
- Variables
  - Namespace
    This table is used to group variables that belong together, to avoid conflicts between variables from different sources.
  - Integer system variable
    This table contains one row for each system-dependent integer variable.
  - Decimal system variable
    This table contains one row for each system-dependent decimal variable.
  - Text system variable
    This table contains one row for each system-dependent string variable.
  - Integer company variable
    This table contains one row for each company-dependent integer variable.
  - Integer company variable processings
    The following processings are available from the Integer company variable table:
  - Decimal company variable
    This table contains one row for each company-dependent decimal variable.
  - Text company variable
    This table contains one row for each company-dependent string variable.
  - Free information 1
    The tables with free information can be used as extensions to other tables, using foreign keys.
  - Free information 2
    The tables with free information can be used as extensions to other tables, using foreign keys.
  - Free information 3
    The tables with free information can be used as extensions to other tables, using foreign keys.
- Task overview administration
- Approval task
- Email configuration
  You can set up the email functionality for the entire system or for individual companies.
- Webhooks
  Webhooks are used to send real-time data between web applications, based on specific events, instead of constant polling.
- Data Model Extension (DME)
  Data model extensions allow you to extend and enhance the capabilities of the core data model.
- AI Connect
  You can use different AI-supported finance skills in Business NXT using the GAiA assistant and the AI Connect MCP server.
- Logs
  In Business NXT, some information is logged automatically, while other data can be logged if needed.
- Integrations
  For some Visma.net services that are integrated with Business NXT, you can start processings and also see the status of operations in dedicated tables.
- General Data Protection Regulation (GDPR)
  The EU General Data Protection Regulation (GDPR) replaced the Data Protection Directive 95/46/EC and was designed to harmonise data privacy laws across Europe, to protect and empower all EU citizens' data privacy and to reshape the way organisations across the region approach data privacy. The enforcement date for all EU countries was 25th of May 2018. Norway, not being a member of the EU, transposed the EU regulations into its national law in accordance with the provisions of the GDPR.

Integer system variable

This table contains one row for each system-dependent integer variable.

Property	Value	Description
Database	System	This table is in the system (vbsys) database.
SQL name	IntSVar	The table name in the database.
API identifier	integerSystemVariable	The API identifier used in GraphQL.
Table no.	270	The table number in the data model.

The following fields exist in this table:

Namespace

Used for grouping of variables and avoiding name conflicts.

Refers to a row in the Namespace table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	GUID	Text (40)
Primary key	Yes	Namespace, Variable name
SQL name	NmSp	The database field name.
API identifier	namespace	The API identifier used in GraphQL.
Number	10673

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Namespace	Namespace	Namespace	Namespace

Value 1

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val1	The database field name.
API identifier	value1	The API identifier used in GraphQL.
Number	10675

Value 2

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val2	The database field name.
API identifier	value2	The API identifier used in GraphQL.
Number	10676

Value 3

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val3	The database field name.
API identifier	value3	The API identifier used in GraphQL.
Number	10677

Value 4

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val4	The database field name.
API identifier	value4	The API identifier used in GraphQL.
Number	10678

Value 5

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val5	The database field name.
API identifier	value5	The API identifier used in GraphQL.
Number	10679

Value 6

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val6	The database field name.
API identifier	value6	The API identifier used in GraphQL.
Number	10680

Value 7

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val7	The database field name.
API identifier	value7	The API identifier used in GraphQL.
Number	10681

Value 8

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val8	The database field name.
API identifier	value8	The API identifier used in GraphQL.
Number	10682

Value 9

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val9	The database field name.
API identifier	value9	The API identifier used in GraphQL.
Number	10683

Value 10

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val10	The database field name.
API identifier	value10	The API identifier used in GraphQL.
Number	10684

Value 11

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val11	The database field name.
API identifier	value11	The API identifier used in GraphQL.
Number	10685

Value 12

An integer value that can be used for calculations in formulas in reports and in calculated columns in other tables.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	Val12	The database field name.
API identifier	value12	The API identifier used in GraphQL.
Number	10686

Variable name

The name of the integer system variable.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Identifier	Text (40)
Primary key	Yes	Namespace, Variable name
SQL name	VarNm	The database field name.
API identifier	variableName	The API identifier used in GraphQL.
Number	10674

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.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

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.

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.