GetZip4Master

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

zipcode

6 character zip code

zip4code

4 character zip4 code

XML Tag

Column Name

Data Type

Nullable

Definition

zip4_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

zip4_zipcode

ZIPCODE

CHAR(6)

N

ZIP code for this address. Valid Values: 6th character could be special city code linking to a city description..2 cities one zip..alpha cc

zip4_zip4end

ZIP4END

CHAR(4)

N

Zip+4 ending range tied to 5 digit zip code. Valid Values:

zip4_zip4start

ZIP4START

CHAR(4)

N

Zip+4 start range tied to 5 digit zip. Valid Values:

zip4_carrout

CARROUT

CHAR(4)

N

Carrier route assigned to zip+4 range. Valid Values:

zip4_lstupddte

LSTUPDDTE

DATETIME

N

Last CRIS update from Pay 80. Valid Values: YYDDD

zip4_spclcity

SPCLCITY

CHAR(1)

N

The first 3 digits from zip if city has no P.O.. Valid Values:

zip4_scf

SCF

CHAR(3)

N

The special center facility identifier if no P.O.. Valid Values:

8/31/01

Removed erroneous grouping tags in Output XML