Developing and Deploying Siebel Business 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 column records as shown in the following table.

   Name	Type	Length
   X_AGENT	Varchar	50
   X_BATHROOMS	Varchar	20
   X_BEDROOMS	Varchar	20
   X_PRICE_RANGE	Varchar	20
   X_SQUARE_FEET	Varchar	20

3. Apply the schema to the local database.