Download File Record Layout

Field Name

Type

Width

Description

COMPANYID

Numeric

11

Unique Company Identification Number

COMPNAME

Character

65

Company Name

MAILADDR

Character

40

Mailing Address

MAILCITY

Character

30

Mailing City

MAILSTATE

Character

2

Mailing State

MAILZIP

Character

10

Mailing Zip Code + ZIP4
            (Example: "12345-6789")

MAILCTSTZIP

Character

45

Mailing City, State, ZIP combination
            (Example: "Evanston, IL 60201-1569")

LATITUDE Character           8 Latitude Coordinate of Mailing Address
LONGITUDE Character           8 Longitude Coordinate of Mailing Address

PHYSADDR

Character

40

Physical Address

PHYSCITY

Character

30

Physical City

PHYSSTATE

Character

2

Physical State

PHYSZIP

Character

5

Physical Zip Code

PHYSCOUNTY

Character

30

Physical County

VNUMBER

Character

12

Main Telephone (Example: "234-567-8901")

VNUMBER10

Character

10

Main Telephone (Example: "2345678901")

VAREACODE

Character

3

Main Telephone Area Code (Example: "234")

VLOCALNUMBER

Character

7

Main Telephone Local Number (Example: "5678901")

FNUMBER

Character

12

Fax Telephone Number (Example: "234-567-8901")

FNUMBER10

Character

10

Fax Telephone Number (Example: "2345678901")

FAREACODE

Character

3

Fax Telephone Area Code (Example: "234")

FLOCALNUMBER

Character

7

Fax Telephone Local Number (Example: "5678901")

NNUMBER

Character

12

National WATS (800) Telephone Number
            (Example: "877-567-8901")

NNUMBER10

Character

10

National WATS (800) Telephone Number
            (Example: "8775678901")

NAREACODE

Character

3

National WATS Telephone Area Code (Example: "888")

NLOCALNUMBER

Character

7

National WATS Telephone Local Number
            (Example: "5678901")

WEB

Character 

100

Company Web Address

EMAIL

Character 

100

Company E-mail Address

YEARESTAB

Character

4

Year Established

DISTRIBTYP

Character

13

Area of Distribution

ISO

Character

6

Company ISO rating

OWNERTYPE

Character

20

Ownership Type

IMPORTS

Character

1

Imports? ("Y" or "N")

LOCCOUNT

Numeric

11

Employees at Location

MINSALES

Numeric

19

Minimum Annual Sales Volume

MAXSALES

Numeric

19

Maximum Annual Sales Volume

SQUAREFEET

Numeric

11

Square Footage of Plant

COMPUTERSYSTEM

Character

15

Computer system information

PRIMARYSIC

Character

4

Primary SIC Code

PRIMARYSICDESC

Character

50

Primary SIC Code Description

SIC2

Character

4

Secondary SIC Code

SIC2DESC

Character

50

Secondary SIC Code Description

SIC3

Character

4

Secondary SIC Code

SIC3DESC

Character

50

Secondary SIC Code Description

SIC4

Character

4

Secondary SIC Code

SIC4DESC

Character

50

Secondary SIC Code Description

PRIMARYNAICS

Character

6

Primary NAICS Code

PRIMARYNAICSDESC

Character

50

Primary NAICS Code Description

PRODUCTS

Character

20

Product Description

BRANDS

Character

20

Brand Names

NEWLISTING Character 2    True if company was added to the database within the past year

PARENTNAME

Character

65

Parent Company Name

PARENTADDR

Character

40

Parent Company Address

PARENTCITY

Character

40