Touchstone 4.0 Database Documentation
tCurrencyExchangeRateSetConversion Table

Stores detailed information about the exchange rate for each currency available in Touchstone. 

Information about the exchange rate sets is available in tCurrencyExchangeRateSet Table.

Creation Date5/31/2016 9:46 AM
Text File Group
System Object
Published for Replication
Data Space Used24.00 KB
Index Space Used80.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CurrencyExchangeRateSetSID

Unique system-generated sequential identifier for the exchange rate set record.

For a complete list of records, see tCurrencyExchangeRateSet Table.

Primary Key CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

 ExchangeRateConversion factor that represents the exchange rate. Used during the currency conversion calculation.Numeric9 (20,15)   
 AsOfDateDate the exchange rate was valid for use.VarWChar10   
Objects that depend on tCurrencyExchangeRateSetConversion
 Database ObjectObject TypeDescriptionDep Level
tDefaultUserOption tabletDefaultUserOptionTable

Stores the default non-catastrophe Loss analysis options. 

Objects that tCurrencyExchangeRateSetConversion depends on
 Database ObjectObject TypeDescriptionDep Level
tCurrencyExchangeRateSet tabletCurrencyExchangeRateSetTable

Stores information about the currency exchange rate sets available in Touchstone. 

Detailed information about the exchange rate for each currency is available in tCurrencyExchangeRateSetConversion Table.

See Also

Related Objects

AIRUserSetting Database



AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.