ACT! Standard Fields
Top  Previous  Next

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







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




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.