Combination matrix
This table is used to define valid combinations of accounts and organisational units for combination groups.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | CombMat | The table name in the database. |
| API identifier | combinationMatrix | The API identifier used in GraphQL. |
| Table no. | 305 | The table number in the data model. |
The following fields exist in this table:
Account type
The Account type the combination is to be valid for.
- 1 - Customer
- 2 - Supplier
- 3 - General ledger account
- 4 - Capital asset
- 6 - Resource
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account type | 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 | AcCl | The database field name. |
| API identifier | accountType | The API identifier used in GraphQL. |
| Number | 11546 |
Combination group no.
The Combination group no..
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Combination group no., Line 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 | CombG | The database field name. |
| API identifier | combinationGroupNo | The API identifier used in GraphQL. |
| Number | 11544 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Combination group | CombinationGroup |
|
From account no.
The from account number that the combination applies to, depending on Account type during voucher registration.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account 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 | FrAcNo | The database field name. |
| API identifier | fromAccountNo | The API identifier used in GraphQL. |
| Number | 11547 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | FromCustomer |
| ||
| Associate | FromSupplier |
| ||
| General ledger account | FromGeneralLedgerAccount |
| ||
| Capital asset | FromCapitalAsset |
|
From employee no.
The from employee number that the combination applies to.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. 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 | FrEmpNo | The database field name. |
| API identifier | fromEmployeeNo | The API identifier used in GraphQL. |
| Number | 11573 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | FromEmployee |
|
From organisational unit 1
The from organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | FrR1 | The database field name. |
| API identifier | fromOrgUnit1 | The API identifier used in GraphQL. |
| Number | 11549 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | FromOrgUnit1 |
|
From organisational unit 2
The from organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | FrR2 | The database field name. |
| API identifier | fromOrgUnit2 | The API identifier used in GraphQL. |
| Number | 11551 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | FromOrgUnit2 |
|
From organisational unit 3
The from organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | FrR3 | The database field name. |
| API identifier | fromOrgUnit3 | The API identifier used in GraphQL. |
| Number | 11553 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | FromOrgUnit3 |
|
From organisational unit 4
The from organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | FrR4 | The database field name. |
| API identifier | fromOrgUnit4 | The API identifier used in GraphQL. |
| Number | 11555 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | FromOrgUnit4 |
|
From organisational unit 5
The from organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | FrR5 | The database field name. |
| API identifier | fromOrgUnit5 | The API identifier used in GraphQL. |
| Number | 11557 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | FromOrgUnit5 |
|
From organisational unit 6
The from organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | FrR6 | The database field name. |
| API identifier | fromOrgUnit6 | The API identifier used in GraphQL. |
| Number | 11559 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | FromOrgUnit6 |
|
From organisational unit 7
The from organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | 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 | FrR7 | The database field name. |
| API identifier | fromOrgUnit7 | The API identifier used in GraphQL. |
| Number | 11561 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | FromOrgUnit7 |
|
From organisational unit 8
The from organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | FrR8 | The database field name. |
| API identifier | fromOrgUnit8 | The API identifier used in GraphQL. |
| Number | 11563 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | FromOrgUnit8 |
|
From organisational unit 9
The from organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | FrR9 | The database field name. |
| API identifier | fromOrgUnit9 | The API identifier used in GraphQL. |
| Number | 11565 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | FromOrgUnit9 |
|
From organisational unit 10
The from organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | FrR10 | The database field name. |
| API identifier | fromOrgUnit10 | The API identifier used in GraphQL. |
| Number | 11567 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | FromOrgUnit10 |
|
From organisational unit 11
The from organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | FrR11 | The database field name. |
| API identifier | fromOrgUnit11 | The API identifier used in GraphQL. |
| Number | 11569 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | FromOrgUnit11 |
|
From organisational unit 12
The from organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | FrR12 | The database field name. |
| API identifier | fromOrgUnit12 | The API identifier used in GraphQL. |
| Number | 11571 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | FromOrgUnit12 |
|
From product no.
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product no. | 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 | FrProdNo | The database field name. |
| API identifier | fromProductNo | The API identifier used in GraphQL. |
| Number | 11575 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | FromProduct |
|
From resource no.
The from resource number that the combination applies to during appointment and resources registration.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Res. 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 | FrResNo | The database field name. |
| API identifier | fromResourceNo | The API identifier used in GraphQL. |
| Number | 12791 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Resource | FromResource |
|
Line no.
Each line in the table is given a consecutive number in the order in which they are 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 | Combination group no., Line 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 | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 11545 |
Sort seq. no.
The order of the lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sort seq. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Srt | The database field name. |
| API identifier | sortSequenceNo | The API identifier used in GraphQL. |
| Number | 11580 |
To account no.
The to account number that the combination applies to, depending on Account type during voucher registration.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account 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 | ToAcNo | The database field name. |
| API identifier | toAccountNo | The API identifier used in GraphQL. |
| Number | 11548 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | ToCustomer |
| ||
| Associate | ToSupplier |
| ||
| General ledger account | ToGeneralLedgerAccount |
| ||
| Capital asset | ToCapitalAsset |
|
To employee no.
The to employee number that the combination applies to.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. 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 | ToEmpNo | The database field name. |
| API identifier | toEmployeeNo | The API identifier used in GraphQL. |
| Number | 11574 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | ToEmployee |
|
To organisational unit 1
The to organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | ToR1 | The database field name. |
| API identifier | toOrgUnit1 | The API identifier used in GraphQL. |
| Number | 11550 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | ToOrgUnit1 |
|
To organisational unit 2
The to organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | ToR2 | The database field name. |
| API identifier | toOrgUnit2 | The API identifier used in GraphQL. |
| Number | 11552 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | ToOrgUnit2 |
|
To organisational unit 3
The to organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | ToR3 | The database field name. |
| API identifier | toOrgUnit3 | The API identifier used in GraphQL. |
| Number | 11554 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | ToOrgUnit3 |
|
To organisational unit 4
The to organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | ToR4 | The database field name. |
| API identifier | toOrgUnit4 | The API identifier used in GraphQL. |
| Number | 11556 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | ToOrgUnit4 |
|
To organisational unit 5
The to organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | ToR5 | The database field name. |
| API identifier | toOrgUnit5 | The API identifier used in GraphQL. |
| Number | 11558 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | ToOrgUnit5 |
|
To organisational unit 6
The to organisational unit allowed by the combination.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit 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 | ToR6 | The database field name. |
| API identifier | toOrgUnit6 | The API identifier used in GraphQL. |
| Number | 11560 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | ToOrgUnit6 |
|
To organisational unit 7
The to organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | 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 | ToR7 | The database field name. |
| API identifier | toOrgUnit7 | The API identifier used in GraphQL. |
| Number | 11562 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | ToOrgUnit7 |
|
To organisational unit 8
The to organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | ToR8 | The database field name. |
| API identifier | toOrgUnit8 | The API identifier used in GraphQL. |
| Number | 11564 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | ToOrgUnit8 |
|
To organisational unit 9
The to organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | ToR9 | The database field name. |
| API identifier | toOrgUnit9 | The API identifier used in GraphQL. |
| Number | 11566 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | ToOrgUnit9 |
|
To organisational unit 10
The to organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | ToR10 | The database field name. |
| API identifier | toOrgUnit10 | The API identifier used in GraphQL. |
| Number | 11568 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | ToOrgUnit10 |
|
To organisational unit 11
The to organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | ToR11 | The database field name. |
| API identifier | toOrgUnit11 | The API identifier used in GraphQL. |
| Number | 11570 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | ToOrgUnit11 |
|
To organisational unit 12
The to organisational unit allowed by the combination.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| 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 | ToR12 | The database field name. |
| API identifier | toOrgUnit12 | The API identifier used in GraphQL. |
| Number | 11572 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | ToOrgUnit12 |
|
To product no.
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product no. | 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 | ToProdNo | The database field name. |
| API identifier | toProductNo | The API identifier used in GraphQL. |
| Number | 11576 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | ToProduct |
|
To resource no.
The to resource number that the combination applies to during appointments and resources registration.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Res. 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 | ToResNo | The database field name. |
| API identifier | toResourceNo | The API identifier used in GraphQL. |
| Number | 12792 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Resource | ToResource |
|
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. |