Page element

This table contains one row for each page element layout.

PropertyValueDescription
DatabaseSystemThis table is in the system (vbsys) database.
SQL nameSbWinThe table name in the database.
API identifierpageElementThe API identifier used in GraphQL.
Table no.9The 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).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameDmDefSrcThe database field name.
API identifierprinterSetupDefaultSourceThe API identifier used in GraphQL.
Number8999 

$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).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameDmCpThe database field name.
API identifierprinterSetupCopiesThe API identifier used in GraphQL.
Number8998 

$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).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameDmOrThe database field name.
API identifierprinterSetupOrientationThe API identifier used in GraphQL.
Number8994 

$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).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameDmPLenThe database field name.
API identifierprinterSetupPaperHeigthThe API identifier used in GraphQL.
Number8996 

$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).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameDmPSzThe database field name.
API identifierprinterSetupPaperSizeThe API identifier used in GraphQL.
Number8995 

$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).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameDmPWidThe database field name.
API identifierprinterSetupPaperWidthThe API identifier used in GraphQL.
Number8997 

$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).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
Domain$Printer nameText (64)
SQL nameDmDevNmThe database field name.
API identifierprinterSetupPrinterNameThe API identifier used in GraphQL.
Number8993 

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

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameInitThe database field name.
API identifierinitialThe API identifier used in GraphQL.
Number280 

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

A look-up in this field gives you the following list of possible values:
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.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainApply on lookupInteger
SQL nameLRoleThe database field name.
API identifierroleThe API identifier used in GraphQL.
Number4351 

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

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

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.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainColourInteger
SQL nameBkColBtThe database field name.
API identifierbuttonOrFormColorThe API identifier used in GraphQL.
Number8721 

Company group no.

The company group the page element 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.
Number10526 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Company groupCompanyGroup
  • Company group no.

Company no.

The company the page element 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.
Number10525 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
CompanyCompany
  • Company no.

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameCpPrPgThe database field name.
API identifiercopiesPerPageThe API identifier used in GraphQL.
Number8989 

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

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.

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

Element Json

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

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

Tip:
If a value is added to the field double-clicking or pressing * displays the file. If no file is selected a Select file dialog will be opened.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFile nameText (260)
SQL nameXlTplNmThe database field name.
API identifierexcelTemplateFileNameThe API identifier used in GraphQL.
Number16130 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameFstPgNoThe database field name.
API identifierfirstPageNoThe API identifier used in GraphQL.
Number8987 

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.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainFontInteger
SQL nameFSzThe database field name.
API identifierfontSizeThe API identifier used in GraphQL.
Number284 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameFontScThe database field name.
API identifierfontScalePercentThe API identifier used in GraphQL.
Number8990 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainForm no.Integer
SQL nameFormNoThe database field name.
API identifierformNoThe API identifier used in GraphQL.
Number8985 

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

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
SQL nameHdrLinThe database field name.
API identifierheadingLinesThe API identifier used in GraphQL.
Number287 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcessing numbersUnlimited text
SQL nameHidProcThe database field name.
API identifierhiddenProcessingsThe API identifier used in GraphQL.
Number16494 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainReport numbersUnlimited text
SQL nameHidRepThe database field name.
API identifierhiddenReportsThe API identifier used in GraphQL.
Number16495 

Layout gr. no.

The layout group the page element 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.
Number4403 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
Layout groupUserGroup
  • Layout gr. no.

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

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

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

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOptimization parametersText (40)
SQL nameOptimThe database field name.
API identifieroptimizationParametersThe API identifier used in GraphQL.
Number6667 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL namePgBrLevThe database field name.
API identifierpageBreakLevelThe API identifier used in GraphQL.
Number8986 

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.

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 namePgElIdThe database field name.
API identifierpageElementIdThe API identifier used in GraphQL.
Number8946 

Page elem. no.

