Customer Defined Fields (ttadv4591m000)

Use this session to define the customer defined fields.

Note: 
  • Text fields added to a session with extensions are read-only. You can edit the texts, in multiple languages, in the sessions where the table with the customer defined text fields is the main table.
  • If you run this session in the cloud, the calculated fields functionality is not available. Instead, use the Application Extensibility feature for calculated fields. See the Infor LN Extensions Development Guide.

Actualizing the changes

To actualize the changes to runtime, on the appropriate menu, select Convert to Runtime. The Convert to Runtime Data Dictionary (ttadv5215m000) session starts. Follow the instructions described in the online help of that session.

Field Information

Package Combination

The package combination for which a customer defined field must be defined.

Table

The table for which a customer defined field must be defined.

Field Name

The name of the customer defined field. This name is used to create the column in the table.

Note: In the data dictionary, the name is prefixed by ‘ cdf_ ’. Therefore, for example in case of field name ‘ fld1 ’ for table ‘ tdsls400 ’, the field name becomes tdsls400.cdf_fld1.
Multi Language

If this check box is selected, the field can store application data in multiple data languages.

Note: 

The field is only displayed if the Multi Language feature is enabled and at least two data languages are available on runtime.

If you run LN in the cloud, see Configuration Multilanguage Fields Support (CE).

If you run LN on premises, see Configuration Multilanguage Fields Support (OP).

Multi Language fields are only allowed for fields of the string data type. If an existing domain is used, the domain must be a multibyte string.

Multi Language is not allowed for these fields:

  • Fields that are marked as array, and the number of elements exceeds 1.
  • Fields that are marked as calculated.
  • Fields that refer to a related table.
Number of Elements

If the field is an array field, specify the array depth. That is, specify the number of times the field must occur in the table with the same name and characteristics.

Array fields are not allowed for calculated fields and fields of the Text data type.

At runtime, customer defined array fields show this behavior:

  • All individual elements of an array field are added on the UI. The maximum number of elements is 99.
  • All individual elements have the same description as the customer defined field.

To suppress elements or change the description, use form personalization.

Allowed values

1-99

Default value

1

Label

A customer defined field is identified by a label or a fixed description.

In case of a label, specify the label code here. The label must include the package code.

Constraints:

  • The label must be present in the linked package combination.
  • The label must be present in one of these packages:
    • The same package as the defined customer defined field
    • The tx package
  • The label must be of type “General”.
  • Only labels with height 1 are allowed.
Note: For translatability, we recommend that you link a label code, instead of a fixed description, to a customer defined field.
Description

Description to identify the customer defined field.

You can only edit this field if the Label field is empty. If the Label field contains a label code, the description of the longest label present within the linked package combination is displayed. Otherwise, the actually specified (fixed) description is displayed. This description is used in the UI.

Hidden (overview)

If this check box is selected, it indicates that the field is initial hidden for overview (multi occurrence) type of sessions.

Hidden (detail)

If this check box is selected, it indicates that the field is initial hidden for detail (single occurrence) type of sessions.

Hidden (MMT Controller)

If this check box is selected, it indicates that the field is initial hidden for Multi Main Table Controller (header) type of sessions (for all fields). The fields can be made visible with Form Personalization.

Data Type

The data type of the customer defined field.

Allowed values

String

Used for text; data type ‘multi byte string’. The default Input Length and Display Length is 30.

Integer

Used for whole numbers; data type ‘long’. The default number of digits is 10.

Numeric

Used for numbers containing a decimal point; data type ‘double’; default maximum number of digits before decimal point: 9, after: 5.

Date

Used for date/time; data type ‘UTC Date/Time’.

Checkbox

Used for check boxes; data type ‘enumerated’.

The domain must be defined as check box within the Domains to be Displayed as Checkbox (ttgfd4520m000) session.

List

Used for a list of constants; data type ‘enumerated’.

The domain must not be defined as check box within the Domains to be Displayed as Checkbox (ttgfd4520m000) session.

Text

Used for texts; data type ‘text’.

In both, overview and details sessions, the added CDF texts are added automatically to the Text button menu.

