Creating Property in SCV entity

To create a new property:

  1. Click '+' in the Properties tab. The Properties window is displayed.
  2. Specify this information in the Details tab:
    Name
    The name of the property.
    Display Name
    The name of the property that is displayed. If not specified, the value specified in the Name field is defaulted.
    Data Type
    The data type for the property. Possible values:
    • Text (NVARCHAR)
    • Decimal (FLOAT)
    • Integer (INT)
    • Date/Time (DATE/TIME 2(7))
    • Date (DATE)
    Number of Characters
    The numerical value that defines the length of the Data Type, Text.
    Nullable
    Sets the table value to Null if enabled.
    Business Key Sequence
    A unique sequential number assigned to the selected entity.
    Hash Key Sequence
    A unique sequential number that define the order in which the properties use the reference.
    Refresh Key
    Refresh the Property, if the value is set to On.
    Note: Only one property can be set to Refresh.
    Export/Publish Key
    Export or publish the Property, if the value is set to On.
    Note: Only one property can be set to Export/Publish.
  3. Specify the validation conditions in the respective sections (Constant, Expression and List of Values) of the Validation Rules tab.
    Note: The Validation Rules tab is disabled if the Staging Table option is set to Off in the Details tab.
  4. Click Add. A new row is added to the Properties list.
Parent topic: Creating SCV Entity