Bookshelf Home | Contents | Index | Search | PDF

Developing and Deploying Siebel eBusiness Applications > Configuring the House and Opportunity Entities > Configuring the House Detail - Appraisals View >

Creating the Appraisals Business Component

---

To display data from a one-to-many extension table you must define a new business component with fields that map to the generic columns in the extension table (ATTRIB_01, ATTRIB_02, and so on), as well as three fields that provide the user key and map to the following columns:

PAR_ROW_ID. This column should map to the foreign key field using in the one-to-many link.
NAME. This column should map to the field being tracked in the business component. The value in the name needs to make the record unique for each parent record.
TYPE. This column will be used to group records in the extension table. This column should be mapped to the Type field. You will set a default value for the Type field and then configure the business component to automatically search for those records in the extension table that contain this value.

NOTE:  The combination of NAME, TYPE, and PAR_ROW_ID will be unique in order to satisfy the U1 index of the _XM table.

The following procedure walks you through creating the appraisals business component for the NREC example.

To create the appraisals business component

Choose File > New Object.

The New Object Wizards dialog box appears.

Under the General tab, select the BusComp icon and then click OK.

The New Business Component wizard appears.

Enter the following information, and then click Next.

Field	Value
Project	Product (SSE)
Name	Appraisals
Table	S_PROD_INT_XM

The Single Value Fields dialog box appears.

Enter the following fields and columns, and then click Finish.

Column in Base Table	Field Name	Description
ATTRIB_01	Date	Date the appraisal is done.
ATTRIB_02	Appraisal Value	Appraised value of the property.
ATTRIB_03	Comments	Comments.
PAR_ROW_ID	Par Row Id	Parent Row ID.
NAME	Name	Used to store the name of the Appraiser.
TYPE	Type	Used to group records. Will be set to a unique predefault value.

The Business Component Wizard creates the business component based on the information you entered.

To set the Search Specification for the Business Component and the Pre Default Value of the Type field

In the Object Explorer, expand the Business Component Object type.

The Business Component window appears in the Object List Editor.

In the Business Component window, find and select the Appraisals business component.
Add the following Search Specification property:
[TYPE]= `Appraisals'

The business component will retrieve only those records in which the TYPE field contains the value Appraisals.

In the Object Explorer, select the Field object type (child of Business Component).

The list of fields that you created in the previous procedure appear in the Fields window of the Object List Editor.

Select the Type field and then enter Appraisals as the Pre Default Value.

The Type field will always default to Appraisals.

Bookshelf Home | Contents | Index | Search | PDF