Tables - Intergraph Smart Materials - Version 2020 (10.0) - Administration & Configuration - Hexagon PPM

Intergraph Smart Materials Classic Administration (2020)

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

Tables to be later used in Smart Reference Data for gathering data like commodity attribute groups and details, or geometric details, can be defined on the A.50.02 Tables screen.

In the first (Table Types) block, you define the category of the tables in the Description field and assign the appropriate table type from the list in the Type field. With the table type, you specify the function of the table (which screens will use the tables assigned to the type). The available table types with the associated screens are listed below.

Table Type

Table Type Short

Description

Associated Screen

COMMATTR

COMMATTR

Commodity Attributes

S.20.01/S.20.02

COMPANY

COMPANY

Company Tables

S.20.C.01/S.20.C.02/S.20.C.03

GEOM_S4010

GS

Standard Geometrics

S.40.10

GEOM_S4011

GO

Other Geometrics

S.40.11

GEOM_S4012

GC

Commodity Geometrics

S.40.12

GEOM_S4013

GF

Filter Geometrics

S.40.13

GEOM_S5020

GW

Wallthickness Geometrics

S.50.20

GEOM_S5021

GR

Rating Geometrics

S.50.21

GEOM_S5022

GT

Other Spec Geometrics

S.50.22

INTERFACE

INTERFACE

Interface Tables

S.20.I.01/S.20.I.02/S.20.I.03

OTHER

OTHER

Miscellaneous Tables

PHYSICAL

PHYSICAL

Physical database tables

all

SPEC

SPEC

Specification Tables

S.50.10/S.50.11

SPECIAL

SPECIAL

Special Tables

S.10.02

In the second (Table Names) block, you define the table name in the Name field and the table descriptions in the Short Desc and Description fields.

Click the Next Block button from the toolbar to open Window 2.

Here you can define table links. For more information about table links, read Commodity Codes with Linked Tables.

The table structure of the geometric tables and the attribute assignment of other tables must be defined on the A.50.03 Tables/Attributes screen.

In the first (Table Names) block, you select the tablename for which you want to define the structure. To limit the LOV in the Tablename field for selection of the table, you can use the table type for pre-selection.

The layout of the second (Attributes) block varies depending on the selected table type. For all tables except for geometric tables (table type GEOM_....), the layout looks like the picture above. To assign attributes to the selected table, select a predefined attribute from the LOV in the Attr Name field and the database column from the LOV in the Physical Attribute field. For table types COMMATTR, COMPANY, INTERFACE, and SPEC, you can assign attributes on the table group level (TG....) or on the table detail level (TD....). The attributes should be assigned to the appropriate physical attributes depending on the attribute type: assign Character attributes to ….CHAR1-3 and Number attributes to ….NUM1-3.

For all geometric tables (table type GEOM_S....), this second block looks like the picture below. Geometric tables are used on the screens S.40.10 - .13 and S.50.20 - .22. You can define up to five input columns and up to 15 output columns for geometric tables. To define a column for a geometric table, select an attribute from the LOV in the Attr Name field, and select the input (GD.IN1 - 5) or output (GD.OUT1 - 15) column in the Physical Attribute field. Next select the Kind of Attribute from the list and assign a unit using the LOV in the Unit field. With the selection of the Required indicator, you define the attribute as mandatory.

For example, the definition of table P_GASKET_FL is displayed in the picture below.

A geometric created on S.40.12 based on this table would look like the P_D016INCAT displayed below.

The structure of the commodity geometrics (table type GEOM_S4012) and maybe other geometrics corresponds with the object parameter details. You can use the <Copy Attributes from Object Param.> button to automatically assign all attributes from the selected object parameter to the table.