User-Defined Fields

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 Limitations.

Limitations

Managing user-defined tables through (CMS082) is only supported for:

Table	Program
MITVEN	'Supplier. Connect Item' (PPS040)
MPHEAD	'Purchase Order. Open' (PPS200)
MPLINE	'Purchase Order Line. Open' (PPS201)
OOHEAD	'Customer Order. Open' (OIS100)
OOLINE	'Customer Order. Open Line' (OIS101)

Follow these steps

Start 'User-defined Fields. Open' (CMS082).
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 definitions.
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 purposes.
- 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 purposes.
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.
Note: Value maps can only be created if the reference field is no longer than 20 characters.

The fields are now ready for use in the program that manages the table.