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.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 1026 |
| Data Space Used | 40.00 KB |
| Index Space Used | 80.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CurrencyExchangeRateSetSID | Unique system-generated sequential identifier for the exchange rate set record. For a complete list of records, see tCurrencyExchangeRateSet Table. | int | 4 | |||
| | CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | |||
| ExchangeRate | Conversion factor that represents the exchange rate. The application uses the factor during currency conversion operations. | numeric | 9 (20,15) | ||||
| AsOfDate | Date the exchange rate became valid for use. | date | 8 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tDefaultUserOption | Table | Stores administrator-specified default currency rate settings. | 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 |