Type Property of a Business Component Field

The following table describes the data types that Siebel CRM includes in the Type property of a business component field. Siebel CRM prefaces all field data types with the following text: DTYPE_.

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 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 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 that includes a date and a time component that 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 creates. A field mapped to an extension column with a physical type of Varchar(15) 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 gets 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.