Stores administrator-specified default currency rate and geocoding settings.
Touchstone 2022 Database Reference
tDefaultUserOption Table
Stores administrator-specified default currency rate and geocoding settings.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 3 |
| Data Space Used | 8.00 KB |
| Index Space Used | 56.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DefaultUserOptionSID | Unique system-generated sequential identifier for the default user options record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the default options. | int | 4 | ||||
| AnalysisCurrencyExchangeRateSetSID | Unique system-generated sequential identifier for the default currency exchange rate set used during analysis. For a complete list of records, see tCurrencyExchangeRateSet Table. | int | 4 | ||||
| AnalysisCurrencyCode | ISO 3-character code for the default currency used during analyses. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| ViewingCurrencyExchangeRateSetSID | Unique system-generated sequential identifier for the default currency exchange rate set used to display results. For a complete list of records, see tCurrencyExchangeRateSet Table. | int | 4 |  | |||
| ViewingCurrencyCode | ISO 3-character code for the default currency used to display results. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| ResultDataSourceSID | Unique system-generated sequential identifier for the data source (database) in which the results are stored. For a complete list of records, see tDataSource Table. | int | 4 | | |||
| ResultDataSourceName | Name of the data source (database) in which the results are stored. | varchar | 255 | | |||
| IsInternationaGeocodingEnabled | Indicates whether geocoding of international locations in enabled.
| bit | 1 | ((0)) | |||
| GeocodeOption | XML string that defines the geocode option. Used internally by Touchstone. | xml | 0 | | |||
| ViewingCurrencyUnit | Not used by Touchstone. | tinyint | 1 | | ((1)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCurrencyExchangeRateSet | Table | Stores information about the exchange rate sets available in the application. For more information about the currency exchange rate sets, see tCurrencyExchangeRateSetConversion Table. | 2 |
| tCurrencyExchangeRateSetConversion | Table | Stores information about the exchange rate set that corresponds to each currency in the application. For more information about the exchange rate sets, see tCurrencyExchangeRateSet Table. | 1 |