External configuration
This table contains fields that can be used for integration with other systems.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | ExtConf | The table name in the database. |
| API identifier | externalConfiguration | The API identifier used in GraphQL. |
| Table no. | 276 | The table number in the data model. |
The following fields exist in this table:
Column name 1
The SQL name of a field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 50 | Text (50) |
| SQL name | ColNm1 | The database field name. |
| API identifier | columnName1 | The API identifier used in GraphQL. |
| Number | 10821 |
Column name 2
The SQL name of a field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 50 | Text (50) |
| SQL name | ColNm2 | The database field name. |
| API identifier | columnName2 | The API identifier used in GraphQL. |
| Number | 10823 |
Config. flags
Settings defining the behaviour of the record.
- Inactive
- The record is inactive.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Config. flags | Integer |
| SQL name | CfFl | The database field name. |
| API identifier | configurationFlags | The API identifier used in GraphQL. |
| Number | 10814 |
Config. program no.
The program the record is intended for.
- 0 - Visma Business
- 1 - Visma CRM
- 2 - SuperOffice (not supported)
- Note:SuperOffice support was discontinued in version 5.0.0.
- 3 - Microsoft Outlook (classic)
- 4 - Microsoft Exchange
- 5 - Microsoft Word
- 6 - Microsoft Excel
- 7 - Crystal Reports
- 8 - Other
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Config. program no. | Integer |
| SQL name | PrgNo | The database field name. |
| API identifier | configurationProgramNo | The API identifier used in GraphQL. |
| Number | 10813 |
Description
The description of the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (260) |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 10841 |
Excl. from no.
The first value to excluded.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | ExFrNo | The database field name. |
| API identifier | excludeFromNo | The API identifier used in GraphQL. |
| Number | 10815 |
Excl. to no.
The last value to excluded.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | ExToNo | The database field name. |
| API identifier | excludeToNo | The API identifier used in GraphQL. |
| Number | 10816 |
Expression 1
The expression that is used by the external application, for example WHERE or GROUP BY.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 100 | Text (100) |
| SQL name | Exp1 | The database field name. |
| API identifier | expression1 | The API identifier used in GraphQL. |
| Number | 10825 |
Expression 2
The expression that is used by the external application, for example WHERE or GROUP BY.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 100 | Text (100) |
| SQL name | Exp2 | The database field name. |
| API identifier | expression2 | The API identifier used in GraphQL. |
| Number | 10826 |
Expression 3
The expression that is used by the external application, for example WHERE or GROUP BY.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 100 | Text (100) |
| SQL name | Exp3 | The database field name. |
| API identifier | expression3 | The API identifier used in GraphQL. |
| Number | 10827 |
Expression 4
The expression that is used by the external application, for example WHERE or GROUP BY.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 100 | Text (100) |
| SQL name | Exp4 | The database field name. |
| API identifier | expression4 | The API identifier used in GraphQL. |
| Number | 10828 |
Free 1
Additional numeric information about the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 10837 |
Free 2
Additional numeric information about the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 10838 |
Free 3
Additional numeric information about the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 10839 |
Free 4
Additional numeric information about the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 10840 |
Gr. 1
A group to which the record belongs.
External conf. group 1 texts for different languages can be
defined in the Text
table. These texts has text type 150.
Note:
If you double-click or press
* in this field, you can look up a External conf. group 1 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | External conf. group 1 | Integer |
| SQL name | Gr1 | The database field name. |
| API identifier | group1 | The API identifier used in GraphQL. |
| Number | 10833 |
Gr. 2
A group to which the record belongs.
External conf. group 2 texts for different languages can be
defined in the Text
table. These texts has text type 151.
Note:
If you double-click or press
* in this field, you can look up a External conf. group 2 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | External conf. group 2 | Integer |
| SQL name | Gr2 | The database field name. |
| API identifier | group2 | The API identifier used in GraphQL. |
| Number | 10834 |
Gr. 3
A group to which the record belongs.
External conf. group 3 texts for different languages can be
defined in the Text
table. These texts has text type 152.
Note:
If you double-click or press
* in this field, you can look up a External conf. group 3 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | External conf. group 3 | Integer |
| SQL name | Gr3 | The database field name. |
| API identifier | group3 | The API identifier used in GraphQL. |
| Number | 10835 |
Gr. 4
A group to which the record belongs.
External conf. group 4 texts for different languages can be
defined in the Text
table. These texts has text type 153.
Note:
If you double-click or press
* in this field, you can look up a External conf. group 4 in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | External conf. group 4 | Integer |
| SQL name | Gr4 | The database field name. |
| API identifier | group4 | The API identifier used in GraphQL. |
| Number | 10836 |
Incl. from no.
The first value to included.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | InFrNo | The database field name. |
| API identifier | includeFromNo | The API identifier used in GraphQL. |
| Number | 10817 |
Incl. to no.
The last value to included.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | InToNo | The database field name. |
| API identifier | includeToNo | The API identifier used in GraphQL. |
| Number | 10818 |
Message type
The message type.
Message type texts for different languages can be
defined in the Text
table. These texts has text type 149.
Note:
If you double-click or press
* in this field, you can look up a Message type in the Text
table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Message type | Integer |
| SQL name | MsgTp | The database field name. |
| API identifier | messageType | The API identifier used in GraphQL. |
| Number | 10809 |
Object name
The name for the record to be used by the external application.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 50 | Text (50) |
| SQL name | ObNm | The database field name. |
| API identifier | objectName | The API identifier used in GraphQL. |
| Number | 10810 |
Object no.
The record's reference.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | ObNo | The database field name. |
| API identifier | objectNo | The API identifier used in GraphQL. |
| Number | 10812 |
Object text
The text that will be used by the external application.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 50 | Text (50) |
| SQL name | ObTxt | The database field name. |
| API identifier | objectText | The API identifier used in GraphQL. |
| Number | 10811 |
Primary key
A unique number identifying the record.
Note:
If you press + in this
field, the next available number is suggested. Gaps in the number series
resulting from any deleted rows are not suggested. If you enter an
existing number you will receive an error message. The number cannot be
changed once it is entered.
| 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 | 10808 |
Separator 1
The separator that is used in the external application.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 1 | Text (1) |
| SQL name | Sep1 | The database field name. |
| API identifier | separator1 | The API identifier used in GraphQL. |
| Number | 10822 |
Separator 2
The separator that is used in the external application.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 1 | Text (1) |
| SQL name | Sep2 | The database field name. |
| API identifier | separator2 | The API identifier used in GraphQL. |
| Number | 10824 |
Table name 1
The SQL name of a table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 50 | Text (50) |
| SQL name | TbNm1 | The database field name. |
| API identifier | tableName1 | The API identifier used in GraphQL. |
| Number | 10819 |
Table name 2
The SQL name of a table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 50 | Text (50) |
| SQL name | TbNm2 | The database field name. |
| API identifier | tableName2 | The API identifier used in GraphQL. |
| Number | 10820 |
Text 1
The variable text that is used by the external application.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (260) |
| SQL name | Txt1 | The database field name. |
| API identifier | text1 | The API identifier used in GraphQL. |
| Number | 10829 |
Text 2
The variable text that is used by the external application.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (260) |
| SQL name | Txt2 | The database field name. |
| API identifier | text2 | The API identifier used in GraphQL. |
| Number | 10830 |
Text 3
The variable text that is used by the external application.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (260) |
| SQL name | Txt3 | The database field name. |
| API identifier | text3 | The API identifier used in GraphQL. |
| Number | 10831 |
Text 4
The variable text that is used by the external application.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (260) |
| SQL name | Txt4 | The database field name. |
| API identifier | text4 | The API identifier used in GraphQL. |
| Number | 10832 |
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. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |