# | Name | Location | Type | Details | Index | Description |
---|---|---|---|---|---|---|
.01 | mail code(+) | 0;1 | FREE TEXT | B | This field holds recognized postal codes. Although this file will only start with US postal codes, it may be expanded in the future to also contain postal codes from other countries. | |
1 | city | 0;2 | FREE TEXT | C | This field holds the city represented by this Postal Code. | |
2 | county | 0;3 | POINTER | 5.13 | AC | This field contains a pointer to the County that this Postal Code is within. |
3 | state | 0;4 | POINTER | 5 | This field contains a pointer to the State File to represent the state associated with this Postal Code. | |
4 | inactive date | 0;5 | DATE-TIME | This is the date that the Postal Code became Inactive. | ||
5 | city key(+) | 0;6 | FREE TEXT | D | This is the unique City State Key that has been assigned by the USPS. | |
6 | preferred city key(+) | 0;7 | FREE TEXT | This key is assigned by USPS. | ||
7 | city abbreviation | 0;8 | FREE TEXT | This field contains the USPS's city abbreviation. | ||
8 | unique key (va)(+) | 0;9 | FREE TEXT | E | This field is the value when the MAIL CODE(#.01) and the CITY KEY(#6) are concatenated. The purpose of this field is to create a unique lookup value using the "E" cross-reference. |
Not Referenced