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 >

Guidelines for Defining the Name of a Business Component Field

If you define the name of a business component field, then use the following guidelines:

  • Do not use parentheses in a field name. If you do a query on a field name that contains parentheses, then you might receive an SQL error because SQL expects a valid SQL expression in the parentheses.
  • Apply the following requirements if each field is the only such field in the business component:
    • If you name a currency code, then name it Currency Code.
    • If you name a currency date, then name it Exchange Date.

      If multiple instances of a similar field exist, then it is recommended that you prefix each field with the name of the corresponding Amount column. For example, Revenue Currency Code for revenue or Budget Currency Code for budgets. The reason for this configuration is that other fields reference these fields when you define the Currency Code Field property and the Exchange Date field. This configuration makes sure Siebel CRM can understand the reference.

  • For a link, you must name the URL field URL and you must set the Class property of the business component to CSSBCBase.

For more information, see the following topics:

      
Configuring Siebel Business Applications Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.