Touchstone 4.0 Database Documentation
tCountryCurrencyXref Table
Description
Reserved for internal use, this system reference table is used by Touchstone to map currency to a county when exporting CLF and UNICEDE/2 files for CATRADER .
Properties
Creation Date3/5/2014 4:30 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows107
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)
Boolean1  
Objects that tCountryCurrencyXref depends on
 Database ObjectObject TypeDescriptionDep Level
tCurrency tabletCurrencyTable

Stores the AIR currency codes.

1
See Also

Related Objects

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