ZIPcode database

[hubix]

Hi, we want to integrate a german postal code database and need to know the meaning and the german equivalent of some datafields:

Zip Code = zip code number
Zip Code Type = U (unique) P (P.O.-box-only) S (standard)
City = Name of the City
City Type = ???
State = Name of the State
StateCode = Shorten State name
Area Code = ???
Latitude = coordinates
Longitude = coordinates

[Chuck S]

The only fields we really query in the database zipcode and lat and lon. If you look at the table structure you can have null values for anything else. Just format whatever zipcode thing your doing to the format of our table and you should be able to input them

Your meanings above look fine. City type as noted does not matter