The package combination for which a customer defined field must be defined.
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. Note In the data dictionary, the name is prefixed by ‘ 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:
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:
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 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 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 Checkbox or List. This table shows the possible values:
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:
The Extensibility feature can be used for adding for example a zoom option or additional fields of the reference table. Reference Mode Indicates whether or not the reference record must exist in the reference table. Allowed values
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. Calculated 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. Note The calculated fields functionality within CDF is deprecated. We strongly recommend that you use the Application Extensibility feature instead. See the Infor LN Extensions Development Guide. 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
Compares the values of two table fields and returns the highest value. Example 2 - data type Checkbox
Fills checkbox (1=ttyeno.yes, 2= ttyeno.no) based on the value of a table field. Example 3 - datatype String
Concatenates two table string fields. Note 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 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.
| |||||||||||||