Table Definition- field descriptions

Fields are presented in the order that they are presented in a form. Click a link to see the field descriptions for the form.

Overview

Extension tables are supported in Oracle and SQL Server databases. Using the Custom Table Definition form, you can create extension tables for these objects: formulas, items, specifications, projects, companies, and label content. You can also create extension tables for the Lab and Workflows in Progress form.

It is possible to change the object’s extension table values by either accessing the object’s form or by using a workflow.

For more information about extension tables, see the Optiva Application Configuration Guide.

Main tab

Allow Users to add rows

Select this check box to enable users to add rows to the extension tables. To prevent users from adding rows, clear this check box.

Database Table Name

Required. Specify the name of the extension table. Prefix the table name with C_.

Description

Required. Specify the description for the extension table. The description is the label that identifies the table to users. Click Language Translation to specify the translated description label

Sort Order

Required. Specify the database column that is used to sort the rows in the extension table. Typically, this value is LINE_ID.

Supported Symbol

Specify the business object in which to add the extension table. The business objects are formula, item, label content, project, company and specification. You can also select Lab and Action WIP as a supported symbol in the Custom Table Definition form.

View ID

This table number is assigned by Optiva. The value is -1 until you click Save.

Lookup Sequence

Specify a numeric value. This value indicates the order in which the table is listed in the Business object Custom Table filter. For example, if you specify 1 for Extension Table and you specify 2 for Extension Table A, Extension Table B is listed above Extension Table A in the Business object Custom Table filter list.

Rows tab

If you opt to leave the Row Label Set filter blank, then you must manually specify your row labels.

Label

Specify the text that you want to be displayed in the first column of the row. Click Language Translation to specify the translated Row label.

Row#

Shows the system-generated sequence number for the row.

Columns tab

Auto Desc. Source

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. For an example, see the Optiva Application Configuration Guide.

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 Custom Table tab in the object form, the value can be forced to display in uppercase or lowercase, or 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 Label

Required. Specify the name of the column. This label is displayed to the user. Click Language Translation to specify the translated column label

Column#

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

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
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

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.

Enum Style X

Specify whether to show the value or the description of the enumerated list.

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 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 alphanumeric characters.

A blank value is used to specify a single line of alphanumerics that is the size of the Data Length.

MULTILINE and <any alphanumeric text> are used to format the text within a 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

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 custom 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 Multi-value Lookup for the Enum Style.

Max Val

Required if the Set Ind column is minmax. Specify a maximum allowable value for the column.

Min Val

Required if the Set Ind column is minmax. Specify the minimum allowable value for the column.

Primary Key

Specify whether the column is a primary key. You cannot change the primary key if data already exists in the extension table.

Read Only

Specify Yes to prevent users from entering data to the custom 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 and uses ‘OR’ logic to search for the multiple criteria values that are selected.

For more information, see the Optiva 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 Optiva. Click Language Translations to specify the translated tooltip label.

Users tab

To specify the users who will have privilege to the extension table:
  1. Click Add Row.
  2. Select a user to assign custom table privileges to in the User Code field.
  3. Select the privilege for the user in the Security Level list:
    • Read
    • Read/Write
  4. Click Save.

Roles tab

To specify the roles who will have privilege to see the extension table:

  1. Click Add Row.
  2. Select a user to assign custom table privileges to in the Role Code field.
  3. Select the privilege for the user in the Security Level list:
    • Read
    • Read/Write
  4. Click Save.

Groups tab

To specify the groups who will have privilege to see the extension table:

  1. Click Add Row.
  2. Select a user to assign extension table privileges to in the Group Code field.
  3. Select the privilege for the user in the Security Level list:
    • Read
    • Read/Write
  4. Click Save.

Classifications tab

You can assign set codes in the Table Definition form. Set Codes are optional. They restrict the list of custom tables that are displayed in the object's Tables tab. The Filter list shows only the table definitions that have the same set codes as the set codes that are defined for the object itself.

For example, if the table definition has a set code called ADDITIVES, then the object must have the same set code. Otherwise, the table definition is not displayed in the object's Filter list.

If set codes are omitted from the Table Definition form for a custom table, then that table is displayed for all set codes on the business object.

The security privileges that are assigned to the user, role, and group in the Table Definition form determine whether users can view and edit the extension table in the object form.