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.
|