How Siebel CRM Handles Data Types During a Calculation

The Type property of a field specifies the data type. A multivalue field gets the data type from the source field. Siebel CRM can convert some types to another type during a calculation. Some operations might create different results with different types. For example, "10" + "10" creates "1010", while 10 + 10 creates 20.

An item that occurs first in a calculation possesses a higher precedent. For example, "10" + 10 creates the following result. Siebel CRM converts the argument that is after the operator to a string:

"1010"

For example, 10 + "10" creates the following result. Siebel CRM converts the argument that is after the operator to a number:

20

The Type property of a field can contain one of the following values. The user cannot query a DTYPE_NOTE field:

• DTYPE_BOOL

• DTYPE_CURRENCY

• DTYPE_DATE

• DTYPE_DATETIME

• DTYPE_ID

• DTYPE_INTEGER

• DTYPE_NOTE

• DTYPE_NUMBER

• DTYPE_PHONE

• DTYPE_TEXT

• DTYPE_TIME

• DTYPE_UTCDATETIME