Developing and Deploying Siebel Business Applications > Configuring the House and Opportunity Entities > Process of Configuring the Opportunity Details View >

Adding Columns to the Opportunity Table


This task is a step in Process of Configuring the Opportunity Details View.

In this topic, you add columns to the opportunity table.

To add columns to the Opportunity table

  • Perform the same work you perform to add columns to the products table, with the following differences:

    Add columns to the S_OPTY table using values from 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

    For more information, see Adding Columns to the Products Table.

Developing and Deploying Siebel Business Applications Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.