Fluid class unique key - Intergraph Smart Reference Data - Help - Hexagon PPM

Intergraph Smart Reference Data Help Classic (2020)

Language
English (United States)
Product
Intergraph Smart Reference Data
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

On the S.60.12 Fluid Class Unique Key screen, define the project-specific unique key fields for the M_FLUID_CLASSES table.

The default unique key includes the following fields, and are highlighted with a red background:

  • FLUID_ID

  • SPEC_HEADER_ID

  • PROJ_ID

  • NOM_SIZE_MIN

  • NOM_SIZE_MAX

  • DIVISION

  • LOCATION

  • UNIT

If you want to change the unique key, proceed as follows:

  1. Select the add to UK check box on the fields to be added to the unique key.

  2. Clear the box for the fields to be removed from the unique key.

    If you clear all unique key fields, no unique key is defined for M_FLUID_CLASSES table.

  3. Click Save.

If you change (insert, delete, or update) a value of a field that belongs to the unique key, the software checks if any row exists in M_FLUID_CLASSES or M_FLUID_CLASS_ATTRS that would cause a unique key violation.