Salesforce Docs Portal

Act! CRM Connector Objects

note: This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.

Objects Supported

Name Description
Activities Create, update, delete and query the Activities in your Act! CRM database.
ActivityCompanies Query the Companies participating in an Act! CRM Activity.
AnalyticsHistory Gets historical e-marketing information for a given date range.
CampaignLeads Gets contacts leads.
CampaignLeadsinfo Gets opportunities within a campaign within a specified date range.
CampaignResults Gets campaign result information.
CampaignSent Gets campaign sent within a specified date range.
CloseReason Generates opportunity data to summerizes how many times a reason has been closed.
CloseReasonDetails Generates opportunity data to summerizes how many times a reason has been closed.
Companies Create, update, delete and query the Companies created in your Act! CRM database.
CompanyContacts Query the Contacts belonging to a Company.
CompanyNotes Query the Notes for a given Act! CRM Company.
ContactGroups Query the Act! CRM Groups the Contact belongs to.
ContactHistories Get all the history related to a contact.
ContactNotes Query and delete the Notes for a given Act! CRM Contact.
Contacts Create, update, delete and query the Contacts in your Act! CRM database.
ForecastByProduct Generates forecasted opportunity data by given products.
ForecastByProductDetails Generates forecasted opportunity data by a given product..
ForecastByRep Generates forecasted opportunity data by given users.
ForecastByRepDetails Generates forecasted opportunity data by a given user.
GroupContacts Query and delete the Contacts belonging to a Group.
GroupNotes Query the Notes for a given Act! CRM Group.
Groups Create, update, delete and query the Groups participating in your Act! CRM database.
Histories Get, Create, Update or Delete all history items.
Notes Create, update, delete and query the Notes in your Act! CRM database.
Opportunities Create, update, delete and query the Opportunities in your Act! CRM database.
OpportunityCompanies Query and delete the Companies related to an Act! CRM opportunity.
OpportunityContacts Query and delete the Contacts associated with an Opportunity.
OpportunityCount Generates a summary of the total number of opportunities within a stage.
OpportunityGroups Query and delete the Act! CRM Groups associated with an Opportunity.
OpportunityNotes Query the Notes for a given Act! CRM Opportunity.
OpportunityProducts Update, delete and query the Products associated with an Opportunity.
Pipeline Gets all opportunity matching the custom filter that are currently being worked.
Products Create, update, delete and query the Products in your Act! CRM database.
RevenueActualVsPredicted Generates actual vs predicted opportunity revenue.
RevenueCost Generates opportunity periodic revenue versus cost data for given products.
RevenueWonVsLost Generates opportunty win versus loss data.
SalesByProduct Generates opportunity sales by product data for given products.
SalesByProductDetails Generates opportunity sales by product detail data for a given product.
SalesByRep Generates opportunity sales by user data for given users.
SalesByRepDetails Generates opportunity sales by user data for a given user.
StageTime Generates opportunity data for the average time in a stage.
UserActivities Generates activity sales by user data for given users.
UserActivityDetails Generated schema file.

Activities

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No A unique identifier that represents the activity.
ActivityPriorityId Integer False No Activity Priority value
ActivityPriorityName String False No Displays the priority of the activity.
ActivityTypeId Integer True No Displays the id of the type of the activity.
ActivityTypeName String True No Displays the type of the activity.
AttachmentDisplayName String False No Gets presentation name of the attachment.
AttachmentFileExtension String False No Gets the extension of the Attachment
AttachmentFileName String False No Gets a string representing the directory's full path.
AttachmentFileSize Int False No Gets the size (bytes) of the attachments.
AttachmentFileSizeDisplay String False No Gets the displayable text representation of the attachment
AttachmentFileType String False No Gets the registered system file type name of the attachment
AttachmentLastModified Datetime False No Gets the last modified date of the attachment
AttachmentPersonal Bool False No Indicates whether the attachment is bound for the personal supplemental files or the workgroup supplemental files.
CompaniesAggregate String False No List of companies that are associated to this activity.
ContactsAggregate String False No List of contacts that are associated to this activity.
Created Datetime True No The date and time the activity was created.
Details String False No Additional detailed information about the activity.
Edited Datetime True No The date and time the activity was last updated.
EndTime Datetime False No The time the activity is to end
GroupsAggregate String False No List a groups that are associated to this activity.
IsCleared Bool False No Indicates that the activity has been cleared.
IsPrivate Bool False No Indicates elevated security that only the creator/owner has access to this activity.
IsTimeless Bool False No Indicates whether a specifies action is to be completed at a specific time-of-day.
Location String False No Describes the physical location that the activity is to take place.
OpportunitiesAggregate String False No List a opportunities that are associated to this activity.
RecurSpecDayDayAsInt Int False No An integer representation of the day of the week portion of a recurrence pattern.
RecurSpecDayDaysOfWeek String False No Representation of the day of the week portion of a recurrence pattern.
RecurSpecDayDayType String False No Describing the day-portion of the recurrence pattern.
RecurSpecDayOrdinal String False No Describes recurrence in relative terms for certain recurrence patterns (i.e. First, Third, Last) .
RecurSpecDayTypedDay String False No Describing the TypedDay (Day, WeekDay or Weekend Day) for the recurrence pattern when DayType is
RecurSpecFrequency Int False No Represents how often for the recurrence patterns
RecurSpecIsEndless Bool False No Flag denoting whether an end date has been specified for the pattern. Note: If false, the following defaults are used: For Daily and Weekly: 2 years beyond the start date For Monthly and Yearly: June 6, 2073.
RecurSpecMonth Int False No Represents the specific month for certain recurrence patterns
RecurSpecRecurType String False No Represents a unit of time used to separate recurences (i.e. Daily, Weekly, Monthly, Yearly).
RecurSpecSeriesEnd Datetime False No Specifiying the ending time for a given day.
RecurSpecSeriesStart Datetime False No Specifiying the starting time for a given day.
ScheduledBy String True No The contact who created this activity.
ScheduledFor String False No The name of the activity's organizer.
SeriesID String True No A unique identifier that represents the activity. The id that is returned is based on if it is a recurring or not. Recurrent activity: RecurSourceActivityId or Single Occurence activity: ActivityID
StartTime Datetime False No The time the activity is to begin
Subject String False No A description of the action to be completed.
IsAlarmCleared Bool False No Boolean value of IsAlarmCleared.
IsAlarmed Bool False No Boolean value of IsAlarmed.
LeadMinutes Int False No Lead minutes.
AlarmDue String False No Alarm due.
ExternalId String False No External Id.
AccessorId String False No Accessor Id.
ScheduledById String False No Scheduled Id.
ScheduledForId String False No Scheduled for Id.

Return to Top

