Editing and viewing table metadata
Click here to see this page in full context

Editing and viewing table metadata

Metadata is data about data. When you open the page, the available tables are listed with the option to edit or view them. For each table and column, you can edit the FAST or ERP comments.

Required roles:

To edit the table metadata you must have the ADMINS role or the EDITMETADATA_FASTSTU role.

To edit table metadata:

  1. On the Administration menu, click Table Metadata.

The list of tables opens; the last column shows the edit or viewing icon.

  1. Find the table and click one of the following:

  2. i_pencil.gif to edit a table.

  3. Click to view metadata to view a table. Skip to Step 10.

The Table/Column Metadata form opens.

  1. You can change the Fast Comment. This is the FAST comment about the table.

  2. You can add your ERP Comment. This is where you can explain what the table does in your ERP.

  3. Click i_save.gif Save. The FAST and ERP comments are concatenated (linked together) and applied to the database.

The Revert button opens—you can click it to change the comments back to their original state.

  1. You can find the Column Name you want to edit and click i_pencil.gif.

  2. You can change the Fast Comment. This is the FAST comment about the column.

  3. You can add your ERP Comment. This is where you can explain what the column does in your ERP.

  4. Click save i_save.gif. The FAST and ERP comments are concatenated (linked together) and applied to the database.

The i_xdelete.gif opens—you can click it to revert/change the comments back to their original state.

  1. Click Close to exit the form.

Related Topics: