Create a sample commodity code - Intergraph Smart Reference Data - Help - Hexagon

Intergraph Smart Reference Data Help (10.2)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

Purpose

This section explains how to create table detail-based commodity codes, and by means of predefined commodity rules. A commodity code with its descriptions and layouts describes a component with all its properties, but without the dimensions.

The following work process diagram explains how a commodity code is generated. After you finish the process, a commodity code VBAAABAZABBF is generated for the part B.

CommodityCodes_F

Create a commodity rule

  1. Click SRD > XS10 Component Manager > XS1010 Commodity/Ident Management.

  2. In the drop-down list at the top, select Commodity Rules.

  3. Click Add Add and in the Rule box, type P_VLV_W_OP.

    CCRules

  4. (Optional) Complete the other properties for the new commodity rule.

Add tables to a commodity rule

  1. Double-click the P_VLV_OP commodity rule.

  2. Click Edit grid.

  3. Click Add row Add, and select Table Name P_ALIAS. Similarly add rest of the tables as shown:

    CCRules_Tables

Assign commodity keys

  1. Right click the P_VLV_OP commodity rule and then click Manage Commodity Keys.

  2. In the Commodity Keys grid, click Edit grid .

  3. Click Add row Add , and select tables from the Table Name pane.

    Use Open to view the tables. Select Table Names Count and then drag the tables to the Commodity Keys grid. If you are dragging P_DIM_STD with the Table Names Count as 3, you will see three tables with P_DIM_STD in the Commodity Key grid .

  4. Add the following commodity keys as shown.

    CCKyes

The above rule generates a code with 12 characters. Each character represents the value of the table details based on the commodity keys defined for the rule.

Create commodity table group and assign commodity rule

  1. From the Data: Explorer drop-down, select Commodity Group.

  2. Click Add Add and then in the Group Code box, type VBB.

  3. In the Rule Code box, click Browse, and then select P_VLV_OP.

  4. Click Refresh . The newly added commodity group is displayed in the tree view.

Add commodity parts

  1. Double-click a commodity group to open the grid.

  2. Click Edit grid.

  3. Click Add row.

  4. In the new row, type Part Code as B for the new part.

Rule is automatically populated as commodity group is based on the rule.

Add table details and generate commodity codes

  1. From the Data Explorer drop-down, select Commodity Group/Part/Commodity Code.

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

  3. Click Edit grid .

  4. Click Add row .

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

    • M_COMMODITY_GROUPS - VBB

    • M_PARTS - B

    • P_ALIAS - AAA

    • P_ALIAS_TRIM - AAA

    • P_DIM_STD - AA

    • P_SYSTEM - B

    • P_MATERIAL - AAA

    • P_MAT_SYSTEM - Z

    • P_RATING - A

    • P_VLV_BODY_TYPE - B

    • P_VLV_OPERATOR - B

    • P_END_PREP - FJ

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

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

Commodity Code Generated

Character

Digit ID

Table Name

Table Detail

VBAAABAZABBF

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

B

6

P_SYSTEM

B

A

7

P_MATERIAL

AAA

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