Commodity Attributes - Intergraph Smart Materials - Version 2020 (10.0) - Training - Hexagon

Intergraph Smart Materials Classic Lab Tutorials (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Training
Smart Materials/Smart Reference Data Version
2020 (10.0)

Purpose

This section explains how to define commodity attributes (properties). These property values, which are needed to create commodity codes, are stored in tables of type commodity attribute.

Exercise

  1. Open the A.50.02 Tables screen from the Administration > A.50 Database Structure menu branch. The screen opens in query mode; all fields are empty and displayed with a yellow background.

    screen1

  2. Select COMMATTR from the drop-down list in the Type field.

    screen2

  3. Click the Run Query question mark button to display the selected table type.

    screen3

  4. Click in the Name field in the second (Table Names) block.

  5. Click the Enter Query question mark button.

  6. Enter P_END_PREP into the Name field, or select it from the LOV using the List of Values button.

    screen4

  7. Click the Run Query question mark button to display the selected table. This table represents the End Preparation property; we will further use it in this exercise.

  8. Close the screen by selecting File > Close or Close All from the main menu

    File menu

  9. Open the S.20.01 Tablenames with Groups screen from the Smart Reference Data > S.20 Commodity Attributes menu branch. If the screen is not in query mode (all fields empty and displayed with a yellow background), click the Enter Query question mark button.

  10. Enter P_END_PREP in the Tablename field in the first block, or select it from the LOV using the List of Values button.

  11. Click the Run Query button to display the selected tablename with its groups.

    The second (Table Groups) block shows the existing groups of the selected table. Click the WELD group; it will be used later in this exercise.

    • The purpose of the WELD group is to contain all values for the End Preparation property for butt weld components.

    • At least one group must exist for a table to make this table available on S.20.02 for defining the table details (property values).

  12. Close the screen by selecting File > Close or Close All from the main menu.

  13. Open the S.20.02 Tablenames with Details screen from the Smart Reference Data > S.20 Commodity Attributes menu branch. The screen opens in query mode; all fields are empty and displayed with a yellow background.

  14. Enter P_END_PREP in the Tablename field and WELD in the Group field, or select both values from the LOV using the List of Values button.

  15. Click the Run Query button to display the selected tablename and group with its details.

    • The second (Details) block shows the existing table details (property values) of the selected table and group.

    • The table details represent the property values; for example, the purpose of detail BE is to define the value ‘Bevelled End’ of the End Preparation property.

  16. Close the screen by selecting File > Close All from the main menu.