Folder

This table contains one row for each folder.

Window layouts are stored in folders, similar to files and folders in Windows.

Folders are usually created and edited in the Layout explorer.

Property	Value	Description
Database	System	This table is in the system (vbsys) database.
SQL name	Fldr	The table name in the database.
API identifier	folder	The API identifier used in GraphQL.
Table no.	109	The table number in the data model.

The following fields exist in this table:

Available to

Who will have access to the folder.

Tip:

Folders are normally access regulated using commands in the Layout explorer.

A look-up in this field gives you the following list of possible values:

1 - User / Company
2 - User / Company group
3 - User / All companies
4 - Layout group / Company
5 - Layout group / Company group
6 - Layout group / All companies
7 - All users / Company
8 - All users / Company group
9 - All users / All companies

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Available to	Integer
SQL name	LtTp	The database field name.
API identifier	availableTo	The API identifier used in GraphQL.
Number	2483

Company group no.

The company group the folder is accessible for, if it is required by the Available to field.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Company group no.	Integer
SQL name	FrmGr	The database field name.
API identifier	companyGroupNo	The API identifier used in GraphQL.
Number	10520

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Company group	CompanyGroup	Company group no.	Company group no.

Company no.

The company the folder is accessible for, if it is required by the Available to field.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Company no.	Integer
SQL name	FrmNo	The database field name.
API identifier	companyNo	The API identifier used in GraphQL.
Number	10519

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Company	Company	Company no.	Company no.

Data collection

The package number for the rows in different tables that belongs together in a package.

Rows in different tables that belongs together in a package are given the same value in this field. Rows from joined tables are also covered. On upgrade to newer versions, old rows may be deleted before new rows are imported, without conflicting with rows that the users have added.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
Write Access	Program	Only the program is allowed to modify the value in this field.
SQL name	DCol	The database field name.
API identifier	dataCollection	The API identifier used in GraphQL.
Number	8918

Folder ID

Identifies the row in the data collection it belongs to.

For internal use by the program.

Rows in a data collection that need to be recognized on later upgrades, are assigned a unique value in this field, in addition to a common value in the Data collection field.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
Write Access	Program	Only the program is allowed to modify the value in this field.
SQL name	FlId	The database field name.
API identifier	folderId	The API identifier used in GraphQL.
Number	8931

Folder no.

A unique number identifying the folder.

Note:

If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Folder no.	Integer
Primary key	Yes	Folder no.
SQL name	FldrNo	The database field name.
API identifier	folderNo	The API identifier used in GraphQL.
Number	2482

Folder processing

A look-up opens the dialog box where you can see the following check boxes and options:

Include in navigation panel: The Folder should appear in the navigation panel (the Layout tabs in the Ribbon). Is normally toggled with the Include in navigation panel command in the Layout explorer.
Web layout

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Folder processing	Integer
SQL name	FPro	The database field name.
API identifier	folderProcessing	The API identifier used in GraphQL.
Number	7899

Included in folder no.

The parent folder, if is not on the top level.

Tip:

Folders are normally moved using the Cut (Ctrl+X) and Paste (Ctrl+V) commands in the Layout explorer.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Folder no.	Integer
SQL name	SFldr	The database field name.
API identifier	includedInFolderNo	The API identifier used in GraphQL.
Number	2486

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Folder	IncludedInFolder	Included in folder no.	Folder no.

Layout gr. no.

The layout group the folder is accessible for, if it is required by the Available to field.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Layout gr. no.	Integer
SQL name	AccGr	The database field name.
API identifier	userGroupNo	The API identifier used in GraphQL.
Number	4400

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
Layout group	UserGroup	Layout gr. no.	Layout gr. no.

Name

The name of the folder.

Tip:

Folders are normally renamed using the Rename (Ctrl+N) command in the Layout explorer.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Name	Text (64)
SQL name	Nm	The database field name.
API identifier	name	The API identifier used in GraphQL.
Number	2485

User name

The user the folder is accessible for, if it is required by the Available to field.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	User name	Text (24)
SQL name	Usr	The database field name.
API identifier	userName	The API identifier used in GraphQL.
Number	2484

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
User	User	User name	User name

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by provenance

The provenance for the record change.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Provenance	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChPvn	The database field name.
API identifier	changedByProvenance	The API identifier used in GraphQL.
Number	A unique column number.

Changed by user

The name of the user that changed the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChUsr	The database field name.
API identifier	changedByUser	The API identifier used in GraphQL.
Number	A unique column number.

Changed date

The date when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChDt	The database field name.
API identifier	changedDate	The API identifier used in GraphQL.
Number	A unique column number.

Changed time

The time when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTm	The database field name.
API identifier	changedTime	The API identifier used in GraphQL.
Number	A unique column number.

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTs	The database field name.
API identifier	changedTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Created by provenance

The provenance for the record creation.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Provenance	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CrePvn	The database field name.
API identifier	createdByProvenance	The API identifier used in GraphQL.
Number	A unique column number.

Created by user

The name of the user that created the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreUsr	The database field name.
API identifier	createdByUser	The API identifier used in GraphQL.
Number	A unique column number.

Created date

The date when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreDt	The database field name.
API identifier	createdDate	The API identifier used in GraphQL.
Number	A unique column number.

Created time

The time when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTm	The database field name.
API identifier	createdTime	The API identifier used in GraphQL.
Number	A unique column number.

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTs	The database field name.
API identifier	createdTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Edit status

The current status of the record.

A look-up in this field gives you the following list of possible values:

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Edit status	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	LckSt	The database field name.
API identifier	editStatus	The API identifier used in GraphQL.
Number	A unique column number.

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Process no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChPrc	The database field name.
API identifier	lockedByProcessNo	The API identifier used in GraphQL.
Number	A unique column number.

Table 6. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.