Specifying the criteria in the Columns tab

Each column in the Columns tab is explained briefly here. The columns are listed in alphabetical order.

Auto Desc Source

This entry is required if the Data Type is auto descrip. This column is used in conjunction with another column in the Columns tab. Typically, the associated column is a lookup that has a description.

The Auto Desc Source value entered must be the DB Name of the source field in this Columns grid. Enum Style will automatically default to the Field_No (from FSVALIDATIONFIELD) of that source field.

See Specifying an autodescrip column.

Call Ind

Specify the type of validation. Callbacks are used to call the server object. Key validates against the symbol that is entered in the Key Check column.

Case Force

Specify the final appearance of the text. When users manually type a value in the Extension Tables tab in the object form, the value can be forced to display in uppercase or lowercase. Or, the value can remain as the user originally typed that value (i.e., no force).

If users type the text in lowercase, but the Case Force value is “upper”, then the final appearance of the text is changed to uppercase.

Column #

Shows the system-generated sequence number for the columns in this tab.

Column Label

This entry is required. Specify the name of the column. This label is displayed to the user.

Data Type

Specify the type of data. The choices are integer, long, double, date, string, auto descrip, or auto long. An auto long column increments itself by one for each line number.

You can change the Data Type to a string even if data already exists in the extension table.

DB Name

This entry is required. Specify the name of the database column.

Enum Code

Select an enumeration code from the list. This column is required if enum val list is specified for the Enum Ind column.

Enum Ind

Specify the type of enumerated list. The choices are enum query, lookup code, and enum val list.

Enum Query

This entry is required if enum query is specified for the Enum Ind column. You must create the query before you can select it. Enum Style must be drop list or Multi-value drop list.

Enum Style

Select a style for the column. The choices are none, checkbox, lookup, drop-list, date, Multi-value, Multi-value lookup, Multi-value drop list, Multi-value date and Multi-value keyed. The word “Multi-value” means that the user can select multiple values.

Format Code

Specify the display format for the extension table column.

• For Data Types that are Double, specify # or 0. The pound sign shows the number of decimal places. The zero shows where to use a 0 value if a value is not present. If the format is 0.00#, then 3 becomes 3.00 and 3.1415 becomes 3.142.
• For Data Types that are String, you can leave the format code blank, specify MULTILINE, or specify any alpha-numeric characters. A blank value is used to specify a single line of alpha-numerics that is the size of the Data Length. MULTILINE and <any alphanumeric text> are used to format the text within a web client cell correctly. In other words, the text wraps to the next line and carriage returns are permitted.

Input Code

Read-only. Shows the name that is used when you write a workflow against this extension table.

Key Check

This entry is required when you select key in the Call Ind column. Specify the symbol that is used to validate against an existing key.

Length

Specify the length of the database column. The maximum length is 200.

This entry is not required if the data type is auto long, double, date, integer, and long. You can expand the length of a column even if data already exists in the extension table for that column.

For Enumerated Type lists, ensure that the length is sufficient to accommodate the column definitions and delimiters.

Lookup code

Specify a lookup code. This entry is required when you specify lookup code for the Enum Ind column. You must also specify Lookup or Extended Lookup for the Enum Style.

Min Val

This entry is required if the Set Ind column is minmax. Specify a minimum allowable value for the column.

Max Val

This entry is required if the Set Ind column is minmax. Specify the maximum allowable value for the column.

Primary Key

Specify whether the column is a primary key. You must have a primary key for all custom table definitions. You can no longer import into custom tables that have not been upgraded to have a primary key, and you will receive an error if you attempt to import.

Read Only

Specify Yes to prevent the users from entering data to the extension table column. Otherwise, specify No.

Required

Specify whether the column is required. The choices are: not required, required, or set blank string to null.

Search Ind

Specify whether you want the extension table to be visible in the Search forms. The choices are: Not Searchable, Searchable, Searching - Using SubCode.

The Searchable - Using SubCode choice applies only to fields that have sub-coded validation entries. Parameters (TPALL) are one example of sub-coded validation entries.

Search Style

Specify the format for the searchable column. This column is not relevant if the Search Ind column is not Searchable.

• The Standard choice formats the searchable column as a text box, a drop-list, or a date calendar.
• The Range choice displays a text box for a Min value and a text box for a Max value.
• The Multi-Select choice displays a multi-select text box. The ‘OR’ logic is used to search for these values.

For more information, see the Infor PLM for Process User Guide.

Set Ind

If the extension table column is a lookup, select none. Otherwise, specify whether the column is to be used to validate ranges (min, max) or to validate enumerated lists.

Tooltip

Displays the default tooltip for the standard fields. This text is provided by PLM for Process.