...
You can rename or customize table columns. Click the 3 Dot icon in the column heading and select the Rename and Customize Column option. Note that this option is available for attributes, not for system fields.
NameLabel – Enter a new name label for the attribute/column. Changing attribute names . As the label can be used as an identifier in calculation logics, it is advisable not to use spaces or special characters in the label. For the same reason, changing attribute labels can have an impact on the calculation logiclogics. Make sure that these are changed accordingly.
The column name label has to be unique. If you give the column an already existing namelabel, the change will not be saved.Label Translation – 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. Note that regular expressions are not supported here.
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.
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.
...
This functionality is available for Quotes, Agreements/Promotions, Rebate Agreements, Compensation Plans, Custom Forms, Rebate Records (and their groups), Price Records, Actions, Company Parameters , and Payout Records and (but note that attribute extensions added to Product, Customer and Seller ExtensionsExtension tables cannot be modified this way). It allows you to add an unlimited number (in theory) of columns of any type and this way scale the project size over the time. This is done through DB native JSON columns support. Note that on Oracle DB, mass edit is supported for versions 12.2 and higher.
...