ACT and Outlook Fields

Top Previous Next

ACT Contact Fields

Database schema name	Field name	Description
ADDR1	Address 1 (“Address” displays)	First line of the contact’s primary address.
ADDR2	Address 2	Second line of the contact’s primary address. This field is spliced with ADDR1
ADDR3	Address 3	Third line of the contact’s primary address. This field is spliced with ADDR1
ALT1REACH	2nd Last Reach (not displayed unless added in the Layout Designer)	Date of the last completed call to the second contact. The format is YYYYMMDD. This field is supplied by the system.
ALT2REACH	3rd Last Reach (not displayed unless added in the Layout Designer)	Date of the last completed call to the third contact. The format is YYYYMMDD. This field is supplied by the system.
ALTADDR1	Home Address 1	First line of the contact’s home address.
ALTADDR2	Home Address 2	Second line of the contact’s home address.
ALTCITY	Home City	City in the contact’s home address.
ALTCOUNTRY	Home Country	Country in the contact’s home address.
ALTEXT	Alt Phone Ext. (“Ext.” displays)	Extension for the contact’s alternate phone number.
ALTPHONE	Alt Phone	Contact’s alternate phone number.
ALTSTATE	Home State	State in the contact’s home address.
ALTZIP	Home Zip	Zip code in the contact’s home address.
ASSISTANT	Assistant	Name of the contact’s assistant.
ASST_EXT	Asst. Phone Ext. (“Ext.” displays)	Extension for the phone number of the contact’s assistant.
ASST_PHONE	Asst. Phone	Phone number of the contact’s assistant.
ASST_TITLE	Asst. Title	Title of the contact’s assistant.
CITY	City	City in the contact’s address.
COMPANY	Company	Contact’s company name.
CONT_TYPE	Contact Type	Contact record type. Values are: blank, 0, or 1 for normal 2 for “My Record”
COUNTRY	Country	Country in the contact’s address.
CREATOR	Record Creator	The database user who created the contact record. This field is supplied by the system.
CTIME	Create Timestamp (“Create Date” displays)	Date and time the contact record was created. This field is supplied by the system and stored in a compressed format.
DEPARTMENT	Department	Contact’s department.
ETIME	Edit Timestamp (“Edit Date” displays)	Date and time the contact record was last modified. This field is supplied by the system and stored in a compressed format.
EXT	Phone Ext. (“Ext.” displays)	Extension for the contact’s primary phone number.
FAX	Fax	Contact’s fax number.
FAX_EXT	Fax Ext. (not displayed unless added in the Layout Designer)	Extension for the contact’s fax number.
FNAME	First Name (not displayed unless added in the Layout Designer)	Contact’s first name. This field is parsed by the system from the contact.
HOME_PHONE	Home Phone	Contact’s home phone number.
IDSTATUS	ID/Status	Category assigned to the contact.
LAST_ATMPT	Last Attempt	Date of the last attempt to call the contact. The format is YYYYMMDD. This field is supplied by the system.
LAST_MEET	Last Meeting	Date of the last meeting with the contact. The format is YYYYMMDD. This field is supplied by the system.
LAST_REACH	Last Reach	Date of the last completed call to the contact. The format is YYYYMMDD. This field is supplied by the system.
LAST_RSLTS	Last Results	Comments on the last results with the contact.
LNAME	Last Name (not displayed unless added in the Layout Designer)	Contact’s last name. This field is parsed by the system from the contact name.
LTTR_DATE	Letter Date	Date of the last letter sent to the contact. The format is YYYYMMDD. This field is supplied by the system.
MOBILPHONE	Mobile Phone	Contact’s mobile phone number.
MTIME	Merge Timestamp (“Merge Date” displays)	Date and time the contact record was imported into ACT! or synchronized with another ACT! database. This field is supplied by the system and stored in a compressed format.
NAME	Contact	Contact’s name.
NAME2	2nd Contact	Second contact’s name.
NAME3	3rd Contact	Third contact’s name.
—	Note	This field is obsolete and is supplied for backward-compatibility with ACT! 2.0 databases.
OWNER	Owner (not displayed unless added in the Layout Designer)	The company name of the database user who created the contact record.
PAGER	Pager	Contact’s pager number.
PHONE	Phone	Contact’s primary phone number.
PHONE2	2nd Phone	Second contact’s phone number.
PHONE2_EXT	2nd Phone Ext. (“Ext.” displays)	Extension for the second contact’s phone number.
PHONE3	3rd Phone	Third contact’s phone number.
PHONE3_EXT	3rd Phone Ext. (“Ext.” displays)	Extension for the third contact’s phone number.
PUB_STATUS	Public/Private	Access level for the contact. Values are: 1 Public (default) 2 Private
REFER_BY	Referred By	Description of the contact’s referral source.
SALUTATION	Salutation	Contact’s letter salutation or greeting name.
SPOUSE	Spouse	Name of the contact’s spouse.
STATE	State	State in the contact’s address.
TICKERSYM	Ticker Symbol	Company’s stock ticker symbol for ACT! 4.0 or later databases only.
TITLE	Title	Contact’s title.
TITLE2	2nd Title	Second contact’s title.
TITLE3	3rd Title	Third contact’s title.
UNIQUE_ID	Unique Id	Unique contact record identification number. This field is supplied by the system.
URL	Web Site	Contact’s web site URL address.
USER	Record Manager	The Unique ID of the database user permitted to access and change the status of private contacts. This field is supplied by the system.
USER1	User 1	User-definable field 1.
USER2	User 2	User-definable field 2.
USER3	User 3	User-definable field 3.
USER4	User 4	User-definable field 4.
USER5	User 5	User-definable field 5.
USER6	User 6	User-definable field 6.
USER7	User 7	User-definable field 7.
USER8	User 8	User-definable field 8.
USER9	User 9	User-definable field 9.
USER10	User 10	User-definable field 10.
USER11	User 11	User-definable field 11.
USER12	User 12	User-definable field 12.
USER13	User 13	User-definable field 13.
USER14	User 14	User-definable field 14.
USER15	User 15	User-definable field 15.
ZIP	Zip	Zip code in the contact’s address.

