Configuring Siebel Business Applications > Configuring Business Components, Links, and Business Objects > Configuring a Business Component >

Determining How a Business Component Sequences Records

Sequential numbering is not predefined in any system column in a predefined table in Siebel CRM. You can configure a sequence field in a child business component to determine how a business component sequences records. For more information, see How a Business Component Field Sequences Records.

To determine how a business component sequences records

1. Verify that the class of the child business component is CSSBCBase or a subclass of CSSBCBase.

   If it is not, then contact Oracle Global Customer Support for assistance with this procedure. For more information, see Getting Help From Oracle.

2. Verify that the business component where you must add a sequence field is the child business component in a parent-child relationship.

   This child is the numbered business component. Siebel CRM numbers child records beginning with 1 in each parent record.

3. Add a child field to the numbered business component using values from the following table.

   Property	Value
   Name	Enter text that identifies the data that Siebel CRM sorts, such as Line Number or Order.
   Column	Enter a numeric extension column, such as ATTRIB_14.
   Type	DTYPE_NUMBER

4. Add a child business component user property to the numbered business component using values from the following table.

   Property	Value
   Name	Sequence Field
   Value	Enter the field name you defined in Step 3.

5. Create a business component using values from the following table.

   Property	Value
   Class	CSSSequence
   table	Enter the name of the base table of the numbered business component.
   Name	Enter a name using the following format: name of the numbered business component.name of the sequence value field (Sequence)

6. Set the Sort Spec of the business component you created in Step 5 to Sequence (DESCENDING).
7. Add a child field to the sequence business component using values from the following table.

   Property	Value
   Name	Sequence
   Column	Enter the same value you entered for the column in Step 3.

8. Add a child field to the sequence business component.

   This field is the foreign key field that creates the parent-child relationship to the parent business component. Set the Column property to the same column as the corresponding field in the numbered business component.

9. Create a link that creates a parent-child relationship between the parent and sequence business components.

   For more information, see About Links.

10. Create a child business object component of the business object that uses the predefined link that exists between the parent business component and the numbered business component. Use values from the following table.

    Property	Value
    Link	Choose the link you defined in Step 9.
    BusinessComp	Choose the sequence business component.

11. Display the sequence value field in applets that display records from the numbered business component.
12. Compile and test your modifications.

    For more information, see Using Siebel Tools.