Defining Field Types

Objectives

After completing this lesson, you will be able to:
  • Explain the differences between Normal vs. Computed fields
  • Decide which field type to use

Normal vs. Computed Fields

When creating a new custom field, you need to choose whether the field will be defined as Normal or Computed. You may see the term derived in place of computed throughout this course and in product documentation. The two words should be considered interchangeable.

What are the differences between those two options?

Normal field specifications:

  • Are Reportable by default
  • Value is either defined by the end users in the UI, or it can have a calculated value
  • There are limited amounts of fields per class

Computed field specifications:

  • Value of the field must always be calculated based on specific logic or inherited from another existing field value
  • The field is not editable in the UI by end users
  • Fields cannot be made reportable
  • In Procurement, computed fields are commonly used for exporting custom object unique IDs to an ERP
  • There are limited amounts of computed fields per site
  • Derived fields can be recognized in Field Configuration by special icon.

Each custom field has a unique identifier with the prefix cus_. The field name cannot contain any special characters.

The remaining part of the name is calculated from the field label, however, both values can be manually changed during field creation.

Note:

  • On each class, field technical names must be unique.
  • Once the field is published, the field name and type cannot be modified.

Fields Types

When creating a custom field, you need to decide which field type to use. Depending on the class you are customizing, the following options may be available in the Type drop down in addition to the standard field types that may appear:

Type in General Tab drop downCorresponding Type in Class Browser
BooleanBoolean
DateDate
Date (Calendar)Date
Decimal NumberBigDecimal
Integerint
Flex Master DataDynamicFlexMasterData
Flex Master Data Multiple SelectDynamicFlexMasterData Vector
MoneyMoney
Multiline TextString
PercentageBigDecimal
TextString
Text Multiple SelectString Vector
URL LinkString
User Multiple SelectUser Vector

Note

Text and Integer fields can be associated to an Enumeration and Text Multiple Select fields must be associated to an Enumeration. Instructions on how to associate an Enumeration to a field are included in a later unit.

Access What field types are available for custom field requests for a comprehensive list of custom field types and their descriptions.

Log in to track your progress & complete quizzes