Configuring Siebel Business Applications > Reference Materials for Configuring Siebel Business Application > Properties of Object Types >

Type Property of a Business Component Field


Table 87 describes the data types that are included in the Type property of a business component field. Siebel CRM prefaces all field data types with the following text: DTYPE_.

Table 87. Type Property of a Business Component Field
Field Data Type
Physical Type
Maximum Length
Description

DTYPE_BOOL

Character

1

Describes data as Y or N. Siebel Tools often displays this type in the following ways:

  • TRUE or FALSE
  • checked or unchecked

DTYPE_CURRENCY

Number

22

Describes data as currency.

You can use the Windows Control Panel to control the appearance of currency values that Siebel CRM displays in a screen.

To define an explicit format mask in the Display Format property, you can also use the following symbols:

  • Dollar sign ($). Specifies the position for the currency symbol.
  • Trailing period (.). Specifies the default precision for the currency.
  • All valid symbols described for DTYPE_NUMBER.

DTYPE_DATE

Date

7

Describes data as a date. When Siebel CRM returns the date, it ignores other information, such as time. For more information, see Formats for the Date Physical Type.

DTYPE_DATETIME

Date Time

7

Describes data as a date and time. You can use the Windows Control Panel to set the appearance of time and date values. You can also use a combination of DTYPE_DATE and DTYPE_TIME to configure an explicit date format.

Alternatively, you can use one of the following properties. Each of these properties use the format configured in the Windows Control Panel:

  • Date. Displays only the date portion of the value.
  • Time. Displays only the time portion of the value.
  • TimeNoSec. Displays only the hour and minute portion of the value.

DTYPE_UTCDATETIME

UTC Date Time

30

Describes data as date information, with a date and a time component, which Siebel CRM stores in the Siebel database in UTC time. UTC is the equivalent of Greenwich Mean Time without any adjustments for daylight savings time.

A field of this type must correspond to a database column of type U. The default time zone that is configured in the user preferences determines how Siebel CRM converts the display value for this field to or from UTC time.

DTYPE_ID

Varchar

15

Describes data as the primary key that Siebel CRM automatically generates.

A field mapped to an extension column with a physical type of Varchar(15) automatically defaults to a DTYPE_ID data type.

DTYPE_INTEGER

Number

22*

Describes data as a whole number ranging in value from negative 2147483648 to 2147483647.

DTYPE_NOTE

Long

16 KB

Describes data as a long string that is less than or equal to 16 KB, or 16383 bytes. If the length is not explicitly defined, then the default is 16 KB. If used with the Pop-up Edit property in a control or list column, then the DTYPE_NOTE data type indicates to the Siebel client to use a multiline edit box.

The user cannot query on a DTYPE_NOTE field.

DTYPE_NUMBER

Number

22

Describes data as a number. For more information, see Formats for a DTYPE_NUMBER Business Component Field.

DTYPE_PHONE

Number

40

Describes data as a phone number. Siebel CRM ignores the DisplayFormat property for DTYPE_PHONE values.

DTYPE_TEXT

Varchar

2 KB

Describes data as a string that is less than or equal to 4000 bytes. The default value is 255. Siebel CRM ignores the DisplayFormat property for DTYPE_TEXT values.

DTYPE_TIME

Time

7

Describes data as a time.

When Siebel CRM retrieves the time, it ignores other information. You can set the appearance of time values through the Windows Control Panel, or you can use the following symbols to specify an explicit time:

  • HH. Hour according to a 24-hour clock without a leading zero.
  • H. Hour according to a 24-hour clock with a leading zero.
  • hh. Hour according to a 12-hour clock without a leading zero.
  • h. Hour according to a 12-hour clock with a leading zero.
  • mm. Minute without a leading zero.
  • m. Minute with a leading zero.
  • ss. Second without a leading zero.
  • s. Second with a leading zero.
  • Colon (:). The position of the time separator. You specify the character in the Windows Control Panel.

Formats for the Date Physical Type

You can use the Windows Control Panel to control the appearance of date values that Siebel CRM displays in a screen.

To define an explicit date format, you can also use the following symbols:

  • YY. Two-digit year without a leading zero.
  • Y. Two-digit year with a leading zero.
  • YYYY. Four-digit year without a leading zero.
  • YYY. Four-digit year with a leading zero.
  • MM. Month without a leading zero.
  • M. Month with a leading zero.
  • DD. Day without a leading zero.

For more information, see How Siebel CRM Handles Certain Date Formats.

Formats for a DTYPE_NUMBER Business Component Field

You can use the Windows Control Panel to control the appearance of numeric values, or you can use the following symbols to specify an explicit format mask:

  • Zero (0). Specifies the position of a mandatory digit.
  • Pound sign (#). Specifies the position of an optional digit.
  • Comma (,). Specifies the position of the thousands separator. You specify the character in the Windows Control Panel.
  • Period (.). Specifies the position of the decimal separator. You specify the character in the Windows Control Panel.
  • Trailing period (.). Specifies default display precision.
  • Plus sign (+). Specifies the position and appearance of the positive value indicator.
  • Minus sign (-). Specifies the position and appearance of the negative value indicator.

There are restrictions regarding the number of digits you can use with a business component field whose Type property is DTYPE_NUMBER. For more information, see Maximum Number of Digits for a Numeric Physical Type.

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