Add table details and generate commodity codes - Intergraph Smart Reference Data - Version 10.2 - Training - Hexagon

Intergraph Smart Reference Data Training (10.2)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Training
Smart Materials/Smart Reference Data Version
10.2
  1. From the Data Explorer drop-down, select All Commodity Groups/Commodity Group/Part/Commodity Code.

  2. Expand VBB, Ball Valves and double click the commodity part B, Swing Type.

  3. Click Edit grid Edit grid.

  4. Click Add row Add icon.

  5. In the new row, enter the following table details for the table names:

    • P_ALIAS (Group)– VB_US

    • P_ALIAS (Detail) – AAA

    • P_ALIAS_TRIM (Group)- VB_US

    • P_ALIAS_TRIM (Detail) – AAA

    • P_ DIM_STD (Group) – VB_US

    • P_DIM_STD (Detail) – AA

    • P_SYSTEM (Group) – US

    • P_SYSTEM (Detail) – A

    • P_MATERIAL (Group) – FORG_US

    • P_MATERIAL (Detail) – A4

    • P_MAT_SYSTEM (Group) - BZ

    • P_MAT_SYSTEM (Detail) – Z

    • P_RATING (Group) – RAT_US

    • P_RATING (Detail) – A

    • P_VLV_BODY_TYPE (Group) – VB_ALL

    • P_VLV_BODY_TYPE (Detail) – B

    • P_VLV_OPERATOR (Group) – ALL

    • P_VLV_OPERATOR (Detail) – B

    • P_END_PREP (Group) – VALVE

    • P_END_PREP (Detail) - FJ

  6. Click Save grid Save grid icon .

  7. Click Read-only grid Read-only grid to set the grid back to read-only mode.

Commodity code VBAAAAAZABBF is now generated. The following table shows how each character of the code is represented:

Commodity Code Generated

Character

Digit ID

Table Name

Table Detail

VBAAAAAADBCR

V

1

M_COMMODITY_GROUPS

VBB

B

2

M_PARTS

B

A

3

P_ALIAS

AAA

A

4

P_ALIAS_TRIM

AAA

A

5

P_DIM_STD

AA

A

6

P_SYSTEM

A

A

7

P_MATERIAL

A4

Z

8

P_MAT_SYSTEM

Z

A

9

P_RATING

A

B

10

P_VLV_BODY_TYPE

B

B

11

P_VLV_OPERATOR

B

F

12

P_END_PREP

FJ

question Can you guess what will be the commodity code, if you add another P_VLV_BODY_TYPE key with the value Z?

SHARED Tip To duplicate the existing commodity code, right-click the commodity code either in the tree view or in the grid, and click Duplicate or Duplicate Row respectively.