Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Name – Enter a new name for the attribute/column. Changing attribute names can have an impact on the calculation logic. Make sure that these are changed accordingly.
    The column name has to be unique. If you give the column an already existing name, the change will not be saved.

  • Label – You can add a translation for the column's label by clicking the Translation Editor icon. The translated label will be displayed in the corresponding language version of the user interface. In the Locale column of the editor, use the language code that you see in the locale URL parameter, e.g., 'de' for German.

  • Description – Add or change the description of the column.

  • Color – Set a color for the column.

  • Extra Styling – Specify extra styling in the form of CSS declarations (e.g., color: red; font-weight: bold).

  • Type – Change the type of the column.
    The type value Entity Reference allows you to create a link to another object. The object type is specified in the Entity Reference Type where you can select from: Product, Customer, Quote, Rebate Agreement, Agreement/Promotion and Data Change Request. The link usage is supported at the following pages: Customer Extensions, Customers, Price List items, Price Grid items, Price Records, Product Extensions, Products, Simulation items, Rebate Records, Company Parameters values.

  • Restrict Values – The following options are available:

    • by List – You can manually enter the values e.g., 1, 3, 10.

    • by Filter – You can build a filter to restrict the data, e.g., greater than 1 and less than 10.

    • by Data Source – You can reference another table in the system and its field whose values will be selectable in the column's drop-down list. In addition to default system tables, you can add almost any other table to the list of data sources using the Add columns to "Rename ... / Restrict Values list menu option.
      (info) See also How to restrict values in drop-down in Company Parameter key column based on another Company Parameter column.

  • Required – If enabled, users will be required to enter a value in this column.

  • Read Only – If enabled, users will not be able to edit values in this column.

  • Do not display warnings for this section – If enabled, user warnings are not displayed when making changes in this dialog.

  • Attribute extension (JSON column) – Identifies an attribute extension that is stored in the database as a JSON column.

  • Integration Tag – Available for Manual Price Lists. This tag can be used in filters that work with element names. See Integration Tags for details.

...