Organisational unit 12

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

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL nameR12The table name in the database.
API identifierorgUnit12The API identifier used in GraphQL.
Table no.262The 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.
Number10444 

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.
Number15366 

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.
Number10448 

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.
Number10447 

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.
Number10397 

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.
Number10398 

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.
Number10399 

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.
Number10400 

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.
Number10451 

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.
Number10452 

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.
Number10453 

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.
Number10454 

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.
Number10455 
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.
Number10456 
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.
Number10457 
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.
Number10458 
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.
Number14388 

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.
Number11002 
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.
Number10577 
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.
Number14345 
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.
Number14346 
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.
Number10408 
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.
Number10459 

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.
Number10460 

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.
Number10461 

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.
Number10462 

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.
Number10404 

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.
Number19684 
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.
Number10412 

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.
Number10413 

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.
Number10414 

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.
Number10415 

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.
Number10416 

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.
Number10417 

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.
Number10418 

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.
Number10419 

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.
Number10420 

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.
Number10421 

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.
Number10422 

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.
Number10423 

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.
Number10424 

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.
Number10425 

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.
Number10426 

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.
Number10427 

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.
Number10428 

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.
Number10429 

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.
Number10430 

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.
Number10431 

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.

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 nameMainR12The database field name.
API identifiermainUnitThe API identifier used in GraphQL.
Number10443 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • 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.
Number10450 

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.
Number19231 
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.
Number10396 

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.
Number10411 

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.

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.
DomainShort alphanumeric organisational unit no.Text (10)
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.
Number10405 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnitTemplate
  • 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.
Number10432 
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.
Number10433 
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.
Number10434 
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.
Number10435 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5

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 nameR5The database field name.
API identifierorgUnit5The API identifier used in GraphQL.
Number10436 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

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.
Number10437 
Table 19. 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.
Number10438 
Table 20. 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.
Number10439 
Table 21. 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.
Number10440 
Table 22. 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.
Number10441 
Table 23. 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.
Number10442 
Table 24. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12 no.

A unique number identifying the organisational unit.

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

Note:
If you enter + in this field, the value from the line above is suggested.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
Primary keyYesOrganisational unit 12 no.
SQL nameRNoThe database field name.
API identifierorgUnit12NoThe API identifier used in GraphQL.
Number10395 

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.
Number10449 

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.
Number10446 

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.
Number10445 

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.
Number10401 
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.
Number10402 

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.
Number10406 

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.
Number10407 
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.
Number10410 

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.
Number10409 
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.
Number10403 

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.