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:
-
Select the add to UK check box on the fields to be added to the unique key.
-
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.
-
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.