ActivityCompanies

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for this company.
ActivityId [KEY] String False Activities.id No A unique identifier that represents the activity the companies are part of.
Created Datetime False No Created date and the activity.
Name String False No The company's given name.
AddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
AddressCountry String False No A nation with its own government, occupying a particular territory.
AddressLine1 String False No Primary street address
AddressLine2 String False No Secondary street address
AddressLine3 String False No Miscellaneous street address
AddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState String False No A nation or territory considered as an organized political community under one government.
BillingAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
BillingAddressCountry String False No A nation with its own government, occupying a particular territory.
BillingAddressLine1 String False No Primary street address
BillingAddressLine2 String False No Secondary street address
BillingAddressLine3 String False No Miscellaneous street address
BillingAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
BillingAddressState String False No A nation or territory considered as an organized political community under one government.
Description String False No A brief written representation or account of this company.
Division String False No The name of a smaller part of a parent company tasked with overseeing different types of products or services than those offered by the parent company.
Edited Datetime False No Edited date of the activity.
EditedBy String False No User that edited the activity.
Fax String False No The company's fax phone number.
FaxExtension String False No The company's fax phone number extension.
HierarchyLevel Int False No The positional level of where this company lays within a company hierarchy.
IdStatus String False No The relative social or professional position of an individual within a group or organization.
Industry String False No Economic activity concerned with the processing of raw materials and manufacture of goods in factories.
NumberOfEmployees Int False No The total number of employees that this company operates with.
ParentID String False No The unique identifier (id) of the parent company.
Phone String False No The company's phone number.
PhoneExtension String False No The company's phone number extension.
RecordOwner String False No Owner of the activity.
ReferredBy String False No Mention or allude to.
Region String False No A part of a country, of the world, etc., that is different or separate from other parts in some way.
Revenue Decimal False No The amount of money that this company actually receives during a specific period, including discounts and deductions for returned merchandise.
ShippingAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
ShippingAddressCountry String False No A nation with its own government, occupying a particular territory.
ShippingAddressLine1 String False No Primary street address
ShippingAddressLine2 String False No Secondary street address
ShippingAddressLine3 String False No Miscellaneous street address
ShippingAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
ShippingAddressState String False No A nation or territory considered as an organized political community under one government.
SicCode String False No Standard Industrial Classification (SIC) codes are four-digit numerical codes assigned by the U.S. government to business establishments to identify the primary business of the establishment.
Territory String False No Geographical area.
TickerSymbol String False No An arrangement of characters (usually letters) representing a particular security listed on an exchange or otherwise traded publicly.
TollFreeExtension String False No The company's toll free phone number.
TollFreePhone String False No The company's toll free phone number.
Website String False No The company's website.
AddressLatitude Decimal False No The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.
AddressLongitude Decimal False No The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.
BillingAddressLatitude Decimal False No The Billing address latitude.
BillingAddressLongitude Decimal False No The Billing address longitude.
HasDivisions Boolean False No This readonly property indicates that this company has divisions.
ImportDate Datetime False No This readonly property displays the date that the opportunity was imported into the system.
IsPrivate Boolean False No Indicates elevated security that only the creator/owner has access to this company.
RootParentId String False No The unique identifier (id) of the parent company.
ShippingAddressLatitude Decimal False No The Shipping address latitude.
ShippingAddressLongitude Decimal False No The Shipping address longitude.
RecordManagerID String False No The record manager.
CustomFields String False No Custom fields.
RecordManager String False No Manager of the activity.

Return to Top

AnalyticsHistory

Name Type ReadOnly References FilterOnly Description
EmailActions String True No Email Actions
Sends Integer True No Count of mail sent
Date Datetime False Yes Date Range of Activities By User

Return to Top

CampaignLeads

Name Type ReadOnly References FilterOnly Description
AmaScore Integer True No Ama Score
BusinessEmail String True No Business Email
BusinessPhone String True No Business Phone
CompanyName String True No Company Name
ContactId String True No Contact Id
ContactName String True No Contact Name
Sends Integer True No Sends
TotalClicks Integer True No Total Clicks
TotalOpens Integer True No Total Opens
UniqueClicks Integer True No Unique Clicks
UniqueOpens Integer True No Unique Opens

Return to Top

CampaignLeadsinfo

Name Type ReadOnly References FilterOnly Description
CampaignId String True No Campaign Id
CampaignName String True No Campaign Name
LeadCount Integer True No Lead Count
TotalValue Integer True No Total Value
WeightedValue Integer True No Weighted Value
Status String True No Staus
UserId String True No User Id
Date Datetime False Yes Date Range of Activities By User

Return to Top

CampaignResults

Name Type ReadOnly References FilterOnly Description
CampaignDate Datetime True No Campaign Date
CampaignName String True No Campaign Name
Clicks Integer True No Clicks
Opens Integer True No Opens
Sends Integer True No Sends
UniqueClicks Integer True No Unique Clicks
UniqueSends Integer True No Unique Sends
CampaignId String True No Campaign Ids
Date Datetime False Yes Date Range of Activities By User

Return to Top

CampaignSent

Name Type ReadOnly References FilterOnly Description
CampaignId String True No Campaign Id
CampaignName String True No Campaign Name
SendDate Datetime True No Send Date
Date Datetime False Yes Date Range of Activities By User

Return to Top

CloseReason

Name Type ReadOnly References FilterOnly Description
Count Integer True No
Reason String True No
Status String True No Status of Activities
Date Datetime False Yes Date Range of Activities By User

Return to Top

CloseReasonDetails

Name Type ReadOnly References FilterOnly Description
OppId String True No Opp Id
OppName String True No Opp Name
ActualCloseDate Datetime True No Actual Close Date
ActualValue Integer True No Actual Value
CloseReason String True No Close Reason
Status String True No Status
Date Datetime False Yes Date Range of Activities By User

Return to Top

Companies

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No The unique identifier (id) for this company.
Created Datetime True No Created date of the company.
Name String False No The company's given name.
AddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
AddressCountry String False No A nation with its own government, occupying a particular territory.
AddressLine1 String False No Primary street address
AddressLine2 String False No Secondary street address
AddressLine3 String False No Miscellaneous street address
AddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState String False No A nation or territory considered as an organized political community under one government.
BillingAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
BillingAddressCountry String False No A nation with its own government, occupying a particular territory.
BillingAddressLine1 String False No Primary street address
BillingAddressLine2 String False No Secondary street address
BillingAddressLine3 String False No Miscellaneous street address
BillingAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
BillingAddressState String False No A nation or territory considered as an organized political community under one government.
Description String False No A brief written representation or account of this company.
Division String False No The name of a smaller part of a parent company tasked with overseeing different types of products or services than those offered by the parent company.
Edited Datetime True No Edited data of the company.
EditedBy String True No User who edited the company record.
Fax String False No The company's fax phone number.
FaxExtension String False No The company's fax phone number extension.
HierarchyLevel Int False No The positional level of where this company lays within a company hierarchy.
IdStatus String False No The relative social or professional position of an individual within a group or organization.
Industry String False No Economic activity concerned with the processing of raw materials and manufacture of goods in factories.
NumberOfEmployees Int False No The total number of employees that this company operates with.
ParentID String True No The unique identifier (id) of the parent company.
Phone String False No The company's phone number.
PhoneExtension String False No The company's phone number extension.
RecordOwner String True No Owner of the company record.
ReferredBy String False No Mention or allude to.
Region String False No A part of a country, of the world, etc., that is different or separate from other parts in some way.
Revenue Decimal False No The amount of money that this company actually receives during a specific period, including discounts and deductions for returned merchandise.
ShippingAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
ShippingAddressCountry String False No A nation with its own government, occupying a particular territory.
ShippingAddressLine1 String False No Primary street address
ShippingAddressLine2 String False No Secondary street address
ShippingAddressLine3 String False No Miscellaneous street address
ShippingAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
ShippingAddressState String False No A nation or territory considered as an organized political community under one government.
SicCode String False No Standard Industrial Classification (SIC) codes are four-digit numerical codes assigned by the U.S. government to business establishments to identify the primary business of the establishment.
Territory String False No Geographical area.
TickerSymbol String False No An arrangement of characters (usually letters) representing a particular security listed on an exchange or otherwise traded publicly.
TollFreeExtension String False No The company's toll free phone number.
TollFreePhone String False No The company's toll free phone number.
Website String False No The company's website.
AddressLatitude Decimal False No The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.
AddressLongitude Decimal False No The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.
BillingAddressLatitude Decimal False No The Billing address latitude.
BillingAddressLongitude Decimal False No The Billing address longitude.
ShippingAddressLatitude Decimal False No The Shipping address latitude.
ShippingAddressLongitude Decimal False No The Shipping address longitude.
HasDivisions Boolean False No This readonly property indicates that this company has divisions.
ImportDate Datetime False No This readonly property displays the date that the opportunity was imported into the system.
IsPrivate Boolean False No Indicates elevated security that only the creator/owner has access to this company.
RootParentId String False No The unique identifier (id) of the parent company.
RecordManagerID String False No The record manager.
CustomFields String False No Custom fields.
RecordManager String False No Manager of the activity.

