FO_Zips
This table requires a single record for each zip code. Its purpose is to create a data entry point link between zip code, city, state and county. The data is often imported and represents standard USPS postal definitions. The data can be obtained from http://federalgovernmentzipcodes.us/
| Field | Type | Notes |
|---|---|---|
|
ZipCode |
varchar(50) |
Postal zip code (5 character version for USA) |
|
City |
varchar(50) |
City name associated with this zip code. |
|
St |
varchar(50) |
Standard two character state postal abbreviation. |
|
Country |
varchar(50) |
Country |
|
Zip_ID |
int |
ID field, a counter. Unique |
|
SalesTaxPercent |
decimal(18, 2) |
Enter a real number as the sales tax for the zip code. This will be referenced by the Payment Collection Module. For a sales tax percent of 8.36%, enter 8.36 |
|
County |
varchar(50) |
County associated with this zip code. |
|
DefaultTown |
bit |
Enter 0 or 1 0 = not default town, city, for this zip code 1 = default town, city, for this zip code |
|
ZipType |
varchar(50) |
USPS zip type for this zip code. Informational |
|
Lattitude |
varchar(50) |
USPS latitude for this zip code. Informational |
|
Longitude |
varchar(50) |
USPS longitude for this zip code. Informational |
|
AreaCode |
varchar(500) |
Telephone area code. |
|
StateName |
varchar(50) |
State name. |
|
CityType |
varchar(50) |
USPS city type for this zip code. Informational |