Window

This table contains one row for each window layout.

PropertyValueDescription
DatabaseSystemThis table is in the system (vbsys) database.
SQL nameWinThe table name in the database.
API identifierwindowThe API identifier used in GraphQL.
Table no.5The table number in the data model.

The following fields exist in this table:

Active page element

The page element to activate initially in the document window.

Is normally set by activating the actual page element before the layout is saved.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameActPrtThe database field name.
API identifieractivePageElementThe API identifier used in GraphQL.
Number8663 

Available to

Who will have access to the window layout.

Normally, the initial access regulation is set in design mode in the drop-downs for Access. These values can later be updated in design mode, or in the Manage layouts window.

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
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAvailable toInteger
SQL nameLtTpThe database field name.
API identifieravailableToThe API identifier used in GraphQL.
Number158 

Company group no.

The company group the window layout is accessible for, if 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.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCompany group no.Integer
SQL nameFrmGrThe database field name.
API identifiercompanyGroupNoThe API identifier used in GraphQL.
Number10524 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Company groupCompanyGroup
  • Company group no.

Company no.

The company the window layout is accessible for, if 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.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCompany no.Integer
SQL nameFrmNoThe database field name.
API identifiercompanyNoThe API identifier used in GraphQL.
Number10523 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
CompanyCompany
  • 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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessProgramOnly the program is allowed to modify the value in this field.
SQL nameDColThe database field name.
API identifierdataCollectionThe API identifier used in GraphQL.
Number8920 

Data version

The data version that was current when the window layout was saved.

Is taken into account when the layout is read, to be backward compatible with layouts saved with earlier versions, without requiring data conversions when the meaning of fields have changed or old rows are missing values ​​in new fields.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDVerThe database field name.
API identifierdataVersionThe API identifier used in GraphQL.
Number8915 

Folder no.

The folder in which the window layout is included, if any.

If this field is not filled in, the window layout remains on the top level.

Normally, the folder is chosen in the Save layout dialog box in design mode. The folder can later be updated the Manage layouts window.

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.
DomainFolder no.Integer
SQL nameFldrNoThe database field name.
API identifierfolderNoThe API identifier used in GraphQL.
Number2495 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
FolderFolder
  • Folder no.

Layout gr. no.

The layout group the window layout is accessible for, if 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.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainLayout gr. no.Integer
SQL nameAccGrThe database field name.
API identifieruserGroupNoThe API identifier used in GraphQL.
Number4402 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
Layout groupUserGroup
  • Layout gr. no.

Layout Json

Used internally by the system to structure layouts.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainJson in BLOBUnlimited text
SQL nameLayJsonThe database field name.
API identifierlayoutJsonThe API identifier used in GraphQL.
Number19119 

Layout name

The name of the window layout.

The layout name is entered in design mode, or in the Save layout dialog box.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (64)
SQL nameNmThe database field name.
API identifierlayoutNameThe API identifier used in GraphQL.
Number161 

Linked to window no.

The window no. of the window layout to be replaced with this window layout, if any.

A standard layout can be saved as a custom layout by pressing the Save as copy button in design mode. Custom layouts can be copied by selecting the Save as copy option (behind the Save changes button).

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.
DomainNo.Integer
SQL nameLnkToWNoThe database field name.
API identifierlinkedToWindowNoThe API identifier used in GraphQL.
Number11934 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
WindowWindow
  • Linked to window no.

Next available page elem. no.

The page element no. to be assigned to the next page element that is added.

Page element numbers identify page elements uniquely, also over time, and are not reused after page elements are deleted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameNxtPgElThe database field name.
API identifiernextAvailablePageElementNoThe API identifier used in GraphQL.
Number9404 

Parameter

Drill-through parameters for the document window.

The parameters are separated with a comma (and a space). Each parameter is specified with the name of the parameter, a space, and a number in parentheses indicating the formatting:

  • 1. Text
  • 2. Number
  • 3. General ledger account no
  • 4. Date
  • 5. Time
  • 6. Time span
  • 7. Year and week
  • 8. Year and period
  • 9. Year and time-calendar period
  • 10. Boolean

Parameter names can be up to 40 characters long, and must be unique in the list.

Drill-through parameters are normally defined with the Parameters command (in the Layout group in the Design tab).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainParameterText (260)
SQL nameDrThParmThe database field name.
API identifierparametreThe API identifier used in GraphQL.
Number14925 

User name

The user the window layout is accessible for, if 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.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainUser nameText (24)
SQL nameUsrThe database field name.
API identifieruserNameThe API identifier used in GraphQL.
Number159 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
UserUser
  • User name

WE layout type

