ACT! allows you to view the 7 Basic Tables - but not Activities
ACT! allows you to view the 7 Basic Tables - but not Activities
Database Tables and Fields
|
COMPANY |
CONTACT 1 _2nd_last_reach 2 _3rd_last_reach 3 Aaccount_id 4 Abilling_city 5 Abilling_country 6 Abilling_state 7 Abilling_street 8 Abilling_zip 9 Account_number 10 Account_site 11 Acreated_by 12 Acreated_date 13 Adescription 14 Afax 15 Afinalld 16 Alt_phone_ext_ 17 Alternate_phone 18 Aowner 19 Aphone 20 Birth_date 21 Caccount_id 22 Cbilling_city 23 Cbilling_country 24 Cbilling_state 25 Cbilling_zip 26 Ccreated_by 27 Cell 28 Company 29 Companyid 30 Contact 31 Contact_status 32 Contactid 33 Create_date 34 Cshort_description 35 Department 36 Edit_date 37 E_mail 38 E_mail_2 39 Fax 40 Fax_ext_ 41 First_name 42 Group_1 43 Home_address_1 44 Home_address_2 45 Home_address_3 46 Home_city 47 Home_country 48 Home_extension 49 Home_phone 50 Home_state 51 Home_zip 52 Idstatus 53 Is_imported 54 Last_attempt 55 Last_edited_by 56 Last_meeting 57 Last_name 58 Last_reach 59 Last_results 60 Letter_date 61 Machine_type 62 Mailing_city 63 Mailing_country 64 Mailing_state 65 Mailing_street 66 Mailing_zip 67 Messenger_id 68 Middle_name 69 Mobile_extension 70 Name_prefix 71 Name_suffix 72 No_of_locations 73 No_of_machines_bought 74 Obsolete_1 75 Obsolete_2 76 Pager 77 Pager_extension 78 Personal_e_mail 79 Phone 80 Phone_ext_ 81 Private_contact 82 Record_creator 83 Record_manager 84 Referred_by 85 Salutation 86 Spouse 87 Ticker 88 Title 89 Type 90 User_1 91 User_2 92 User_3 93 User_4 94 User_5 95 User_6 96 User_7 97 User_8 98 User_9 99 User_9_1_ 100 User_10 101 User_11 102 User_12 103 User_13 104 User_14 105 User_15 106 Web_site |
GROUP 1 Address_1 2 Address_2 3 Address_3 4 City 5 Country 6 Create_date 7 Division 8 Edit_date 9 Group_description 10 Group_name 11 Groupid 12 Has_subgroups 13 Hierarchy_level 14 Industry 15 Last_edited_by 16 Number_of_employees 17 Parentgroupid 18 Priority 19 Private 20 Queryversionid 21 Record_creator 22 Record_manager 23 Referred_by 24 Region 25 Revenue 26 Sic_code 27 State 28 Ticker_symbol 29 User_1 30 User_2 31 User_3 32 User_4 33 User_5 34 User_6 35 Web_site 36 Zip |
HISTORY 1 History_contactid 2 History_historyid 3 Accessor_activity_clearedid 4 Created_on 5 Details 6 Duration 7 Edited_on 8 End_datetime 9 Historyid 10 Historytypeid 11 Last_edited_by 12 Private_history 13 Record_creator 14 Record_manager 15 Regarding 16 Start_datetime 17 Types_active 18 Types_activitytypeid 19 Types_created_on 20 Types_custom 21 Types_description 22 Types_edited_on 23 Types_historytypeguid 24 Types_historytypeid 25 Types_isdefault 26 Types_name 27 Types_recordable |
SALES 1 Actual_close_date 2 Competitor 3 Contactid 4 Create_date 5 Days_open 6 Details 7 Edit_date 8 Estimated_close_date 9 Last_edited_by 10 Open_date 11 Opportunity_field_1 12 Opportunity_field_2 13 Opportunity_field_3 14 Opportunity_field_4 15 Opportunity_field_5 16 Opportunity_field_6 17 Opportunity_field_7 18 Opportunity_field_8 19 Opportunity_name 20 Opportunityid 21 Private_opportunity 22 Probability_of_close 23 Product_subtotal 24 Reason 25 Record_creator 26 Record_manager 27 Referred_by 28 Stageid 29 Status 30 Total 31 Weighted_total 32 Stage_created_on 33 Stage_edited_on 34 Stage_opportunityprocessid 35 Stage_opportunitystageid 36 Stage_stage 37 Stage_stage_description 38 Stage_step 39 Process_active_process 40 Process_created_on 41 Process_edited_on 42 Process_opportunityprocessid 43 Process_process 44 Process_process_description |
MYRECORD 1 Accessorid 2 Userid 3 Name 4 Descriptio 5 Statusnum 6 Status 7 Isverified 8 Contactid 9 Roleid 10 Rolename 11 Userlogin 12 Password 13 Createuser 14 Createdate 15 Edituserid 16 Editdate |
| NOTES 1 Note_contactid 2 Note_noteid 3 Created_on 4 Edited_on 5 Last_edited_by 6 Note 7 Note_date 8 Noteid 9 Notetypeid 10 Private_note 11 Record_creator 12 Record_manager 13 Types_active 14 Types_created_on 15 Types_custom 16 Types_description 17 Types_edited_on 18 Types_name 19 Types_notetypeguid 20 Types_notetypeid |