Organisational unit 5

The Organisational unit 5 table includes specific information about this unit.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL nameR5The table name in the database.
API identifierorgUnit5The API identifier used in GraphQL.
Table no.40The table number in the data model.

The following fields exist in this table:

Acc. PL

The balances in the profit accounts are not reset at the beginning of the year but are carried forward to the new year in the same way as balance sheet totals.

If not selected, an organisational unit follows the financial year.

This would typically be used for projects which are not completed at the end of the year.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameAccResThe database field name.
API identifieraccumulateProfitAndLossThe API identifier used in GraphQL.
Number765 

Account set

Used together with the VAT and accounting group field to get the correct VAT and accounting information on orders. The VAT and accounting group and the Account set fields in the Order line table define the tax processing.

Account set texts for different languages can be defined in the Text table. These texts has text type 18.
Note:
If you double-click or press * in this field, you can look up a Account set in the Text table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount setInteger
SQL nameAcSetThe database field name.
API identifieraccountSetThe API identifier used in GraphQL.
Number15359 

Actual end date

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
SQL nameREndDtThe database field name.
API identifieractualEndDateThe API identifier used in GraphQL.
Number778 

Actual start date

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
SQL nameRStDtThe database field name.
API identifieractualStartDateThe API identifier used in GraphQL.
Number777 

Address line 1

The address of the organisational unit.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
SQL nameAd1The database field name.
API identifieraddressLine1The API identifier used in GraphQL.
Number759 

Address line 2

The address of the organisational unit.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
SQL nameAd2The database field name.
API identifieraddressLine2The API identifier used in GraphQL.
Number760 

Address line 3

The address of the organisational unit.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
SQL nameAd3The database field name.
API identifieraddressLine3The API identifier used in GraphQL.
Number3804 

Address line 4

The address of the organisational unit.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
SQL nameAd4The database field name.
API identifieraddressLine4The API identifier used in GraphQL.
Number3805 

Amount 1

Additional numeric information about the organisational unit.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameAm1The database field name.
API identifieramount1The API identifier used in GraphQL.
Number9371 

Amount 2

Additional numeric information about the organisational unit.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameAm2The database field name.
API identifieramount2The API identifier used in GraphQL.
Number9372 

Amount 3

Additional numeric information about the organisational unit.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameAm3The database field name.
API identifieramount3The API identifier used in GraphQL.
Number9373 

Amount 4

Additional numeric information about the organisational unit.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameAm4The database field name.
API identifieramount4The API identifier used in GraphQL.
Number9374 

Associate no. 1

Optional field for associate references.

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.
DomainAssociate no.Integer
SQL nameActNo1The database field name.
API identifierassociateNo1The API identifier used in GraphQL.
Number9375 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateAssociate1
  • Associate no. 1

Associate no. 2

Optional field for associate references.

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.
DomainAssociate no.Integer
SQL nameActNo2The database field name.
API identifierassociateNo2The API identifier used in GraphQL.
Number9376 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateAssociate2
  • Associate no. 2

Associate no. 3

Optional field for associate references.

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.
DomainAssociate no.Integer
SQL nameActNo3The database field name.
API identifierassociateNo3The API identifier used in GraphQL.
Number9377 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateAssociate3
  • Associate no. 3

Associate no. 4

Optional field for associate references.

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.
DomainAssociate no.Integer
SQL nameActNo4The database field name.
API identifierassociateNo4The API identifier used in GraphQL.
Number9378 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateAssociate4
  • Associate no. 4

Balance processing

Settings defining the behaviour of creating general ledger balances.

A look-up opens the dialog box where you can see the following check boxes and options:
Create all balance periods
One record per month is generated in the General ledger balance table when you are running the Create acc balances for all periods processing in the Accounting period table.

If the check box is not selected then only one record is created for the whole year.

Note:
You need to select the Create all balance periods check box in the Balance processing field in the General ledger account table as well. Otherwise the settings in the organisational unit table will not be taken into consideration when balances are created.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBalance processingInteger
SQL nameBalProcThe database field name.
API identifierbalanceProcessingThe API identifier used in GraphQL.
Number14381 

Contact

The contact for the organisational unit.

If the customer no. and/or supplier no. field has been completed for the organisational unit, a contact person will be suggested based on these fields. You can manually override the contact person.

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.
DomainAssociate no.Integer
SQL nameLiaActNoThe database field name.
API identifiercontactThe API identifier used in GraphQL.
Number10995 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateContact
  • Contact

Country no.

You can link the organisational unit to a country.

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.
DomainCountry no.Integer
SQL nameCtryThe database field name.
API identifiercountryNoThe API identifier used in GraphQL.
Number10570 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
CountryCountry
  • Country no.