Standard Outlook Contact Fields

Name	Description
Account	Specifies the account information
Anniversary	Specifies the date of the contact’s anniversary
AssistantName	The name of the contact’s assistant
AssistantTelephoneNumber	The telephone number for the contact’s assistant
BillingInformation	Contains a free-form string that can be used to hold the billing information associated with the item.
Birthday	The date of the contact’s birthday
Body	A free-form string containing the body of the item.
Business2TelephoneNumber	The second business telephone number for the contact
BusinessAddress	The entire unparsed business address for the contact
BusinessAddressCity	The city part of the contact’s business address
BusinessAddressCountry	The country part of the contact’s business address
BusinessAddressPostalCode	The postal code part of the contact’s business address
BusinessAddressPostOfficeBox	The Post Office Box of the contact’s business address
BusinessAddressState	The state code for the contact’s business address
BusinessAddressStreet	The street information for the contact’s business address
BusinessFaxNumber	The contact’s business fax number
BusinessHomePage	The URL of the home web page of the business
BusinessTelephoneNumber	The contact’s business telephone number
CallbackTelephoneNumber	The telephone number at which the contact may be called back
CarTelephoneNumber	The contact’s car telephone number
Categories	Specifies the categories that are assigned to the item.
Children	The names of the contact’s children
Companies	A free form string containing the company names associated with the item
CompanyMainTelephoneNumber	The main telephone number for the contact’s company
CompanyName	The name of the company that the contact works for
ComputerNetworkName	The name of the contact’s computer network
CustomerID	The customer ID for the contact
Department	The name of the department the contact works in
Email1Address	The contact’s first email address
Email1AddressType	The address type (“SMTP”) of the contact’s first email address
Email2Address	The contact’s second email address
Email2AddressType	The address type (“SMTP”) of the contact’s second email address
Email3Address	The contact’s third email address
Email3AddressType	The address type (“SMTP”) of the contact’s third email address
FileAs	The keyword for the contact
FirstName	The contact’s first name
FTPSite	The contact’s FTP site entry
FullName	The contact’s whole name
Gender	The gender of the contact
GovernmentIDNumber	The government ID number for the contact
Hobby	The contact’s hobby
Home2TelephoneNumber	The second home telephone number for the contact
HomeAddress	The entire unparsed home address of the contact
HomeAddressCity	The city part of the home address
HomeAddressCountry	The country part of the home address
HomeAddressPostalCode	The postal code part of the home address
HomeAddressPostOfficeBox	The Post Office Box of the home address
HomeAddressState	The state code for the home address
HomeAddressStreet	The street information for the home address
HomeFaxNumber	The contact’s home fax number
HomeTelephoneNumber	The home telephone number of the contact
Importance	Specifies the importance of the contact (0=low, 1=medium, 2=high)
Initials	The initials of the contact
InternetFreeBusyAddress	The URL for the contact’s free/busy information
ISDNNumber	The contact’s ISDN number
JobTitle	The contact’s job title
Journal	Specifies whether all the transactions are to be entered into the journal
Language	The language for the contact
LastName	Specifies the contact’s last name
MailingAddress	The entire unparsed mailing address of the contact
MailingAddressCity	The city part of the mailing address
MailingAddressCountry	The country part of the mailing address
MailingAddressPostalCode	The postal code part of the mailing address
MailingAddressPostOfficeBox	The Post Office Box of the mailing address
MailingAddressState	The state code for the mailing address
MailingAddressStreet	The street information for the mailing address
ManagerName	The name of the manager of the contact
MiddleName	The middle name of the contact
Mileage	Mileage record for the contact
MobileTelephoneNumber	The contact mobile phone number
NetMeetingAlias	The contact’s ID or alias for Net Meetings
NetMeetingServer	The name of the server to host the Net Meeting
NickName	The contact’s nickname
OfficeLocation	The office location information for the contact
OrganizationalIDNumber	The organizational ID number for the contact
OtherAddress	The entire, unparsed for of another address for the contact
OtherAddressCity	The city part of the other address
OtherAddressCountry	The country part of the other address
OtherAddressPostalCode	The postal code part of the other address
OtherAddressPostOfficeBox	The Post Office Box part of the other address
OtherAddressState	The state code for the other address
OtherAddressStreet	The street information for the other address
OtherFaxNumber	Another Fax Number for the contact
OtherTelephoneNumber	Another Telephone Number for the contact.
PagerNumber	The contact’s pager number
PersonalHomePage	The URL for the contact’s personal home page
PrimaryTelephoneNumber	The primary phone number for the contact
Profession	The profession for the contact
RadioTelephoneNumber	The radio telephone number of the contact
ReferredBy	The name of the person that referred this contact to you.
Sensitivity	Specifies the level of sensitivity for the contact (0=normal, 1=personal, 2=private, 3=confidential)
Spouse	The name of the contact’s spouse
Subject	Contains the subject of the item
Suffix	The contact’s suffix
TelexNumber	The contact’s telex number
Title	The contact’s Title
TTYTDDTelephoneNumber	The TTY/TDD telephone number for the contact
User1	The first MS Schedule+ user for the contact
User2	The second MS Schedule+ user for the contact
User3	The third MS Schedule+ user for the contact
User4	The fourth MS Schedule+ user for the contact
UserCertificate	The authentication certificate for the contact
WebPage	The URL for the contact’s web page
YomiCompanyName	The Japanese phonetic rendering of the company name
YomiFirstName	The Japanese phonetic rendering of the contact’s first name
YomiLastName	The Japanese phonetic rendering of the contact’s last name