Return to Top

CompanyContacts

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for this contact.
CompanyId [KEY] String False Companies.Id No The unique identifier (id) of the company to retrieve contacts from.
Created Datetime False No Created data of the contact.
FullName String False No The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act!
AltEmailAddress String False No A unique electronic address that an individual can be contacted.
AlternateExtension String False No The contact's alternate phone number extension.
AlternatePhone String False No The contact's alternate phone number.
Birthday Datetime False No The anniversary of the day on which a person was born.
BusinessAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
BusinessAddressCountry String False No A nation with its own government, occupying a particular territory.
BusinessAddressLine1 String False No Primary street address
BusinessAddressLine2 String False No Secondary street address
BusinessAddressLine3 String False No Miscellaneous street address
BusinessAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
BusinessAddressState String False No A nation or territory considered as an organized political community under one government.
BusinessExtension String False No The contact's business phone number extension.
BusinessPhone String False No The contact's business phone number.
Company String False No The organization that this contact is associated with.
ContactType String False No The type of contact: Contact, Secondary, or User.
Department String False No An area of special expertise or responsibility.
Edited Datetime False No Edited date of the contact.
EditedBy String False No User who edited the contact.
EmailAddress String False No A unique electronic address that an individual can be contacted.
FaxExtension String False No The contact's fax phone number extension.
FaxPhone String False No The contact's fax phone number.
FirstName String False No A personal given name.
HomeAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
HomeAddressCountry String False No A nation with its own government, occupying a particular territory.
HomeAddressLine1 String False No Primary street address
HomeAddressLine2 String False No Secondary street address
HomeAddressLine3 String False No Miscellaneous street address
HomeAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
HomeAddressState String False No A nation or territory considered as an organized political community under one government.
HomeExtension String False No The contact's home phone extension.
HomePhone String False No The contact's home phone number.
IdStatus String False No The relative social or professional position of an individual within a group or organization.
IsUser Bool False No An indicator if this contact is also a user within the system.
JobTitle String False No The title or position this contact holds.
LastName String False No The family name or surname.
LastResults String False No Identifies last communication or action with a contact.
Latitude Decimal False No The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.
Longitude Decimal False No The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.
MessengerID String False No An online identifier alias.
MiddleName String False No A name between one's first name and surname.
MobileExtension String False No The contact's mobile phone extension.
MobilePhone String False No The contact's mobile phone number.
NamePrefix String False No A patronymic prefix.
NameSuffix String False No Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors.
PagerExtension String False No The contact's pager phone number extension
PagerPhone String False No The contact's pager phone number.
PersonalEmailAddress String False No A unique electronic address that an individual can be contacted.
RecordOwner String False No Owner user of the record.
ReferredBy String False No Indiciates how this contact came about.
Salutation String False No A gesture or utterance made as a greeting or acknowledgment.
Website String False No The contact's web site.
IsFavorite Bool False No Assign this contact as a favorite.
IsImported Bool False No Identifies last communication or action with a contact.
ImportDate Datetime False No This readonly property displays the date that the opportunity was imported into the system.
IsPrivate Bool False No Identifies last communication or action with a contact.
LastEmail String False No The last email.
LastAttempt String False No The last attempt.
LastReach String False No The last reach.
LastMeeting String False No The last meeting.
LastLetterSent String False No The last letter sent.
AmaScore Int False No The contact's.
BusinessAddressLatitude Decimal False No The business address latitude.
BusinessAddressLongitude Decimal False No The business address longitude.
BusinessCountryCode Int False No The contact's business phone country code.
BusinessMaskFormat String False No The contact's business phone mask format.
MobileCountryCode Int False No The contact's mobile phone country code.
MobileMaskFormat String False No The contact's mobile phone mask format.
FaxCountryCode Int False No The contact's fax phone country code.
FaxMaskFormat String False No The contact's fax phone mask format.
HomeAddressLatitude Decimal False No The Home address latitude.
HomeAddressLongitude Decimal False No The Home address longitude.
HomeCountryCode Int False No The contact's home phone country code.
HomeMaskFormat String False No The contact's home phone mask format.
AlternateCountryCode Int False No The contact's alternate phone country code.
AlternateMaskFormat String False No The contact's alternate phone mask format.
PagerCountryCode Int False No The contact's pager phone country code.
PagerMaskFormat String False No The contact's pager phone mask format.
AemOptOut Boolean False No AemOptOut.
AemBounceBack Boolean False No AemBounceBack.
RecordManagerID String False No The record manager.
QuickbooksId String False No Quickbooks external Id to match record with quickbooks contact.
NylasContactId String False No Nylas contact Id to match record with a contact.
CustomFields String False No Custom fields.
RecordManager String False No Manager of the activity.

Return to Top

CompanyNotes

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for a given note.
CompanyId [KEY] String False No The unique identifier (id) for the company included in the note.
ManageUserID String False No The unique identifier (id) of the user managing the note.
CreateUserID String False No The unique identifier (id) of the user who created the note.
IsPrivate Boolean False No Indicator if the note is private.
NoteText String False No Descriptive text of the note.
NoteTypeID Long False No The id of the type of the note.
DisplayDate Datetime False No Display date of the note.
Created Datetime False No Datetime of the note creation.
Edited Datetime False No Datetime of the last edit of the note.
AttachmentDisplayName String False No Display name of the attachment.
AttachmentFileExtension String False No File extension of the attachment.
AttachmentFileName String False No File name of the attachment.
AttachmentFileSize Long False No File size of the attachment.
AttachmentFileSizeDisplay String False No Display file size of the attachment.
AttachmentFileType String False No Type of the attachment file.
AttachmentLastModified Datetime False No Last modified datetime of the attachment.
AttachmentPersonal Boolean False No Indicator if the attachment is personal.
RecordManager String False No Record Manager.
RecordManagerId String False No Record Manager Id.
Companies String False No List of companies that are associated to this note entity.
Contacts String False No List of contacts that are associated to this note entity.
Groups String False No List of groups that are associated to this note entity.
Opportunities String False No List of opportunities that are associated to this note entity.

Return to Top

ContactGroups

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for a group.
ContactId [KEY] String False Contacts.Id No The unique identifier (id) for the contact included in the group.
Created Datetime False No A timestamp when this group was created
Name String False No The name of the group.
AddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
AddressCountry String False No A nation with its own government, occupying a particular territory.
AddressLine1 String False No Primary street address
AddressLine2 String False No Secondary street address
AddressLine3 String False No Miscellaneous street address
AddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState String False No A nation or territory considered as an organized political community under one government.
Description String False No A brief written respresentation of a group.
Edited Datetime False No Edited date of the contact.
EditedBy String False No User who edited the contact.
HierarchyLevel Int False No The level this group appears in its hierarchy.
ParentID String False No The group's parent entity.
RecordOwner String False No Owner user of the record.
HasSubgroups Boolean False No This readonly property indicates that this group has sub groups.
RecordManager String False No Record Manager of the record.
RecordManagerID String False No The record manager id of the record.
ImportDate Datetime False No This readonly property displays the date that the opportunity was imported into the system.
IsPrivate Boolean False No Indicates elevated security that only the creator/owner has access to this company.
CustomFields String False No Custom fields.
AddressLatitude Decimal False No The Address latitude.
AddressLongitude Decimal False No The Address longitude.

Return to Top

