Creating SCV Constraint
To create a SCV Constraint:
- Select Configuration > SCV > Constraints.
- Click New.
- Specify this information:
- Name
- A unique name of the Constraint.Note: This field is disabled for the existing SCV Constraint.
- Table
- The table name, based on which the constraint is defined.
- Description
- The description of the Constraint.
- Type
- The type of the Constraint. Possible values:
- Primary Key
- Business Key
- Foreign Key
- Hash Key
- Change Key
- Order Number Key
- Export Key
- Refresh Key
- Parent
- Indicates, if the Foreign Key Type Constraint is a
reference to the parent table. Possible values:
- On
- Off
Note: This field is visible only if the Type of the constraint is set to Foreign Key. - Referenced Constraint
- A reference to the Business Key or Primary Key
Constraint.Note: This field is visible only if the Type of the constraint is set to Foreign Key.
- Enabled
- Indicates the status of the Constraint. Possible values:
- On (Active)
- Off (Inactive)
Note: By default, the field is set to On. - System
- Indicates if the Constraint is system defined or user
defined.Note: This option is enabled for the constraint defined by the system.
- Click '+' in the Constraints section to add a new column.
-
Specify this information:
- Column
- The columns to be included in the constraint from the selected Table.
- Sequence
- The numeric value (except zero) that indicates the position of the Column in the constraint. The Sequence must be defined for each Column.
- Click Add. A new row is added to the Constraints section.
- Repeat Steps 4, 5 & 6 to add multiple columns.
-
Click Save. The new SCV Constraint
is created after successful validation of the specified information.
Note: You can use the Constraint list page to:
- Create a duplicate of the existing SCV Constraint and modify the parameters as required using the Duplicate option.
- Delete SCV Constraints using the Delete option.