Validation of hierarchy table Link data

The specified information is validated when you create or modify a SCP hierarchy table link. The related error message is displayed, if the validation fails.

These are the validation rules:

Ensure that a value is specified for the mandatory field. Else, this error message is displayed:
```
This field is required.
```
This error message is displayed when a new hierarchy link is created using the table and hierarchy for which the hierarchy link is already defined:
```
Cannot Save Hierarchy Table Link {0}. There is already a Link defined between Hierarchy {1} and Table {2}.
```

This table lists the validation conditions and the related messages:


Field	Validation Condition	Error Message
Name	Check that the name of the table link is unique.	Cannot save Hierarchy Table Link with name "{0}" because the name already exists.
Name	Check that the name is populated.	Cannot save Hierarchy Table Link. Name is not specified.
Enabled	Check the possible values.	Hierarchy Table Link "{0}" has an incorrect Enabled flag. Valid values are true or false.
Table Name	Check that the name of the table is populated.	Cannot save Hierarchy Table Link "{0}". Table Name is not specified.
Table Name	Check that the specified table exists in the SCV core table registry.	Cannot save Hierarchy Table Link "{0}". Table Name cannot be resolved.
Hierarchy	Check that the hierarchy is populated.	Hierarchy for Hierarchy Table Link "{0}" is not specified.
Hierarchy	Check that the specified hierarchy exists in the SCV hierarchy configuration.	Cannot save Hierarchy Table Link "{0}". Hierarchy cannot be resolved.
Link Value	Check that the value is valid if type = Column (Table Hierarchy Value Column).	Cannot save hierarchy Table Link "{0}". Link Value cannot be resolved.
Link Value	Checks that the value is valid if type = Expression (Table Hierarchy Value Expression). Check if the specified value is a valid SQL select expression on "Table Name". Use "t" as table alias. For example, t.item_id.	Cannot save hierarchy Table Link "{0}". Link Value must be a valid SQL select expression. SQL Error: "{2}"
Link Value	Check that the values are valid if type = Query (Table Hierarchy Value Query). Check if the specified value is a valid SQL select statement. Check if the specified SQL selects one column with name/alias "id" and one column with name/alias "base_level_value".	Cannot save Hierarchy Table Link "{0}". The Query value must be a valid SQL select query returning 2 columns: id and base_level_value. SQL Error: "{2}"
Link Value	Check that the value is specified for Table Hierarchy Value, Table Hierarchy Value Column, Table Hierarchy Value Expression or Table Hierarchy Value Query.	Cannot save Hierarchy Table Link "{0}". Only one of Table Hierarchy Value, Table Hierarchy Value Column, Table Hierarchy Value Expression or Table Hierarchy Value Query can be defined.

Note:

For imported records, if the value is not specified:
- The System option is set to off.
- The Enabled option is set to On.
The values for Internal SCV fields, SC Ref Type and SC Ref are set to the default value.