ContactHistories

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No Id of the history item created
ContactId String True Contacts.Id No Id of the contact
AttachmentDisplayName String True No Name of the attachment related to a history
AttachmentFileExtension String True No FileExtension of the attachment related to a history
AttachmentFileName String True No FileName of the attachment related to a history
AttachmentFileSize Integer True No File Size of the attachment related to a history
AttachmentFileSizeDisplay String True No File Size Display of the attachment related to a history
AttachmentFileType String True No FileType of the attachment related to a history
AttachmentLastModified Datetime True No File Last Modified date of the attachment related to a history
AttachmentPersonal Boolean True No Attachment Personal
CompaniesAggregate String True No Companies associated with a history
ContactsAggregate String True No Contacts associated with a history
Created Datetime True No The datetime when history was created
CreateUserID String True No User Id of the user who craeted the history
Details String True No Details of history
Duration String True No Duration
Edited Datetime True No Datetime when history was last edited
EndTime Datetime True No End Time of history
GroupsAggregate String True No Groups associated with history
HistoryTypeDescription String True No Description of the type of history
HistoryTypeId Integer True No History Type ID
HistoryTypeName String True No Name of history type
TypeID Integer True No Id of history type
IsPrivate Boolean True No Indicates whether history is private or not
ManageUserID String True No User Id of manager
OpportunitiesAggregate String True No Opportunities associated with history
OutlookID String True No Outlook Id
RecordManager String True No Record Manager
RecordManagerID String True No Id of Record Msnager
Regarding String True No Tells what history is about
StartTime Datetime True No Start Time

Return to Top

ContactNotes

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for a given note.
ContactId [KEY] String False Contacts.Id No The unique identifier (id) for the contact included in the note.
ManageUserID String False No The unique identifier (id) of the user managing the note.
CreateUserID String False No The unique identifier (id) of the user who created the note.
IsPrivate Boolean False No Indicator if the note is private.
NoteText String False No Descriptive text of the note.
NoteTypeID Long False No The id of the type of the note.
DisplayDate Datetime False No Display date of the note.
Created Datetime False No Datetime of the note creation.
Edited Datetime False No Datetime of the last edit of the note.
AttachmentDisplayName String False No Display name of the attachment.
AttachmentFileExtension String False No File extension of the attachment.
AttachmentFileName String False No File name of the attachment.
AttachmentFileSize Long False No File size of the attachment.
AttachmentFileSizeDisplay String False No Display file size of the attachment.
AttachmentFileType String False No Type of the attachment file.
AttachmentLastModified Datetime False No Last modified datetime of the attachment.
AttachmentPersonal Boolean False No Indicator if the attachment is personal.
RecordManager String False No Record Manager of the record.
RecordManagerID String False No The record manager id of the record.
Companies String False No List of companies that are associated to this note entity.
Contacts String False No List of contacts that are associated to this note entity.
Groups String False No List of groups that are associated to this note entity.
Opportunities String False No List of opportunities that are associated to this note entity.

Return to Top

Contacts

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No The unique identifier (id) for this contact.
Created Datetime True No Created date of the contact.
FullName String True No The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act!
Company String False No The organization that this contact is associated with.
AltEmailAddress String False No A unique electronic address that an individual can be contacted.
AlternateExtension String False No The contact's alternate phone number extension.
AlternatePhone String False No The contact's alternate phone number.
Birthday Datetime False No The anniversary of the day on which a person was born.
BusinessAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
BusinessAddressCountry String False No A nation with its own government, occupying a particular territory.
BusinessAddressLine1 String False No Primary street address
BusinessAddressLine2 String False No Secondary street address
BusinessAddressLine3 String False No Miscellaneous street address
BusinessAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
BusinessAddressState String False No A nation or territory considered as an organized political community under one government.
BusinessExtension String False No The contact's business phone number extension.
BusinessPhone String False No The contact's business phone number.
CompanyID String False No The unique identifier (companyID) for a given companies.
ContactType String True No The type of contact: Contact, Secondary, or User.
Department String False No An area of special expertise or responsibility.
Edited Datetime True No Edited date of the contact.
EditedBy String True No User who edited the contact.
EmailAddress String False No A unique electronic address that an individual can be contacted.
FaxExtension String False No The contact's fax phone number extension.
FaxPhone String False No The contact's fax phone number.
FirstName String False No A personal given name.
HomeAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
HomeAddressCountry String False No A nation with its own government, occupying a particular territory.
HomeAddressLine1 String False No Primary street address
HomeAddressLine2 String False No Secondary street address
HomeAddressLine3 String False No Miscellaneous street address
HomeAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
HomeAddressState String False No A nation or territory considered as an organized political community under one government.
HomeExtension String False No The contact's home phone extension.
HomePhone String False No The contact's home phone number.
IdStatus String False No The relative social or professional position of an individual within a group or organization.
IsUser Bool True No An indicator if this contact is also a user within the system.
JobTitle String False No The title or position this contact holds.
LastName String False No The family name or surname.
LastResults String False No Identifies last communication or action with a contact.
Latitude Decimal False No The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.
Longitude Decimal False No The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.
MessengerID String True No An online identifier alias.
MiddleName String False No A name between one's first name and surname.
MobileExtension String False No The contact's mobile phone extension.
MobilePhone String False No The contact's mobile phone number.
NamePrefix String False No A patronymic prefix.
NameSuffix String False No Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors.
PagerExtension String False No The contact's pager phone number extension
PagerPhone String False No The contact's pager phone number.
PersonalEmailAddress String False No A unique electronic address that an individual can be contacted.
RecordOwner String True No Owner user of the contact.
ReferredBy String False No Indiciates how this contact came about.
Salutation String True No A gesture or utterance made as a greeting or acknowledgment.
Website String False No The contact's web site.
IsFavorite Bool False No Assign this contact as a favorite.
IsImported Bool False No Identifies last communication or action with a contact.
ImportDate Datetime False No This readonly property displays the date that the opportunity was imported into the system.
IsPrivate Bool False No Identifies last communication or action with a contact.
LastEmail String False No Last email.
LastAttempt String False No Last attempt.
LastReach String False No Last reach.
LastMeeting String False No Last meeting.
LastLetterSent String False No Last letter sent.
AmaScore Int False No The contact's.
BusinessAddressLatitude Decimal False No Business address latitude.
BusinessAddressLongitude Decimal False No Business address longitude.
BusinessCountryCode Int False No The contact's business phone country code.
BusinessMaskFormat String False No The contact's business phone mask format.
MobileCountryCode Int False No The contact's mobile phone country code.
MobileMaskFormat String False No The contact's mobile phone mask format.
FaxCountryCode Int False No The contact's fax phone country code.
FaxMaskFormat String False No The contact's fax phone mask format.
HomeAddressLatitude Decimal False No Home address latitude.
HomeAddressLongitude Decimal False No Home address longitude.
HomeCountryCode Int False No The contact's home phone country code.
HomeMaskFormat String False No The contact's home phone mask format.
AlternateCountryCode Int False No The contact's alternate phone country code.
AlternateMaskFormat String False No The contact's alternate phone mask format.
PagerCountryCode Int False No The contact's pager phone country code.
PagerMaskFormat String False No The contact's pager phone mask format.
AemOptOut Bool False No AemOptOut.
AemBounceBack Bool False No AemBounceBack.
RecordManagerId String False No The record manager.
QuickBooksId String False No Quickbooks external Id to match record with quickbooks contact.
NylasContactId String False No Nylas contact Id to match record with a contact.
CustomFields String False No Custom fields.
RecordManager String False No Record manager.

Return to Top

ForecastByProduct

Name Type ReadOnly References FilterOnly Description
CountPercent Decimal True No Count Percent
OppCount Integer True No Opp Count
ProductId String True No Product ID
ProductName String True No Product Name
TotalValue Decimal True No Total Value
TotalValuePercent Decimal True No Total Value Percent
WeightedValue Decimal True No Weighted Value
WeightedValuePercent Decimal True No Weighted Value Percent

Return to Top

ForecastByProductDetails

Name Type ReadOnly References FilterOnly Description
EstCloseDate Datetime True No Est Close Date
OppName String True No Opp Name
ProbabilityPct Integer True No Probability Pct
ProductName String True No Product Name
ProductWeightedValue Decimal True No Product Weighted Value
Status String True No Status
ProductId String True No Product Id
OppId String True No Opp Id

