Related topics
This panel displays a list of information fields and their attributes. These are preloaded in your system via the Update preloaded application tables routine and retrieved from the Field reference file.
The Customer Management Console (CMC) uses these fields each time you select a CMC view to display customer related information.
On this panel you select the fields that apply to your company. You also define how these fields are to be displayed. The definitions made here are used for the creation of data sets in the Work with CMC data set routine.
Note:
Options
Selection fields
- Seq
- Enter any number between 0 and 9999 to select the field and to determine in what sequence it should be displayed and click OK. The selected fields are listed first and renumbered in intervals of ten. By sequencing the fields, you are able to create a logical grouping of the fields into useful groups of information.
- Field name
- Displays the code identifying the field name retrieved from the Field reference file.
- Len
- Displays the field length in bytes for alpha fields and the number of digits for numeric fields. This parameter is retrieved from the Field reference file for display purpose only and cannot be changed.
- DDL
- Displays the field display length, i.e., the actual length by which data is displayed in the Customer Management Console (CMC).
Work with CMC field definition file (DSR80204)
On this panel you can add new fields to your file or maintain the field definitions already included in a data set. This enables you to tailor the CMC for each customer installation.
Function keys
- Field
-
Note: The value entered in this field may be the same as in the FRF field field provided that the record is unique.
- FRF field
- Mandatory entry. Enter a code from the Field reference file. This parameter is used for retrieving data definitions preloaded in your system.
If the field is left blank, a description will be retrieved automatically from the Field reference file.
- Column heading long
- Enter the column heading, 20 characters long, to be used for field description in panels with one or two columns of information. If the field is left blank, the field description entered in the Description field on this panel will be retrieved.
- Column heading short
- Enter the column heading, 12 characters long, to be used for field description in panels with three columns of information. If the field is left blank, the system will automatically enter a short version of the column heading entered in the Column heading long field.
- Field length
- Displays the field length in bytes for alpha fields and the number of digits for numeric fields. This parameter is retrieved from the Field reference file for display purpose only and cannot be changed.
- Data display length
- Optional entry. Enter the actual length in bytes by which data is to be displayed in the Customer Management Console (CMC). For numeric fields, if the display length is not long enough to display the actual data value, “XXXXXX” will be displayed in the console. If a value is entered in this field, it must be less than or equal to the value displayed in the Field length field.
- Data type
- Optional entry. If the information in the field definition you are creating is alphabetical, set this field to YES to indicate that the information is to be translated before it is displayed, as defined in the Language table. If the information is numeric, enter a code to determine the number of decimals to be displayed based on system currency.
Code Description A Amount C Cost D Date. The format and date separator is determined by the system. P Price Q Quantity. No decimals will be used.
- Edit code
- Optional entry and only valid for numeric fields. Enter a code to convert numeric to alpha. Valid entries are: 1, 2, 3, 4, A, B, C, D, J, K, L, M, Q.
- Panel value group
- Optional entry. Enter a code from the Panel value group table to indicate that this field needs to be translated from database value into panel value before it is displayed in the Customer Management Console (CMC).
- Database files
- Enter the DC1 database file(s) that you wish to view to find a record. If more than one file is used they must be separated by a comma.
- Database field
- Enter the name of the field from which the value is retrieved. The entered field must be one of the database files entered in the Database files field.
- Key values
- Key values are used to specify how the value is retrieved, i.e. the selection criteria using SQL syntax. Selection must be made among the fields specified in the Database files field on this panel, or of type &CUNO for reference to the selected customer in the CMC.