Window
This table contains one row for each window layout.
| Property | Value | Description |
|---|---|---|
| Database | System | This table is in the system (vbsys) database. |
| SQL name | Win | The table name in the database. |
| API identifier | window | The API identifier used in GraphQL. |
| Table no. | 5 | The 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | ActPrt | The database field name. |
| API identifier | activePageElement | The API identifier used in GraphQL. |
| Number | 8663 |
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.
- 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 | 158 |
Company group no.
The company group the window layout is accessible for, if required by the Available to field.
| 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 | 10524 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Company group | CompanyGroup |
|
Company no.
The company the window layout is accessible for, if required by the Available to field.
| 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 | 10523 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Company | Company |
|
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 | 8920 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DVer | The database field name. |
| API identifier | dataVersion | The API identifier used in GraphQL. |
| Number | 8915 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Folder no. | Integer |
| SQL name | FldrNo | The database field name. |
| API identifier | folderNo | The API identifier used in GraphQL. |
| Number | 2495 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Folder | Folder |
|
Layout gr. no.
The layout group the window layout is accessible for, if required by the Available to field.
| 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 | 4402 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Layout group | UserGroup |
|
Layout Json
Used internally by the system to structure layouts.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Json in BLOB | Unlimited text |
| SQL name | LayJson | The database field name. |
| API identifier | layoutJson | The API identifier used in GraphQL. |
| Number | 19119 |
Layout name
The name of the window layout.
The layout name is entered in design mode, or in the Save layout dialog box.
| 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 | layoutName | The API identifier used in GraphQL. |
| Number | 161 |
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).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | LnkToWNo | The database field name. |
| API identifier | linkedToWindowNo | The API identifier used in GraphQL. |
| Number | 11934 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Window | Window |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | NxtPgEl | The database field name. |
| API identifier | nextAvailablePageElementNo | The API identifier used in GraphQL. |
| Number | 9404 |
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).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Parameter | Text (260) |
| SQL name | DrThParm | The database field name. |
| API identifier | parametre | The API identifier used in GraphQL. |
| Number | 14925 |
User name
The user the window layout is accessible for, if required by the Available to field.
| 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 | 159 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| User | User |
|
WE layout type
- 1 - Main
- 2 - Sub
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | WE layout type | Integer |
| SQL name | WeLayTp | The database field name. |
| API identifier | weLayoutType | The API identifier used in GraphQL. |
| Number | 18594 |
WE module no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | WeModNo | The database field name. |
| API identifier | weModuleNo | The API identifier used in GraphQL. |
| Number | 18593 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| WE module | WebExtensionModule |
|
WE sorting
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | WeSrt | The database field name. |
| API identifier | weSorting | The API identifier used in GraphQL. |
| Number | 18595 |
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.
- Page elements inside the window
- Window size and location
- Window name
- Font
- Preferences
- Page setup
- Report parameters
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | What window flags | Integer |
| SQL name | WhWinFl | The database field name. |
| API identifier | whatWindowInformation | The API identifier used in GraphQL. |
| Number | 189 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Colour | Integer |
| SQL name | BackCol | The database field name. |
| API identifier | windowBackgroundColor | The API identifier used in GraphQL. |
| Number | 8569 |
Window flags
Options and state for the document window.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Window flags | Integer |
| SQL name | WinFl | The database field name. |
| API identifier | windowFlags | The API identifier used in GraphQL. |
| Number | 190 |
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.
| 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 | WinId | The database field name. |
| API identifier | windowId | The API identifier used in GraphQL. |
| Number | 8940 |
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).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (64) |
| SQL name | WinNm | The database field name. |
| API identifier | windowName | The API identifier used in GraphQL. |
| Number | 2479 |
Window no.
A unique number identifying the window layout.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Window no. |
| SQL name | WNo | The database field name. |
| API identifier | windowNo | The API identifier used in GraphQL. |
| Number | 2501 |
Window pref.
Settings defining the behaviour of the document window.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Window pref. | Integer |
| SQL name | WinPref | The database field name. |
| API identifier | windowPreferences | The API identifier used in GraphQL. |
| Number | 8662 |
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |