User Defined Data Def'n - Inventory (UD03)

The User Defined Data Def'n-Iventory (UD03) program defines the fields used in the User Defined Panel Def'n-Inventory (UD04) program.

• These fields are subsequently used in the Maintain Inventory Master (IM13) program on the UDF folders.

  Note: Fields created through UD03/UD04 are for additional internal information only and cannot be used anywhere else in the Enterprise system. User Defined fields can be reported through Crystal Reporting.

The following list defines every field on UD03:

• Field Name - enter a maximum of 25 characters as the Field Name. The text you enter in this field is used to describe the field that will display in one of the UDF folders in IM13.

• Field Type - select the Field Type for the field from the drop down list. You can select one of the following valid options:
  • Alpha Field - select this option to allow both alpha and numeric characters in the field.

  • Numeric Field - select this option to allow only numbers in the field.

  • Date Field - select this option to allow a date to be entered in the field.

  • Check Box - select this option to display a check box that can be selected or deselected.

  • Variable DropBox - select this option to allow a predefined value to be populated into this field. Predefined values are entered in the 'Drop Box Values' field.

  Note: You cannot change the Field Type once UD04 has been updated. The following message will displays: "You cannot change the Field Type since the database has been updated and data may exist in this field. If you want to change the Type, delete this field and re-enter."

• Negative - this check box is only available if the Field Type selected is 'Numeric Field'. Selecting this check box allows you to enter negative values for the field.

• Field Size - depending the Field Type selected, the Field Size varies or may not be available. The following table describes the effect each Field Type has on the Field Size field and the maximum values that can be entered:

  Field Type	Field Size	Value
  Alpha Field	Open	Can enter a maximum of 113.0. Note: If you try to enter a value with a decimal, e.g. 98.5, the following message displays: "Field size must be a whole number for alpha fields". Click OK to clear the message and enter a valid value.
  Numeric Field	Open	Can enter a maximum of 18.9 for decimal values. This entry displays a mask of ##,###,##0.000000000. Can enter a maximum of 12.0 for whole numbers. This entry displays a mask of ###,###,###,##0. Note: If you enter values greater than those above, errors will occur in UD04 and the field will be rendered useless in the UDF folders in IM13.
  Date Field	Closed	n/a
  CheckBox	Closed	n/a
  Variable DropBox	Closed	n/a

• Mask - displays the format for Numeric fields.

• Drop Box Values - This field is only available when the Field Type is 'Variable DropBox'. Each variable must be separated by a '\'. At least 2 variables must be entered.

The following table outlines the functionality of each button in UD03:

Button Label	Icon	Functionality
Add Record		Updates the current record to the list box.
Delete Record		Removes the current record from the User Definitions. Note: If you try to delete a field that is updated in UD04 the following message displays: "You cannot delete this Data Field because it is on the following panels: IMPRODCT.XXX. OK". Click OK to clear the message. If you wish to delete the field you must delete it in the affected panel in UD04 before deleting the field in UD03.
Re-Build Database		Builds the current definitions in the database. Once you click this button the 'Rebuild Status' bar displays. The definitions are applied to every company setup in your Enterprise environment. When the rebuild is complete the following message displays: "Re-Build is complete. If an existing field was changed, you must re-call all panels where the field is used and Re-Build the panel. Run CC84. Load DDE and Generate INI update the Crystal Driver for this file. OK". Click OK to clear the message. UD03 automatcally closes. Note: If you close UD03 by clicking the 'X' in the upper right corner of the panel without re-building the database the following message displays: "The changes made will not take effect until you Re-Build the database. OK". Click OK to clear the message. UD03 will close. You will not be able to select any of changed or new fields added to the database in UD04 until you re-build the database. Panels are rebuilt through UD04. For more information on UD04 click here. You are only required to run CC84 if you are using Crystal Reporting. Note: You cannot update the database if any users are accessing files that effect the update. The following message will display: "Cannot proceed with database update. A user(s) has the file(s) listed below opened. Please have all users with the file(s) opened logoff, then rebuild the database. Files(s)company+file. OK". Click OK to clear the message. UD03 automatically closes. You must have any users accessing the indicated files within the indicated company log out of the programs using the listed files before you can update the database.

^{User Defined Data Def'n - Inventory (UD03)}