| Bookshelf Home | Contents | Index | Search | PDF | |
Siebel Tools Reference > Business Objects Layer >
Fields
A field associates a column with a business component. This is how columns are assigned to a business component, and provided with meaningful names that do not require knowledge of the tables or joins of their origin.
Fields are the source of data for controls and list columns in applets. Figure 87 illustrates data from fields displayed in a form applet.
Figure 88 illustrates data from fields displayed in a list applet.
As you can see from Figure 87 and Figure 88, controls in a form applet and list columns in a list applet obtain their data from fields in the business component used by the applet. The Field property setting in a Control or List Column object definition specifies the field. The Business Component property in the applet specifies the business component. These property relationships are illustrated in Figure 89.
Field is a child object type of Business Component. A field represents information from a database column obtained through the corresponding column object definition. Columns may be from the base table, extension tables, and joined tables of the business component. Alternately, a field may be a calculated field whose values are derived from the values in other fields in the business component, but not stored in the database.
In the field object definition (for other than calculated fields), the column and Join properties together specify the table and column from which the field's data is obtained. The Join property, if blank, indicates that the column is obtained from the business component's base table. If it is non-blank, the Join property identifies the join object definition that supplies data from an extension table or other joined table. Based on the Join property, the table supplying the field's data is identified. The Column property identifies the column to use within the specified table. These relationships are illustrated in Figure 90.
NOTE: You should not map multiple fields to the same column in a table. This can lead to error messages when updating the data. The SQL query fails because it tries to access the same column twice in the same query.
| Bookshelf Home | Contents | Index | Search | PDF | |
Siebel Tools Reference, Version 7.5, Rev. A Published: 18 April 2003 |
