User

This table includes user information.

Note:
Only a user with System supervisor permissions can update this table.
PropertyValueDescription
DatabaseSystemThis table is in the system (vbsys) database.
SQL nameUsrThe table name in the database.
API identifieruserThe API identifier used in GraphQL.
Table no.12The table number in the data model.

The following fields exist in this table:

1 at a time

Only one active session is allowed for the user.

If multiple sessions are detected for the user after login, a warning is given and the user is asked if the other active session are to be stopped. If you click Yes you will be logged in and the other session will be cancelled. If you click No you will be logged in, but only the Active session table is available so you can stop the active session. If you manually stop the other session you will need to login again to get access to the other tables.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameOneSesThe database field name.
API identifieroneAtATimeThe API identifier used in GraphQL.
Number4874 

Access group no.

The access group the user belongs to.

You should organise users who are to have the same rights to edit entries and perform actions in the same access group.

On installation, a System supervisor user will be placed in access group 1.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccess group no.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameAccGrThe database field name.
API identifieraccessGroupNoThe API identifier used in GraphQL.
Number346 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Access groupAccessGroup
  • Access group no.

Aggreg. sum colour 1

The colour for total and break lines.

Total lines and break lines have by default gradually lighter blue colours for each level. You can override these colours.

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameBreakColThe database field name.
API identifieraggregationSumColor1The API identifier used in GraphQL.
Number8567 

Aggreg. sum colour 2

The colour for total and break lines.

Total lines and break lines have by default gradually lighter blue colours for each level. You can override these colours.

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameBrkCol2The database field name.
API identifieraggregationSumColor2The API identifier used in GraphQL.
Number8596 

Aggreg. sum colour 3

The colour for total and break lines.

Total lines and break lines have by default gradually lighter blue colours for each level. You can override these colours.

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameBrkCol3The database field name.
API identifieraggregationSumColor3The API identifier used in GraphQL.
Number8597 

Aggreg. sum colour 4+

The colour for total and break lines.

Total lines and break lines have by default gradually lighter blue colours for each level. You can override these colours.

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameBrkCol4The database field name.
API identifieraggregationSumColor4PlusThe API identifier used in GraphQL.
Number8598 

Alternating row colour

If set, the alternating row colour is used to highlight the active row on tables instead of the default colour.

If Alternating background colour on each other row option is selected in User pref. column, defined colour will be used as a background colour for every other row in the tables instead of the default colour.

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameAltRwColThe database field name.
API identifieralternatingRowColorThe API identifier used in GraphQL.
Number15371 

Alternative background colour

The alternative background colour that will be used for the layout where it is activated in the window preferences. The default background colour is dark gray.

Is normally activated with the Alternative background (F8) command (in the Layout group in the Design tab).

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameAltBkColThe database field name.
API identifieralternativeBackgroundColorThe API identifier used in GraphQL.
Number8603 

Appointment length

The default length of a new appointment for the user.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameAgrLenThe database field name.
API identifierappointmentLengthThe API identifier used in GraphQL.
Number4447 

AutoInvoice user API key

The user's Visma AutoInvoice user ID.

If the field holds content, a key icon will be displayed. While field content is hidden, it is possible to paste into, edit, or delete content.
Note:
Copying from the field is not possible.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainSecured GUIDText (80)
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameMavKeyThe database field name.
API identifierautoInvoiceUserApiKeyThe API identifier used in GraphQL.
Number16454 

Autosave interval

The number of minutes between automatic saving.

If you want the program to save the content of the layout at regular intervals, enter the number of minutes between each save in this field.

Using this feature you risk incomplete edits being made available to other concurrent users and sudden save pauses occurring. It is therefore recommended that you save edits in a logically related sequence.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameSaveIntThe database field name.
API identifierautosaveIntervalThe API identifier used in GraphQL.
Number4762 

Colour for design mode focus

The background colour for the active field when you are in Design mode.

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameMoveColThe database field name.
API identifiercolorForDesignModeFocusThe API identifier used in GraphQL.
Number8564 

Colour of active field

The background colour for the active field.

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameFieldColThe database field name.
API identifiercolorOfActiveFieldThe API identifier used in GraphQL.
Number10799 

Colour of search row

The colour of the Search row.

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameSeekColThe database field name.
API identifiercolorOfSearchRowThe API identifier used in GraphQL.
Number8565 

Company group no.

