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.
  4. Select an entity: Table Column.
  5. Click the link to More Options for additional search filter.
    • Select a Component.
    • Set the Search Limit. The default value is 500.
  6. Click Search.

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

    Column Name
    The name of the column.
    Description
    The description of the column.
    Data type
    The data type of the column.
    Length
    The length of the column.
    Decimals
    The decimals of the column.
    Edit code
    The edit code of the column.
    Indexes
    The list of index names.
    Parent table
    The name of the Parent table of the column.
    Component
    The 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 specify a dynamic free text filter for each column.

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