Return to Top

ForecastByRep

Name Type ReadOnly References FilterOnly Description
CountPercent Decimal True No Count Percent
OppCount Integer True No Opp Count
SalesRep String True No Sales Rep
TotalValue Decimal True No Total Value
TotalValuePercent Decimal True No Total Value Percent
UserId String True No User Id
WeightedValue Decimal True No Weighted Value
WeightedValuePercent Decimal True No Weighted Value Percent

Return to Top

ForecastByRepDetails

Name Type ReadOnly References FilterOnly Description
EstCloseDate Datetime True No Est Close Date
OppName String True No Opp Name
ProbabilityPct Integer True No Probablity Pct
RepName String True No Rep Name
Status String True No Status
WeightedValue Decimal True No Weighted Value
UserId String False No User ID
OppId String True No Opp Id

Return to Top

GroupContacts

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for this contact.
GroupId [KEY] String False Groups.Id No The unique identifier (id) of the group to retrieve contacts from.
Created Datetime False No Created date of the group.
FullName String False No The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act!
AltEmailAddress String False No A unique electronic address that an individual can be contacted.
AlternateExtension String False No The contact's alternate phone number extension.
AlternatePhone String False No The contact's alternate phone number.
Birthday Datetime False No The anniversary of the day on which a person was born.
BusinessAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
BusinessAddressCountry String False No A nation with its own government, occupying a particular territory.
BusinessAddressLine1 String False No Primary street address
BusinessAddressLine2 String False No Secondary street address
BusinessAddressLine3 String False No Miscellaneous street address
BusinessAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
BusinessAddressState String False No A nation or territory considered as an organized political community under one government.
BusinessExtension String False No The contact's business phone number extension.
BusinessPhone String False No The contact's business phone number.
Company String False No The organization that this contact is associated with.
CompanyID String False No The unique identifier (companyID) for a given companies.
ContactType String False No The type of contact: Contact, Secondary, or User.
Department String False No An area of special expertise or responsibility.
Edited Datetime False No Edited date of the group.
EditedBy String False No User who edited the group.
EmailAddress String False No A unique electronic address that an individual can be contacted.
FaxExtension String False No The contact's fax phone number extension.
FaxPhone String False No The contact's fax phone number.
FirstName String False No A personal given name.
HomeAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
HomeAddressCountry String False No A nation with its own government, occupying a particular territory.
HomeAddressLine1 String False No Primary street address
HomeAddressLine2 String False No Secondary street address
HomeAddressLine3 String False No Miscellaneous street address
HomeAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
HomeAddressState String False No A nation or territory considered as an organized political community under one government.
HomeExtension String False No The contact's home phone extension.
HomePhone String False No The contact's home phone number.
IdStatus String False No The relative social or professional position of an individual within a group or organization.
IsUser Bool False No An indicator if this contact is also a user within the system.
JobTitle String False No The title or position this contact holds.
LastName String False No The family name or surname.
LastResults String False No Identifies last communication or action with a contact.
Latitude Decimal False No The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.
Longitude Decimal False No The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.
MessengerID String False No An online identifier alias.
MiddleName String False No A name between one's first name and surname.
MobileExtension String False No The contact's mobile phone extension.
MobilePhone String False No The contact's mobile phone number.
NamePrefix String False No A patronymic prefix.
NameSuffix String False No Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors.
PagerExtension String False No The contact's pager phone number extension
PagerPhone String False No The contact's pager phone number.
PersonalEmailAddress String False No A unique electronic address that an individual can be contacted.
RecordOwner String False No Owner user of the record.
ReferredBy String False No Indiciates how this contact came about.
Salutation String False No A gesture or utterance made as a greeting or acknowledgment.
Website String False No The contact's web site.
IsFavorite Bool False No Assign this contact as a favorite.
IsImported Bool False No Identifies last communication or action with a contact.
ImportDate Datetime False No This readonly property displays the date that the opportunity was imported into the system.
IsPrivate Bool False No Identifies last communication or action with a contact.
LastEmail String False No Last email.
LastAttempt String False No Last attempt.
LastReach String False No Last reach.
LastMeeting String False No Last meeting.
LastLetterSent String False No Last letter sent.
AmaScore Int False No The contact's.
BusinessAddressLatitude Decimal False No Business address latitude.
BusinessAddressLongitude Decimal False No Business address longitude.
BusinessCountryCode Int False No The contact's business phone country code.
BusinessMaskFormat String False No The contact's business phone mask format.
MobileCountryCode Int False No The contact's mobile phone country code.
MobileMaskFormat String False No The contact's mobile phone mask format.
FaxCountryCode Int False No The contact's fax phone country code.
FaxMaskFormat String False No The contact's fax phone mask format.
HomeAddressLatitude Decimal False No Home address latitude.
HomeAddressLongitude Decimal False No Home address longitude.
HomeCountryCode Int False No The contact's home phone country code.
HomeMaskFormat String False No The contact's home phone mask format.
AlternateCountryCode Int False No The contact's alternate phone country code.
AlternateMaskFormat String False No The contact's alternate phone mask format.
PagerCountryCode Int False No The contact's pager phone country code.
PagerMaskFormat String False No The contact's pager phone mask format.
AemOptOut Bool False No AemOptOut.
AemBounceBack Bool False No AemBounceBack.
RecordManagerId String False No The record manager.
QuickBooksId String False No Quickbooks external Id to match record with quickbooks contact.
NylasContactId String False No Nylas contact Id to match record with a contact.
CustomFields String False No Custom fields.
RecordManager String False No Record manager.

Return to Top

GroupNotes

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for a given note.
GroupId [KEY] String False No The unique identifier (id) for the group included in the note.
ManageUserID String False No The unique identifier (id) of the user managing the note.
CreateUserID String False No The unique identifier (id) of the user who created the note.
IsPrivate Boolean False No Indicator if the note is private.
NoteText String False No Descriptive text of the note.
NoteTypeID Long False No The id of the type of the note.
DisplayDate Datetime False No Display date of the note.
Created Datetime False No Datetime of the note creation.
Edited Datetime False No Datetime of the last edit of the note.
AttachmentDisplayName String False No Display name of the attachment.
AttachmentFileExtension String False No File extension of the attachment.
AttachmentFileName String False No File name of the attachment.
AttachmentFileSize Long False No File size of the attachment.
AttachmentFileSizeDisplay String False No Display file size of the attachment.
AttachmentFileType String False No Type of the attachment file.
AttachmentLastModified Datetime False No Last modified datetime of the attachment.
AttachmentPersonal Boolean False No Indicator if the attachment is personal.
RecordManager String False No Record Manager of the record.
RecordManagerID String False No The record manager id of the record.
Companies String False No List of companies that are associated to this note entity.
Contacts String False No List of contacts that are associated to this note entity.
Groups String False No List of groups that are associated to this note entity.
Opportunities String False No List of opportunities that are associated to this note entity.

Return to Top

Groups

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No The unique identifier (id) for a group.
Created Datetime True No A timestamp when this group was created
Name String False No The name of the group.
AddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
AddressCountry String False No A nation with its own government, occupying a particular territory.
AddressLine1 String False No Primary street address
AddressLine2 String False No Secondary street address
AddressLine3 String False No Miscellaneous street address
AddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState String False No A nation or territory considered as an organized political community under one government.
AddressLatitude Decimal False No The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.
AddressLongitude Decimal False No The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.
Description String False No A brief written respresentation of a group.
Edited Datetime True No Edited date of the group.
EditedBy String True No User who edited the group.
HierarchyLevel Int False No The level this group appears in its hierarchy.
ParentID String True No The group's parent entity.
HasSubgroups Bool False No An indicator if this group contains subgroups.
RecordOwner String False No Owner user of the record.
RecordManager String True No Manager user of the record.
IsPrivate Boolean False No Indicator if the group is private.
Contacts Int False No Get the total number of contacts within the group. Contacts is nullable and hide it if the value is null.
ImportDate Datetime True No This readonly property displays the date that the opportunity was imported into the system.
RecordManagerID String False No The record manager.
CustomFields String False No Custom fields.