Currency no.

The currency which will be used in the voucher lines.

The currency number will be suggested in the voucher lines if the field is not already completed.

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.
DomainCurrency no.Integer
SQL nameCurThe database field name.
API identifiercurrencyNoThe API identifier used in GraphQL.
Number14331 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency
  • Currency no.

Currency no. 2

The currency 2 which will be used in the voucher lines.

The currency number will be suggested in the voucher lines if the field is not already completed.

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.
DomainCurrency no.Integer
SQL nameCur2The database field name.
API identifiercurrencyNo2The API identifier used in GraphQL.
Number14332 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency2
  • Currency no. 2

Cust. no.

You can associate a customer with the organisational unit.

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.
DomainCust. no.Integer
SQL nameCustNoThe database field name.
API identifiercustomerNoThe API identifier used in GraphQL.
Number773 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateCustomer
  • Cust. no.

Date 1

Optional field for additional dates.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameDt1The database field name.
API identifierdate1The API identifier used in GraphQL.
Number9379 

Date 2

Optional field for additional dates.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameDt2The database field name.
API identifierdate2The API identifier used in GraphQL.
Number9380 

Date 3

Optional field for additional dates.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameDt3The database field name.
API identifierdate3The API identifier used in GraphQL.
Number9381 

Date 4

Optional field for additional dates.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameDt4The database field name.
API identifierdate4The API identifier used in GraphQL.
Number9382 

E-mail address

The e-mail address for the organisational unit.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainE-mail addressText (60)
SQL nameMailAdThe database field name.
API identifieremailAddressThe API identifier used in GraphQL.
Number7979 

Flow group

The organisation unit's predefined flow group.

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
SQL nameFlGrThe database field name.
API identifierflowGroupThe API identifier used in GraphQL.
Number19677 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
Flow groupFlowGroup
  • Flow group

Gr. 1

A group to which the organisational unit belongs.

Organisational unit grouping 1 texts for different languages can be defined in the Text table. These texts has text type 36.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 1 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 1Integer
SQL nameGrThe database field name.
API identifiergroup1The API identifier used in GraphQL.
Number4291 

Gr. 2

A group to which the organisational unit belongs.

Organisational unit grouping 2 texts for different languages can be defined in the Text table. These texts has text type 37.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 2 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 2Integer
SQL nameGr2The database field name.
API identifiergroup2The API identifier used in GraphQL.
Number4292 

Gr. 3

A group to which the organisational unit belongs.

Organisational unit grouping 3 texts for different languages can be defined in the Text table. These texts has text type 38.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 3 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 3Integer
SQL nameGr3The database field name.
API identifiergroup3The API identifier used in GraphQL.
Number4293 

Gr. 4

A group to which the organisational unit belongs.

Organisational unit grouping 4 texts for different languages can be defined in the Text table. These texts has text type 39.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 4 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 4Integer
SQL nameGr4The database field name.
API identifiergroup4The API identifier used in GraphQL.
Number4294 

Gr. 5

A group to which the organisational unit belongs.

Organisational unit grouping 5 texts for different languages can be defined in the Text table. These texts has text type 40.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 5 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 5Integer
SQL nameGr5The database field name.
API identifiergroup5The API identifier used in GraphQL.
Number4295 

Gr. 6

A group to which the organisational unit belongs.

Organisational unit grouping 6 texts for different languages can be defined in the Text table. These texts has text type 41.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 6 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 6Integer
SQL nameGr6The database field name.
API identifiergroup6The API identifier used in GraphQL.
Number4296 

Gr. 7

A group to which the organisational unit belongs.

Organisational unit grouping 7 texts for different languages can be defined in the Text table. These texts has text type 92.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 7 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 7Integer
SQL nameGr7The database field name.
API identifiergroup7The API identifier used in GraphQL.
Number6037 

Gr. 8

A group to which the organisational unit belongs.

Organisational unit grouping 8 texts for different languages can be defined in the Text table. These texts has text type 93.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 8 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 8Integer
SQL nameGr8The database field name.
API identifiergroup8The API identifier used in GraphQL.
Number6038 

Gr. 9

A group to which the organisational unit belongs.

Organisational unit grouping 9 texts for different languages can be defined in the Text table. These texts has text type 94.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 9 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 9Integer
SQL nameGr9The database field name.
API identifiergroup9The API identifier used in GraphQL.
Number6039 

Gr. 10

A group to which the organisational unit belongs.

Organisational unit grouping 10 texts for different languages can be defined in the Text table. These texts has text type 95.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 10 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 10Integer
SQL nameGr10The database field name.
API identifiergroup10The API identifier used in GraphQL.
Number6040 

Gr. 11

