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.

Properties

Property
Description/Usage
Valid Values/Examples
Calculated (O)
A TRUE or FALSE value.
TRUE = Causes the field's value to be calculated by the business component rather than retrieved from the database server.
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. All references to the field are 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.
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.
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)
The value used for an empty field when the record is initially written to the database. This value is not used if the field is left empty on subsequent updates to the record.
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.
Required (O)
A TRUE or FALSE value.
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.
 
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
Field
Multi Value Field


 Object Types Reference 
 Published: 18 April 2003