Act! CRM Connector Objects
This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.
| Name | Description |
|---|---|
| Activities | Create, update, delete and query the Activities in your Act! CRM database. |
| ActivityCompanies | Query the Companies participating in an Act! CRM Activity. |
| AnalyticsHistory | Gets historical e-marketing information for a given date range. |
| CampaignLeads | Gets contacts leads. |
| CampaignLeadsinfo | Gets opportunities within a campaign within a specified date range. |
| CampaignResults | Gets campaign result information. |
| CampaignSent | Gets campaign sent within a specified date range. |
| CloseReason | Generates opportunity data to summerizes how many times a reason has been closed. |
| CloseReasonDetails | Generates opportunity data to summerizes how many times a reason has been closed. |
| Companies | Create, update, delete and query the Companies created in your Act! CRM database. |
| CompanyContacts | Query the Contacts belonging to a Company. |
| CompanyNotes | Query the Notes for a given Act! CRM Company. |
| ContactGroups | Query the Act! CRM Groups the Contact belongs to. |
| ContactHistories | Get all the history related to a contact. |
| ContactNotes | Query and delete the Notes for a given Act! CRM Contact. |
| Contacts | Create, update, delete and query the Contacts in your Act! CRM database. |
| ForecastByProduct | Generates forecasted opportunity data by given products. |
| ForecastByProductDetails | Generates forecasted opportunity data by a given product.. |
| ForecastByRep | Generates forecasted opportunity data by given users. |
| ForecastByRepDetails | Generates forecasted opportunity data by a given user. |
| GroupContacts | Query and delete the Contacts belonging to a Group. |
| GroupNotes | Query the Notes for a given Act! CRM Group. |
| Groups | Create, update, delete and query the Groups participating in your Act! CRM database. |
| Histories | Get, Create, Update or Delete all history items. |
| Notes | Create, update, delete and query the Notes in your Act! CRM database. |
| Opportunities | Create, update, delete and query the Opportunities in your Act! CRM database. |
| OpportunityCompanies | Query and delete the Companies related to an Act! CRM opportunity. |
| OpportunityContacts | Query and delete the Contacts associated with an Opportunity. |
| OpportunityCount | Generates a summary of the total number of opportunities within a stage. |
| OpportunityGroups | Query and delete the Act! CRM Groups associated with an Opportunity. |
| OpportunityNotes | Query the Notes for a given Act! CRM Opportunity. |
| OpportunityProducts | Update, delete and query the Products associated with an Opportunity. |
| Pipeline | Gets all opportunity matching the custom filter that are currently being worked. |
| Products | Create, update, delete and query the Products in your Act! CRM database. |
| RevenueActualVsPredicted | Generates actual vs predicted opportunity revenue. |
| RevenueCost | Generates opportunity periodic revenue versus cost data for given products. |
| RevenueWonVsLost | Generates opportunty win versus loss data. |
| SalesByProduct | Generates opportunity sales by product data for given products. |
| SalesByProductDetails | Generates opportunity sales by product detail data for a given product. |
| SalesByRep | Generates opportunity sales by user data for given users. |
| SalesByRepDetails | Generates opportunity sales by user data for a given user. |
| StageTime | Generates opportunity data for the average time in a stage. |
| UserActivities | Generates activity sales by user data for given users. |
| UserActivityDetails | Generated schema file. |
| 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. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier (id) for this company. | |
| ActivityId [KEY] | String | False | Activities.id | No | A unique identifier that represents the activity the companies are part of. |
| Created | Datetime | False | No | Created date and the activity. | |
| Name | String | False | No | The company’s given name. | |
| AddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| AddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| AddressLine1 | String | False | No | Primary street address | |
| AddressLine2 | String | False | No | Secondary street address | |
| AddressLine3 | String | False | No | Miscellaneous street address | |
| AddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| AddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| BillingAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| BillingAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| BillingAddressLine1 | String | False | No | Primary street address | |
| BillingAddressLine2 | String | False | No | Secondary street address | |
| BillingAddressLine3 | String | False | No | Miscellaneous street address | |
| BillingAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| BillingAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| Description | String | False | No | A brief written representation or account of this company. | |
| Division | String | False | No | The name of a smaller part of a parent company tasked with overseeing different types of products or services than those offered by the parent company. | |
| Edited | Datetime | False | No | Edited date of the activity. | |
| EditedBy | String | False | No | User that edited the activity. | |
| Fax | String | False | No | The company’s fax phone number. | |
| FaxExtension | String | False | No | The company’s fax phone number extension. | |
| HierarchyLevel | Int | False | No | The positional level of where this company lays within a company hierarchy. | |
| IdStatus | String | False | No | The relative social or professional position of an individual within a group or organization. | |
| Industry | String | False | No | Economic activity concerned with the processing of raw materials and manufacture of goods in factories. | |
| NumberOfEmployees | Int | False | No | The total number of employees that this company operates with. | |
| ParentID | String | False | No | The unique identifier (id) of the parent company. | |
| Phone | String | False | No | The company’s phone number. | |
| PhoneExtension | String | False | No | The company’s phone number extension. | |
| RecordOwner | String | False | No | Owner of the activity. | |
| ReferredBy | String | False | No | Mention or allude to. | |
| Region | String | False | No | A part of a country, of the world, etc., that is different or separate from other parts in some way. | |
| Revenue | Decimal | False | No | The amount of money that this company actually receives during a specific period, including discounts and deductions for returned merchandise. | |
| ShippingAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| ShippingAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| ShippingAddressLine1 | String | False | No | Primary street address | |
| ShippingAddressLine2 | String | False | No | Secondary street address | |
| ShippingAddressLine3 | String | False | No | Miscellaneous street address | |
| ShippingAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| ShippingAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| SicCode | String | False | No | Standard Industrial Classification (SIC) codes are four-digit numerical codes assigned by the U.S. government to business establishments to identify the primary business of the establishment. | |
| Territory | String | False | No | Geographical area. | |
| TickerSymbol | String | False | No | An arrangement of characters (usually letters) representing a particular security listed on an exchange or otherwise traded publicly. | |
| TollFreeExtension | String | False | No | The company’s toll free phone number. | |
| TollFreePhone | String | False | No | The company’s toll free phone number. | |
| Website | String | False | No | The company’s website. | |
| AddressLatitude | Decimal | False | No | The angular distance of a place north or south of the earth’s equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes. | |
| AddressLongitude | Decimal | False | No | The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes. | |
| BillingAddressLatitude | Decimal | False | No | The Billing address latitude. | |
| BillingAddressLongitude | Decimal | False | No | The Billing address longitude. | |
| HasDivisions | Boolean | False | No | This readonly property indicates that this company has divisions. | |
| ImportDate | Datetime | False | No | This readonly property displays the date that the opportunity was imported into the system. | |
| IsPrivate | Boolean | False | No | Indicates elevated security that only the creator/owner has access to this company. | |
| RootParentId | String | False | No | The unique identifier (id) of the parent company. | |
| ShippingAddressLatitude | Decimal | False | No | The Shipping address latitude. | |
| ShippingAddressLongitude | Decimal | False | No | The Shipping address longitude. | |
| RecordManagerID | String | False | No | The record manager. | |
| CustomFields | String | False | No | Custom fields. | |
| RecordManager | String | False | No | Manager of the activity. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier (id) for this contact. | |
| CompanyId [KEY] | String | False | Companies.Id | No | The unique identifier (id) of the company to retrieve contacts from. |
| Created | Datetime | False | No | Created data of the contact. | |
| FullName | String | False | No | The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act! | |
| AltEmailAddress | String | False | No | A unique electronic address that an individual can be contacted. | |
| AlternateExtension | String | False | No | The contact’s alternate phone number extension. | |
| AlternatePhone | String | False | No | The contact’s alternate phone number. | |
| Birthday | Datetime | False | No | The anniversary of the day on which a person was born. | |
| BusinessAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| BusinessAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| BusinessAddressLine1 | String | False | No | Primary street address | |
| BusinessAddressLine2 | String | False | No | Secondary street address | |
| BusinessAddressLine3 | String | False | No | Miscellaneous street address | |
| BusinessAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| BusinessAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| BusinessExtension | String | False | No | The contact’s business phone number extension. | |
| BusinessPhone | String | False | No | The contact’s business phone number. | |
| Company | String | False | No | The organization that this contact is associated with. | |
| ContactType | String | False | No | The type of contact: Contact, Secondary, or User. | |
| Department | String | False | No | An area of special expertise or responsibility. | |
| Edited | Datetime | False | No | Edited date of the contact. | |
| EditedBy | String | False | No | User who edited the contact. | |
| EmailAddress | String | False | No | A unique electronic address that an individual can be contacted. | |
| FaxExtension | String | False | No | The contact’s fax phone number extension. | |
| FaxPhone | String | False | No | The contact’s fax phone number. | |
| FirstName | String | False | No | A personal given name. | |
| HomeAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| HomeAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| HomeAddressLine1 | String | False | No | Primary street address | |
| HomeAddressLine2 | String | False | No | Secondary street address | |
| HomeAddressLine3 | String | False | No | Miscellaneous street address | |
| HomeAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| HomeAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| HomeExtension | String | False | No | The contact’s home phone extension. | |
| HomePhone | String | False | No | The contact’s home phone number. | |
| IdStatus | String | False | No | The relative social or professional position of an individual within a group or organization. | |
| IsUser | Bool | False | No | An indicator if this contact is also a user within the system. | |
| JobTitle | String | False | No | The title or position this contact holds. | |
| LastName | String | False | No | The family name or surname. | |
| LastResults | String | False | No | Identifies last communication or action with a contact. | |
| Latitude | Decimal | False | No | The angular distance of a place north or south of the earth’s equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes. | |
| Longitude | Decimal | False | No | The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes. | |
| MessengerID | String | False | No | An online identifier alias. | |
| MiddleName | String | False | No | A name between one’s first name and surname. | |
| MobileExtension | String | False | No | The contact’s mobile phone extension. | |
| MobilePhone | String | False | No | The contact’s mobile phone number. | |
| NamePrefix | String | False | No | A patronymic prefix. | |
| NameSuffix | String | False | No | Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors. | |
| PagerExtension | String | False | No | The contact’s pager phone number extension | |
| PagerPhone | String | False | No | The contact’s pager phone number. | |
| PersonalEmailAddress | String | False | No | A unique electronic address that an individual can be contacted. | |
| RecordOwner | String | False | No | Owner user of the record. | |
| ReferredBy | String | False | No | Indiciates how this contact came about. | |
| Salutation | String | False | No | A gesture or utterance made as a greeting or acknowledgment. | |
| Website | String | False | No | The contact’s web site. | |
| IsFavorite | Bool | False | No | Assign this contact as a favorite. | |
| IsImported | Bool | False | No | Identifies last communication or action with a contact. | |
| ImportDate | Datetime | False | No | This readonly property displays the date that the opportunity was imported into the system. | |
| IsPrivate | Bool | False | No | Identifies last communication or action with a contact. | |
| LastEmail | String | False | No | The last email. | |
| LastAttempt | String | False | No | The last attempt. | |
| LastReach | String | False | No | The last reach. | |
| LastMeeting | String | False | No | The last meeting. | |
| LastLetterSent | String | False | No | The last letter sent. | |
| AmaScore | Int | False | No | The contact’s. | |
| BusinessAddressLatitude | Decimal | False | No | The business address latitude. | |
| BusinessAddressLongitude | Decimal | False | No | The business address longitude. | |
| BusinessCountryCode | Int | False | No | The contact’s business phone country code. | |
| BusinessMaskFormat | String | False | No | The contact’s business phone mask format. | |
| MobileCountryCode | Int | False | No | The contact’s mobile phone country code. | |
| MobileMaskFormat | String | False | No | The contact’s mobile phone mask format. | |
| FaxCountryCode | Int | False | No | The contact’s fax phone country code. | |
| FaxMaskFormat | String | False | No | The contact’s fax phone mask format. | |
| HomeAddressLatitude | Decimal | False | No | The Home address latitude. | |
| HomeAddressLongitude | Decimal | False | No | The Home address longitude. | |
| HomeCountryCode | Int | False | No | The contact’s home phone country code. | |
| HomeMaskFormat | String | False | No | The contact’s home phone mask format. | |
| AlternateCountryCode | Int | False | No | The contact’s alternate phone country code. | |
| AlternateMaskFormat | String | False | No | The contact’s alternate phone mask format. | |
| PagerCountryCode | Int | False | No | The contact’s pager phone country code. | |
| PagerMaskFormat | String | False | No | The contact’s pager phone mask format. | |
| AemOptOut | Boolean | False | No | AemOptOut. | |
| AemBounceBack | Boolean | False | No | AemBounceBack. | |
| RecordManagerID | String | False | No | The record manager. | |
| QuickbooksId | String | False | No | Quickbooks external Id to match record with quickbooks contact. | |
| NylasContactId | String | False | No | Nylas contact Id to match record with a contact. | |
| CustomFields | String | False | No | Custom fields. | |
| RecordManager | String | False | No | Manager of the activity. |
| 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. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier (id) for a group. | |
| ContactId [KEY] | String | False | Contacts.Id | No | The unique identifier (id) for the contact included in the group. |
| Created | Datetime | False | No | A timestamp when this group was created | |
| Name | String | False | No | The name of the group. | |
| AddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| AddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| AddressLine1 | String | False | No | Primary street address | |
| AddressLine2 | String | False | No | Secondary street address | |
| AddressLine3 | String | False | No | Miscellaneous street address | |
| AddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| AddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| Description | String | False | No | A brief written respresentation of a group. | |
| Edited | Datetime | False | No | Edited date of the contact. | |
| EditedBy | String | False | No | User who edited the contact. | |
| HierarchyLevel | Int | False | No | The level this group appears in its hierarchy. | |
| ParentID | String | False | No | The group’s parent entity. | |
| RecordOwner | String | False | No | Owner user of the record. | |
| HasSubgroups | Boolean | False | No | This readonly property indicates that this group has sub groups. | |
| RecordManager | String | False | No | Record Manager of the record. | |
| RecordManagerID | String | False | No | The record manager id of the record. | |
| ImportDate | Datetime | False | No | This readonly property displays the date that the opportunity was imported into the system. | |
| IsPrivate | Boolean | False | No | Indicates elevated security that only the creator/owner has access to this company. | |
| CustomFields | String | False | No | Custom fields. | |
| AddressLatitude | Decimal | False | No | The Address latitude. | |
| AddressLongitude | Decimal | False | No | The Address longitude. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | Id of the history item created | |
| ContactId | String | True | Contacts.Id | No | Id of the contact |
| AttachmentDisplayName | String | True | No | Name of the attachment related to a history | |
| AttachmentFileExtension | String | True | No | FileExtension of the attachment related to a history | |
| AttachmentFileName | String | True | No | FileName of the attachment related to a history | |
| AttachmentFileSize | Integer | True | No | File Size of the attachment related to a history | |
| AttachmentFileSizeDisplay | String | True | No | File Size Display of the attachment related to a history | |
| AttachmentFileType | String | True | No | FileType of the attachment related to a history | |
| AttachmentLastModified | Datetime | True | No | File Last Modified date of the attachment related to a history | |
| AttachmentPersonal | Boolean | True | No | Attachment Personal | |
| CompaniesAggregate | String | True | No | Companies associated with a history | |
| ContactsAggregate | String | True | No | Contacts associated with a history | |
| Created | Datetime | True | No | The datetime when history was created | |
| CreateUserID | String | True | No | User Id of the user who craeted the history | |
| Details | String | True | No | Details of history | |
| Duration | String | True | No | Duration | |
| Edited | Datetime | True | No | Datetime when history was last edited | |
| EndTime | Datetime | True | No | End Time of history | |
| GroupsAggregate | String | True | No | Groups associated with history | |
| HistoryTypeDescription | String | True | No | Description of the type of history | |
| HistoryTypeId | Integer | True | No | History Type ID | |
| HistoryTypeName | String | True | No | Name of history type | |
| TypeID | Integer | True | No | Id of history type | |
| IsPrivate | Boolean | True | No | Indicates whether history is private or not | |
| ManageUserID | String | True | No | User Id of manager | |
| OpportunitiesAggregate | String | True | No | Opportunities associated with history | |
| OutlookID | String | True | No | Outlook Id | |
| RecordManager | String | True | No | Record Manager | |
| RecordManagerID | String | True | No | Id of Record Msnager | |
| Regarding | String | True | No | Tells what history is about | |
| StartTime | Datetime | True | No | Start Time |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier (id) for a given note. | |
| ContactId [KEY] | String | False | Contacts.Id | No | The unique identifier (id) for the contact included in the note. |
| ManageUserID | String | False | No | The unique identifier (id) of the user managing the note. | |
| CreateUserID | String | False | No | The unique identifier (id) of the user who created the note. | |
| IsPrivate | Boolean | False | No | Indicator if the note is private. | |
| NoteText | String | False | No | Descriptive text of the note. | |
| NoteTypeID | Long | False | No | The id of the type of the note. | |
| DisplayDate | Datetime | False | No | Display date of the note. | |
| Created | Datetime | False | No | Datetime of the note creation. | |
| Edited | Datetime | False | No | Datetime of the last edit of the note. | |
| AttachmentDisplayName | String | False | No | Display name of the attachment. | |
| AttachmentFileExtension | String | False | No | File extension of the attachment. | |
| AttachmentFileName | String | False | No | File name of the attachment. | |
| AttachmentFileSize | Long | False | No | File size of the attachment. | |
| AttachmentFileSizeDisplay | String | False | No | Display file size of the attachment. | |
| AttachmentFileType | String | False | No | Type of the attachment file. | |
| AttachmentLastModified | Datetime | False | No | Last modified datetime of the attachment. | |
| AttachmentPersonal | Boolean | False | No | Indicator if the attachment is personal. | |
| RecordManager | String | False | No | Record Manager of the record. | |
| RecordManagerID | String | False | No | The record manager id of the record. | |
| Companies | String | False | No | List of companies that are associated to this note entity. | |
| Contacts | String | False | No | List of contacts that are associated to this note entity. | |
| Groups | String | False | No | List of groups that are associated to this note entity. | |
| Opportunities | String | False | No | List of opportunities that are associated to this note entity. |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier (id) for this contact. | |
| GroupId [KEY] | String | False | Groups.Id | No | The unique identifier (id) of the group to retrieve contacts from. |
| Created | Datetime | False | No | Created date of the group. | |
| FullName | String | False | No | The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act! | |
| AltEmailAddress | String | False | No | A unique electronic address that an individual can be contacted. | |
| AlternateExtension | String | False | No | The contact’s alternate phone number extension. | |
| AlternatePhone | String | False | No | The contact’s alternate phone number. | |
| Birthday | Datetime | False | No | The anniversary of the day on which a person was born. | |
| BusinessAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| BusinessAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| BusinessAddressLine1 | String | False | No | Primary street address | |
| BusinessAddressLine2 | String | False | No | Secondary street address | |
| BusinessAddressLine3 | String | False | No | Miscellaneous street address | |
| BusinessAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| BusinessAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| BusinessExtension | String | False | No | The contact’s business phone number extension. | |
| BusinessPhone | String | False | No | The contact’s business phone number. | |
| Company | String | False | No | The organization that this contact is associated with. | |
| CompanyID | String | False | No | The unique identifier (companyID) for a given companies. | |
| ContactType | String | False | No | The type of contact: Contact, Secondary, or User. | |
| Department | String | False | No | An area of special expertise or responsibility. | |
| Edited | Datetime | False | No | Edited date of the group. | |
| EditedBy | String | False | No | User who edited the group. | |
| EmailAddress | String | False | No | A unique electronic address that an individual can be contacted. | |
| FaxExtension | String | False | No | The contact’s fax phone number extension. | |
| FaxPhone | String | False | No | The contact’s fax phone number. | |
| FirstName | String | False | No | A personal given name. | |
| HomeAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| HomeAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| HomeAddressLine1 | String | False | No | Primary street address | |
| HomeAddressLine2 | String | False | No | Secondary street address | |
| HomeAddressLine3 | String | False | No | Miscellaneous street address | |
| HomeAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| HomeAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| HomeExtension | String | False | No | The contact’s home phone extension. | |
| HomePhone | String | False | No | The contact’s home phone number. | |
| IdStatus | String | False | No | The relative social or professional position of an individual within a group or organization. | |
| IsUser | Bool | False | No | An indicator if this contact is also a user within the system. | |
| JobTitle | String | False | No | The title or position this contact holds. | |
| LastName | String | False | No | The family name or surname. | |
| LastResults | String | False | No | Identifies last communication or action with a contact. | |
| Latitude | Decimal | False | No | The angular distance of a place north or south of the earth’s equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes. | |
| Longitude | Decimal | False | No | The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes. | |
| MessengerID | String | False | No | An online identifier alias. | |
| MiddleName | String | False | No | A name between one’s first name and surname. | |
| MobileExtension | String | False | No | The contact’s mobile phone extension. | |
| MobilePhone | String | False | No | The contact’s mobile phone number. | |
| NamePrefix | String | False | No | A patronymic prefix. | |
| NameSuffix | String | False | No | Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors. | |
| PagerExtension | String | False | No | The contact’s pager phone number extension | |
| PagerPhone | String | False | No | The contact’s pager phone number. | |
| PersonalEmailAddress | String | False | No | A unique electronic address that an individual can be contacted. | |
| RecordOwner | String | False | No | Owner user of the record. | |
| ReferredBy | String | False | No | Indiciates how this contact came about. | |
| Salutation | String | False | No | A gesture or utterance made as a greeting or acknowledgment. | |
| Website | String | False | No | The contact’s web site. | |
| IsFavorite | Bool | False | No | Assign this contact as a favorite. | |
| IsImported | Bool | False | No | Identifies last communication or action with a contact. | |
| ImportDate | Datetime | False | No | This readonly property displays the date that the opportunity was imported into the system. | |
| IsPrivate | Bool | False | No | Identifies last communication or action with a contact. | |
| LastEmail | String | False | No | Last email. | |
| LastAttempt | String | False | No | Last attempt. | |
| LastReach | String | False | No | Last reach. | |
| LastMeeting | String | False | No | Last meeting. | |
| LastLetterSent | String | False | No | Last letter sent. | |
| AmaScore | Int | False | No | The contact’s. | |
| BusinessAddressLatitude | Decimal | False | No | Business address latitude. | |
| BusinessAddressLongitude | Decimal | False | No | Business address longitude. | |
| BusinessCountryCode | Int | False | No | The contact’s business phone country code. | |
| BusinessMaskFormat | String | False | No | The contact’s business phone mask format. | |
| MobileCountryCode | Int | False | No | The contact’s mobile phone country code. | |
| MobileMaskFormat | String | False | No | The contact’s mobile phone mask format. | |
| FaxCountryCode | Int | False | No | The contact’s fax phone country code. | |
| FaxMaskFormat | String | False | No | The contact’s fax phone mask format. | |
| HomeAddressLatitude | Decimal | False | No | Home address latitude. | |
| HomeAddressLongitude | Decimal | False | No | Home address longitude. | |
| HomeCountryCode | Int | False | No | The contact’s home phone country code. | |
| HomeMaskFormat | String | False | No | The contact’s home phone mask format. | |
| AlternateCountryCode | Int | False | No | The contact’s alternate phone country code. | |
| AlternateMaskFormat | String | False | No | The contact’s alternate phone mask format. | |
| PagerCountryCode | Int | False | No | The contact’s pager phone country code. | |
| PagerMaskFormat | String | False | No | The contact’s pager phone mask format. | |
| AemOptOut | Bool | False | No | AemOptOut. | |
| AemBounceBack | Bool | False | No | AemBounceBack. | |
| RecordManagerId | String | False | No | The record manager. | |
| QuickBooksId | String | False | No | Quickbooks external Id to match record with quickbooks contact. | |
| NylasContactId | String | False | No | Nylas contact Id to match record with a contact. | |
| CustomFields | String | False | No | Custom fields. | |
| RecordManager | String | False | No | Record manager. |
| 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. |
| 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. |
| 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 |
| 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. |
| 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. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier (id) for this company. | |
| OpportunityId [KEY] | String | False | Opportunities.Id | No | The unique identifier of the opportunity the companies are related to. |
| Created | Datetime | False | No | Created date of the company. | |
| Name | String | False | No | The company’s given name. | |
| AddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| AddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| AddressLine1 | String | False | No | Primary street address | |
| AddressLine2 | String | False | No | Secondary street address | |
| AddressLine3 | String | False | No | Miscellaneous street address | |
| AddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| AddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| BillingAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| BillingAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| BillingAddressLine1 | String | False | No | Primary street address | |
| BillingAddressLine2 | String | False | No | Secondary street address | |
| BillingAddressLine3 | String | False | No | Miscellaneous street address | |
| BillingAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| BillingAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| Description | String | False | No | A brief written representation or account of this company. | |
| Division | String | False | No | The name of a smaller part of a parent company tasked with overseeing different types of products or services than those offered by the parent company. | |
| Edited | Datetime | False | No | Edited date of the company. | |
| EditedBy | String | False | No | User who edited the company. | |
| Fax | String | False | No | The company’s fax phone number. | |
| FaxExtension | String | False | No | The company’s fax phone number extension. | |
| HierarchyLevel | Int | False | No | The positional level of where this company lays within a company hierarchy. | |
| IdStatus | String | False | No | The relative social or professional position of an individual within a group or organization. | |
| Industry | String | False | No | Economic activity concerned with the processing of raw materials and manufacture of goods in factories. | |
| NumberOfEmployees | Int | False | No | The total number of employees that this company operates with. | |
| ParentID | String | False | No | The unique identifier (id) of the parent company. | |
| Phone | String | False | No | The company’s phone number. | |
| PhoneExtension | String | False | No | The company’s phone number extension. | |
| RecordOwner | String | False | No | Owner user of the record. | |
| ReferredBy | String | False | No | Mention or allude to. | |
| Region | String | False | No | A part of a country, of the world, etc., that is different or separate from other parts in some way. | |
| Revenue | Decimal | False | No | The amount of money that this company actually receives during a specific period, including discounts and deductions for returned merchandise. | |
| ShippingAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| ShippingAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| ShippingAddressLine1 | String | False | No | Primary street address | |
| ShippingAddressLine2 | String | False | No | Secondary street address | |
| ShippingAddressLine3 | String | False | No | Miscellaneous street address | |
| ShippingAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| ShippingAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| SicCode | String | False | No | Standard Industrial Classification (SIC) codes are four-digit numerical codes assigned by the U.S. government to business establishments to identify the primary business of the establishment. | |
| Territory | String | False | No | Geographical area. | |
| TickerSymbol | String | False | No | An arrangement of characters (usually letters) representing a particular security listed on an exchange or otherwise traded publicly. | |
| TollFreeExtension | String | False | No | The company’s toll free phone number. | |
| TollFreePhone | String | False | No | The company’s toll free phone number. | |
| Website | String | False | No | The company’s website. | |
| AddressLatitude | Decimal | False | No | The address latitude. | |
| AddressLongitude | Decimal | False | No | The address longitude. | |
| BillingAddressLatitude | Decimal | False | No | The billing address latitude. | |
| BillingAddressLongitude | Decimal | False | No | The billing address longitude. | |
| HasDivisions | Bool | False | No | This readonly property indicates that this company has divisions. | |
| ImportDate | Datetime | False | No | This readonly property displays the date that the opportunity was imported into the system. | |
| IsPrivate | Bool | False | No | Indicates elevated security that only the creator/owner has access to this company. | |
| RootParentId | String | False | No | The unique identifier (id) of the parent company. | |
| ShippingAddressLatitude | Decimal | False | No | The shipping address latitude. | |
| ShippingAddressLongitude | Decimal | False | No | The shipping address longitude. | |
| RecordManagerID | String | False | No | The record manager. | |
| CustomFields | String | False | No | Custom fields. | |
| RecordManager | String | False | No | Manager of the activity. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier (id) for this contact. | |
| OpportunityId [KEY] | String | False | Opportunities.Id | No | The unique identifier (id) for the opportunity to query contacts from. |
| Created | Datetime | False | No | Created date of the contact. | |
| FullName | String | False | No | The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act! | |
| AltEmailAddress | String | False | No | A unique electronic address that an individual can be contacted. | |
| AlternateExtension | String | False | No | The contact’s alternate phone number extension. | |
| AlternatePhone | String | False | No | The contact’s alternate phone number. | |
| Birthday | Datetime | False | No | The anniversary of the day on which a person was born. | |
| BusinessAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| BusinessAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| BusinessAddressLine1 | String | False | No | Primary street address | |
| BusinessAddressLine2 | String | False | No | Secondary street address | |
| BusinessAddressLine3 | String | False | No | Miscellaneous street address | |
| BusinessAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| BusinessAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| BusinessExtension | String | False | No | The contact’s business phone number extension. | |
| BusinessPhone | String | False | No | The contact’s business phone number. | |
| Company | String | False | No | The organization that this contact is associated with. | |
| CompanyID | String | False | No | The unique identifier (companyID) for a given companies. | |
| ContactType | String | False | No | The type of contact: Contact, Secondary, or User. | |
| Department | String | False | No | An area of special expertise or responsibility. | |
| Edited | Datetime | False | No | Edited date of the contact. | |
| EditedBy | String | False | No | User who edited the contact. | |
| EmailAddress | String | False | No | A unique electronic address that an individual can be contacted. | |
| FaxExtension | String | False | No | The contact’s fax phone number extension. | |
| FaxPhone | String | False | No | The contact’s fax phone number. | |
| FirstName | String | False | No | A personal given name. | |
| HomeAddressCity | String | False | No | An inhabited place of greater size, population, or importance than a town or village. | |
| HomeAddressCountry | String | False | No | A nation with its own government, occupying a particular territory. | |
| HomeAddressLine1 | String | False | No | Primary street address | |
| HomeAddressLine2 | String | False | No | Secondary street address | |
| HomeAddressLine3 | String | False | No | Miscellaneous street address | |
| HomeAddressPostalCode | String | False | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| HomeAddressState | String | False | No | A nation or territory considered as an organized political community under one government. | |
| HomeExtension | String | False | No | The contact’s home phone extension. | |
| HomePhone | String | False | No | The contact’s home phone number. | |
| IdStatus | String | False | No | The relative social or professional position of an individual within a group or organization. | |
| IsUser | Bool | False | No | An indicator if this contact is also a user within the system. | |
| JobTitle | String | False | No | The title or position this contact holds. | |
| LastName | String | False | No | The family name or surname. | |
| LastResults | String | False | No | Identifies last communication or action with a contact. | |
| Latitude | Decimal | False | No | The angular distance of a place north or south of the earth’s equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes. | |
| Longitude | Decimal | False | No | The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes. | |
| MessengerID | String | False | No | An online identifier alias. | |
| MiddleName | String | False | No | A name between one’s first name and surname. | |
| MobileExtension | String | False | No | The contact’s mobile phone extension. | |
| MobilePhone | String | False | No | The contact’s mobile phone number. | |
| NamePrefix | String | False | No | A patronymic prefix. | |
| NameSuffix | String | False | No | Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors. | |
| PagerExtension | String | False | No | The contact’s pager phone number extension | |
| PagerPhone | String | False | No | The contact’s pager phone number. | |
| PersonalEmailAddress | String | False | No | A unique electronic address that an individual can be contacted. | |
| RecordOwner | String | False | No | Owner user of the record. | |
| ReferredBy | String | False | No | Indiciates how this contact came about. | |
| Salutation | String | False | No | A gesture or utterance made as a greeting or acknowledgment. | |
| Website | String | False | No | The contact’s web site. | |
| IsFavorite | Bool | False | No | Assign this contact as a favorite. | |
| IsImported | Bool | False | No | Identifies last communication or action with a contact. | |
| ImportDate | Datetime | False | No | This readonly property displays the date that the opportunity was imported into the system. | |
| IsPrivate | Bool | False | No | Identifies last communication or action with a contact. | |
| LastEmail | String | False | No | Last email. | |
| LastAttempt | String | False | No | Last attempt. | |
| LastReach | String | False | No | Last reach. | |
| LastMeeting | String | False | No | Last meeting. | |
| LastLetterSent | String | False | No | Last letter sent. | |
| AmaScore | Int | False | No | The contact’s. | |
| BusinessAddressLatitude | Decimal | False | No | The business address latitude. | |
| BusinessAddressLongitude | Decimal | False | No | The business address longitude. | |
| BusinessCountryCode | Int | False | No | The contact’s business phone country code. | |
| BusinessMaskFormat | String | False | No | The contact’s business phone mask format. | |
| MobileCountryCode | Int | False | No | The contact’s mobile phone country code. | |
| MobileMaskFormat | String | False | No | The contact’s mobile phone mask format. | |
| FaxCountryCode | Int | False | No | The contact’s fax phone country code. | |
| FaxMaskFormat | String | False | No | The contact’s fax phone mask format. | |
| HomeAddressLatitude | Decimal | False | No | The home address latitude. | |
| HomeAddressLongitude | Decimal | False | No | The home address longitude. | |
| HomeCountryCode | Int | False | No | The contact’s home phone country code. | |
| HomeMaskFormat | String | False | No | The contact’s home phone mask format. | |
| AlternateCountryCode | Int | False | No | The contact’s alternate phone country code. | |
| AlternateMaskFormat | String | False | No | The contact’s alternate phone mask. | |
| PagerCountryCode | Int | False | No | The contact’s pager phone country code. | |
| PagerMaskFormat | String | False | No | The contact’s pager phone mask. | |
| AemOptOut | Bool | False | No | AemOptOut. | |
| AemBouncBack | Bool | False | No | AemBouncBack. | |
| RecordManagerID | String | False | No | The record manager. | |
| QuickbooksId | String | False | No | Quickbooks external Id to match record with quickbooks contact. | |
| NylasContactId | String | False | No | Nylas contact Id to match record with a contact. | |
| CustomFileds | String | False | No | Custom fields. | |
| RecordManager | String | False | No | Manager of the activity. |
| 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 |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The unique identifier (id) for a group. | |
| OpportunityId [KEY] | String | False | Opportunities.Id | No | The unique identifier (id) for the opportunity to retrieve groups from. |
| Created | Datetime | True | No | A timestamp when this group was created | |
| Name | String | True | No | The name of the group. | |
| AddressCity | String | True | No | An inhabited place of greater size, population, or importance than a town or village. | |
| AddressCountry | String | True | No | A nation with its own government, occupying a particular territory. | |
| AddressLine1 | String | True | No | Primary street address | |
| AddressLine2 | String | True | No | Secondary street address | |
| AddressLine3 | String | True | No | Miscellaneous street address | |
| AddressPostalCode | String | True | No | A code of letters and digits added to a postal address to aid in the sorting of mail. | |
| AddressState | String | True | No | A nation or territory considered as an organized political community under one government. | |
| Description | String | True | No | A brief written respresentation of a group. | |
| Edited | Datetime | True | No | Edited date of the group. | |
| EditedBy | String | True | No | User who edited the group. | |
| HierarchyLevel | Int | True | No | The level this group appears in its hierarchy. | |
| ParentID | String | True | No | The group’s parent entity. | |
| RecordOwner | String | True | No | Owner user of the record. | |
| Contacts | Int | True | No | Get the total number of contacts within the group. Contacts is nullable and hide it if the value is null. | |
| HasSubgroups | Bool | True | No | This readonly property indicates that this group has sub groups. | |
| IsPrivate | Bool | True | No | Indicates elevated security that only the creator/owner has access to this company. | |
| ImportDate | Datetime | True | No | This readonly property displays the date that the opportunity was imported into the system. | |
| AddressLatitude | Decimal | True | No | The address latitude. | |
| AddressLongitude | Decimal | True | No | The address longitude. | |
| RecordManagerID | String | True | No | The record manager. | |
| CustomFields | String | True | No | Custom fields. | |
| RecordManager | String | True | No | Manager of the activity. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier (id) for a given note. | |
| OpportunityId [KEY] | String | False | Opportunities.Id | No | The unique identifier (id) for the opportunity included in the note. |
| ManageUserID | String | False | No | The unique identifier (id) of the user managing the note. | |
| CreateUserID | String | False | No | The unique identifier (id) of the user who created the note. | |
| IsPrivate | Boolean | False | No | Indicator if the note is private. | |
| NoteText | String | False | No | Descriptive text of the note. | |
| NoteTypeID | Long | False | No | The id of the type of the note. | |
| DisplayDate | Datetime | False | No | Display date of the note. | |
| Created | Datetime | False | No | Datetime of the note creation. | |
| Edited | Datetime | False | No | Datetime of the last edit of the note. | |
| AttachmentDisplayName | String | False | No | Display name of the attachment. | |
| AttachmentFileExtension | String | False | No | File extension of the attachment. | |
| AttachmentFileName | String | False | No | File name of the attachment. | |
| AttachmentFileSize | Long | False | No | File size of the attachment. | |
| AttachmentFileSizeDisplay | String | False | No | Display file size of the attachment. | |
| AttachmentFileType | String | False | No | Type of the attachment file. | |
| AttachmentLastModified | Datetime | False | No | Last modified datetime of the attachment. | |
| AttachmentPersonal | Boolean | False | No | Indicator if the attachment is personal. | |
| RecordManager | String | False | No | Manager of the activity. | |
| RecordManagerId | String | False | No | The record manager. | |
| Companies | String | False | No | List of companies that are associated to this note entity. | |
| Contacts | String | False | No | List of contacts that are associated to this note entity. | |
| Groups | String | False | No | List of groups that are associated to this note entity. | |
| Opportunities | String | False | No | List of opportunities that are associated to this note entity. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | A unique identifier (id) for a given product. | |
| OpportunityId [KEY] | String | True | Opportunities.Id | No | A unique identifier (id) of the opportunity containing the products. |
| Created | Datetime | True | No | A timestamp when this group was created | |
| CreateDate | Datetime | True | No | The date that the product was created. | |
| Cost | Decimal | False | No | The cost of the product. | |
| EditDate | Datetime | True | No | The date that the opportunity product was lasted modified. | |
| ItemNumber | String | False | No | A item number assigned to this opportunity product. | |
| Name | String | False | No | The name of the product. | |
| Price | Decimal | False | No | The price of the opportunity product. | |
| Discount | Decimal | False | No | The opportunity product’s discounted percentage (ignore on updates). | |
| DiscountPrice | Decimal | False | No | The discounted price of the opportunity product. | |
| ProductID | String | True | No | A unique identifier (id) for a given product. | |
| Quantity | Decimal | False | No | The quantity of opportunity products. | |
| Type | String | False | No | The quantity of opportunity products. | |
| IsQuickBooksproduct | Boolean | False | No | Define is product linked with Quickbooks Product. | |
| RecordOwner | String | False | No | Record Owner. | |
| RecordManager | String | False | No | Record Manager. | |
| Total | Decimal | False | No | The total pricie of the opportunity product (adjusted price * quantity). | |
| CustomFields | String | False | No | Custom fields. | |
| Edited | Datetime | False | No | Edited. | |
| EditedBy | String | False | No | Edited by. |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |