Column Type Length Description ----------- ---- ------ -------------------------------- F_Name Char 30 First Name M_I Char 15 Middle Name L_Name Char 50 Last Name Nick_Name Char 30 Title / Nick Name Co_Name Char 70 Company Name Co_Abbr Char 20 Company Abbreviation Address1 Char 60 Address (Line 1) Address2 Char 60 Address (Line 2) City Char 50 City State Char 10 State ZipCode Char 20 ZipCode Phone1 Char 20 Primary Phone Number Phone1_id Char 10 Primary Phone Number Location Phone2 Char 20 Secondary Phone Number Phone2_id Char 10 Secondary Phone Number Location Phone3 Char 20 Third Phone Number Phone3_id Char 10 Third Phone Number Location Phone4 Char 20 Fourth Phone Number Phone4_id Char 10 Fourth Phone Number Location Phone5 Char 20 Fifth Phone Number Phone5_id Char 10 Fifth Phone Number Location E_Mail Char 75 Email Address Comments Char 90 Comments Birth_date Date Birthdate WWW Char 75 Web Address DisplayName Char 100 Display Name