Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Defining Business Objects and Business Components > Defining Business Objects >

Adding Fields to a Business Component

---

To add a field to a business component

In the Object Explorer window, select the Business Component object type.
In the Object List Editor window, select the business component you are defining.
In the Object Explorer window, expand the Business Component object type, and then select Field.
Modify the Field properties, as shown in Figure 121.

Figure 121. Single Value Field Properties of a Business Component (Account Product)

Field Properties

Following are descriptions for key properties of the Field object type. For a complete list and more detailed descriptions, see Siebel Object Types Reference.

Column. (Required unless it is a calculated field.) The name of the table's column. Default table is the business component table.
Name. (Required.) User-defined name for the field. It must be unique within the business component.
No Copy. If TRUE, the field's value is not copied into the newly created record during a Copy Record operation. The No Copy property of a Multi Value Link will override the No Copy property of a Field in the child Business Component.
Read Only. If TRUE, the field value cannot be changed by the user.
Required. If TRUE, a value must be entered before the record can be written.
Text Length. Siebel Tools gets the text length from the database and, for columns with a physical type of varchar, sets the Text Length property for a business component field to this value.

If the physical type is character(1), the Text Length is set to 1 and the Type is set to DTYPE_BOOL.

For number, date, and datetime fields, Siebel Tools does not put a value in Text Length. Exceptions are fields mapped to foreign key columns (these columns have names that end in ID and have a physical type of varchar and length of 15). These fields get a Siebel Type of DTYPE_ID and a Text Length of 15.

If you edit the value in the Text Length property, it is ignored unless the value in a picklist is longer than what is specified on the business component field. In this case you get an error.

Type. The field data type.

For information about the data types for the field object type, see Siebel Object Types Reference.

Single-Value and Multi-Value Fields

As shown in Figure 122, the Object Explorer shows Business Component child object types for Field, Single Value Field, and Multi-Value Field.

Figure 122. Field, Single Value Field, and Multi-Value Field Object Types

Normally you would modify all Field objects by selecting the Field object type, finding the field you want, and making the changes. If you select the Single Value Field object type, you see only Single Value objects and their properties; the Multi Value Field object type shows only Multi Value objects. You can also configure particular Single Value Field and Multi Value Field objects by viewing and changing them within Single Value Field and Multi Value Field object type. Changes you make there will be reflected when you select the changed object in Field object type.

NOTE:  You can configure queries to be case sensitive or case insensitive by setting the Use Default Sensitivity property in the configuration (.cfg) file. Set the property to TRUE for case-sensitive queries. Set the property to FALSE for case-insensitive queries. However, you cannot configure fields of the type DTYPE_ID in this way because these fields always conduct case sensitive searches.

Bookshelf Home | Contents | Index | Search | PDF