Editing the table overview

Use this procedure to edit the properties of a table of a database interface.

  1. In the Table pane, select a table. The Table Overview pane is displayed.
  2. Specify this information:
    Name
    Specify a new table name.
    Description
    Specify a new description of the current table The abbreviation of the file type is placed first in the description.

    These are the different types of abbreviations:

    • MF – Master table

    • PT – Temporary program table

    • SF – System table

    • ST – Temporary session table

    • TF – Transaction table

    • WF – Work table

    The text line ends with the field prefix of the file within parenthesis.

    For example, MF: Item master file (MM) For JOIN tables, the text line contains the tables joined in this file. For example, Join: MWRKMA, MWRKOP.

    File Type
    Select the abbreviation of the file type as described above.
    Tablespace
    Select the tablespace that the table is connected to. These tablespaces are created for tables in an M3 BE database:

    • TMVXL – large extent size > 1 000 000 rows

    • TMVXM – medium extent size 10 000 < rows ≤ 1 000 000

    • TMVXS – small extent size 100 < rows < 10 000

    • TMVXT – tiny extent size < 100 rows

    Browse program
    This field is only applicable for M3 Business Engine 14.1.2 or later.

    Specify the main program used to display and edit data in the table. It does not need to be a menu function.

    Archiving function
    This field is only applicable for M3 Business Engine 14.1.2 or later.

    Specify the menu function name of an archiving program where the table is included.

    Mass delete function

    This field is only applicable for M3 Business Engine 14.1.2 or later.

    Specify the menu function for a mass delete program where the table is included.

    Program heading for description
    This field is only applicable for M3 Business Engine 14.1.2 or later.

    Specify a program heading that will be used for description.

    Comment
    Specify comments to describe the use of tables. These comments can also be applied by using the CommentDB administration tool.
  3. Press CTRL+S to save the changes. The changes are now applied to the Table Overview.