CEDE 2024 (12.0) Database Reference
tCountryCurrencyXref Table
AIRReference Database : tCountryCurrencyXref Table
Description
System reference table used to map currencies to countries when exporting company loss files (CLFs) and UNICEDE/2 files for CATRADER.
Properties
Creation Date3/5/2014 4:30 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows206
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

varchar15   
Primary Key CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

char3   
 IsDefault

Indicates whether the currency is the default.

  • 1 = Yes (default)
  • 0 = No (not default)
bit1  
Objects that tCountryCurrencyXref depends on
 Database ObjectObject TypeDescriptionDep Level
tCurrency tabletCurrencyTable

Stores AIR currency codes.

1
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2024. Extreme Event Solutions.

Please send your feedback or questions to SoftwareDocumentationFeedback@verisk.com.