How Business Component Fields Reference Base Table Columns

Siebel CRM gets the main data for a business component from a base table and one or more joined extension tables. For example, the Account business component references the S_PARTY table, but the S_ORG_EXT joined extension table stores most of the data that the Account business component gets.

Siebel CRM assigns a base table to each predefined business component. The base table for a party business component includes the most important columns that provide data to fields that reside in the business component. The Table property of the business component references the base table. A single business component field references a single base table column.

The following figure shows an example of how fields (First Name, Job Title, M/F, Mail Stop) in the Contact business component reference columns (FST_NAME, JOB_TITLE, SEX_MF, OU_MAIL_STOP) in the S_CONTACT base table. As shown in this figure, the First Name field references the FST_NAME column, the Job Title field references the JOB_TITLE column, and so on.

Example of how fields in a business component reference columns in a base table: This image is described in the surrounding text.

A business component does not always reference all columns that reside in the base table, but typically it does reference most of them. Implied fields in the business component represent system columns in the base table, such as ROW_ID, CREATED_BY, and LAST_UPD_BY. A system column does not require a field object definition in the business component.

For more information, see How an Implicit Join Creates a Relationship Between a Base Table and a Business Component.