Managing User-Defined Queue Column Options

When creating your user-defined queue, you have several options to make sure the queue displays the data you want to retrieve from the Eclipse system. These options give you versatility when creating your queue.

Use the Column Display area to define how you want the columns in the queue to display for users.

Column	Description
Column Heading	Enter the name you want to use to label the column, such as Product ID. This label displays as the column heading in the queue.
File	The system populates this field with the Universe File you enter. You can change this if you need to retrieve information from another Eclipse file. For information about the common files and what they contain, see Files Commonly Used In Reports . The file structure is the same for user-defined queues.
Dictionary ID	Select the dictionary line the information for the column you want to display. - Displays if more than one value is available for the option. Set these values, sub-values, and sub-sub-values in the Value Level field. - Displays if column prompts have been added for the user to answer prior to displaying your queue.
Conversion	Select how you want the information to display in your queue. This determines how it will display. For example, if you select Product Desc you must select Product Description in this field so that the product description displays instead of the product ID.
Validation	Select the information you want the system to use for the conversion. If this validation field is left blank, the system does not check entries and free-form information can be added.
	For example, if you select Buy Line for a column, then in this field you must select Buy Line so that the system knows what kind of entry is valid. If you do not select the corresponding entry, the system does not update records or may update records with possibly invalid entries.
	Note: If you select Branch/Territory/ALL with a territory or ALL and the Ignore Branch Hierarchy field in < > is set to Yes, then the territory and ALL selections are displayed along with the associated branches. If a user is not authorized for all the branches in the territory they cannot edit the Column field in the queue.
	Like File Import Maintenance, the Field Validation and Field Conversion fields work together. The value or field type you have in the Field Validation field, determines what you need to enter in the Field Conversion field. Similar to a MS Excel cell format, if you select in the Field Validation field for the value to be Numeric, then you use the Field Conversion field to tell the system how you want that number to use the decimals. For example, to move the decimal to the right two places, you enter MR2. Press F10 to display a list of valid options.
Editable	Select to make the column editable when the queue displays. For more information, see How Editing Works in User-Defined Queues below.

Use the Options menu for the Column Display tab, as needed:

Option	Description
Column Link ID	If you want to link the column information to a file other than the primary Eclipse file with which you are working. For example, you build your queue using the PRODUCT file, but want one row to display BUY_LINE information. Use this option to select the Eclipse File.
Column Prompts	Enter the prompts you want the user to use when adding information to the queue.
Column Dictionary Prompts	If you are using an Eclipse dictionary file and it has sub-values, indicate which values you want to use. You must highlight the Dictionary ID for this selection to display.
Column Custom Validation	Create custom validations for your queue based an Eclipse file, control maintenance record, data list, or subroutine. If this validation field is left blank, the system does not check entries and free-form information can be added. For more information, see Validating Custom Column Data in this document.
Column Sort	Define how you want the columns to sort by default for the user. Similar to selecting report columns, move items from the right-hand column to the left-hand column based on how you want the items in your queue to sort by default. The system uses the Sort Sequence order as a hierarchy to determine what order to sort by. Use the Sort By column to determine if you want the column to sort in ascending or descending order. For example, you are creating a queue for on hand items. You want the queue to sort alphabetically by buy line and then by product. Move the BUY_LINE option to the Sort Sequence by double-clicking and select Ascending in the Sort By column. Move PRODUCT to the Sort Sequence second.
Column Update From	To limit the update from specific dictionaries, select how to manage the updates. Note: This option activates for Advanced Demand Forecasting only.