The company group user has access to.

On installation the System supervisor user is given access to company group 1.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCompany group no.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameFrmGrThe database field name.
API identifiercompanyGroupNoThe API identifier used in GraphQL.
Number348 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
Company groupCompanyGroup
  • Company group no.

Connect application

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameConnectAppThe database field name.
API identifierconnectApplicationThe API identifier used in GraphQL.
Number19170 

Days before following up

The number of days to pass between each time you follow up an appointment.

A follow-up dialog box appears when you save a quotation order with transaction type 1 - Sales, 2 - Hire or 6 - Purchase, and a quotation appointment is created in the Appointment table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDaysInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameFolDyThe database field name.
API identifierdaysBeforeFollowingUpThe API identifier used in GraphQL.
Number4483 

Default company no.

The default company for the user.

If the field is not filled in for a user, the company in an initial workspace layout will be used.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCompany no.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameStdFrmNoThe database field name.
API identifierdefaultCompanyNoThe API identifier used in GraphQL.
Number14802 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
CompanyDefaultCompany
  • Default company no.

E-mail address

The user's e-mail address.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainE-mail addressText (60)
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameMailAdThe database field name.
API identifieremailAddressThe API identifier used in GraphQL.
Number14807 

End working time

When the working time ends for an appointment.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameWkTmEndThe database field name.
API identifierendWorkingTimeThe API identifier used in GraphQL.
Number7370 

Inf.

Additional user information.

For example, you can enter the full name of the users here if you have used initials and abbreviations in the User name field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameInfThe database field name.
API identifierinformationThe API identifier used in GraphQL.
Number6604 

Language no.

The language for the user.

This value overrides the Language no. field in the Company information table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainLanguage no.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameLangNoThe database field name.
API identifierlanguageNoThe API identifier used in GraphQL.
Number15977 

Last syncron. date

The last synchronization date.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSyncDtThe database field name.
API identifierlastSyncronizationDateThe API identifier used in GraphQL.
Number7573 

Modules

Information about which modules the user has access to.

The flags are in addition to system preferences which form part of the system key and which apply regardless of user. The options are used in installations which are licensed with Users per module (not Concurrent users).

You can insert a check for the modules to which access is enabled through the system key and, if you have a licence for named users, you must insert checks for each user for the modules to which the person in question is to have access.

The following dependencies apply between the options:

  • EFT is deselected and greyed out unless Accounting is checked.
  • A user who has selected CRM extended does not need to select CRM. This means that the user will be screened from all functions that are not in the Order and Order line tables. Nor will they be able to create orders with customer numbers. This means that they can create an order with an employee number and register time/internal issue for this. To approve this time/internal issue the user must use the processings Split, Transfer to order or Finish.
A look-up opens the dialog box where you can see the following check boxes and options:
CRM
Outlook (classic) integration
CRM extended
EDI user
All other boxes in the "Module" dialog box will be cleared, and the user will always be logged off from the previous session if an EDI user is logged on. Counting will be performed in relation to the number of EDI users in the licence file.

Logistics

Import order
Invoice
Order and time recording
Purchase

Accounting

Import batches
Accounting
Customer and supplier ledger
External user
EFT

____

See ledger info.

Third party solutions

Doc. scanning/accounting
Doc. workflow
OCR interpreter

Visma Business Services

Named user
Server integration

Elevated privileges

Login as system
In order to know who did what in the system it is not recommended to use the user "system". Instead you should create a new user in the user table with this option set. In this way you can do all your changes as before, but it will be logged with the user name. Only one user by the time can be logged into Business NXT with system user rights, either by log on as the user "system" or a named user with this option set.
Note:
For some operations the System supervisor flag must be set. This is the same as for the user "system".
Note:
Starting with version 17.10, Login as system users do not need any organisational (company) roles to be able to login to Business NXT.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainModulesInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameAcFlThe database field name.
API identifiermodulesThe API identifier used in GraphQL.
Number8482 

Notify time

How far in advance notification is to be given of an appointment.

This value is the default value for an appointment. The value can be overridden on the appointment.

The value in this field can be in hours or minutes. You specify what is to apply in the Notify time unit field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameNtfTmThe database field name.
API identifiernotifyTimeThe API identifier used in GraphQL.
Number4201 

Notify time unit

The unit of time to apply to the Notify time field.

Possible values are 1 - Minutes or 2 - Hours.

This can be overridden in the Appointment table.