Return to Top

Histories

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No Id of the history item created
AttachmentDisplayName String True No Name of the attachment related to a history
AttachmentFileExtension String True No FileExtension of the attachment related to a history
AttachmentFileName String True No FileName of the attachment related to a history
AttachmentFileSize Integer True No File Size of the attachment related to a history
AttachmentFileSizeDisplay String True No File Size Display of the attachment related to a history
AttachmentFileType String True No FileType of the attachment related to a history
AttachmentLastModified Datetime True No File Last Modified date of the attachment related to a history
AttachmentPersonal Boolean True No Attachment Personal
CompaniesAggregate String False No Companies associated with a history
ContactsAggregate String False No Contacts associated with a history
Created Datetime True No The datetime when history was created
CreateUserID String True No User Id of the user who craeted the history
Details String False No Details of history
Duration String True No Duration
Edited Datetime True No Datetime when history was last edited
EndTime Datetime False No End Time of history
GroupsAggregate String False No Groups associated with history
HistoryTypeDescription String True No Description of the type of history
HistoryTypeId Integer True No History Type ID
HistoryTypeName String True No Name of history type
TypeID Integer False No Id of history type
IsPrivate Boolean False No Indicates whether history is private or not
ManageUserID String True No User Id of manager
OpportunitiesAggregate String False No Opportunities associated with history
OutlookID String False No Outlook Id
RecordManager String True No Record Manager
RecordManagerID String True No Id of Record Msnager
Regarding String False No Tells what history is about
StartTime Datetime False No Start Time

Return to Top

Notes

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No The unique identifier (id) for a given note.
ManageUserID String True No The unique identifier (id) of the user managing the note.
CreateUserID String True No The unique identifier (id) of the user who created the note.
IsPrivate Boolean False No Indicator if the note is private.
NoteText String False No Descriptive text of the note.
NoteTypeID Long True No The id of the type of the note.
DisplayDate Datetime True No Display date of the note.
Created Datetime True No Datetime of the note creation.
Edited Datetime True No Datetime of the last edit of the note.
AttachmentDisplayName String False No Display name of the attachment.
AttachmentFileExtension String False No File extension of the attachment.
AttachmentFileName String False No File name of the attachment.
AttachmentFileSize Long False No File size of the attachment.
AttachmentFileSizeDisplay String False No Display file size of the attachment.
AttachmentLastModified Datetime False No Last modified datetime of the attachment.
AttachmentFileType String False No Type of the attachment file.
AttachmentPersonal Boolean False No Indicator if the attachment is personal.
Companies String False No List of companies that are associated to this note entity.
Contacts String False No List of contacts that are associated to this note entity.
Groups String False No List of groups that are associated to this note entity.
Opportunities String False No List of opportunities that are associated to this note entity.
RecordManager String False No Manager of the activity.
RecordManagerId String False No The record manager.

Return to Top

Opportunities

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No A unique identifier that represents the opportunity.
Created Datetime True No Created date of the opportunity.
Name String False No The opportunity name.
ActualCloseDate Datetime False No The date that the opportunity as closed.
CompaniesAggregate String False No List of companies that are associated to this opportunity entity.
Competitor String False No Gets the name of the competitor for this opportunity.
ContactNames String False No The names of the contacts associated with this opportunity.
ContactsAggregate String False No The names of the contacts associated with this opportunity.
Creator String False No Indicates elevated security that only the creator has access to this opportunity.
DaysOpen Int True No The number of days this opportunity has been opened.
Edited Datetime True No The date that this record was edited.
EditedBy String True No The user's name that last editied this record.
EstimatedCloseDate Datetime False No The date the opportunity is expected to be closed.
GrossMargin Decimal False No Represents the net sales less the cost of goods and services sold.
GroupsAggregate String False No List a groups that are associated to this opportunity entity.
IsPrivate Bool False No Indicates whether this opportunity is private
Manager String False No The name of the record manager of this opportunity.
OpenDate Datetime False No The date the opportunity was opened.
Probability Int False No The likelihood this opportunity will will be won by the close date.
ProductTotal Decimal False No The total cost of the product or services.
Reason String False No Describs why the opportunity status changed.
RecordOwner String False No The user's name that owners this record.
RelatedEntitiesResolver Bool False No If true prevents related entities from serializing.
Source String False No Describs the source of the opportunity.
StageDescription String False No Gets or sets the description of the stage.
StageId String False No Gets the unique identifier of the stage.
StageName String False No The name of the stage.
StageNumber Int False No The ordinal number of the stage.
StageProbability Int False No The probability of the stage.
StageProcessDescription String False No The description of the stage process.
StageProcessId String False No The unique identifier of the stage process.
StageProcessName String False No The name of the stage process.
Status String False No The status of the opportunity.
TotalPerCompany Decimal False No The average total per associated company.
TotalPerContact Decimal False No The average total per associated contact.
TotalPerGroup Decimal False No The average total per associated group.
WeightedTotal Decimal False No The weight of the product.
DaysInStage Int False No The number of days this opportunity has been in a given stage.
StageStartDate Datetime False No The date the opportunity stage started.
SourceId String False No The external source id for the opportunity.
StageProcessStatus String False No Stage process status.
StageProcessStagesCount Int False No Stage process stages count
StageProcessStages String False No Stage process stages
ImportDate Datetime True No This readonly property displays the date that the opportunity was imported into the system.
QuickBooksInvoiceId String False No Quickbooks external Id to match record with quickbooks contact.
RecordManagerId String False No The record manager.
CustomFields String False No Custom fields.
RecordManager String False No Manager of the activity.

Return to Top

OpportunityCompanies

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for this company.
OpportunityId [KEY] String False Opportunities.Id No The unique identifier of the opportunity the companies are related to.
Created Datetime False No Created date of the company.
Name String False No The company's given name.
AddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
AddressCountry String False No A nation with its own government, occupying a particular territory.
AddressLine1 String False No Primary street address
AddressLine2 String False No Secondary street address
AddressLine3 String False No Miscellaneous street address
AddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState String False No A nation or territory considered as an organized political community under one government.
BillingAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
BillingAddressCountry String False No A nation with its own government, occupying a particular territory.
BillingAddressLine1 String False No Primary street address
BillingAddressLine2 String False No Secondary street address
BillingAddressLine3 String False No Miscellaneous street address
BillingAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
BillingAddressState String False No A nation or territory considered as an organized political community under one government.
Description String False No A brief written representation or account of this company.
Division String False No The name of a smaller part of a parent company tasked with overseeing different types of products or services than those offered by the parent company.
Edited Datetime False No Edited date of the company.
EditedBy String False No User who edited the company.
Fax String False No The company's fax phone number.
FaxExtension String False No The company's fax phone number extension.
HierarchyLevel Int False No The positional level of where this company lays within a company hierarchy.
IdStatus String False No The relative social or professional position of an individual within a group or organization.
Industry String False No Economic activity concerned with the processing of raw materials and manufacture of goods in factories.
NumberOfEmployees Int False No The total number of employees that this company operates with.
ParentID String False No The unique identifier (id) of the parent company.
Phone String False No The company's phone number.
PhoneExtension String False No The company's phone number extension.
RecordOwner String False No Owner user of the record.
ReferredBy String False No Mention or allude to.
Region String False No A part of a country, of the world, etc., that is different or separate from other parts in some way.
Revenue Decimal False No The amount of money that this company actually receives during a specific period, including discounts and deductions for returned merchandise.
ShippingAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
ShippingAddressCountry String False No A nation with its own government, occupying a particular territory.
ShippingAddressLine1 String False No Primary street address
ShippingAddressLine2 String False No Secondary street address
ShippingAddressLine3 String False No Miscellaneous street address
ShippingAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
ShippingAddressState String False No A nation or territory considered as an organized political community under one government.
SicCode String False No Standard Industrial Classification (SIC) codes are four-digit numerical codes assigned by the U.S. government to business establishments to identify the primary business of the establishment.
Territory String False No Geographical area.
TickerSymbol String False No An arrangement of characters (usually letters) representing a particular security listed on an exchange or otherwise traded publicly.
TollFreeExtension String False No The company's toll free phone number.
TollFreePhone String False No The company's toll free phone number.
Website String False No The company's website.
AddressLatitude Decimal False No The address latitude.
AddressLongitude Decimal False No The address longitude.
BillingAddressLatitude Decimal False No The billing address latitude.
BillingAddressLongitude Decimal False No The billing address longitude.
HasDivisions Bool False No This readonly property indicates that this company has divisions.
ImportDate Datetime False No This readonly property displays the date that the opportunity was imported into the system.
IsPrivate Bool False No Indicates elevated security that only the creator/owner has access to this company.
RootParentId String False No The unique identifier (id) of the parent company.
ShippingAddressLatitude Decimal False No The shipping address latitude.
ShippingAddressLongitude Decimal False No The shipping address longitude.
RecordManagerID String False No The record manager.
CustomFields String False No Custom fields.
RecordManager String False No Manager of the activity.

