LocaleNumCurrFormatLU (ver7.0.0)
Number and currency formats supported by the system. This table is pre-seeded with common values; it is possible (though probably not necessary) to add new ones through the application.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DecimalSeparator | 7.0.0 | Char(1) | Required. Foreign Key to LocaleSeparatorLU.LocaleSeparatorCode The character used as the decimal separator for this Numeric or Currency format. |
DisplayLabel | 7.0.0 | Varchar2(100) | Required. The 'user friendly' label displayed when referencing this format. |
GroupSeparator | 7.0.0 | Char(1) | Required. Foreign Key to LocaleSeparatorLU.LocaleSeparatorCode The character used as the grouping separator for this Numeric or Currency format. |
LocaleNumCurrFormat | 7.0.0 | Varchar2(100) | Required. The format used within the application to format numeric or currency values by locale. This is independent of the specific characters chosen as decimal or group separators. |
LocaleNumCurrID | 7.0.0 | Number(10) | Required. The unique identifier for this format. |
WhenCreated | 7.0.0 | Timestamp | Required. Created timestamp. Defaults to system date. |
WhenModified | 7.0.0 | Timestamp | Modified timestamp. Defaults to system date. |
WhoCreated | 7.0.0 | Varchar2(100) | Required. User that created the record. Defaults to user. |
WhoModified | 7.0.0 | Varchar2(100) | User that modified the record. Defaults to user. |