The CDF texts are preceded by "CDF". For example, the Text button menu can contain these texts:

  • Text A
  • Text B
  • CDF Text A
  • CDF Text B

In this example, Text A and Text B are standard; CDF Text A and CDF Text B are custom.

In details sessions, the texts are displayed as multi-line edit boxes within the Configurable Fields part: texts are visible by default and can be made hidden through Personalize Form. The size of the multi-line edit boxes is fixed and cannot be customized. The length is 80 characters and the height is 8 lines.

Use Existing Domain

A Customer Defined Field can either use a domain generated based on the specified settings, or an existing domain. In case of an existing domain, specify the package and domain here.

Generated Domain

When a generated domain is used for the CDF, this field shows the domain code that will be generated.

String Length

The length of the customer defined field in the database. When an existing domain is used, the value of the selected domain is shown.

You can only specify a length for fields of type String.

Display Length

The display length of the customer defined field. When an existing domain is used, the value of the selected domain is shown.

You can only specify a length for fields of type String.

Number of Digits before Decimal Point

For data type Integer, this is the maximum number of digits. For data type Numeric this is the maximum number of digits before the decimal point.

Specify this field for data types Integer and Numeric. When an existing domain is used, the value of the selected domain is shown.

Number of Digits after Decimal Point

The maximum number of digits after the decimal point.

Specify this field for data type Numeric. When an existing domain is used, the value of the selected domain is shown.

Display Format

The display format that is used in forms and reports to display the data of this CDF.

Specify this field for data type Integer, Numeric and Date. When an existing domain is used, the value of the selected domain is shown.

For data type Date, the Display Format has an effect on reports, not on sessions.

List

The list that contains the constants for a customer defined field of data type List.

Initial value

The default value for a data type Checkbox or List.

This table shows the possible values:

Data type Possible values
Checkbox

DefaultIf an existing domain is used, the possible values are the checked and unchecked value defined within the Domains to be Displayed as Checkbox (ttgfd4520m000) session. The unchecked value is used as the initial default.

DefaultIf a standard domain is used, the possible values are fixed: Yes and No, based on the ttyeno standard domain.

List The possible values are based on the selected domain or specified list code. In both cases, the first constant is used as initial default.

For all other data types the initial value is empty and not editable.

Reference Table

The related table to which the customer defined field refers (also known as parent table).

Notes:

  • No support for combined fields, only single field references are allowed.
  • For fields of data type Text, the reference data is filled automatically; the data is not editable.

The Extensibility feature can be used for adding for example a zoom option or additional fields of the reference table.

Reference Mode

Indicates whether the reference record must exist in the reference table.

Allowed values

Mandatory The reference record must exist in the reference table.
Mandatory unless empty (Default) Same as Mandatory, but the reference record can be blank.
Reference Message

The message that is displayed in case no related record in the reference table exists.

Delete Check

If this check box is selected, the deletion of the parent is restricted if any child refers to the parent.

If this check box is cleared, and the parent is deleted, no check or action is performed on the child records that refer to the parent. In that case, the referential integrity of the database cannot be guaranteed.

Internal Use

Indicates whether the field is for internal or external use, such as external reports.

Active

If this check box is selected, the customer defined field is displayed in the UI.

Available

If this check box is selected, the customer defined field is actually available on runtime.

This field is not editable and only set to ‘Yes’ after a successfully processed convert to runtime of the customer defined field.

For calculated fields a convert to runtime is required, when the field is linked to a domain that is not converted to runtime. Therefore the field is not always set to ‘Yes’ automatically.

Origin

This field can have two values, Manual and From PMC.

  • Manual

    The Customer Defined Field is created in Customer Defined Fields (ttadv4591m000) session and is not overwritten by a PMC solution. This Customer Defined Field is not removed when the table is overwritten with a new PMC solution, but if the solution has a Customer Defined Field with the same name for the same table, it receives the origin value From PMC.

  • From PMC

    A Customer Defined Field received from a PMC solution. This customer defined field is removed when the table is overwritten with a new PMC solution that does not contain this Customer Defined Field anymore. If you overwrite this field with session Import Customer Defined Fields (ttadv4292m000) the origin value remains From PMC.