CEDE 9.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
Rows204
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

 

 

© 2021. 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.