Master Data Management

Create Base Table Columns H

Vertical View

Use this page to:

This page can be accessed in two ways.

It can be accessed when creating a task based on a table.

  1. Select Design > Create New Task in the Navigation pane.

  2. Click the Create Task From Existing Table icon for a category.

  3. Enter the unique table name, which must begin with tt, in the TABLE NAME field..

  4. Enter a brief description in the PAGE DESCRIPTION field.

  5. Click Save.

  6. Click the Create Base Table Structure icon.

  7. Click the Table Columns icon.

It can also be accessed when creating a task based on an Integrate BDC Script template:

  1. Select Design > Create New Task in the Navigation pane.

  2. Click the Create Task From Integrate Template icon for a category.

  3. Enter the unique table name, which must begin with tt, in the TABLE NAME field.

  4. Select the template from the INTEGRATE TEMPLATE ID list box.

  5. Enter a brief description of the task (page) in the PAGE DESCRIPTION field.

  6. Click Save.

  7. Click the Create Base Table Structure icon.

  8. Click the Table Columns icon.

NOTE: Excel Integration has been enabled on this page. Refer to Use Excel Integration for more information.

Field

Description

COLUMN NAME

Displays the name of the column containing the data to be included in the task. 

NOTE: This column cannot be edited if the table is based on an existing table.

COLUMN ORDER

Displays the order the column appears in the table. 

NOTE: This column cannot be edited if the table is based on an existing table.

DATA TYPE

Displays the type of data in the column, such as NVARCHAR or INT.  

NOTE: This column cannot be edited if the table is based on an existing table.

VIEW TYPE

Displays whether the column is on the Horizontal or Vertical view.

NOTE: This column cannot be edited if the table is based on an existing table.

HORIZONTAL VIEW ORDER

Displays the order the column appears on the Horizontal View. 

NOTE: This column cannot be edited if the table is based on an existing table.

VERTICAL VIEW ORDER

Displays the order the column appears on the Vertical View. 

NOTE: This column cannot be edited if the table is based on an existing table.

TABLE KEY

If checked, this column is the key field on the table. 

If unchecked, this column is not the key field..

NOTE: This column cannot be edited if the table is based on an existing table.

PAGE KEY

If checked, this column is the key field on the page. 

If unchecked, this column is not the key field.

CONTROL

Displays the behavior of the column within the page. By default, all controls are text boxes but can be overridden by assigning a column property.

CONTROL STATUS

Displays an option that determines the visibility of a column on a page.

Options are:

  • Enabled—Displays the column on the page. This is the default value.

  • Hide—Hides the column on the page.

  • Disable— Protects the column. Displays as read-only columns when in edit mode

Create Base Table Columns V

Horizontal View

Field

Description

Column Name

Displays the name of the column containing the data to be included in the task. 

Column Order

Displays the order the column appears in the table. 

Data Type

Displays the type of data in the column, such as NVARCHAR or INT.  

Length

Displays the maximum length for the column.

Decimal Places

Displays the number of decimal places the field allows if it is a numeric field. 

Table Key

If checked, this column is the key field on the table. 

If unchecked, this column is not the key field..

Page Key

If checked, this column is the key field on the page. 

If unchecked, this column is not the key field.

Table Default

Displays the default value used in the column in the table. 

Page Default

Displays the default value used in the column on the page

Control

Displays the behavior of columns within a page. By default, all controls are text boxes but can be overridden by assigning a column property. 

Control Statius

Displays an option that determines the visibility of a column on a page.

Options are:

  • Enabled—Displays the column on the page. This is the default value.

  • Hide—Hides the column on the page.

  • Disabled—Protects the column. Displays as read-only columns when in edit mode

Consider Valid

If checked, the boaStatus column is used to determine whether the control is enabled or disabled.

If unchecked, and the Control Status Field on the Enable/Disable Control tab on the Page Columns page displays another column in the view, this column’s value (NULL/0, 1, or 2) determines the Control Status of this column for a given row.

If unchecked and the Control Status Field is blank, the control status field is not set using either of these methods. Control Status can also be set as a column property. Refer to Set Column Control Status for more information.

List Source

Displays the source of the data when the Control is Combo Box or List Box. The value can either be a SQL object (table or view) or a List Data Provider plugin.

Refer to Add List Boxes and Combo Boxes for more information.

List Display Field

Displays the option visible in the List Box or Combo Box.

Refer to Add List Boxes and Combo Boxes for more information.

List Value Field

Displays the name of the field that stores the value.

In most cases, List Value Field is the primary key stored in the table

Refer to Add List Boxes and Combo Boxes for more information.

List Where Clause

Displays the Where clause used to restrict the values that display in a List Box or Combo Box.

Refer to Set a Dynamic List Box and Enable List Where Clause for more information.

Horizontal View Order

Displays the order the column appears in the Horizontal View. 

Vertical View Order

Displays the order the column appears in the Vertical View. 

Required

If checked, this column is required. 

If unchecked it is not required.