Touchstone 4.0 Database Documentation
mvwCityStateZip Table
Description
Stores information regarding city/state/ZIP combinations.
Properties
Creation Date12/14/2006 4:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows355152
Data Space Used18,432.00 KB
Index Space Used29,000.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key cszIDIdentifier for the city/state/ZIP combination.Integer4   
 statecdCode that represents the state (area) code.Char2   
 aircountyidCode that represents the county (subarea) where the ZIP-5 resides.Integer4   
 citytestAlternative name for the city.VarChar40   
 cityName of the cityVarChar40   
 zip55-digit ZIP Code.Char5   
See Also

Related Objects

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