Champs définis par le client (ttadv4591m000)

Use this session to define the customer defined fields.

Rubriques liées

 

Combinaison d'applications
The package combination for which a customer defined field must be defined.
Table
The table for which a customer defined field must be defined.
Nom champ
The name of the customer defined field. This name is used to create the column in the table.

The name used is prefixed by ‘ cdf_ ’, so for example in case of field name ‘ fld1 ’ for table ‘ tdsls400 ’, the table name becomes tdsls400.cdf_fld1.

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 the same package as the defined customer defined field.
  • The label must be of type “General”.
  • Only labels with height 1 are allowed.
Remarque

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.

Data Type
The data type of the customer defined field.

Valeurs autorisées

Possible values

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. You can only specify the domains from the package of the table, or from the tables package tc and tx.
Generated Domain
When a generated domain is used for the CDF, this field shows the domain code that will be generated.
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 Chaîne.

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 Chaîne.

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.

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 which 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 Case à cocher or List.

In case of data type Case à cocher, the list is filled fixed with the constant descriptions linked to the standard ‘ttyeno’ domain, that is: ‘ Oui and Non.

In case of data type List, the list contains all constant descriptions present for the specified list, which are defined in the List Constants (ttadv4593m000) session.

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

Calculated Field
If this check box is selected, the value of the customer defined field is calculated through an expression. For information about what expression you can use, see the online help on the Expression field.
Expression
The expression to calculate the value of the customer defined field.

This field is a free string field where you can specify an expression that consists of 255 characters at most. The calculated result must match the selected data type. You can use all CDF data types to store a calculated value.

Example 1 - data type Nombre entier

CASE WHEN tedzw103.int1 > tedzw103.int2 THEN tedzw103.int1 ELSE tedzw103.int2 END

Compares the values of two table fields and returns the highest value.

Example 2 - data type Case à cocher

CASE WHEN tdsls401.pric>1000 THEN ttyeno.yes ELSE ttyeno.no END

Fills checkbox (1=ttyeno.yes, 2= ttyeno.no) based on the value of a table field.

Example 3 - datatype Chaîne

trim(tdsls400.refa) & trim(ttdsls400.refb)

Concatenates two table string fields.

Remarque

On runtime (only) the actual validation is done.

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.

 

Convert to Runtime
Starts the Convert to Runtime Data Dictionary (ttadv5215m000) session, which actualizes the specified modifications to runtime.
Print
Starts the Impression des champs définis par le client (ttadv4491m000) session, which enables you to print the customer defined field related data.
Lists
Starts the Lists (ttadv4592m000) session, which enables you to specify lists and their constants.