Return to Top

OpportunityContacts

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for this contact.
OpportunityId [KEY] String False Opportunities.Id No The unique identifier (id) for the opportunity to query contacts from.
Created Datetime False No Created date of the contact.
FullName String False No The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act!
AltEmailAddress String False No A unique electronic address that an individual can be contacted.
AlternateExtension String False No The contact's alternate phone number extension.
AlternatePhone String False No The contact's alternate phone number.
Birthday Datetime False No The anniversary of the day on which a person was born.
BusinessAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
BusinessAddressCountry String False No A nation with its own government, occupying a particular territory.
BusinessAddressLine1 String False No Primary street address
BusinessAddressLine2 String False No Secondary street address
BusinessAddressLine3 String False No Miscellaneous street address
BusinessAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
BusinessAddressState String False No A nation or territory considered as an organized political community under one government.
BusinessExtension String False No The contact's business phone number extension.
BusinessPhone String False No The contact's business phone number.
Company String False No The organization that this contact is associated with.
CompanyID String False No The unique identifier (companyID) for a given companies.
ContactType String False No The type of contact: Contact, Secondary, or User.
Department String False No An area of special expertise or responsibility.
Edited Datetime False No Edited date of the contact.
EditedBy String False No User who edited the contact.
EmailAddress String False No A unique electronic address that an individual can be contacted.
FaxExtension String False No The contact's fax phone number extension.
FaxPhone String False No The contact's fax phone number.
FirstName String False No A personal given name.
HomeAddressCity String False No An inhabited place of greater size, population, or importance than a town or village.
HomeAddressCountry String False No A nation with its own government, occupying a particular territory.
HomeAddressLine1 String False No Primary street address
HomeAddressLine2 String False No Secondary street address
HomeAddressLine3 String False No Miscellaneous street address
HomeAddressPostalCode String False No A code of letters and digits added to a postal address to aid in the sorting of mail.
HomeAddressState String False No A nation or territory considered as an organized political community under one government.
HomeExtension String False No The contact's home phone extension.
HomePhone String False No The contact's home phone number.
IdStatus String False No The relative social or professional position of an individual within a group or organization.
IsUser Bool False No An indicator if this contact is also a user within the system.
JobTitle String False No The title or position this contact holds.
LastName String False No The family name or surname.
LastResults String False No Identifies last communication or action with a contact.
Latitude Decimal False No The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.
Longitude Decimal False No The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.
MessengerID String False No An online identifier alias.
MiddleName String False No A name between one's first name and surname.
MobileExtension String False No The contact's mobile phone extension.
MobilePhone String False No The contact's mobile phone number.
NamePrefix String False No A patronymic prefix.
NameSuffix String False No Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors.
PagerExtension String False No The contact's pager phone number extension
PagerPhone String False No The contact's pager phone number.
PersonalEmailAddress String False No A unique electronic address that an individual can be contacted.
RecordOwner String False No Owner user of the record.
ReferredBy String False No Indiciates how this contact came about.
Salutation String False No A gesture or utterance made as a greeting or acknowledgment.
Website String False No The contact's web site.
IsFavorite Bool False No Assign this contact as a favorite.
IsImported Bool False No Identifies last communication or action with a contact.
ImportDate Datetime False No This readonly property displays the date that the opportunity was imported into the system.
IsPrivate Bool False No Identifies last communication or action with a contact.
LastEmail String False No Last email.
LastAttempt String False No Last attempt.
LastReach String False No Last reach.
LastMeeting String False No Last meeting.
LastLetterSent String False No Last letter sent.
AmaScore Int False No The contact's.
BusinessAddressLatitude Decimal False No The business address latitude.
BusinessAddressLongitude Decimal False No The business address longitude.
BusinessCountryCode Int False No The contact's business phone country code.
BusinessMaskFormat String False No The contact's business phone mask format.
MobileCountryCode Int False No The contact's mobile phone country code.
MobileMaskFormat String False No The contact's mobile phone mask format.
FaxCountryCode Int False No The contact's fax phone country code.
FaxMaskFormat String False No The contact's fax phone mask format.
HomeAddressLatitude Decimal False No The home address latitude.
HomeAddressLongitude Decimal False No The home address longitude.
HomeCountryCode Int False No The contact's home phone country code.
HomeMaskFormat String False No The contact's home phone mask format.
AlternateCountryCode Int False No The contact's alternate phone country code.
AlternateMaskFormat String False No The contact's alternate phone mask.
PagerCountryCode Int False No The contact's pager phone country code.
PagerMaskFormat String False No The contact's pager phone mask.
AemOptOut Bool False No AemOptOut.
AemBouncBack Bool False No AemBouncBack.
RecordManagerID String False No The record manager.
QuickbooksId String False No Quickbooks external Id to match record with quickbooks contact.
NylasContactId String False No Nylas contact Id to match record with a contact.
CustomFileds String False No Custom fields.
RecordManager String False No Manager of the activity.

Return to Top

OpportunityCount

Name Type ReadOnly References FilterOnly Description
Count Integer True No Count
Ordinal Integer True No Ordinal
StageId String True No Stage Id
StageName String True No Stage Name
Value Integer True No Value
StartTime Datetime True No Start Time
EndTime Datetime True No End Time
DateType Integer True No Date Type
ValueType Integer True No Value Type
ProbabilityValue Integer True No Probability
ProbabilityOperation String True No Probability Operation
AmountValue Decimal True No Amount Value
AmountOperation String True No Amount Operation
OmitPrivate Boolean True No Omit Private
TypeId String True No Type Id
UserId String True No User Id
StageId String True No Stage Id
PickListItemId String True No Pick List Item Id
Status String True No Status

Return to Top

OpportunityGroups

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No The unique identifier (id) for a group.
OpportunityId [KEY] String False Opportunities.Id No The unique identifier (id) for the opportunity to retrieve groups from.
Created Datetime True No A timestamp when this group was created
Name String True No The name of the group.
AddressCity String True No An inhabited place of greater size, population, or importance than a town or village.
AddressCountry String True No A nation with its own government, occupying a particular territory.
AddressLine1 String True No Primary street address
AddressLine2 String True No Secondary street address
AddressLine3 String True No Miscellaneous street address
AddressPostalCode String True No A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState String True No A nation or territory considered as an organized political community under one government.
Description String True No A brief written respresentation of a group.
Edited Datetime True No Edited date of the group.
EditedBy String True No User who edited the group.
HierarchyLevel Int True No The level this group appears in its hierarchy.
ParentID String True No The group's parent entity.
RecordOwner String True No Owner user of the record.
Contacts Int True No Get the total number of contacts within the group. Contacts is nullable and hide it if the value is null.
HasSubgroups Bool True No This readonly property indicates that this group has sub groups.
IsPrivate Bool True No Indicates elevated security that only the creator/owner has access to this company.
ImportDate Datetime True No This readonly property displays the date that the opportunity was imported into the system.
AddressLatitude Decimal True No The address latitude.
AddressLongitude Decimal True No The address longitude.
RecordManagerID String True No The record manager.
CustomFields String True No Custom fields.
RecordManager String True No Manager of the activity.

