Adding User-Defined Table Columns

In order to give you better ability to configure Eclipse to best meet your needs on a daily business in how you do your work, you can add any data represented by an Eclipse Dictionary to tables in Solar Eclipse that have a View Manager. The View Manager provides quick access to all views which you are authorized to see and is readily available throughout Solar Eclipse on tables such as the Inventory History Ledger, A/R Inquiry, Suggested P/O Queue, and the P/O Variance Queue.

Note: You can assign any views you create to other users, as needed. Users may need to close the window or log off and back in to Solar Eclipse to see the change and use the new views assigned to them.

To add a user-defined table column:

  1. Display the window with the table to which you want to add a column.

  2. Click the View Manager icon and select User Defined View Maintenance to display the User Defined View Maintenance window.

  3. From File menu, select User Defined Table Columns to display the User Defined Table Columns window.

  4. In the Column ID field, enter a free-form field to label your column information. This ID is for your reference only. We highly recommend following a standard naming convention so you can locate your user-defined column descriptions later.

  5. In the Column Name field, enter the actual label for the column to display in the table.

  6. Use the Key(s) Definitions area, to define the columns source:

Field

Description

Key Source*

The identifier, or key, for the information you get from the file selected, such as Warehouse #. This key is an exact match to the record ID in the file from which you are getting the additional field data. For example, if the 4-digit branch is in an existing view, you can use that as the key to the Territory file to gain access to the dictionaries from the Territory file.

ClosedClick here to view your key source ID options.

You can use any of the following for a key source:

  • Bill To/Pay To

  • Ship To/Ship From

  • Line Item Part Number

  • Customer/Vendor

  • Part Number

  • Active ID

  • None

  • Order ID Line Item ID

  • Matrix ID

Note: Inventory Inquiry and AR Inquiry have the additional option to use the Screen-Active ID from the screen, example in Inventory Inquiry the Screen-Active ID is the product ID.  This allows you to display branch specific product information in the table.  Example: Screen-Active ID * Warehouse Br is the key to the PROD.BR file.

Separator

A data separator, such an as asterisk, if the file or program you are using requires a it. For example, you link to PROD.BR to pull branch information, the product ID and the branch ID are listed together: 43256*3 where 43256 is the product ID and 3 is the branch. List the * as the separator so the system can retrieve the correct information.

  1. In the Column Data Source area, select Universe File or PICK Program to tell the system which kind of file you are using for the column data. ClosedExample

  1. Use the Universe File field, enter the file in the system from which you want to pull information, such as TERRITORY. The field is mutually exclusive with Pick Program and available only if you select Universe File in the Column Data Source area.

  2. In the File Dictionary field, enter the item within the file that you want to populate on the table, such as TERRITORY_DESC, within the Universe file selected.

  3. In the PICK Program field, enter the PICK program name you want to use. This field is mutually exclusive with Universe File and available only if you select PICK program in the Column Data Source area.

  4. Save your changes and exit the window to apply your new column. For example:

See Also:

User-Defined Screens

User-Defined Functions Overview