A group to which the organisational unit belongs.

Organisational unit grouping 11 texts for different languages can be defined in the Text table. These texts has text type 96.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 11 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 11Integer
SQL nameGr11The database field name.
API identifiergroup11The API identifier used in GraphQL.
Number6041 

Gr. 12

A group to which the organisational unit belongs.

Organisational unit grouping 12 texts for different languages can be defined in the Text table. These texts has text type 97.
Note:
If you double-click or press * in this field, you can look up a Organisational unit grouping 12 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit grouping 12Integer
SQL nameGr12The database field name.
API identifiergroup12The API identifier used in GraphQL.
Number6042 

Inf. 1

Additional organisational unit information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInfThe database field name.
API identifierinformation1The API identifier used in GraphQL.
Number763 

Inf. 2

Additional organisational unit information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf2The database field name.
API identifierinformation2The API identifier used in GraphQL.
Number3507 

Inf. 3

Additional organisational unit information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf3The database field name.
API identifierinformation3The API identifier used in GraphQL.
Number3508 

Inf. 4

Additional organisational unit information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf4The database field name.
API identifierinformation4The API identifier used in GraphQL.
Number3509 

Inf. 5

Additional organisational unit information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf5The database field name.
API identifierinformation5The API identifier used in GraphQL.
Number3510 

Inf. 6

Additional organisational unit information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf6The database field name.
API identifierinformation6The API identifier used in GraphQL.
Number3511 

Inf. 7

Additional organisational unit information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf7The database field name.
API identifierinformation7The API identifier used in GraphQL.
Number6081 

Inf. 8

Additional organisational unit information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf8The database field name.
API identifierinformation8The API identifier used in GraphQL.
Number6082 

Main unit

The parent organisational unit, if the organisational units are arranged in a hierarchy.

The hierarchy can be used in reports for organisational units. You can group on main units and add summary lines for the main units.

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.

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.
DomainOrganisational unit no.Integer
SQL nameMainR5The database field name.
API identifiermainUnitThe API identifier used in GraphQL.
Number771 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Main unit

Memo file name

The file name for the Memo attached to the organisational unit.

On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.

Double-click or press * to open the Select file dialog box to manually select a memo file.

Note:
It is important that you save the file on a server and in a folder that is available to all users, otherwise users who try to open the memo will receive an error message.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMemo file nameText (260)
SQL nameNoteNmThe database field name.
API identifiermemoFileNameThe API identifier used in GraphQL.
Number4243 

Memo no.

Link to the memo for the entry.

The actual memo is stored in the Memo table.

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.
DomainMemo no.Integer
SQL nameMemoNoThe database field name.
API identifiermemoNoThe API identifier used in GraphQL.
Number19224 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
MemoMemo
  • Memo no.

Name

The name of the organisational unit.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainString of length 80Text (80)
SQL nameNmThe database field name.
API identifiernameThe API identifier used in GraphQL.
Number758 

Org. unit processing

Settings defining the behaviour of the organisational unit.

A look-up opens the dialog box where you can see the following check boxes and options:
Suspended
The organisational unit cannot be used in any tables containing organisational units. Any entry of the organisational unit will be rejected and a message that it is suspended will be displayed.

When updating vouchers, an error code is attached to the transactions and the updated voucher line if the organisational unit was suspended after the voucher was entered (or ceased to exist).

You can still obtain reports for transactions that have already been entered.
Responsible approval
If an employee works in several departments, only the project manager can approve his or her hours. You must also enter the project manager in the Responsible field, so that the project manager can run the Approve Time Schedule processing in the Resource table.

This field is used in combination with the Case organisational units field in the Company information table.

No access to delete
You will not be able to delete the organisational unit, even if there are no transactions linked to it.
This field is intended for use when another program has imported the data and you want to prevent the row being deleted by mistake.
Note:
There are no restrictions on who can select or clear this field.
Exclude from external system
Exclude from Visma Mobile
Exclude from Visma On Demand
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrg. unit processingInteger
SQL nameSuspThe database field name.
API identifierorgUnitProcessingThe API identifier used in GraphQL.
Number2457 

Org. unit template

The template organisational unit. If you enter an organisational unit number in the field, values are suggested from this template organisational unit. Already entered values are not overwritten.

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.

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.
DomainOrganisational unit no.Integer
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierorgUnitTemplateThe API identifier used in GraphQL.
Number8754 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnitTemplate
  • Org. unit template

Organisational unit 1

A organisational unit which is linked to this organisational unit.

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.

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.
DomainOrganisational unit no.Integer
SQL nameR1The database field name.
API identifierorgUnit1The API identifier used in GraphQL.
Number767 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

Organisational unit 2

