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

Display Format Property of a Control or List Column


Table 86 describes values for the Display Format property of a control or list column.

Table 88. Values for the Display Format Property of a Control or List Column
Property
Description

DTYPE_NUMBER

Can include the following values:

  • 0 (zero)
  • # (pound sign)
  • + (plus sign)
  • - (minus sign)
  • , (comma)
  • . (period)

If empty, then to determine the appearance of numeric values, Siebel CRM uses the Regional Settings section of the Windows Control Panel.

DTYPE_CURRENCY

Uses the same symbols as with the DTYPE_NUMBER property, in addition to the dollar sign.

To control how Siebel CRM displays currency, in the Siebel client, you navigate to the Application Administration screen, choose the Currencies view, and then modify the Scale field.

DTYPE_DATETIME

Stores one of the following values in the Display Format property:

  • Date
  • DateTime
  • DateTimeNoSec
  • TimeNoSec

DTYPE_DATE

Uses a combination of the following values:

  • MM/DD/YY

where:

  • MM is the month
  • DD is the day
  • YY is the year

If empty, then to determine the appearance of date values, Siebel CRM uses the Regional Settings section of the Windows Control Panel. For more information, see How Siebel CRM Handles Certain Date Formats.

DTYPE_TIME

You can use one of the following formats:

  • Specify TimeNoSec.
  • Specify a format mask using a combination of the following values:
    • HH:hh:mm:ss

      where:

    • HH is the hours
    • hh is the hours
    • mm is the minutes
    • ss is the seconds

If empty, then to determine the appearance of time values, Siebel CRM uses the Regional Settings section of the Windows Control Panel.

DTYPE_PHONE

If empty, then to determine the appearance of phone values, Siebel CRM uses the Regional Settings section of the Windows Control Panel.

How Siebel CRM Handles Certain Date Formats

If you set DDD, DD/MM/YYYY as the display format on a date list column, then Siebel CRM displays the date with the expected format but you cannot update the date. If you attempt to update the date, then Siebel CRM displays an error that is similar to the following:

Can't convert formatted string to its internal representation. Please check if your data is in correct format.

The same situation occurs if you use the DDD/MM/YYYY format.

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