A look-up in this field gives you the following list of possible values:
1 - Minutes
2 - Hours
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainTime unitInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameNtfTmUnThe database field name.
API identifiernotifyTimeUnitThe API identifier used in GraphQL.
Number4202 

Notify transfer

Selects if notification about transfers will be given.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameMailTrfThe database field name.
API identifiernotifyTransferThe API identifier used in GraphQL.
Number4207 

Picture file name

A link to the picture file for the user.

Tip:
Double-clicking or pressing * in this box opens the picture. If the box is empty, a dialog box for selecting a picture file will open.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPicture file nameText (260)
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL namePictFNmThe database field name.
API identifierpictureFileNameThe API identifier used in GraphQL.
Number8558 

Printer group

The printer group to which the user is to be linked.

If you do not complete this field, the printer options saved in the Window and Workspace tables are used instead.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL namePrintGrThe database field name.
API identifierprinterGroupThe API identifier used in GraphQL.
Number7040 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
Printer groupPrinterGroup
  • Printer group

Program language no.

The language for each individual user.

The Program language no. field overrides the default language that is installed during installation under "INTL_DEFAULT" in registry.

When you log in to the program, a check will be performed to determine whether you have a value in the Program language no. field. If you do have a value in the Program language no. field, this language will be selected for the texts. If you do not have a value in the Program language no. field when you log in, the value in registry will be used. On the Home > Company group, the Texts list will reflect what is in registry or Program language no. In both cases, you can override the language number in this list.

A look-up in this field gives you the following list of possible values:
1 - Norwegian
2 - Danish
3 - Swedish
9 - Finnish
4 - English
5 - German
6 - Polish
7 - Lithuanian
10 - Russian
11 - Estonian
12 - Latvian
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProgram language no.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameTxtLangThe database field name.
API identifiertextLanguageNoThe API identifier used in GraphQL.
Number15881 

Sound

Use sound for notification of appointments.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameSoundThe database field name.
API identifiersoundThe API identifier used in GraphQL.
Number4203 

Start working time

When the working time starts for an appointment.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameWkTmStThe database field name.
API identifierstartWorkingTimeThe API identifier used in GraphQL.
Number7369 

Suppress dialog

If this is selected, a dialog box will not be displayed in connection with notification of an appointment. Instead you receive a message in the Status bar.

This applies if you have checked the Notify field in the Appointment table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameNtfDlgThe database field name.
API identifiersuppressDialogThe API identifier used in GraphQL.
Number4204 

System supervisor

The user will have rights as the system supervisor.

This includes access to edit entries and perform menu items/actions which are particularly risky or which require the highest level of security clearance, for example, access regulation for and overriding other users.

Access regulation requires VUD superusers role when VUD integration is enabled.
  • Without VUD enabled this user can do all access regulations.
  • With VUD enabled this user cannot assign modules or layout groups unless given the VUD superusers in VUD (since modules and layout groups are server roles).

On installation the System user is created. This user will have the system supervisor role. There must always be at least one user defined as the system supervisor.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameSupervThe database field name.
API identifiersystemSupervisorThe API identifier used in GraphQL.
Number345 

Test interval

How often you want to be notified of an appointment from the Appointment table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameTestIntThe database field name.
API identifiertestIntervalThe API identifier used in GraphQL.
Number4205 

Total sum colour

The colour for total and break lines.

Total lines and break lines have by default gradually lighter blue colours for each level. You can override these colours.

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainColourInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameTotColThe database field name.
API identifiertotalLineColorThe API identifier used in GraphQL.
Number8568 

Transfer days

This field is no longer in use. Be aware the field may be removed in later versions.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDaysInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameTrfRngThe database field name.
API identifiertransferDaysThe API identifier used in GraphQL.
Number6410 

Transfer interval

How often you want to synchronize changes with an external application.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameTrfIntThe database field name.
API identifiertransferIntervalThe API identifier used in GraphQL.
Number6409 

Transfer options

Options for synchronize changes with external applications

A look-up opens the dialog box where you can see the following check boxes and options:
Start external application on startup
Changes are transferred when the program starts. All changes to agreements and tasks are transferred from and to the external application to which you are linked.
Transfer from creation date
Changes on the basis of the Created date field in the Associate table will be transferred.

Transfer options

