This document describes how user-defined fields are used.
'User-defined Fields. Open' (CMS082) can
be used to specify headings, field length, allowed values, and other information for
user-definable fields in certain programs.
The setup is similar to M3 Customer-Defined Fields (CDF), but the main
difference is that the user-definable fields are fixed columns in the main table and their
values can be retrieved and updated in the same transaction as the rest of the columns. One
advantage of this is that integrations are easier to make, although customization might be
compromised. This functionality only supports the specific fields in specific tables. See
Managing user-defined tables through (CMS082) is only supported
||'Supplier. Connect Item' (PPS040)
Follow these steps
- Start 'User-defined Fields. Open'
- Use the function key F14='Generate' to generate a standard definition for the supported
fields. You can either specify a supported table or leave the field blank to generate for
all supported tables. The generation will not overwrite already existing field
- Select option 2='Change' to customize the fields. Specify the name, description, and
translations of the field or set a message ID. A category can be set for informational
- For string fields, a maximum field length can be set which will limit the possible
input and determine the size of the field on the panel. The uppercase setting
indicates whether the field values will automatically be stored as uppercase.
- For numeric fields, specify the maximum number of decimals. Also indicate whether
the input should be validated against a minimum or maximum value, or if it must be
evenly divisible by a multiple. An edit code can be specified for informational
- If only a set of predefined values is acceptable as input, use option
11='Value Map' to start 'User-defined Fields Value Map. Open'
(CMS083). For the table and field, create the allowed values and their
translations. A sequence number can be set for each allowed value if you want to, for
example, use a custom sorting of values in prompt dialogs.
are now ready for use in the program that manages the table.