Searching for table column

Use this procedure to search for table columns of M3 Business Engine (BE) system and version.

  1. On the Search tab, click Search By System Configuration.
  2. In the Keywords field, specify a keyword to search.
  3. Select the MDP BE System.

    See System configuration fields.

  4. Select an entity: Table Column.

    See M3 BE entities.

  5. Click the link to More Options for additional search filter.
    1. Select a component.
    2. Set the search limit. The default value is 500.

    See System configuration advanced search.

  6. Click Search.

    On the Search Results tab, the Entity: Total match and a data list with this information is displayed:

    Column heading Description
    Column Name Name of the column.
    Description Description of the column.
    Data type Data type of the column.
    Length Length of the column.
    Decimals Decimals of the column.
    Edit code Edit code of the column.
    Indexes List of index names.
    Parent table Name of the Parent table of the column.
    Component Component of the column.
  7. Use these options to manage the results:

    • To sort the results alphabetically or numerically, click the Sort icon located in one or more column headings.

    • To filter the results, click the Filter icon in the last column and type a dynamic free text filter for each column.

  8. To view table relations, click a Parent Table name.

    See Viewing columns of a parent table.