Never transfer
Changes from and to the external application will never be transferred, even if you have selected this for agreements and tasks or associates.
Always transfer
Changes from and to the external application will always be transferred. The transfers will then be performed when you select Processing > Write to external appl. or Processing > Read from external appl. or when you start the program.
Confirm transfer manually
A dialog box is displayed asking you whether you want to transfer the change. You must confirm with either Yes or No for each change that is transferred.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTransfer optionsInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameTrfPrefThe database field name.
API identifiertransferPreferencesThe API identifier used in GraphQL.
Number6408 

User name

The name of the user.

This is the name which the user must enter when logging on and which is used to refer to the user throughout the tables.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainUser nameText (24)
Primary keyYesUser name
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameNmThe database field name.
API identifieruserNameThe API identifier used in GraphQL.
Number343 

User pref.

Settings defining the behaviour of the user.

A look-up opens the dialog box where you can see the following check boxes and options:
Show credit control messages as dialog
Credit control status and error messages will be shown in a dialog box instead of in the in the status bar at the bottom of the screen.
Windows user
The user name from the PC will be used as the user in Business NXT.
No field pointer in design mode
The mouse pointer will not change when you switch to Design mode.
Warning when closing layout and layout not saved
You will receive a warning if you close the screen without saving following a design change.
Note:
The warning only appears when opening/hiding fields and when you press Ctrl+T (show form/table).
Payments for active company only
You cannot export data from other clients than the client from whom the export was started.
Focus always on search row
The cursor will always move to the column last visited when performing a lookup. Otherwise, the cursor will go to the first column in the lookup table. The search row will be shown when next performing a lookup.
Allow update on appointment processing approve disabled
Select this field to allow changes to the Approve disabled field in the appointment processing dialog box in the Appointment table.
Process only active payment (EFT system)
Only active payment rows for the company where Upload data or Download data was started from can be remitted.
Note:
This will not apply if you start the payment transfer from the Bank partner table.
Disable instant search
This option disables the instant search in fields.
View grid lines in table page elements
You decide that the check boxes for Grid lines between columns and Grid lines between rows in the dialog box of the Design > Table > Other preferences menu choice will be used in the screens instead of different background colours on the rows.
Note:
Grid lines are included in printouts regardless.
Alternating background colour on each other row
When selected, every other line in a table view will have the background color specified in the Alternating row colour column in the User table.
Do not display single sign on warning
When starting Reporting, a warning is displayed when VUD is not activated. This option will disable the warning.
Enable print preview of pick lists
This option will allow print preview of pick lists.
Note:
Preview of pick lists will execute the reservation handling.
Use personalized login in Visma Bizweb
This option will enable Credit check from Business NXT when using Visma Bizweb. The corresponding user account in Visma Bizweb must be enabled for credit checks. The same email address must be entered in the user table as in Visma Bizweb.
Do not show tooltips in context menus
The tool-tip will not appear on the context menus. You will not see the description of the menu item and the help information.
Use Outlook (classic) when sending e-mail from 'Send e-mail' button
When SMTP is configured the internal e-mail editor will be used by default. If the user has Outlook locally installed, they can use this option if they want to use Outlook as the editor instead.
Use 'From' e-mail address from user
When SMTP is configured and e-mail is sent from Send e-mail on the print menu (ad-hoc sending of e-mail), the From address will be fetched in this order:
  • From the E-mail template
  • From the E-mail company configuration table
  • From the E-mail system configuration table
If this parameter is enabled, then the From address will be fetched from the current users row in the Associate table.
Ask before closing Visma Business
This option will display a confirmation dialog before closing Business NXT.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainUser pref.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameUsrPrefThe database field name.
API identifieruserPreferencesThe API identifier used in GraphQL.
Number8563 

VUD static ID

The StaticId from VUD for the user.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainGUIDText (40)
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameVudStIdThe database field name.
API identifiervudStaticIdThe API identifier used in GraphQL.
Number16485 

Weekend appointments

Appointments at weekends.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameWEndAgrThe database field name.
API identifierweekendAppointmentsThe API identifier used in GraphQL.
Number4200 

Working hours per week

Working hours per week you spend on an appointment.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameWkHPrWThe database field name.
API identifierworkingHoursPerWeekThe API identifier used in GraphQL.
Number7371 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPvnThe database field name.
API identifierchangedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Changed by user

The name of the user that changed the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA 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. 

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA 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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrePvnThe database field name.
API identifiercreatedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA 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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA 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.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 5. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.