6.3.11.2 Format Options for Pattern Roles
The following table describes the most commonly used format options for this field (case-sensitive).
Table 6-3 Format Options for Pattern Roles
| Format Option | Description |
|---|---|
| STRING | Does not apply formatting to the value returned from the database. This format is also useful for numbers that should not have thousands separators, for example, numeric account numbers. |
| INTEGER | Applies thousands separators to whole numbers. |
| REAL2 | Applies thousands separators to real numbers, truncating to two digits of fractional data. |
| REAL5 | Applies thousands separators to real numbers, truncating to five digits of fractional data. |
| $.00 | Applies thousands separators and a currency symbol, e.g., $, to a number. Fractions are displayed. For example, a positive number is displayed as $1,234.56 and a negative number is displayed as ($1,234.56). |
| $ | Applies thousands separators and a currency symbol to a number. Fractions are rounded to the nearest whole number. For example, positive numbers are displayed as $1,234 and negative numbers are displayed as ($1,234). |
| $K |
Applies thousands separators and a currency symbol to a number. Fractions are rounded to the nearest whole number. If the number is 1,000,000 or greater, the system rounds the number to the nearest thousand, and replaces the final three digits with the letter K.For example, positive numbers display as $1,234or $2,346K for $2,345678.90, while negative numbers display as ($1,234) or ($2,346K) for -$2,345678.90. |
| CURRENCY | Applies the appropriate currency format (base currency of installation) to a value. |
| MMDDYY | Displays the short form of the date, for example, 02/28/01. |
| MMDDYYYY | Displays the long form of the date is displayed, for example, 02/ 28/2001. |
| DATETIME | Displays the short date format and time format in the 24-hour clock,for example, 02/28/01 23:59:59. |
| HHMMSS | Displays the long time format in 24-hour clock. The expected input is an integer that represents a number of seconds. For example, the display of 93599 seconds is 25:59:59. |
| HHMMSS_PT | Displays the long Time format in 24-hour clock with milliseconds precision. For example, the display of 103001500 willbe as 10:30:01:500 |
| % | Displays the data as a percentage. |
| ALT_CUR | Used for cases where all highlights/roles are of the same
currency, but NOT base currency. The format for the amount(s) should be
ALT_CUR. Then, the scenarios will record an
additional binding with binding name Alt_Currency_Code
that holds the currency code. The highlights generator would then/take
find the value from the Alt_Currency_Code binding and
use it to format all of the bindings with format
ALT_CUR. For example: OrderPrice role with
format ALT_CUR and Alt_Currency_Code
binding with value as ISSUE_CRNCY_CD from pattern,
let's say value is EUR. Thus OrderPrice will be displayed as xxx
EUR. Here xxx is the value coming from pattern.
|
| REF_CUR | Used for cases where all highlights/roles are not of the
same currency (including base currency) or different bindings having
different currencies to display, use a format code
REF_CUR for the amount, and then have an additional
binding with the same name, but with _CUR on the end
and contain the currency to be used. For example, define TradePrice
and ActivityPrice roles with format REF_CUR
and TradePrice_CUR, and
ActivityPrice_CUR binding to hold the Currency to
be used for the above, say EUR and USD respectively. Thus they will be
displayed as TradePrice : xxx EUR & ActivityPrice : zzz USD.
Here xxx and zzz are the values coming from pattern.
|