Company
This table contains one row for each company database.
See also: Companies
| Property | Value | Description |
|---|---|---|
| Database | System | This table is in the system (vbsys) database. |
| SQL name | Frm | The table name in the database. |
| API identifier | company | The API identifier used in GraphQL. |
| Table no. | 13 | The table number in the data model. |
The following fields exist in this table:
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.
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.
| 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 | 20879 |
Company no.
A unique number identifying the company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Company no. | Integer |
| Primary key | Yes | Company no. |
| 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 | FrmNo | The database field name. |
| API identifier | companyNo | The API identifier used in GraphQL. |
| Number | 356 |
Company processing
Settings defining the behaviour of the company.
Used for example by some integrations.
- Exempt from payment suggestions
- Payment suggestions will not be created for the company by external EFT systems.
- Use payment access
- The Payments check box in the Limitation processing
field in the User access
table will determine who can run EFT systems. By selecting this check box you can
define the access to run EFT systems per user per company.
If this check box is not selected the Function access processing in the Access group table will determine who can run EFT systems.
- Payment suggestions only for active company
- You cannot create payments suggestions for other companies than the active company.
- Payment suggestion only for selected payment
- You can only create payment the selected payment records when the Upload data processing in the Payment table is run.
- Transfer automatic deductions together with payments
- Used by some EFT systems. Will then also check whether there are any autogiro/agreement giro lines which are to be transferred with the payments.
- Use Document Center 3.x
- This check box must be selected if you have Visma Document Center version 3.x.
The Scan doc. no. field will be used to identify attached documents. If you are using Visma Document Center version 5.x the Visma ID field will be used to identify attached documents.
- Invoice company information has changed
- For internal use only, do not change.
- Master data synchronization enabled
- Selected for companies that have the Master Data Management integration enabled.See also: Master Data Management
- Process accounting documents automatically
- When selected, the Process document processing will be run automatically when documents are added to Accounting document table
by Visma.net integrations.
This applies to Document type = 1 - Invoice and 2 - Expense claim.
Document type = 3 - Payment, 4 - Reminder, 5 - Receipt and 6 - Other can not be automatically processed.
See also: Process document
- Import currency rates from Visma.net AutoPay
- Selected for companies that shall have automatically update of
currency exchange rates from Visma.net AutoPay.Note:Integration with Visma.net AutoPay must be activated for at least one of the companies, for which the import of currency rates are selected.Note:It is mandatory to have a working Visma Business Host for OD MessageQueue integration, for the automatically import to take place.
- Open Visma.net AutoPay in new window after payment
- Selected for companies that will show the approval page in Visma.net AutoPay after running of the Upload data processing for outgoing payments.
- Dataflyt activated
- Upload payment suggestions automatically
- When selected, a created payment suggestion will automatically be transferred to the connected EFT system, without any need of running the Upload data processing.
- Do not open Visma.net AutoReport in new window after reporting
- When selected, user will not be forwarded anymore to a web browser to continue with VAT or self employed reporting via Visma.net AutoReport.
- Visma.net Approval enabled
- When enabled, allows sending requests to Visma.net Approval.
- Debt collection agreement exists
- The option will be automatically checked when the processing
Enable AutoCollect is executed from the Debt collection agreement
table.Note:The option is checked even though the enabling of the debt collection agreement might not have been accepted by Visma AutoCollect.
- Do not create missing accounting and VAT periods automatically from Visma.net AutoPay
- Decides if rows shall be automatically created in the Accounting period, VAT period and Statistics period tables when importing the first payment with a date within a new year. The parameter is by default set to "OFF".
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Company processing | 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 | FrmPro | The database field name. |
| API identifier | companyProcessing | The API identifier used in GraphQL. |
| Number | 15470 |
Country ISO code
The international numeric ISO code corresponding to the selected country number.
Cannot be manually edited by the user.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | ISO code | Text (3) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CtryISO | The database field name. |
| API identifier | countryIsoCode | The API identifier used in GraphQL. |
| Number | 18962 |
Country no.
A unique number identifying the country which is to be regarded as domestic or default for the company.
Cannot be manually edited by the user.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Country no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 17616 |
Demo company in Visma.net
Whether the company was created as a demo company in Visma.net Admin.
Cannot be manually edited by the user.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DemoVNet | The database field name. |
| API identifier | demoCompanyInVismaNet | The API identifier used in GraphQL. |
| Number | 19535 |
Integration status
Parameters set by Master Data Management triggers showing the integration status of a company.
SyncEngine will not process the company if no flag is set.
- Master Data Management process is pending
- Master Data Management process in progress
- Master Data Management restore of Business in progress
- Master Data Management restore of Contact in progress
- Master Data Management restore of General Ledger Account in progress
- Master Data Management restore of Cost Unit Type in progress
- Master Data Management restore of Cost Unit in progress
- Master Data Management restore of Tax in progress
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Integration status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IntStat | The database field name. |
| API identifier | integrationStatus | The API identifier used in GraphQL. |
| Number | 19087 |
Name
The name of the company.
You must type the Name accurately, just as you gave it to your Visma Partner, in order for the licence to be valid for the company (if you do not have the client version of the program).
Information about the company, in both the Company table and the Company information table can be printed on forms using the @Company macro.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| 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 | Nm | The database field name. |
| API identifier | name | The API identifier used in GraphQL. |
| Number | 357 |
Organisation no.
The company’s organisation number.
Cannot be manually edited by the user.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BsNo | The database field name. |
| API identifier | companyBusinessNo | The API identifier used in GraphQL. |
| Number | 17617 |
Sort
Custom value for sorting of companies.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | 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 | Srt | The database field name. |
| API identifier | sorting1 | The API identifier used in GraphQL. |
| Number | 10517 |
Sort 2
Custom value for sorting of companies.
This field can e.g. be used for sorting of companies in custom layouts.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | 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 | Srt2 | The database field name. |
| API identifier | sorting2 | The API identifier used in GraphQL. |
| Number | 16325 |
Template company
The company is used as a template company.
This company's database can be used as template when adding a new company in Company management.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | 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 | TplComp | The database field name. |
| API identifier | templateCompany | The API identifier used in GraphQL. |
| Number | 18961 |
Visma.net company ID
Identifier for the company in Visma.net.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VNetCId | The database field name. |
| API identifier | vismaNetCompanyId | The API identifier used in GraphQL. |
| Number | 17971 |
VUD static ID
The StaticId from VUD for the company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | GUID | Text (40) |
| 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 | VudStId | The database field name. |
| API identifier | vudStaticId | The API identifier used in GraphQL. |
| Number | 16486 |
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. |