Bookshelf Home | Contents | Index | PDF     

Configuring Siebel Business Applications > About Business Components, Fields, Joins, and Links >

Table 10. Sample table
 
 

Column

The name of the table's column. Default table is the business component table. This property is required unless it is a calculated field.

Name

User-defined name for the field. It must be unique within the business component. This property is required.

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 to the database.

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 How a Business Component Field Identifies the Type of Data.

How Siebel CRM Defines Read-Only Behavior for a Business Component Field >

System Fields of a Business Component

A system field is a business component field that represents the data that Siebel CRM gets from a system column. All business components in Siebel CRM include system fields. You are not required to do any special configuration to display or manipulate a system field. You do not need to define it as a business component field. For example, you can reference a system field in the Field property of a control, list column, or in another object.

You must not modify a system field. For example, by renaming it. Siebel CRM does not support modifying a system field.

For more information, see System Columns of a Siebel Table, and.Displaying a System Field in an Applet.

Relationship Between a System Field and a System Column

The Id field that represents the ROW_ID column in a business component is an implicit field, and Siebel Tools does not display it in the Object Explorer as a child field of a business component. Every business component includes an Id field that represents the ROW_ID column of the base table of the business component, as defined in the Table property of the business component. The Siebel schema references the Id field in various properties throughout Siebel CRM. For example, in the Source Field property of a link where an empty value indicates the Id field.

You must not explicitly create a system field for a business component. If you create a business component field that references a system column, then Siebel CRM attempts to write a value to the column twice in the insert statement, which causes a duplicate column SQL error.

Table 12 describes the relationship that exists between a system field and a system column. Each field is predefined. You do not explicitly define it. You can configure Siebel CRM to reference a system field in the Field property of a control, list column, or other object, even though Siebel Tools does not display the field in the Business Components list.

Table 12. Relationship Between a System Field and a System Column
System Field Name
System Column Name
Description

Id (or empty)

ROW_ID

Stores the primary key for the table.

Created

CREATED

Stores the date and time of when Siebel CRM created the row.

Created By

CREATED_BY

Stores the ROW_ID of the row from the S_USER table that references the person who created the record.

Updated

LAST_UPD

Stores the date of the most recent update that Siebel CRM performed on the row.

Updated By

LAST_UPD_BY

Stores the ROW_ID of the row from the S_USER table that references the person who last updated the record.

In some situations, Siebel CRM updates this field even though the user does not actively update the record. For example, if Siebel CRM configures a multi-value link with a primary join. For more information, see Defining the Primary ID Field of a Multi-Value Link.

(varies)

DB_LAST_UPD

Stores the date of the most recent update that Siebel CRM performed on the row in the Siebel database. The system field name varies.
      
Configuring Siebel Business Applications Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.