Siebel Developer's Reference > Operators, Expressions, and Conditions >

Field Object Data Types

All field objects have a data type. Single-value fields have a data type value. Multivalue fields inherit the data type from the source field. Many types can convert to other types during calculations. Many operations produce different results with different types. For example, "10" + "10" produces "1010", while 10 + 10 produces 20.

Calculations in Oracle's Siebel Business Applications are "left-centric"; for example, "10" + 10 produces "1010", while 10 + "10" produces 20. In the first example, the right argument 10 converts itself to a string, but in the second example, the right argument "10" converts itself to a number.

Field objects can have any of the following Siebel data types:

• DTYPE_BOOL
• DTYPE_CURRENCY
• DTYPE_DATE
• DTYPE_DATETIME
• DTYPE_ID
• DTYPE_INTEGER
• DTYPE_NOTE
• DTYPE_NUMBER
• DTYPE_PHONE
• DTYPE_TEXT
• DTYPE_TIME
• DTYPE_UTCDATETIME

NOTE:  Users cannot query on fields of type DTYPE_NOTE.