Create a User-Defined Field (UDF)

Home | FAQs & Troubleshooting

                      

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

You can create any number of user-defined fields (UDFs) for a given entity; however, the total number of characters for all UDFs cannot exceed 20,000. When a new UDF is created or a change is made to an existing UDF, the ODBC Dictionary file and other system files are updated automatically to reflect the changes.

The UDFs defined for a table are defined for all companies; different sets of UDFs cannot be created for each company. You can, however, use the Customizer module to create panels containing different UDFs for each company. The field name, control type, and other attributes that determine the type of information to store in the field can be specified for each UDF.

Note Panels in the Customer Relationship Management module cannot be customized, and UDFs cannot be created for Customer Relationship Management tables.

 

Use one of the following methods to create a UDF:

  • To create a UDF for modules other than Material Requirements Planning and Work Orderr

  • To create a UDF for the Material Requirements Planning and Work Order modules

    •  

    To create a UDF for modules other than Material Requirements Planning and Work Order

    1. Select Custom Office Main menu > User-Defined Field and Table Maintenance.

    2. Select the table to add the UDF to.

    3. In the User-Defined Fields window, click Add.

    4. In the Add Field window, enter the field name and description. For more information, see Add Field - Fields.

    5. To copy the UDF definition and data from another field, select Business Object and select the data source and column. To enter all UDF data manually, select Manual Entry.

    6. Click OK. A second Add/Edit Field window appears.

    Note  If the field properties are based on a business object selected in Add Field, [Sourced] appears next to the field, and the field properties cannot be changed.

    1. In the second Add/Edit Field window, change the description if desired. Select a control type. For more information, see Add Field/Edit Field - Fields.

    2. Click the Attributes tab, and enter the UDF attributes.

    3. Click the Validation tab, and enter the data validation types. To validate the UDF against an existing user-defined table (UDT) whose key field length is the same as that of the UDF, select User-Defined Table. Click OK.

    4. In the User-Defined Fields window, click OK.

    5. When you are prompted to update the ODBC data dictionary and UDF data files, click OK.

    After you have created the UDF, you can add it to a panel or a Crystal report. For more information, see Add a User-Defined Field (UDF) to a Panel.

     

    To create a UDF for Material Requirements Planning and Work Order modules

    1. Select Custom Office Main menu > User-Defined Field and Table Maintenance.

    2. Select the module and table you are adding the UDF to. Click the Edit Fields button at the top of the User-Defined Field and Table Maintenance window.

    3. In the User-Defined Fields window, click Add.

    4. In the Add Field window, type the field name and description. Select a control type. For more information, see Add Field - Fields.

    5. Click the Attributes tab, and enter the UDF attributes.

    6. Click the Validation tab, and enter the data validation types. Click OK.

    7. In the User-Defined Fields window, click OK.

    8. When you are prompted to update the ODBC data dictionary and UDF data files, click OK.

    After you have created the UDF, you can add it to a panel or a Crystal report. For more information, see Add a User-Defined Field (UDF) to a Panel.

    When a change is made to a UDF, the ODBC Dictionary file and other system files are updated automatically to reflect the changes. If a UDF is deleted, all existing UDF data files for the entity are updated to remove the data field. The update process is performed for all UDF files for all defined companies.