A look-up in this field gives you the following list of possible values:
1 - Main
2 - Sub
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWE layout typeInteger
SQL nameWeLayTpThe database field name.
API identifierweLayoutTypeThe API identifier used in GraphQL.
Number18594 

WE module no.

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.
DomainNo.Integer
SQL nameWeModNoThe database field name.
API identifierweModuleNoThe API identifier used in GraphQL.
Number18593 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
WE moduleWebExtensionModule
  • WE module no.

WE sorting

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameWeSrtThe database field name.
API identifierweSortingThe API identifier used in GraphQL.
Number18595 

What window flags

What information should be stored about the document window.

If the field has the value 0, it is processed in the same way as -1, i.e. all the check boxes are selected on and all information is saved.

This field is not relevant for Business NXT.

A look-up opens the dialog box where you can see the following check boxes and options:
Page elements inside the window
Window size and location
Window name
Font
Preferences
Page setup
Report parameters
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainWhat window flagsInteger
SQL nameWhWinFlThe database field name.
API identifierwhatWindowInformationThe API identifier used in GraphQL.
Number189 

Window background colour

The colour of the background in the document window.

Is normally changed with the Background colour command (in the Layout group in the Design tab).

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainColourInteger
SQL nameBackColThe database field name.
API identifierwindowBackgroundColorThe API identifier used in GraphQL.
Number8569 

Window flags

Options and state for the document window.

A look-up opens the dialog box where you can see the following check boxes and options:
System database
The layout is company-independent.

A company-independent layout is normally created by holding down the Shift key while executing the New layout command (in the Design group in the Home tab).

Include in navigation panel
The window layout should appear in the navigation panel (the Layout tabs in the Ribbon).

Is normally set with the Include in navigation panel check box in the Save window layout dialog box (in the Layout group in the Design tab, or in the Design group in the Home tab), and may be toggled with the Include in navigation panel command in the Layout explorer.

Use it as startup window
The window layout should be activated with the Start window (F11) command (in the Navigation group in the Home tab).

Is normally set with the Use it as startup window check box in the Save window layout dialog box (in the Layout group in the Design tab, or in the Design group in the Home tab).

Not editable in Professional
The window layout cannot be edited in the Professional edition of the program.
Used on document copies
The window layout is used on document copies, and may trigger a question if you try to save the layout again.

Is normally set when document copies are made.

Create copy
The window layout is a copy of an original layout in a branch solution data collection.

Is normally set with the Create copy check box in the Save window layout dialog box (in the Layout group in the Design tab, or in the Design group in the Home tab).

Is dashboard report startpage
Web layout
Approval voucher
When set, the window will be used to display voucher details in Approval iframe.
Approval updated voucher
When set, the window will be used to display updated voucher details in Approval iframe.
Approval purchase request
When set, the window will be used to display order details in Approval iframe.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainWindow flagsInteger
SQL nameWinFlThe database field name.
API identifierwindowFlagsThe API identifier used in GraphQL.
Number190 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessProgramOnly the program is allowed to modify the value in this field.
SQL nameWinIdThe database field name.
API identifierwindowIdThe API identifier used in GraphQL.
Number8940 

Window name

The name of the document window, if any.

The window name is displayed on the window tab, and may be printed on forms with the @Report macro function.

If this field is not filled in, the value in the Layout name field will be applied.

Is normally changed with the Window name command (in the Layout group in the Design tab).

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (64)
SQL nameWinNmThe database field name.
API identifierwindowNameThe API identifier used in GraphQL.
Number2479 

Window no.

A unique number identifying the window layout.

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.
DomainNo.Integer
Primary keyYesWindow no.
SQL nameWNoThe database field name.
API identifierwindowNoThe API identifier used in GraphQL.
Number2501 

Window pref.

Settings defining the behaviour of the document window.

A look-up opens the dialog box where you can see the following check boxes and options:
No credit control
The program should not perform credit control in the window layout.

Is normally toggled with the No credit control check box in the Window preferences dialog box (in the Layout group in the Design tab).

Vertical scrollbar
Shows a vertical scrollbar in the window layout, applying to the active page element.

Is normally toggled with the Vertical scrollbar command (in the Layout group in the Design tab).

Horizontal scrollbar
Shows a horizontal scrollbar in the window layout, applying to the active page element.

Is normally toggled with the Horizontal scrollbar command (in the Layout group in the Design tab).

Alternative background
Shows an alternative background colour between the page elements in the window layout.

Is normally set with the Alternative background (F8) command (in the Layout group in the Design tab).

Do not ask for parameter values when opening window
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWindow pref.Integer
SQL nameWinPrefThe database field name.
API identifierwindowPreferencesThe API identifier used in GraphQL.
Number8662 

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