Siebel Developer's Reference > User Properties >

Sequence Use Max

Description
Determines whether the sequence number generated is based upon the current record position or the maximum sequence number. If user property Sequence Use Max is n, then generate the sequence based on the current record position.
For example, you want Quote Items to have an incrementing line number.
Quote Item business component has the following fields/columns:
Line Number/ATTRIB_14 (or any Number field) (Predefault=1)
  1. Add a business component user property to the Quote Item business component with the following properties:
    Name: Sequence Field
    Value: Line Number
    Set the Insert Position property to LAST for the applets that display records from the numbered detail business component.

    NOTE: In older versions of Siebel applications, if this property was left blank, it defaulted to LAST. In Siebel 6.0 and later versions, it does not default to LAST; leaving this property blank could cause unexpected behavior in the line numbers generated in the applet.
  2. Create the sequence business component with the following properties:
    Name: Quote Item.Line Number (Sequence)
    Class: CSSSequence
    Table: S_QUOTE_ITEM
    Field/column: Quote Id/SD_ID
    Field/column: Sequence/LN_NUM
  3. Create Link from Quote Item to Quote Item.Line Number (Sequence) with the following properties:
    Link Name: Quote Item / Quote Item.Line Number (Sequence)
    Dest field: Quote Id
    Source field: Id
  4. Add Quote Item.Line Number (Sequence) business component to the Quote business object using the link created in step 3.
  5. Expose the fields in a list applet, and create a Parent-Child view with a form and a list applet.
You can renumber all records by invoking ReSequence () method from a button.
 
Sequence Use Max Example:
NAME SEQUENCE Record
1. Record
2. Record
Suppose that Record 2 is the current record. The new record sequence depends on your insert position. Create a New record called MYREC.
If you insert LAST, then MYREC sequence number = 1.
If you insert AFTER, MYREC sequence number = 2.
If you insert BEFORE, MYREC sequence number = 1.
If you insert FIRST, MYREC sequence number = 0.
Parent Object Type
Business Component
Functional Area
Cfg Web
Where Documented
Siebel Tools Reference

 Siebel Developer's Reference 
 Published: 23 October 2003