A unique number identifying the page element.

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 keyYesPage elem. no.
SQL nameSbWNoThe database field name.
API identifierpageElementNoThe API identifier used in GraphQL.
Number2505 

Page element flags 1

Settings defining the behaviour of the page element.

A look-up opens the dialog box where you can see the following check boxes and options:
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
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPage element flags 1Integer
SQL nameSbWFlThe database field name.
API identifierpageElementFlags1The API identifier used in GraphQL.
Number302 

Page element flags 2

Settings defining the behaviour of the page element.

A look-up opens the dialog box where you can see the following check boxes and options:
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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPage element flags 2Integer
SQL namePgElFl2The database field name.
API identifierpageElementFlags2The API identifier used in GraphQL.
Number8774 

Page element flags 3

Settings defining the behaviour of the page element.

A look-up opens the dialog box where you can see the following check boxes and options:
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
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPage element flags 3Integer
SQL namePgElFl3The database field name.
API identifierpageElementFlags3The API identifier used in GraphQL.
Number8947 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL namePgAtOnceThe database field name.
API identifierpagesAtOnceThe API identifier used in GraphQL.
Number8988 

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

A look-up opens the dialog box where you can see the following check boxes and options:
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.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPreferencesInteger
SQL namePrFlThe database field name.
API identifierotherPreferencesThe API identifier used in GraphQL.
Number286 

Print destination

The current print destination.

Is normally set with commands in the Printing group in the Design tab.

A look-up in this field gives you the following list of possible values:
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.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPrint destinationInteger
SQL namePrnDstThe database field name.
API identifierprintDestinationThe API identifier used in GraphQL.
Number16362 

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

A look-up opens the dialog box where you can see the following check boxes and options:
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).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPrint optionsInteger
SQL namePgFlThe database field name.
API identifierpageSetupFlagsThe API identifier used in GraphQL.
Number8991 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainReport nameText (32)
SQL nameRepNmThe database field name.
API identifierreportNameThe API identifier used in GraphQL.
Number11989 

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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainReport no.Integer
SQL nameRepNoThe database field name.
API identifierreportNoThe API identifier used in GraphQL.
Number16361 

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainReport parametersText (240)
SQL nameRepParThe database field name.
API identifierreportParametersThe API identifier used in GraphQL.
Number10803 

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

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
SQL nameResRowsThe database field name.
API identifierrowsInResultsetThe API identifier used in GraphQL.
Number6524 

Std. column heading colour

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainColourInteger
SQL nameColThe database field name.
API identifierstandardColumnHeadingColorThe API identifier used in GraphQL.
Number7602 

Surrounding area background colour

Press * or double-click to select colour.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainColourInteger
SQL nameBkColThe database field name.
API identifiersurroundingAreaBackgroundColorThe API identifier used in GraphQL.
Number8605 

Table no.

The table the page element shows data for.

You can select a table by looking up in this field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainTable no.Integer
SQL nameTabNoThe database field name.
API identifiertableNoThe API identifier used in GraphQL.
Number278 

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

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

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.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainColourInteger
SQL nameTitColThe database field name.
API identifiertitleColorThe API identifier used in GraphQL.
Number8720 

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.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainFontInteger
SQL nameTitFSzThe database field name.
API identifiertitleFontSizeThe API identifier used in GraphQL.
Number8718 

User name

The user the page element 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.
Number277 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
UserUser
  • User name

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.

A look-up opens the dialog box where you can see the following check boxes and options:
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.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainWhat page element flagsInteger
SQL nameWhSbWFlThe database field name.
API identifierwhatPageElementInformationThe API identifier used in GraphQL.
Number301 

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

Tip:
If a value is added to the field double-clicking or pressing * displays the file. If no file is selected a Select file dialog will be opened.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFile nameText (260)
SQL nameWrFNmThe database field name.
API identifierwriteToFileNameThe API identifier used in GraphQL.
Number8992 

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