--- schema_version: "1" id: 4810affbe6c92367b1869f805415e57bdf73331132f9b50368c93233f246d791 title: Act! CRM Connector Objects collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/act/c360-a-act-objects.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-act-objects.html source_site: developer.salesforce.com content_type: documentation content_hash: c81420faedfd866198eb7bf210ac5aae5f1dae1bb6c7548898caf3a2d73fe439 products: - Data 360 Integration Guide - Data 360 Developer Documentation --- # 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.](https://www.salesforce.com/company/legal/agreements/) If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at [datacloud-connectors-beta@salesforce.com.](mailto:datacloud-connectors-beta@salesforce.com) ## Objects Supported | Name | Description | | ----------------------------------------------------- | ------------------------------------------------------------------------------------ | | [Activities](#activities) | Create, update, delete and query the Activities in your Act! CRM database. | | [ActivityCompanies](#activitycompanies) | Query the Companies participating in an Act! CRM Activity. | | [AnalyticsHistory](#analyticshistory) | Gets historical e-marketing information for a given date range. | | [CampaignLeads](#campaignleads) | Gets contacts leads. | | [CampaignLeadsinfo](#campaignleadsinfo) | Gets opportunities within a campaign within a specified date range. | | [CampaignResults](#campaignresults) | Gets campaign result information. | | [CampaignSent](#campaignsent) | Gets campaign sent within a specified date range. | | [CloseReason](#closereason) | Generates opportunity data to summerizes how many times a reason has been closed. | | [CloseReasonDetails](#closereasondetails) | Generates opportunity data to summerizes how many times a reason has been closed. | | [Companies](#companies) | Create, update, delete and query the Companies created in your Act! CRM database. | | [CompanyContacts](#companycontacts) | Query the Contacts belonging to a Company. | | [CompanyNotes](#companynotes) | Query the Notes for a given Act! CRM Company. | | [ContactGroups](#contactgroups) | Query the Act! CRM Groups the Contact belongs to. | | [ContactHistories](#contacthistories) | Get all the history related to a contact. | | [ContactNotes](#contactnotes) | Query and delete the Notes for a given Act! CRM Contact. | | [Contacts](#contacts) | Create, update, delete and query the Contacts in your Act! CRM database. | | [ForecastByProduct](#forecastbyproduct) | Generates forecasted opportunity data by given products. | | [ForecastByProductDetails](#forecastbyproductdetails) | Generates forecasted opportunity data by a given product.. | | [ForecastByRep](#forecastbyrep) | Generates forecasted opportunity data by given users. | | [ForecastByRepDetails](#forecastbyrepdetails) | Generates forecasted opportunity data by a given user. | | [GroupContacts](#groupcontacts) | Query and delete the Contacts belonging to a Group. | | [GroupNotes](#groupnotes) | Query the Notes for a given Act! CRM Group. | | [Groups](#groups) | Create, update, delete and query the Groups participating in your Act! CRM database. | | [Histories](#histories) | Get, Create, Update or Delete all history items. | | [Notes](#notes) | Create, update, delete and query the Notes in your Act! CRM database. | | [Opportunities](#opportunities) | Create, update, delete and query the Opportunities in your Act! CRM database. | | [OpportunityCompanies](#opportunitycompanies) | Query and delete the Companies related to an Act! CRM opportunity. | | [OpportunityContacts](#opportunitycontacts) | Query and delete the Contacts associated with an Opportunity. | | [OpportunityCount](#opportunitycount) | Generates a summary of the total number of opportunities within a stage. | | [OpportunityGroups](#opportunitygroups) | Query and delete the Act! CRM Groups associated with an Opportunity. | | [OpportunityNotes](#opportunitynotes) | Query the Notes for a given Act! CRM Opportunity. | | [OpportunityProducts](#opportunityproducts) | Update, delete and query the Products associated with an Opportunity. | | [Pipeline](#pipeline) | Gets all opportunity matching the custom filter that are currently being worked. | | [Products](#products) | Create, update, delete and query the Products in your Act! CRM database. | | [RevenueActualVsPredicted](#revenueactualvspredicted) | Generates actual vs predicted opportunity revenue. | | [RevenueCost](#revenuecost) | Generates opportunity periodic revenue versus cost data for given products. | | [RevenueWonVsLost](#revenuewonvslost) | Generates opportunty win versus loss data. | | [SalesByProduct](#salesbyproduct) | Generates opportunity sales by product data for given products. | | [SalesByProductDetails](#salesbyproductdetails) | Generates opportunity sales by product detail data for a given product. | | [SalesByRep](#salesbyrep) | Generates opportunity sales by user data for given users. | | [SalesByRepDetails](#salesbyrepdetails) | Generates opportunity sales by user data for a given user. | | [StageTime](#stagetime) | Generates opportunity data for the average time in a stage. | | [UserActivities](#useractivities) | Generates activity sales by user data for given users. | | [UserActivityDetails](#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](#objects-supported) ## 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](#activities) | 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#companies) | 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](#objects-supported) ## 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](#objects-supported) ## 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](#contacts) | 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](#objects-supported) ## ContactHistories | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------- | -------- | -------- | ------------------------ | ---------- | -------------------------------------------------------------- | | Id [KEY] | String | True | | No | Id of the history item created | | ContactId | String | True | [Contacts.Id](#contacts) | 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](#objects-supported) ## 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](#contacts) | 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#groups) | 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#opportunities) | 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](#objects-supported) ## 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](#opportunities) | 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](#objects-supported) ## 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](#objects-supported) ## 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](#opportunities) | 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](#objects-supported) ## 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](#opportunities) | 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](#objects-supported) ## 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](#opportunities) | 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported) ## 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](#objects-supported)