Siebel Object Types Reference > Siebel Object Types Reference > Business Component Object Types >

Single Value Field


A single value field defines properties for a single value field.

This object type occurs in the following location in the object hierarchy:

Table 76 describes properties that Siebel CRM uses with a single value field.

Table 76. Properties of the Single Value Field
Property
Description

Calculated (O)

If TRUE, then Siebel CRM calculates the value for this field.

Calculated Value (O)

Specifies an expression that Siebel CRM uses to calculate value for this field.

Column (R)

Specifies the name of a database table column. This name is case-sensitive. It must use the same format that it uses in the Siebel database.

The Column property is not allowed for a calculated field. It is required for a field that Siebel CRM does not calculate.

Currency Code Field (O)

Specifies the name of the currency code field that Siebel CRM uses with a DTYPE_CURRENCY data type. The default value is Currency Code.

Exchange Date Field (O)

Specifies the name of the exchange date field that Siebel CRM uses with a DTYPE_CURRENCY data type. The default value is Exchange Date.

Force Active (O)

If TRUE, then Siebel CRM gets the data value from the Siebel database. For best performance, it is recommended that you set the Force Active to FALSE in most situations.

This property does not affect how browser script references or uses the value that this field contains.

Force Case (O)

Specifies the case for the field value. You can use one of the following values:

  • UPPER
  • LOWER
  • FIRSTUPPER

Hidden (O)

If TRUE, then Siebel CRM does not display this field in any list view that it creates dynamically at runtime. If business component data is:

  • Of type DTYPE_ID, then the default value is TRUE.
  • Not of type DTYPE_ID, then the default value is FALSE.

Join (O)

Specifies the name of the join that this field uses. Siebel CRM uses this name only if the field value it gets is from the table that the join defines. For more information, see Join.

Link Specification (O)

If TRUE, then Siebel CRM sends the field value as a default value to a field in a child business component. If a business component is a child of this link, and if this business component uses the Parent type of default value, and if it expects to get a value, then a link specification is required.

For performance reasons, it is recommended that you set the Link Specification property TRUE only if Siebel CRM must predefault the parent value to the child value through the link. This configuration requires Siebel CRM to get the column value any time that this object is active. It is similar to the configuration that Siebel CRM uses for the ForceActive property.

This property does not affect how browser script references or uses the value that this field contains.

Message Display Mode

Specifies the details that Siebel CRM displays in the validation message. You can use one of the following values:

  • User Msg. Display only the message that you define in Siebel Tools.
  • User Msg with Error Code Only. Display the message and the error code that the Application Object Manager returns.
  • User Msg with Error Code/Msg. Display the message that you define in Siebel Tools Display. Also display the message and the error code that the Application Object Manager returns.

Name (R)

Specifies a name for this field. This name must be unique in the business component. It can contain spaces. Other objects use this name to reference this field.

No Copy (O)

If TRUE, then Siebel CRM does not copy the field value to the new record during a Based On Last operation.

Oracle Sequence Object (O)

Specifies the name of an Oracle sequence object. It determines the sequence that Siebel CRM uses for field defaults when it creates a new record.

PickList (O)

Specifies the name of a picklist that Siebel CRM uses to display a list of valid values that the user can choose.

Post Default Value (O)

Specifies a value that Siebel CRM uses for this field if the user does not enter a value and saves the record. Siebel CRM does not validate this value for a calculated field.

The Post Default Value property can contain no more than 255 characters.

Pre Default Value (O)

Specifies the value that Siebel CRM uses for an empty field if an Add New Record or Copy Record operation creates a new record. The user might modify this value before Siebel CRM writes it to the Siebel database. Siebel CRM does not validate this value for a calculated field.

The Post Default Value property can contain no more than 255 characters.

Precision (O)

For more information, see About the Scale and Precision Properties.

Read Only (O)

If TRUE, then the user cannot modify the field value. Some fields are read-only even if the Read Only property is FALSE. For example, the Effective Start Date field for the following business components is read-only:

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

In general, a field that references a joined table is read-only. There are two exceptions to this rule:

  • The join references an extension table.
  • The join references an active intersection table.

For more information, see Join.

Required (O)

If TRUE, then the user must enter a value in this field before Siebel CRM can write the record to the Siebel database.

For information about how you can use a user property to control required according to an expression, see Siebel Developer's Reference.

Scale (O)

For more information, see About the Scale and Precision Properties.

Text Length (O)

Specifies the maximum length of text that the user can enter in this field. Siebel CRM typically ignores this property. It gets the length from the underlying column definition.

Type (R)

Specifies the data type for this field. You must make sure that the type you choose uses the same data type that the column uses. The Column property of this field specifies this column.

Validation (O)

Specifies the expression Siebel CRM uses to make sure the data that the user enters is correct. You can use validation only with a single value field. You cannot use it with a multivalue field. The Validation property can contain no more than 255 characters.

Siebel Object Types Reference Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.