| # Customer Defined Fields (ttadv4591m000) Use this session to define the customer defined fields. 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. 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. 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. Data Type The data type of the customer defined field. Allowed values Possible values 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. In case of data type Checkbox, the list is filled fixed with the constant descriptions linked to the standard ‘ttyeno’ domain, that is: ‘ Yes and No. 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. 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 Integer `max(tedzw103.int1, tedzw103.int2)` Compares the values of two table fields and returns the highest value. Example 2 - data type Checkbox `tdsls401.pric>1000?1:2` Fills checkbox (1=ttyeno.yes, 2= ttyeno.no) based on the value of a table field. Example 3 - datatype String `tdsls400.refa & tdsls400.refb` Concatenates two table string fields. Note On runtime (only) the actual validation is done. 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. If a customer defined field is marked as calculated, no convert to runtime is required; therefore the indicator is set directly to ‘Yes’ during the update transaction. Convert to Runtime Starts the Convert to Runtime Data Dictionary (ttadv5215m000) session, which actualizes the specified modifications to runtime. Print Starts the Print Customer Defined Fields (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. |