Item Field Name Data Type Description
1 CompanyName Varchar Company Name
2 CompanyID Int Unique ID field of Company
3 EmployeeID int Unique ID field of Employee
4 FirstName Varchar Employee First Name
5 LastName Varchar Employee Last Name
6 Department Varchar Department of Employee
7 Title Varchar Employee Title
8 Email Varchar Employee Email
9 Address1 Varchar Address 
10 Address2 Varchar Address2
11 City Varchar City
12 State Varchar State
13 Zip Varchar Zip
14 Extension Varchar Telephone Extension
15 Fax Varchar Fax Number
16 Phone Varchar Phone Number
17 Small Varchar Narrowed Industry Category
18 Industry Varchar Broad Industry Category
19 DateCreated Date/Time Date Record Was Created
20 AboutCompany Long Text Information about Company
21 WebsiteJobOpenings Varchar Num Job Openings on Web
22 YearlyRevenues Varchar Yearly Revenues
23 NumberofEmployees Varchar Number of Employees