Page element
This table contains one row for each page element layout.
| Property | Value | Description |
|---|---|---|
| Database | System | This table is in the system (vbsys) database. |
| SQL name | SbWin | The table name in the database. |
| API identifier | pageElement | The API identifier used in GraphQL. |
| Table no. | 9 | The table number in the data model. |
The following fields exist in this table:
$Def. source
The default paper bin from which the paper is fed.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DmDefSrc | The database field name. |
| API identifier | printerSetupDefaultSource | The API identifier used in GraphQL. |
| Number | 8999 |
$Number of copies
The number of copies to be printed.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DmCp | The database field name. |
| API identifier | printerSetupCopies | The API identifier used in GraphQL. |
| Number | 8998 |
$Orientation
The orientation of the paper.
- 1 = Portrait
- 2 = Landscape
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DmOr | The database field name. |
| API identifier | printerSetupOrientation | The API identifier used in GraphQL. |
| Number | 8994 |
$Paper height
The length of the paper, in portrait mode, in tenths of a millimetre.
Is applied only if required by the $Paper size field.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DmPLen | The database field name. |
| API identifier | printerSetupPaperHeigth | The API identifier used in GraphQL. |
| Number | 8996 |
$Paper size
The size of the paper to print on.
May be set to 0 if the $Paper height and $Paper width fields are both filled out, or to one of the predefined values (e.g. 9 for A4).
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DmPSz | The database field name. |
| API identifier | printerSetupPaperSize | The API identifier used in GraphQL. |
| Number | 8995 |
$Paper width
The width of the paper, in portrait mode, in tenths of a millimetre.
Is applied only if required by the $Paper size field.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DmPWid | The database field name. |
| API identifier | printerSetupPaperWidth | The API identifier used in GraphQL. |
| Number | 8997 |
$Printer name
The UNC name of the printer.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | $Printer name | Text (64) |
| SQL name | DmDevNm | The database field name. |
| API identifier | printerSetupPrinterName | The API identifier used in GraphQL. |
| Number | 8993 |
Apply on include and join
Whether the page element layout should be applied when including or joining the table.
Is normally set with the Including and joining check box in the Use in conjunction with group box in the dialog box to the Save page element command (in the Table group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | Init | The database field name. |
| API identifier | initial | The API identifier used in GraphQL. |
| Number | 280 |
Apply on lookup
Whether the page element layout should be applied when doing lookups into the table.
Is normally set with the Lookup check box and drop-down list in the Use in conjunction with group box in the dialog box to the Save page element layout command (in the Table group in the Design tab).
- 1 - General
- The Page element layout will be applied on lookups on the primary key of the referenced table.
- 2 - Customer
- The Page element layout will be applied on lookups on the Cust. no. field in the Associate table.
- 4 - Supplier
- The Page element layout will be applied on lookups on the Sup. no. field in the Associate table.
- 8 - Employee
- The Page element layout will be applied on lookups on the Empl. no. field in the Associate table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Apply on lookup | Integer |
| SQL name | LRole | The database field name. |
| API identifier | role | The API identifier used in GraphQL. |
| Number | 4351 |
Available to
Who will have access to the page element layout.
Normally, the initial access regulation is set in the dialog box to the Save page element command (in the Table group in the Design tab).
- 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 | 276 |
Button/Form colour
The background colour of the table, column and row buttons in table view, or on the form in form view.
Is normally set with the Button/form colour command (in the Table 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 | BkColBt | The database field name. |
| API identifier | buttonOrFormColor | The API identifier used in GraphQL. |
| Number | 8721 |
Company group no.
The company group the page element 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 | 10526 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Company group | CompanyGroup |
|
Company no.
The company the page element 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 | 10525 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Company | Company |
|
Copies per page
The number of copies to print of each page, before the next.
Each page can be printed a particular number of times before the next page is printed by defining a value higher than 1 in this field.
Different texts can be printed on the different copies by filling in the Copy variant column in the Form element table, e.g. the text "COPY" on all copies except the first one.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | CpPrPg | The database field name. |
| API identifier | copiesPerPage | The API identifier used in GraphQL. |
| Number | 8989 |
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 | 8921 |
Data version
The data version that was current when the 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 | 8916 |
Element Json
| 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 | ElJson | The database field name. |
| API identifier | elementJson | The API identifier used in GraphQL. |
| Number | 19183 |
Excel template name
The template file to use when printing to Microsoft Excel.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | File name | Text (260) |
| SQL name | XlTplNm | The database field name. |
| API identifier | excelTemplateFileName | The API identifier used in GraphQL. |
| Number | 16130 |
First page no.
The number of the first page.
The pages are allocated consecutive numbers, starting at the number specified in this field, or 1 if the field is not filled in. The value may be increased, for example if a report is to be used as an attachment to a document.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | FstPgNo | The database field name. |
| API identifier | firstPageNo | The API identifier used in GraphQL. |
| Number | 8987 |
Font
The font used in the page element.
The field shows the font family, style and size within square brackets. In the database there are three separate fields for font family, font style and font size. The field shown on the screen keeps the font size in the database.
Is normally set with the Font command (in the Design group in the Home tab).
The font size may be set as a percentage (e.g. 120) of the normal font size, cf. the Relative option in the Type drop-down list in the dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Font | Integer |
| SQL name | FSz | The database field name. |
| API identifier | fontSize | The API identifier used in GraphQL. |
| Number | 284 |
Font scale %
The percent of the font sizes on the screen to use on printouts.
The same font sizes are generally used on printouts as on the screen. However, it is possible to scale them down (or up) by specifying a percentage other than 100 in this field.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | FontSc | The database field name. |
| API identifier | fontScalePercent | The API identifier used in GraphQL. |
| Number | 8990 |
Form no.
The form to be used on printouts.
If the field is not filled in, the standard form for the document type/form type will be applied.
The form is normally selected from the Form split button (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Form no. | Integer |
| SQL name | FormNo | The database field name. |
| API identifier | formNo | The API identifier used in GraphQL. |
| Number | 8985 |
Heading lines
The number of lines the column headings in a table page element are to cover.
The value can be in the range 0 - 4. 0 means that no column headings are displayed.
Is normally set in the dialog box for the Other preferences command (in the Table group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | HdrLin | The database field name. |
| API identifier | headingLines | The API identifier used in GraphQL. |
| Number | 287 |
Hidden processings
The processings that are hidden in a table page element.
Contains the external numbers of the processings, separated with comma.
Is normally set with the Hidden processings command (in the Table group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Processing numbers | Unlimited text |
| SQL name | HidProc | The database field name. |
| API identifier | hiddenProcessings | The API identifier used in GraphQL. |
| Number | 16494 |
Hidden reports
The reports that are hidden in a table page element.
Contains the external numbers of the reports, separated with comma.
Is normally set with the Hidden reports command (in the Table group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Report numbers | Unlimited text |
| SQL name | HidRep | The database field name. |
| API identifier | hiddenReports | The API identifier used in GraphQL. |
| Number | 16495 |
Layout gr. no.
The layout group the page element 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 | 4403 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Layout group | UserGroup |
|
Layout name
The name of the page element layout.
Normally, the initial layout name is entered in the dialog box to the Save page element command (in the Table 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 | Nm | The database field name. |
| API identifier | layoutName | The API identifier used in GraphQL. |
| Number | 279 |
Optimization parameters
Optimizer hints for the database system, when retrieving rows in a table page element.
Is normally set in the dialog box for the Other preferences command (in the Table group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Optimization parameters | Text (40) |
| SQL name | Optim | The database field name. |
| API identifier | optimizationParameters | The API identifier used in GraphQL. |
| Number | 6667 |
Page break level
Up to which join level to do page breaks.
When page elements are joined, the program starts on a new page for each level up to and including the level specified in this field. The head page element is level 1, page elements joined to this are level 2, and so on. If the field is set to 0 you get a continuous listing, broken only by page breaks where necessary for reasons of space in the sheets.
The default value is 1 so that the program goes to a new page for each customer, for example in Open entries list for customers or Account statement for customers.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PgBrLev | The database field name. |
| API identifier | pageBreakLevel | The API identifier used in GraphQL. |
| Number | 8986 |
Page elem. ID
Identifies the row in the data collection it belongs to.
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 | PgElId | The database field name. |
| API identifier | pageElementId | The API identifier used in GraphQL. |
| Number | 8946 |
Page elem. no.
A unique number identifying the page element.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Page elem. no. |
| SQL name | SbWNo | The database field name. |
| API identifier | pageElementNo | The API identifier used in GraphQL. |
| Number | 2505 |
Page element flags 1
Settings defining the behaviour of the page element.
- View page element as scheme
- The table page element is shown in form view, instead of table
view.
Is normally set with the Change display mode (Ctrl+T) command (in the Table group in the Design tab, or in the Design group in the Home tab).
- View only break lines
- Only break lines are shown in the table page element.
Is normally toggled with the View only break lines check box in the dialog box for the Sort (F7) command (in the Sorting group in the Design or Home tab).
- Include total line
- A total line is included in the table page element.
Is normally toggled with the Include total line check box in the dialog box for the Sort (F7) command (in the Sorting group in the Design or Home tab).
- Calculate average
- Averages are shown instead of sums on break lines in the table page
element.
Is normally toggled with the Calculate average check box in the dialog box for the Sort (F7) command (in the Sorting group in the Design or Home tab).
- Sheets
- A background is shown in the book page element.
Is normally toggled with the Background command (in the Book group in the Design tab).
- Nested appearance
- The book page element is shown with nested appearance, instead of
top-level appearance.
Is normally toggled by dragging-and-dropping the book page element inside or outside the background of another book page element.
- Do not forward print commands to the main page element
- Web layout
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Page element flags 1 | Integer |
| SQL name | SbWFl | The database field name. |
| API identifier | pageElementFlags1 | The API identifier used in GraphQL. |
| Number | 302 |
Page element flags 2
Settings defining the behaviour of the page element.
- X Size type, bit 2
- If the X Size type, bit 1 check box is also selected, the page element uses the available space to the right
of the page/window, else the width of the page element follows the right edge of the
window.
Is normally set with commands in the Size group in the Design tab.
- Y Size type, bit 2
- If the Y Size type, bit 1 check box is also selected, the page element uses the available space down the
page/window, else the height of the page element follows the lower edge of the
window.
Is normally set with commands in the Size group in the Design tab.
- Search row
- The search row is shown in the table page element.
Is normally toggled with the Search row (Ctrl+F) command (in the Searching group in the Home or Design tab).
- Identical tabs
- Adjustments of one tab should apply to all the tabs in the book.
Is normally toggled with the Identical tabs command (in the Book group in the Design tab).
- X Size type, bit 1
- If the X Size type, bit 2 value is also set, the page element uses the available space to the right of the
page/window, else the width of the page element is adjusted after its contents.
Is normally set with commands in the Size group in the Design tab.
- View folders in Window list
- Shows folders in the layout page element, cf. the rightmost page
element in the Layout explorer.
Is normally toggled with the Folders command (in the Layout explorer group in the Home tab).
- Skip button frame
- A 3D frame is not shown around the tab or button.
Is normally toggled with the 3D frame command (in the Tab or Button group in the Design tab).
- Hot tracking
- The tab or button may change appearance when the mouse hovers over
it.
Is normally toggled with the Hot tracking command (in the Tab or Button group in the Design tab).
- Add search
- The next search on the Search row will be added to
the previous one.
Is normally toggled with the Add search (Ctrl+6) command (in the Searching group in the Home or Design tab).
- Jump over
- When navigating, the page element will be jumped over and not get the
keyboard focus.
Is normally toggled with the Skip command (in the Sequence group in the Design tab).
- Y Size type, bit 1
- If the Y Size type, bit 2 value is also set, the page element uses the available space down the page /
window, else the height of the page element is adjusted after its contents.
Is normally set with commands in the Size group in the Design tab.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Page element flags 2 | Integer |
| SQL name | PgElFl2 | The database field name. |
| API identifier | pageElementFlags2 | The API identifier used in GraphQL. |
| Number | 8774 |
Page element flags 3
Settings defining the behaviour of the page element.
- Composed of pictures
- The tab or button will be built up by up to 9 pictures, with file
names ending with 1-9.
Is normally toggled with the Composed of pictures command (in the Tab or Button group in the Design tab).
- Picture 1 in frame
- A picture is present for the top left corner of the tab or
button.
Is normally set with the Normal picture (Ctrl+B) command (in the Tab or Button group in the Design tab).
- Picture 2 in frame
- A picture is present for the top center edge of the tab or
button.
Is normally set with the Normal picture (Ctrl+B) command (in the Tab or Button group in the Design tab).
- Picture 3 in frame
- A picture is present for the top right corner of the tab or
button.
Is normally set with the Normal picture (Ctrl+B) command (in the Tab or Button group in the Design tab).
- Picture 4 in frame
- A picture is present for the middle left edge of the tab or
button.
Is normally set with the Normal picture (Ctrl+B) command (in the Tab or Button group in the Design tab).
- Picture 5 in frame
- A picture is present for the middle center area of the tab or
button.
Is normally set with the Normal picture (Ctrl+B) command (in the Tab or Button group in the Design tab).
- Picture 6 in frame
- A picture is present for the middle right edge of the tab or
button.
Is normally set with the Normal picture (Ctrl+B) command (in the Tab or Button group in the Design tab).
- Picture 7 in frame
- A picture is present for the bottom left corner of the tab or
button.
Is normally set with the Normal picture (Ctrl+B) command (in the Tab or Button group in the Design tab).
- Picture 8 in frame
- A picture is present for the bottom center edge of the tab or
button.
Is normally set with the Normal picture (Ctrl+B) command (in the Tab or Button group in the Design tab).
- Picture 9 in frame
- A picture is present for the bottom right corner of the tab or
button.
Is normally set with the Normal picture (Ctrl+B) command (in the Tab or Button group in the Design tab).
- Skip focus rectangle
- A dashed rectangle is shown around the text when the tab is active, or
the button is the active page element.
Is normally toggled with the Focus rectangle command (in the Tab or Button group in the Design tab).
- Underlining
- The text is underlined when the mouse hovers over the tab or
button.
Is normally toggled with the Underlining command (in the Tab or Button group in the Design tab).
- Use text variable element 2 instead of 1
- The company dependent picture will use the Value 2 field instead of the Value 1 field.
Is normally set with the 2 option in the Element no. list in the dialog box for the Company dependent picture command (in the Insert group in the Design tab).
- Pictures per page
- The first, intermediate and final tabs can use their own pictures,
where the file names end with capitalized A, B and C, respectively (before any
1-9).
Is normally toggled with the Pictures per page command (in the Book group in the Design tab).
- Space before first tab
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Page element flags 3 | Integer |
| SQL name | PgElFl3 | The database field name. |
| API identifier | pageElementFlags3 | The API identifier used in GraphQL. |
| Number | 8947 |
Pages at the time
The number of pages to send to the printer at once.
This field makes it possible to start the printout while the program works on producing the rest of the printout. The total time it takes from when you start the printout until it is finished is then reduced. If this field is set to 4, for example, the program sends four pages to the printer at a time. Other printouts can then take place in between.
If the parameter is not set, everything is printed together at the end.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PgAtOnce | The database field name. |
| API identifier | pagesAtOnce | The API identifier used in GraphQL. |
| Number | 8988 |
Preferences
Settings defining the behaviour of the table page element.
Is normally set with the Other preferences command (in the Table group in the Design tab).
- Grid lines between columns
- Shows vertical lines between the columns in the grid (when the page
element is shown in table view). Applies also to printouts.
Is normally toggled with the Grid lines between columns check box in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Grid lines between rows
- Shows horizontal lines between the rows in the grid (when the page
element is shown in table view). Applies also to printouts.
Is normally toggled with the Grid lines between rows check box in the dialog box for the Other preferences command (in the Table group in the Design tab). On the screen, it is also assumed that the View grid lines in table page elements check box is selected in the User pref. field on the user's row in the User table.
- Last row
- Positions the field pointer on the last row when the page element is
opened.
Is normally set with the Last row option in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Go through split page elements
- The Enter or Tab key
will visit split page elements, after the last editable field in the page
element.
Is normally toggled with the Go through split page elements check box in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Do not go through joined page elements
- The Enter or Tab key
will not visit joined page elements, after the last editable field in the page element
(and visits to split page elements).
Is normally toggled with the Go to joined page elements check box in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Empty table (until search/selection)
- No rows are shown when the page element is opened, before the user has
done a search or selection.
Is normally set with the Empty table (until search/selection) option in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Prevent editing on lookup
- Editing in lookup page elements is not possible.
Is normally toggled with the Prevent editing on lookup check box in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Skip title line
- The heading line of the page element is not shown.
Is normally toggled with the Title line command (in the Table group in the Design tab).
- Skip frame
- The 3D frame around the form (when the page element is shown in form
view) is not shown.
Is normally toggled with the Frame command (in the Table group in the Design tab). Assumes that a background colour has been set for the frame with the Button/form colour command (in the Table group in the Design tab).
- Skip background
- The background around the grid (when the page element is shown in
table view) is not shown outside design mode.
Is normally toggled with the Area around table command (in the Table group in the Design tab).
- Do not refresh continuously
- The page element is not continuously refreshed when filling in values
on the search row in the Search pane.
Is normally toggled with the Do not refresh continuously check box in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Suppress warehouse messages
- The No stock balance found warning is not shown.
Applicable only for page elements against the Order line table.
Is normally toggled with the Suppress warehouse messages check box in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Auto refresh from calendar
- The page element is refreshed when selections are done in the calendar
page element it is attached to (established with the Attach to calendar command in the Add group
in the Design tab).
Is normally toggled with the Auto refresh from calendar check box in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Down on Enter
- The Enter key moves the field pointer
vertically, instead of horizontally, in the grid (when the page element is shown in
table view).
Is normally toggled with the Down on Enter (Ctrl+R) command (in the Editing group in the Home tab).
- Enforce entry rules on split page elements
- Entry rules defined on columns in the page element will also be
applied in split page elements, cf. the Entry rules
command (in the Column group in the
Design
tab).
Is normally toggled with the Enforce entry rules on split page elements check box in the dialog box for the Other preferences command (in the Table group in the Design tab).
- Apply background in book
- Apply button colour in grid
- Apply button colour in form
- Keep selections
- For table page elements, the selected area will not be hidden when the table is loosing focus. This can be useful in places where you are working with several table at the same time, e.g. in bank reconciliation where selected rows from two different tables shall be matched.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Preferences | Integer |
| SQL name | PrFl | The database field name. |
| API identifier | otherPreferences | The API identifier used in GraphQL. |
| Number | 286 |
Print destination
The current print destination.
Is normally set with commands in the Printing group in the Design tab.
- 1 - Print preview
- The print destination is ../../business/auto/reference/r_gc_menuchoice_previewprintout.html.
- 2 - Print
- The print destination is ../../business/auto/reference/r_gc_menuchoice_printtocurrentdestination.html.
- 3 - Override to printer
- Not used.
- 4 - Quick print
- The print destination is ../../business/auto/reference/r_gc_menuchoice_quickprint.html.
- 5 - Print to PDF
- The print destination is ../../business/auto/reference/r_gc_menuchoice_printtopdf.html.
- 6 - Send e-mail
- The print destination is ../../business/auto/reference/r_gc_menuchoice_sendemail.html.
- 7 - Design Excel template
- Not used.
- 8 - Print to Excel
- Not used.
- 9 - Print to clipboard
- Not used.
- 10 - Print to file
- The print destination is ../../business/auto/reference/r_gc_menuchoice_printtofile.html.
- 11 - Only approval
- The print destination is ../../business/auto/reference/r_gc_menuchoice_onlyapproval.html.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Print destination | Integer |
| SQL name | PrnDst | The database field name. |
| API identifier | printDestination | The API identifier used in GraphQL. |
| Number | 16362 |
Print options
Settings defining the behaviour of the page setup.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Selection is needed
- Only marked rows will be included in the printout.
Is normally set with the All rows if no rows are selected option in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Current row
- Only the current row will be included in the printout.
Is normally set with the Only the active row if no rows are selected option in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Table and column names, etc.
- The SQL names will be applied for non-memory tables and columns in
table headings, when printing to file or Microsoft Excel.
Is normally set with the Name or Mixed option in the Table heading list in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Convert from ANSI to OEM
- ANSI characters will be converted to OEM, when printing to file or Microsoft Excel.
Is normally toggled with the Convert from ANSI to OEM check box in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Tab delimiter
- The values will be separated with tabs when printing to file or Microsoft Excel.
Is normally set with the Tab option in the Field separator list in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Comma delimiter
- The values will be separated with commas when printing to file or Microsoft Excel.
Is normally set with the Comma option in the Field separator list in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Semicolon delimiter
- The values will be separated with semicolons when printing to file or Microsoft Excel.
Is normally set with the Semicolon option in the Field separator list in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Single quote qualifier
- The values will be enclosed with single quotes when printing to file or Microsoft Excel.
Is normally set with the Single quotes option in the Start of field/End character list in the dialog box for the Page setup command (in the Printing group in the Design tab).
- No text qualifier
- The values will not be enclosed neither with single nor double quotes,
when printing to file or Microsoft Excel.
Is normally set with the None option in the Start of field/End character list in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Split text on multiple rows
- Lines longer than 73 characters will be split, when printing to file or Microsoft Excel.
Is normally toggled with the Split text on multiple rows check box in the dialog box for the Page setup command (in the Printing group in the Design tab).
- External no.
- The external numbers will be applied for tables and columns in table
headings when printing to file or Microsoft Excel.
Is normally set with the Number or Mixed option in the Table heading list in the dialog box for the Page setup command (in the Printing group in the Design tab).
- On columns
- The background colour will be printed on column headings.
Is normally set by selecting the tri-state On columns check box in the Shading group in the dialog box for the Page setup command (in the Printing group in the Design tab).
- On columns
- No background colour will be printed on column headings.
Is normally set by clearing the tri-state On columns check box in the Shading group in the dialog box for the Page setup command (in the Printing group in the Design tab).
- On break lines
- The background colour will be printed on break lines.
Is normally set by selecting the tri-state On break lines check box in the Shading group in the dialog box for the Page setup command (in the Printing group in the Design tab).
- On break lines
- No background colour will be printed on break lines.
Is normally set by clearing the tri-state On break lines check box in the Shading group in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Text from text table
- The corresponding text in fields that refers to the Text table will be
applied when printing to file or Microsoft Excel.
Is normally toggled with the Text from text table check box in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Generate unique file names
- A unique file name will be generated when printing to file or Microsoft Excel, using the Printout counter (defined in the dialog box for
the Change counters processing in the Company information
table).
Is normally toggled with the Generate unique file names check box in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Include database and report name
- The company database name and report name will be included before each
order, when printing to file or Microsoft Excel.
Is normally toggled with the Include database and report name check box in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Prefix header and lines
- Each order will be prefixed with a "H", and each order line with a
"L", when printing to file or Microsoft Excel.
Is normally toggled with the Prefix header and lines check box in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Use comma as decimal separator
- Forces comma as decimal separator in floating-point numbers, when printing to file or Microsoft Excel.
Is normally toggled with the Use comma as decimal separator check box in the dialog box for the Page setup command (in the Printing group in the Design tab).
- Collect all documents in one e-mail
- All documents will be included in one e-mail, instead of one e-mail
per document, when sending e-mail.
Is normally toggled with the Collect all documents in one e-mail check box in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Print options | Integer |
| SQL name | PgFl | The database field name. |
| API identifier | pageSetupFlags | The API identifier used in GraphQL. |
| Number | 8991 |
Report name
The report name to be used on printouts, if any.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Report name | Text (32) |
| SQL name | RepNm | The database field name. |
| API identifier | reportName | The API identifier used in GraphQL. |
| Number | 11989 |
Report no.
The current report for the page element.
Is normally set with commands in the Printing group in the Design tab.
If the field is not filled in, Page element printout is applied.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Report no. | Integer |
| SQL name | RepNo | The database field name. |
| API identifier | reportNo | The API identifier used in GraphQL. |
| Number | 16361 |
Report parameters
Parameters to be used when printing reports.
The parameters are specified in the same way as in the @REPORT_PARAMETERS command in import/command files.
Is normally set with the Report parameters command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Report parameters | Text (240) |
| SQL name | RepPar | The database field name. |
| API identifier | reportParameters | The API identifier used in GraphQL. |
| Number | 10803 |
Rows in result set
The maximum number of rows to read at a time from the database, in a table page element.
The default value is 1000, to prevent accidental large memory consumption on large tables. The user can move between result sets with commands in the Navigation group in the Home tab.
Is normally set in the dialog box for the Other preferences command (in the Table group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | ResRows | The database field name. |
| API identifier | rowsInResultset | The API identifier used in GraphQL. |
| Number | 6524 |
Std. column heading colour
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 | Col | The database field name. |
| API identifier | standardColumnHeadingColor | The API identifier used in GraphQL. |
| Number | 7602 |
Surrounding area background colour
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 | BkCol | The database field name. |
| API identifier | surroundingAreaBackgroundColor | The API identifier used in GraphQL. |
| Number | 8605 |
Table no.
The table the page element shows data for.
You can select a table by looking up in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Table no. | Integer |
| SQL name | TabNo | The database field name. |
| API identifier | tableNo | The API identifier used in GraphQL. |
| Number | 278 |
Text
The text to be shown on the heading line.
If the field is not filled in, the plural name of the table is shown.
Is normally set with the Title command (in the Table 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 | GrNm | The database field name. |
| API identifier | text | The API identifier used in GraphQL. |
| Number | 2478 |
Title colour
The text colour on the heading line of a table page element.
Is normally set with the Title colour command (in the Table 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 | TitCol | The database field name. |
| API identifier | titleColor | The API identifier used in GraphQL. |
| Number | 8720 |
Title font
The font on the heading line of a table page element.
The field shows the font family, style and size within square brackets. In the database there are three separate fields for font family, font style and font size. The field shown on the screen keeps the font size in the database.
Is normally set with the Title font command (in the Table group in the Design tab).
The font size may be set as a percentage (e.g. 120) of the normal font size, cf. the Relative option in the Type drop-down list in the dialog box.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Font | Integer |
| SQL name | TitFSz | The database field name. |
| API identifier | titleFontSize | The API identifier used in GraphQL. |
| Number | 8718 |
User name
The user the page element 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 | 277 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| User | User |
|
What page element flags
What information should be stored about the page element.
Is normally set based on choices made in the What to save dialog box invoked from the What button in the dialog box to the Save page element command (in the Table group in the Design tab).
If the field has the value 0, it is processed in the same way as -1, i.e. all the flags are set on and all information is saved.
- Page elem. name
- The text to be shown on the heading line of the table page element, set with the Title command (in the Table group in the Design tab), cf. the Text field in the Page element table.
- Display mode
- Whether the table page element should be displayed in form view, toggled with the Change display mode (Ctrl+T) command (in the Table group in the Design tab), cf. the View page element as scheme option in the Page element flags 1 field in the Page element table.
- Font
- The fonts used in the Page element and on its heading line, set with the Font or Title font commands (in the Title group in the Design tab), cf. the Font and Title font fields, respectively, in the Page element table.
- Preferences
- Other options set for the table page element, including those in the dialog box to the Other preferences command and commands for choosing colours (in the Table group in the Design tab), commands in the Size group, as well as the Skip command (in the Sequence group), cf. fields in the Page element table.
- Page setup
- Printing related options, set with the Form, Printer and Page setup commands (in the Printing group in the Design tab), cf. fields in the Page element table.
- Selection
- Select conditions, defined thru the Selection (F9) or Search pane commands (in the Searching group in the Home or Design tab), cf. the Page element selection table.
- Sort
- Sort conditions, defined with commands in the Sorting group in the Home or Design tab, cf. fields in the Page element column table
- Size
- The visual width for the visual columns and the width reserved for field names in form view, set with the Width command (in the Columns group in the Design tab, or its mouse equivalents), or by dragging the left edge of the fields with the mouse, respectively, cf. the Width and Descr. width fields, respectively, in the Page element column table.
- Location
- The visibility and sequence of visual columns, defined with the Hide (Ctrl+H) and Unhide (Ctrl+U) commands (in the Columns group in the Design tab, or in the Design group in the Home tab), and the Move command (in the Columns group in the Design tab, or its mouse equivalents), cf. the Visible option in the Column flags field, and the Column seq. no. field, respectively, in the Page element column table.
- Texts
- The name of visual columns, overridden with the Heading (Ctrl+N) command (in the Columns group in the Design tab), cf. the Name field in the Page element column table.
- Entry rules
- The entry rules, defined with the Entry rules command (in the Columns group in the Design tab), cf. fields in the Page element column table.
- Format
- The decimal formats, and recalculation factors, defined with the Format command (in the Columns group in the Design tab), cf. the Decimals and Factor fields, respectively, in the Page element column table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | What page element flags | Integer |
| SQL name | WhSbWFl | The database field name. |
| API identifier | whatPageElementInformation | The API identifier used in GraphQL. |
| Number | 301 |
Write to file
The file name to use when printing to file, if it should not be prompted for.
Is normally defined in the dialog box for the Page setup command (in the Printing group in the Design tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | File name | Text (260) |
| SQL name | WrFNm | The database field name. |
| API identifier | writeToFileName | The API identifier used in GraphQL. |
| Number | 8992 |
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. |