Stores information about the exchange rate sets available in the application.
For more information about the currency exchange rate sets, see tCurrencyExchangeRateSetConversion Table.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 6 |
| Data Space Used | 8.00 KB |
| Index Space Used | 56.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CurrencyExchangeRateSetSID | Unique system-generated sequential identifier for the exchange rate set record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the exchange rate set. | int | 4 | ||||
| BaseCurrencyCode | ISO 3-character code for the base currency used with the exchange rate set. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| CurrencyExchangeRateSet | Name of the currency exchange rate set. | varchar | 40 | ||||
| IsAIRStandard | Indicates whether the exchange rate set has been designated as standard.
| bit | 1 | ((0)) | |||
| Description | Description of the currency exchange rate set. | varchar | 4000 |  | |||
| EnteredDate | Date and time when the currency exchange rate set was created. | date | 8 | (getutcdate()) | |||
| EditedDate | Date and time when the currency exchange rate set was last modified. | date | 8 | (getutcdate()) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | 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 |
| tDefaultUserOption | Table | Stores administrator-specified default currency rate settings. | 1 |