A organisational unit which is linked to this organisational unit.

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.

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.
DomainOrganisational unit no.Integer
SQL nameR2The database field name.
API identifierorgUnit2The API identifier used in GraphQL.
Number768 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

Organisational unit 3

A organisational unit which is linked to this organisational unit.

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.

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.
DomainOrganisational unit no.Integer
SQL nameR3The database field name.
API identifierorgUnit3The API identifier used in GraphQL.
Number769 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

Organisational unit 4

A organisational unit which is linked to this organisational unit.

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.

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.
DomainOrganisational unit no.Integer
SQL nameR4The database field name.
API identifierorgUnit4The API identifier used in GraphQL.
Number770 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5 no.

A unique number identifying the organisational unit.

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.

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.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisational unit no.Integer
Primary keyYesOrganisational unit 5 no.
SQL nameRNoThe database field name.
API identifierorgUnit5NoThe API identifier used in GraphQL.
Number757 

Organisational unit 6

A organisational unit which is linked to this organisational unit.

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.

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.
DomainOrganisational unit no.Integer
SQL nameR6The database field name.
API identifierorgUnit6The API identifier used in GraphQL.
Number772 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

Organisational unit 7

A organisational unit which is linked to this organisational unit.

The field appear with the name assigned to it in the Company information table.

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.
DomainLong alphanumeric organisational unit no.Text (40)
SQL nameR7The database field name.
API identifierorgUnit7The API identifier used in GraphQL.
Number9462 
Table 19. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

Organisational unit 8

A organisational unit which is linked to this organisational unit.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR8The database field name.
API identifierorgUnit8The API identifier used in GraphQL.
Number9463 
Table 20. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

Organisational unit 9

A organisational unit which is linked to this organisational unit.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR9The database field name.
API identifierorgUnit9The API identifier used in GraphQL.
Number9464 
Table 21. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

Organisational unit 10

A organisational unit which is linked to this organisational unit.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR10The database field name.
API identifierorgUnit10The API identifier used in GraphQL.
Number9465 
Table 22. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

Organisational unit 11

A organisational unit which is linked to this organisational unit.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR11The database field name.
API identifierorgUnit11The API identifier used in GraphQL.
Number9466 
Table 23. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12

A organisational unit which is linked to this organisational unit.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR12The database field name.
API identifierorgUnit12The API identifier used in GraphQL.
Number9467 
Table 24. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Picture file name

A link to the picture file for the organisational unit.

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)
SQL namePictFNmThe database field name.
API identifierpictureFileNameThe API identifier used in GraphQL.
Number8556 

Planned end date

Optional field for additional dates.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
SQL nameEEndDtThe database field name.
API identifierplannedEndDateThe API identifier used in GraphQL.
Number776 

Planned start date

Optional field for additional dates.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
SQL nameEStDtThe database field name.
API identifierplannedStartDateThe API identifier used in GraphQL.
Number775 

Post code

The post code of the organisational unit.

If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.

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.
DomainPost codeText (40)
SQL namePNoThe database field name.
API identifierpostCodeThe API identifier used in GraphQL.
Number3806 
Table 25. Table relations
To tablePurposeFrom columnsTo columnsComments
Postal addressPostalAddress
  • Post code

Postal area

The postal area of the organisational unit.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
SQL namePAreaThe database field name.
API identifierpostalAreaThe API identifier used in GraphQL.
Number761 

Principal

The principal of the organisational unit.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
SQL namePrinThe database field name.
API identifierprincipalThe API identifier used in GraphQL.
Number762 

Responsible

The employee who is the responsible for the organisational unit.

The Empl. no. is a unique number identifying one specific Employee.

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.
DomainEmpl. no.Integer
SQL nameRspThe database field name.
API identifierofficialThe API identifier used in GraphQL.
Number766 
Table 26. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateOfficial
  • Responsible

Status

The status of the organisational unit.

You can use this field freely, e.g. to state in which phase of the project you are.

Org. unit status texts for different languages can be defined in the Text table. These texts has text type 60.
Note:
If you double-click or press * in this field, you can look up a Org. unit status in the Text table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrg. unit statusInteger
SQL nameStThe database field name.
API identifierstatusThe API identifier used in GraphQL.
Number764 

Sup. no.

You can associate a supplier with the organisational unit.

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.
DomainSup. no.Integer
SQL nameSupNoThe database field name.
API identifiersupplierNoThe API identifier used in GraphQL.
Number774 
Table 27. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateSupplier
  • Sup. no.

Web page

The address of a web page for the organisational unit.

Double-click or press * to open the web page in your web browser.

Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.

On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeb pageText (260)
SQL nameIntAdThe database field name.
API identifierwebPageThe API identifier used in GraphQL.
Number6609 

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 28. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.