Create the Commodity Rule - Intergraph Smart Reference Data - Version 10.1 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (10.1)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.1

Standard Database for Smart Reference Data (SDB) has a set of commodity rules that cover over a million items. Review the existing rules on S.10.01

The SDB rules always contain two table details:

  • P_SYSTEM to indicate the “country” of the standards

  • P_MAT_SYSTEM to indicate the “country” of the material codes

In addition, the sight glass requires:

  • P_END_PREP for end preparation Raised Face Flange End

  • P_DIM_STD for the dimensional standard

  • P_MATERIAL for the material code

  • P_RATING for the rating of the flange

  • P_ALIAS for the other information, such as glass material

  1. Open the S.10.01 Commodity Rules screen.

  2. Click Run Query so that you see all the rules delivered in SDB

  3. Scroll through the various rules to see if any of the rules fits the table detail requirements.

    The P_RAT_FITT (Rating Fittings) rule could be used because it has all the required tables, assuming we put all the sight glass body material details in an alias table.

    SHARED Tip Before deciding on the rule, consider the rule structure (in particular, the number of characters) and the group and part you are going to use.

  4. Open the S.10.03 Commodity Part screen.

    Looking at the commodity groups and parts, it would be best to add the sight glass under the Miscellaneous Piping (MP) group, with a new Part (SG).

    SHARED Tip There will be two characters for the commodity group and two characters for the commodity part.

  5. Return to the S.10.01 Commodity Rules screen, and select the P_RAT_FITT rule.

  6. Click Go to next block twice to open Window 2.

    This rule structure (commodity keys) does not suit us as it takes only one character from the commodity group and three characters from the commodity part, whereas the commodity group (MP) and the commodity part (SG) in our example have two characters. Because this might cause an inconsistency, we create a new rule.

  7. Click Go to previous block twice to go back to Window 1.

  8. To copy the existing rule, select the P_RAT_FITT rule and click New record (or press F6).

  9. Press F4 to copy the previous rule, change the rule name to P_SIGHT_GL, and change the short description and the description to Sight Glass.

  10. Click Save (or press F10).

  11. Click Enter query (or press F7) and then press Run query (or press F8) to re-query the data to see the copied table details on the Commodity Attributes tab.

  12. To assign table names to the rule, click Go to next block twice to open Window 2.

  13. Select the second record with Digit Id = 2, click in the Tablename box, and select M_COMMODITY_GROUPS from the LOV. Or, press F3 to copy the table name from the box above.

    The P_ALIAS table was defined with Z in the Ins Char box. The assignment of a P_ALIAS table detail is not required when defining a commodity code. If P_ALIAS is not assigned, Z will be used instead for digit 17 and 18 of the commodity code. (SDB has expanded P_ALIAS codes from three to four characters, and as a result, you will see commodity codes with ZZZ and others with ZZZZ).

  14. Click Save (or press F10) to save the rule.

  15. Click Go to next block to open Window 3 where you can view and edit the commodity code layout text.

  16. Review the layout by removing unnecessary text (P_SYSTEM_SHORT/_LONG) and adding commas.

  17. Click Save (or press F10) to save the rule.

  18. On the update message, click Yes.

You can use this functionality to update all commodity code descriptions if you decide to change the layout, but this will take time depending on how many commodity codes have been created with this rule.