Touchstone 4.0 Database Documentation
tCurrencyExchangeRateSetConversion Table
Description

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

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

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows676
Data Space Used24.00 KB
Index Space Used80.00 KB
Columns
 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.

Integer4   
Primary Key CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3   
 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. 

1
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.

2
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.