Touchstone 4.0 Database Documentation
tConvertCL2Country Table
Description

Stores information regarding the county names used in CLASIC/2. This information is used to convert CLASIC/2 country names to Touchstone country names.

Properties
Creation Date1/23/2015 7:25 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows280
Data Space Used16.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OldAreaLevel1

CLASIC/2 code for the area Level 1 (country).

SmallInt2   
 OldAreaLevel1Name

CLASIC/2 name for the Area Level 1 (country).

VarChar60  
 CountryCode

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

For a complete list of codes, see tCountry Table.

VarChar15  
 CountryNameName of the country.VarChar255  
 DescriptionDescription of the country.VarChar1024  
 OldAreaLevel1BriefNameCLASIC/2 abbreviated name for the country.VarChar15  
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.