1. Object Types Reference
  2. Configuring the Type Property of a Field

Configuring the Type Property of a Field

The Type property of a field corresponds to the physical type of the table column that resides in the Siebel database:

  • The value in the Type property includes a DTYPE_ prefix.

  • You must use the data types that come predefined with Siebel CRM.

  • If you configure Siebel CRM to map a column to a data type, then you must make sure you configure it to use a similar type. For example, Siebel CRM can map an integer column to the DTYPE_INTEGER data type. It cannot map an incompatible type. For example, it cannot map a Long column to the DTYPE_BOOL data type.

The following table describes the data types that Siebel CRM supports for a field.

Data Type Description

DTYPE_BOOL

This data type includes the following qualities:

  • Stores Boolean data, such as Y or N.

  • Mapped to a column that uses a Character(1) physical type and length.

  • Typically displayed as TRUE or FALSE, or checked or unchecked.

DTYPE_CURRENCY

This data type includes the following qualities:

  • Stores currency data.

  • Mapped to a column that uses a Number physical type.

DTYPE_DATE

This data type includes the following qualities:

  • Stores date data. It ignores other saved data, such as time.

  • Mapped to a column that uses a Date physical type.

DTYPE_DATETIME

This data type includes the following qualities:

  • Stores date and time data.

  • Mapped to a column that uses a DateTime physical type.

DTYPE_ID

This data type includes the following qualities:

  • Stores a key that Siebel CRM creates.

  • Mapped to a column that uses a Varchar(15) physical type and length.

DTYPE_INTEGER

This data type includes the following qualities:

  • Stores integer data.

  • Mapped to a column that uses a Number physical type.

DTYPE_NOTE

This data type includes the following qualities:

  • Stores long string data.

  • Mapped to a column that uses a Long physical type.

DTYPE_NUMBER

This data type includes the following qualities:

  • Stores number data.

  • Mapped to a column that uses a Number physical type.

DTYPE_PHONE

This data type includes the following qualities:

  • Stores phone number data.

  • Mapped to a column that uses a Varchar(40) physical type and length.

DTYPE_TEXT

This data type includes the following qualities:

  • Stores string data.

  • Mapped to a column that uses a Varchar physical type.

  • Uses upper and lower case text that the user enters.

  • The ForceCase property on a field can force text to Upper, Lower, or FirstUpper case.

DTYPE_TIME

This data type includes the following qualities:

  • Stores time data.

  • Mapped to a column that uses a Time physical type.

  • Siebel CRM ignores other saved data, such as date.

DTYPE_UTCDATETIME

Specifies the time as Greenwich mean time (GMT). For more information, see Siebel Global Deployment Guide.