Master Data Management

Create Base Table

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 the name of the page that is generated along with the task in the PAGE DESCRIPTION field.

5. Click Save.

6. Click the Create Base Table Structure 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 the name of the page that is generated along with the task in the PAGE DESCRIPTION field.

6. Click Save.

7. Click the Create Base Table Structure icon.

Field	Description
Add Partial Rejection Columns	Click to add the Rejected and Rejection Reason columns to the table and task so that the Review role user can reject only the data that is not correct instead of rejecting all of the records in the request.Refer to Perform Partial Request Rejection for more information.  NOTE: This icon only displays after the table has been built.
TABLE NAME	Displays the name of the table containing the columns used in the task.
TABLE CREATED	If checked, the table has been created.  If unchecked, the table has not been created.
Table Columns	Click to open the Create Base Table Columns page to review and edit the table columns before building it.
Create Table In Category Database	Click to create the table with the columns as defined on the Create Base Table Columns page.  NOTE: This icon is dimmed if the table has already been created.  NOTE: This icon does not display when creating a task from an existing table.