Developing and Deploying Siebel eBusiness Applications > Configuring the House and Opportunity Entities > Configuring the Opportunity Details View >

Adding Additional Columns to the Opportunity Base Table

The steps for adding columns to the base table are the same steps you followed to add additional columns to the internal products table. The procedure is covered here at a high-level. For detailed instructions, review the tasks covered in Extending the Database by Adding New Columns to the Base Table.

To add additional columns to the Opportunity base table

  1. Navigate to the Opportunity base table S_OPTY.
  2. Add the following column records:

    3. Name
    Type
    Length
    X_PRICE_RANGE
    Varchar
    20
    X_SQUARE_FEET
    Varchar
    20
    X_BEDROOMS
    Varchar
    20
    X_BATHROOMS
    Varchar
    20
    X_ZIP_CODE
    Varchar
    30

  3. Apply the schema to the local database.

 Developing and Deploying Siebel eBusiness Applications 
 Published: 18 April 2003