Return to Top

OpportunityNotes

Name Type ReadOnly References FilterOnly Description
Id [KEY] String False No The unique identifier (id) for a given note.
OpportunityId [KEY] String False Opportunities.Id No The unique identifier (id) for the opportunity included in the note.
ManageUserID String False No The unique identifier (id) of the user managing the note.
CreateUserID String False No The unique identifier (id) of the user who created the note.
IsPrivate Boolean False No Indicator if the note is private.
NoteText String False No Descriptive text of the note.
NoteTypeID Long False No The id of the type of the note.
DisplayDate Datetime False No Display date of the note.
Created Datetime False No Datetime of the note creation.
Edited Datetime False No Datetime of the last edit of the note.
AttachmentDisplayName String False No Display name of the attachment.
AttachmentFileExtension String False No File extension of the attachment.
AttachmentFileName String False No File name of the attachment.
AttachmentFileSize Long False No File size of the attachment.
AttachmentFileSizeDisplay String False No Display file size of the attachment.
AttachmentFileType String False No Type of the attachment file.
AttachmentLastModified Datetime False No Last modified datetime of the attachment.
AttachmentPersonal Boolean False No Indicator if the attachment is personal.
RecordManager String False No Manager of the activity.
RecordManagerId String False No The record manager.
Companies String False No List of companies that are associated to this note entity.
Contacts String False No List of contacts that are associated to this note entity.
Groups String False No List of groups that are associated to this note entity.
Opportunities String False No List of opportunities that are associated to this note entity.

Return to Top

OpportunityProducts

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No A unique identifier (id) for a given product.
OpportunityId [KEY] String True Opportunities.Id No A unique identifier (id) of the opportunity containing the products.
Created Datetime True No A timestamp when this group was created
CreateDate Datetime True No The date that the product was created.
Cost Decimal False No The cost of the product.
EditDate Datetime True No The date that the opportunity product was lasted modified.
ItemNumber String False No A item number assigned to this opportunity product.
Name String False No The name of the product.
Price Decimal False No The price of the opportunity product.
Discount Decimal False No The opportunity product's discounted percentage (ignore on updates).
DiscountPrice Decimal False No The discounted price of the opportunity product.
ProductID String True No A unique identifier (id) for a given product.
Quantity Decimal False No The quantity of opportunity products.
Type String False No The quantity of opportunity products.
IsQuickBooksproduct Boolean False No Define is product linked with Quickbooks Product.
RecordOwner String False No Record Owner.
RecordManager String False No Record Manager.
Total Decimal False No The total pricie of the opportunity product (adjusted price * quantity).
CustomFields String False No Custom fields.
Edited Datetime False No Edited.
EditedBy String False No Edited by.

Return to Top

Pipeline

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No
CompanyName String True No Company Name
ContactCount Integer True No Contact Count
ContactDisplayName String True No Contact Display Name
EstCloseDate Datetime True No Est Close Date
Name String True No Name
ProbabilityPct Integer True No Probability Pct
StageId String True No Stage Id
StageName String True No Stage Name
TotalValue Decimal True No Total Value
WeightedValue Decimal True No Weighted Value
StartTime Datetime True No Start Time
EndTime Datetime True No End Time
DateType Integer True No Date Type
ValueType Integer True No Value Type
ProbabilityValue Integer True No Probability
ProbabilityOperation String True No Probability Operation
AmountValue Decimal True No Amount Value
AmountOperation String True No Amount Operation
OmitPrivate Boolean True No Omit Private
TypeId String True No Type Id
UserId String True No User ID
StageId String True No Stage Id
PickListItemId String True No Pick List Item Id
Status String True No Status

Return to Top

Products

Name Type ReadOnly References FilterOnly Description
Id [KEY] String True No A unique identifier (id) for a given product.
CreateDate Datetime True No The date that the product was created.
Name String False No The name of the product.
Cost Decimal False No The cost of the product.
EditDate Datetime True No The date that the opportunity product was lasted modified.
ItemNumber String False No A item number assigned to this opportunity product.
Price Decimal False No The price of the opportunity product.

Return to Top

RevenueActualVsPredicted

Name Type ReadOnly References FilterOnly Description
Actual Integer True No Actual
Potential Integer True No Potential
Projected Integer True No Projected
TimePeriod String True No Time Period
Interval String True No Interval
FiscalYearStart Integer True No Fiscal Year Start
Date Datetime False Yes Date Range of Activities By User

Return to Top

RevenueCost

Name Type ReadOnly References FilterOnly Description
AlternateText String True No Alternate Text
Cost Integer True No Cost
OppCount Integer True No Opp Count
Revenue Integer True No Revenue
TimePeriod String True No Time Period
ProductId String True No Product Id
Interval String True No Interval
FiscalYearStart Integer True No Fiscal Year Start
Date Datetime False Yes Date Range of Activities By User

Return to Top

RevenueWonVsLost

Name Type ReadOnly References FilterOnly Description
Count Integer True No Count
CountPercent Integer True No Count Percent
Revenue Decimal True No Revenue
RevenuePercent Integer True No Revenue Percent
Status String True No Status
Date Datetime False Yes Date Range of Activities By User

Return to Top

SalesByProduct

Name Type ReadOnly References FilterOnly Description
Percent Decimal True No Percent
ProductId String True No Product Id
ProductName String True No Product Name
Revenue Decimal True No Revenue
Date Datetime False Yes Date Range of Activities By User

Return to Top

SalesByProductDetails

Name Type ReadOnly References FilterOnly Description
ClosedDate Datetime True No Closed Date
OppName String True No Opp Name
ProductName String True No Product Name
ProductValue Decimal True No Product Value
ProductId String True No Product Id
Date Datetime False Yes Date Range of Activities By User

Return to Top

SalesByRep

Name Type ReadOnly References FilterOnly Description
CountPercent Decimal True No Count Percent
OppCount Integer True No Opp Count
Revenue Decimal True No Revenue
RevenuePercent Decimal True No Revenue Percent
SalesRep String True No Sales Rep
UserId String True No User Id
Date Datetime False Yes Date Range of Activities By User

Return to Top

SalesByRepDetails

Name Type ReadOnly References FilterOnly Description
ClosedDate Datetime True No Close Date
OppName String True No Opp Name
OppValue Decimal True No Opp Value
RepName String True No Rep Name
UserId String True No User Id
Date Datetime False Yes Date Range of Activities By User

Return to Top

StageTime

Name Type ReadOnly References FilterOnly Description
AvgDays Integer True No Average Days
StageName String True No Stage Name
StageId String True No Stage Id
Date Datetime False Yes Date Range of Activities By User

Return to Top

UserActivities

Name Type ReadOnly References FilterOnly Description
ActivityCount Integer True No Activity Count
UserId String True No User Id
UserName String True No User Name
TypeId String True No Type Id
Date Datetime False Yes Date Range of Activities By User

Return to Top

UserActivityDetails

Name Type ReadOnly References FilterOnly Description
ActivityId String True No Activity Id
ContactName String True No Contact Name
Location String True No Location
Regarding String True No Regarding
Type String True No Type
UserName String True No User Name
TypeId String True No Type Id
UserId String True No UserId
Date Datetime False Yes Date Range of Activities By User

Return to Top