Object Types Reference > Siebel Object Types >

Single Value Field

Siebel Object Types > Business Component > Single Value Field

Displays the properties of field object definitions that are applicable to only those fields that are not multi-value fields. When selected, only records that are not multi-value fields are displayed.

Valid Values/Examples

Calculated (O)

A TRUE or FALSE value.

TRUE = Causes the field's value to be calculated by the business component.

Calculated Value (O)

An expression to calculate the field's value.


Column (R)

The name of the database table's column. The column's name is case-sensitive and must be specified the same as it is in the database. Every reference to the field is made through its name.

This property is not allowed for calculated fields but is required for other fields.


Currency Code Field (O)

The name of the currency code field.

Used with a data type of DTYPE_CURRENCY.

Default is Currency Code.

Exchange Date Field (O)

The name of the exchange date field.

Used with a data type of DTYPE_CURRENCY.

Default is Exchange Date.

Force Active (O)

A TRUE or FALSE value.

For best performance, do not use Force Active except where necessary.

TRUE = Specifies that the data value is always retrieved from the database.

Force Case (O)

The case for the field value.

Valid values are UPPER, LOWER, and FIRSTUPPER.

Hidden (O)

A TRUE or FALSE value that governs whether the field is displayed.

For a business component data type of DTYPE_ID, the default is TRUE; otherwise, the default is FALSE.

TRUE = Makes the field invisible to all dynamically created list views.

Join (O)

The name of the join object definition used by this field.

Used when the value of the field is retrieved from the table defined by the join.

See also Join.


Link Specification (O)

A TRUE or FALSE value.

A link specification is necessary if any business component used as the child of a link from this business component uses the Parent type of default values and expects to get a value.

For best performance, only use if you need to predefault the parent value to the child value through the link, because this setting results in the column always being retrieved any time this object is active. Similar to ForceActive.

TRUE = Passes the field's value as a default value to a child business component's field.

Name (R)

The user-defined name for the field.

The name must be unique within the business component. All references to the field are made through its name.

The name can contain spaces.

No Copy (O)

A TRUE or FALSE value.

TRUE = During a Based On Last operation, causes the field's value not to be copied into the newly created record.

Oracle Sequence Object (O)

The name of an Oracle sequence object. The sequence is used for field defaults when creating a new record.


PickList (O)

The name of a picklist object definition used to display a list of valid values from which the user can choose.


Post Default Value (O)

Used to fill in a default value for a field if the user leaves the field blank and saves the record. Just before the row is committed, if the field is blank, the Post Default Value is used for the field. If the field has a user-entered value, the Post Default Value is not used.

This property is not validated for a calculated field.

Limited to 255 characters.

Pre Default Value (O)

The value used for an empty field when a new record is created through an Add New Record or Copy Record operation. The value might be changed by the user before the record is written to the database.

This property is not validated for a calculated field.

Limited to 255 characters.

Precision (O)

The maximum number of digits, to the left and right of the decimal point, for a numeric field.

Default is 16.

The maximum value available is database dependent.

Read Only (O)

A TRUE or FALSE value.

Certain fields are read-only even if the Read Only property is FALSE. The Effective Start Date field for the following business components is always read-only:

  • Account Product
  • Promotion
  • Promotion Account
  • Promotion Account Product
  • Promotion Administration
  • Promotion Product

In general, fields that are based on a joined table are always read-only. There are two exceptions to this rule: joins to extension tables and joins to active intersection tables.

See also Join.

TRUE = Prevents the field value from being changed by the user.

Note that it is also possible to make a field read-only at the applet level.

Required (O)

A TRUE or FALSE value.

There is a user property available to control Required based on an expression. For more information, read Siebel Developer's Reference.

TRUE = Requires a value to be entered into the field before the record can be written to the database.

Scale (O)

The maximum number of digits to the right of the decimal point for a numeric field.

Values are 6 for numeric values and 0 for integers.

The maximum value available is database dependent.

Text Length (O)

The maximum length of the text in the field.

This property is usually ignored, and the length is retrieved from the underlying column definition.


Type (R)

The field's data type. Be sure that the type you select corresponds to the data type in the physical layer.


Use Default Sensitivity (O)

A TRUE or FALSE value.

TRUE = Causes the sensitivity mode that the application is running in (as defined in the data source) to be used in QBE searches that do not explicitly specify which sensitivity mode to use.

Validation (O)

The expression used to ensure data correctness when data is entered.

Should be used only with single value fields, not MVFs.

The property text is limited to 255 characters.

See Also

Business Component
Multi Value Field

Object Types Reference