--- schema_version: "1" id: 989356246ec9566903258f5d80c115e4af64478ca356bf89d9f28999933f3102 title: SuiteCRM Connector Objects (suitecrmv8 Schema) collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/suitecrm/c360-a-suitecrm-objects-suitecrmv8.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-suitecrm-objects-suitecrmv8.html source_site: developer.salesforce.com content_type: documentation content_hash: 667b9e429d0355a659978d597f9ffa5ba70435982eda5df766c0cc04b82238a6 products: - Data 360 Integration Guide - Data 360 Developer Documentation --- # SuiteCRM Connector Objects (suitecrmv8 Schema) **note:** This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at [Agreements and Terms.](https://www.salesforce.com/company/legal/agreements/) If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at [datacloud-connectors-beta@salesforce.com.](mailto:datacloud-connectors-beta@salesforce.com) ## Objects Supported | Name | Description | | ----------------------------------------- | ------------------------------------------------------------------------------------------ | | [Accounts](#accounts) | Create, update, delete, and query accounts created in SuiteCRM | | [Calls](#calls) | Create, update, delete, and query the SuiteCRM project's Calls | | [Campaigns](#campaigns) | Create, update, delete, and query the SuiteCRM project's campaigns | | [Cases](#cases) | Create, update, delete, and query the SuiteCRM cases | | [Contacts](#contacts) | Create, update, delete, and query the contacts in SuiteCRM | | [Contracts](#contracts) | Create, update, delete, and query contracts in SuiteCRM | | [Documents](#documents) | Create, update, delete, and query Documents created in SuiteCRM | | [Emails](#emails) | Create, update, delete, and query the SuiteCRM Emails | | [EmailTemplates](#emailtemplates) | Create, update, delete, and query email templates to be used for emails | | [Events](#events) | Create, update, delete, and query events registered in the SuiteCRM project | | [Invoices](#invoices) | Create, update, delete, and query the invoices saved in the SuiteCRM | | [KBCategories](#kbcategories) | Create, update, delete, and query the KBCategories saved in the SuiteCRM | | [KnowledgeBase](#knowledgebase) | Create, update, delete, and query the Knowledge Base saved in the SuiteCRM | | [Leads](#leads) | Create, update, delete, and query the registered Leads | | [Locations](#locations) | Create, update, delete, and query locations in SuiteCRM | | [Maps](#maps) | Create, update, delete, and query the map information of SuiteCRM | | [MapsAddressCache](#mapsaddresscache) | Create, update, delete, and query information on the Map Address saved in the server cache | | [MapsAreas](#mapsareas) | Create, update, delete, and query maps via Google Maps. | | [MapsMarkers](#mapsmarkers) | Create, update, delete, and query Google Maps Map Markers saved in SuiteCRM | | [Meetings](#meetings) | Create, update, delete, and query Meetings created in SuiteCRM | | [Notes](#notes) | Create, update, delete, and query Notes created in SuiteCRM | | [Opportunities](#opportunities) | Create, update, delete, and query opportunities saved in SuiteCRM | | [PDFTemplates](#pdftemplates) | Create, update, delete, and query PDFTemplates table. | | [Products](#products) | Create, update, delete, and query the products registered for the SuiteCRM project | | [ProductsCategories](#productscategories) | Create, update, delete, and query the product categories. | | [Projects](#projects) | Create, update, delete, and query projects registered in SuiteCRM | | [ProjectsTemplates](#projectstemplates) | Create, update, delete, and query any saved project template. | | [Quotes](#quotes) | Create, update, delete, and query quotes saved in SuiteCRM | | [Reports](#reports) | Create, update, delete, and query information on reports made in SuiteCRM. | | [Spots](#spots) | Create, update, delete, and query the saved spots. | | [Surveys](#surveys) | Create, update, delete, and query the surveys saved in the SuiteCRM | | [Tasks](#tasks) | Create, update, delete, and query Tasks created in SuiteCRM | | [WorkFlow](#workflow) | Create, update, delete, and query the wokflow actions in SuiteCRM | ## Accounts | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the account. | | Name | String | False | | No | The name of the account. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | The full text of the alert. | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | The user name of the user assigned to the record. | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | AccountType | String | False | | No | The type of the account. | | Industry | String | False | | No | The industry that the account belongs in. | | AnnualRevenue | String | False | | No | Annual revenue for this account. | | PhoneFax | String | False | | No | The fax phone number of this account. | | BillingAddressStreet | String | False | | No | The first line of the billing address. | | BillingAddressStreet2 | String | False | | No | The second line of the billing address. | | BillingAddressStreet3 | String | False | | No | The third line of the billing address. | | BillingAddressStreet4 | String | False | | No | The fourth line of the billing address. | | BillingAddressCity | String | False | | No | The city used for the billing address. | | BillingAddressState | String | False | | No | The state used for the billing address. | | BillingAddressPostalcode | String | False | | No | The postal code used for the billing address. | | BillingAddressCountry | String | False | | No | The country used for the billing address. | | Rating | String | False | | No | An arbitrary rating for this account for use in comparisons with others. | | PhoneOffice | String | False | | No | The office phone number. | | PhoneAlternate | String | False | | No | An alternate phone number. | | Website | String | False | | No | The URL of the website for the account. | | Ownership | String | False | | No | The ownership of the account. | | Employees | String | False | | No | Number of employees. Can be a number (100) or range (50-100) | | TickerSymbol | String | False | | No | The stock trading (ticker) symbol for the account. | | ShippingAddressStreet | String | False | | No | The first line of the shipping address. | | ShippingAddressStreet2 | String | False | | No | The second line of the shipping address. | | ShippingAddressStreet3 | String | False | | No | The third line of the shipping address. | | ShippingAddressStreet4 | String | False | | No | The fourth line of the shipping address. | | ShippingAddressCity | String | False | | No | The city used for the shipping address. | | ShippingAddressState | String | False | | No | The state used for the shipping address. | | ShippingAddressPostalcode | String | False | | No | The ZIP code used for the shipping address. | | ShippingAddressCountry | String | False | | No | The country used for the shipping address. | | Email1 | String | False | | No | Email address. | | EmailAddressesPrimary | String | True | | No | Primary email address. | | EmailAddresses | String | True | | No | Alternate Email address. | | EmailAddressesNonPrimary | String | False | | No | Non primary email address. | | ParentId | String | False | | No | The Id of the parent of this account. | | SicCode | String | False | | No | SIC code of the account. | | ParentName | String | True | | No | The name of the parent of this account. | | Members | String | True | | No | | | MemberOf | String | True | | No | | | EmailOptOut | Bool | False | | No | Whether the account has opted out of emails. | | InvalidEmail | Bool | False | | No | Whether the email address of the account has been marked as invalid. | | Cases | String | True | | No | The cases associated with the record. | | Email | String | False | | No | Email address | | Tasks | String | True | | No | The tasks associated with the record. | | Notes | String | True | | No | The notes associated with the record. | | Meetings | String | True | | No | The meetings associated with the record. | | Calls | String | True | | No | The calls associated with the record | | Emails | String | True | | No | The emails associated with the record | | Documents | String | True | | No | The documents associated with the record. | | Bugs | String | True | | No | The bugs associated with the record. | | Contacts | String | True | | No | The contacts associated with the record | | Opportunities | String | True | | No | The opportunities associated with the record. | | Project | String | True | | No | The project associated with the record. | | Leads | String | True | | No | The leads associated with the record. | | Campaigns | String | True | | No | The campaigns associated with the account. | | CampaignAccounts | String | True | | No | | | CampaignId | String | False | | No | The Id of the campaign associated with the record. | | CampaignName | String | True | | No | The name of the campaign associated with the record. | | ProspectLists | String | True | | No | | | AosQuotes | String | True | | No | | | AosInvoices | String | True | | No | | | AosContracts | String | True | | No | | [Return to Top](#objects-supported) ## Calls | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------------------------------------------------------- | | Id [KEY] | String | False | | No | The unique identifier of the call. | | Name | String | False | | No | A brief description of the call. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | The full text of the note. | | Deleted | Bool | False | | No | Record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | DurationHours | String | False | | No | The hours portion of the call duration. | | DurationMinutes | String | False | | No | The minutes portion of the call duration. | | DateStart | Datetime | False | | No | | | DateEnd | Datetime | False | | No | | | ParentType | String | False | | No | The type of the parent Sugar object related to the call. | | ParentName | String | True | | No | The name of the parent of this account. | | Status | String | False | | No | The status of the record. | | Direction | String | False | | No | Indicates whether call is inbound or outbound. | | ParentId | String | False | | No | The Id of the parent of this account. | | ReminderChecked | Bool | False | | No | The checkbox indicating whether or not the reminder value is set. | | ReminderTime | String | False | | No | When a reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start. | | EmailReminderChecked | Bool | False | | No | | | EmailReminderTime | String | False | | No | When a email reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start. | | EmailReminderSent | Bool | False | | No | Whether the email reminder is already sent. | | Reminders | String | False | | No | List of reminders for the call | | OutlookId | String | False | | No | When the Suite Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id. | | AcceptStatus | String | False | | No | | | SetAcceptLinks | String | False | | No | | | ContactName | String | False | | No | | | Opportunities | String | True | | No | The opportunities associated with the record. | | Leads | String | True | | No | The leads associated with the record. | | Project | String | True | | No | The project associated with the record. | | Case | String | True | | No | | | Accounts | String | True | | No | The accounts associated with the record | | Contacts | String | True | | No | The contacts associated with the record | | AosContracts | String | True | | No | | | Users | String | True | | No | | | Notes | String | True | | No | The notes associated with the record. | | ContactId | String | False | | No | The Id of the contact for the call. | | RepeatType | String | False | | No | The type of recurrence. | | RepeatInterval | String | False | | No | The interval of recurrence. | | RepeatDow | String | False | | No | The days of week in recurrence. | | RepeatUntil | String | False | | No | Repeat until the specified date. | | RepeatCount | String | False | | No | Number of recurrences. | | RepeatParentId | String | False | | No | The Id of the first element of recurring records. | | RecurringSource | String | False | | No | The recurring source requesting the call | | RescheduleHistory | String | False | | No | | | RescheduleCount | String | False | | No | | | CallsReschedule | String | True | | No | | [Return to Top](#objects-supported) ## Campaigns | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------------------------------- | | Id [KEY] | String | False | | No | The unique identifier of the campaign. | | Name | String | False | | No | The name of the campaign. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | The description for the campaign. | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | The user name of the user assigned to the record. | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | TrackerKey | String | False | | No | | | TrackerCount | String | False | | No | The number of accesses made to the tracker URL; no longer used as of 4.2. (See CampaignTrackers.) | | ReferUrl | String | False | | No | | | TrackerText | String | False | | No | | | StartDate | String | False | | No | Starting date of the campaign. | | EndDate | String | False | | No | Ending date of the campaign. | | Status | String | False | | No | The status of the record. | | Impressions | String | False | | No | Expected click throughs manually entered by the campaign manager. | | CurrencyId | String | False | | No | | | Budget | String | False | | No | Budgeted amount for the campaign. | | ExpectedCost | String | False | | No | Expected cost of the campaign. | | ActualCost | String | False | | No | Actual cost of the campaign. | | ExpectedRevenue | String | False | | No | Expected revenue stemming from the campaign. | | CampaignType | String | False | | No | | | Objective | String | False | | No | The objective of the campaign. | | Content | String | False | | No | The campaign description. | | Prospectlists | String | True | | No | | | Emailmarketing | String | True | | No | | | Queueitems | String | True | | No | | | LogEntries | String | True | | No | | | TrackedUrls | String | True | | No | | | Frequency | String | False | | No | Frequency of the campaign. | | Leads | String | True | | No | The leads associated with the record. | | Opportunities | String | True | | No | The opportunities associated with the record. | | Contacts | String | True | | No | The contacts associated with the record | | Accounts | String | True | | No | The accounts associated with the record | | Survey | String | True | | No | | | SurveyName | String | True | | No | | | SurveyId | String | False | | No | | | SurveyresponsesCampaigns | String | True | | No | | [Return to Top](#objects-supported) ## Cases | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier for the record. | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | The full text of the note. | | Deleted | Bool | False | | No | Record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The user Id assigned to the record. | | AssignedUserName | String | True | | No | The name of the user assigned to the record. | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | CaseNumber | String | False | | No | | | Type | String | False | | No | The type of case. | | Status | String | False | | No | The status of the record. | | Priority | String | False | | No | The priority of the record. | | Resolution | String | False | | No | The resolution of the case. | | WorkLog | String | False | | No | Free-form text used to denote activities of interest. | | SuggestionBox | String | False | | No | | | AccountName | String | False | | No | The name of the associated account. | | AccountName1 | String | False | | No | A second account for the case | | AccountId | String | False | | No | The Id of the associated account. | | State | String | False | | No | State the case is left in | | CaseAttachmentsDisplay | String | False | | No | | | CaseUpdateForm | String | False | | No | | | ContactCreatedBy | String | True | | No | | | ContactCreatedByName | String | True | | No | | | ContactCreatedById | String | False | | No | | | Tasks | String | True | | No | The tasks associated with the record. | | Notes | String | True | | No | The notes associated with the record. | | Meetings | String | True | | No | The meetings associated with the record. | | Emails | String | True | | No | The emails associated with the record | | Documents | String | True | | No | The documents associated with the record. | | Calls | String | True | | No | The calls associated with the record | | Bugs | String | True | | No | The bugs associated with the record. | | Contacts | String | True | | No | The contacts associated with the record | | Accounts | String | True | | No | The accounts associated with the record | | Project | String | True | | No | The project associated with the record. | | UpdateText | String | False | | No | Text associated with an update on the case. | | Internal | Bool | False | | No | | | AopCaseUpdatesThreaded | String | False | | No | | | AopCaseUpdates | String | True | | No | | | AopCaseEvents | String | True | | No | | [Return to Top](#objects-supported) ## Contacts | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------- | -------- | -------- | ---------- | ---------- | -------------------------------------------------------------------- | | Id [KEY] | String | False | | No | The unique identifier for the record. | | Name | String | False | | No | The name of the contact. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | The full text of the note. | | Deleted | Bool | False | | No | Record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Salutation | String | False | | No | The contact salutation (e.g., Mr. or Ms.). | | FirstName | String | False | | No | The first name of the contact. | | LastName | String | False | | No | The last name of the contact. | | FullName | String | False | | No | The full name of hte contact. | | Title | String | False | | No | The title of the contact. | | Photo | String | False | | No | The avatar for the contact. | | Department | String | False | | No | The department of the contact. | | DoNotCall | Bool | False | | No | An indicator of whether the contact can be called. | | PhoneHome | String | False | | No | | | Email | String | False | | No | The email and name of the contact. | | PhoneMobile | String | False | | No | | | PhoneWork | String | False | | No | | | PhoneOther | String | False | | No | | | PhoneFax | String | False | | No | | | Email1 | String | False | | No | Email address. | | Email2 | String | False | | No | | | InvalidEmail | Bool | False | | No | Whether the email address of the account has been marked as invalid. | | EmailOptOut | Bool | False | | No | Whether the contact has opted out of emails. | | LawfulBasis | String | False | | No | | | DateReviewed | String | False | | No | | | LawfulBasisSource | String | False | | No | | | PrimaryAddressStreet | String | False | | No | The street address for the alternate address. | | PrimaryAddressStreet2 | String | False | | No | The second line of the alternate address. | | PrimaryAddressStreet3 | String | False | | No | The third line of the alternate address. | | PrimaryAddressCity | String | False | | No | The city for the primary address. | | PrimaryAddressState | String | False | | No | The state for the primary address. | | PrimaryAddressPostalcode | String | False | | No | The postal code for the primary address. | | PrimaryAddressCountry | String | False | | No | The country for primary address. | | AltAddressStreet | String | False | | No | | | AltAddressStreet2 | String | False | | No | | | AltAddressStreet3 | String | False | | No | | | AltAddressCity | String | False | | No | | | AltAddressState | String | False | | No | | | AltAddressPostalcode | String | False | | No | | | AltAddressCountry | String | False | | No | | | Assistant | String | False | | No | The name of the assistant of the contact. | | AssistantPhone | String | False | | No | The phone number of the assistant of the contact. | | EmailAddressesPrimary | String | True | | No | Primary email address. | | EmailAddresses | String | True | | No | Alternate Email address. | | EmailAddressesNonPrimary | String | False | | No | Non primary email address. | | EmailAndName1 | String | False | | No | | | LeadSource | String | False | | No | The lead source for the contact. | | AccountName | String | False | | No | The name of the account associated with the contact. | | AccountId | String | False | | No | The Id of the account associated with the contact. | | OpportunityRoleFields | String | True | | No | The opportunity role fields. | | OpportunityRoleId | String | False | | No | The Id of the opportunity role. | | OpportunityRole | String | False | | No | The opportunity role. | | ReportsToId | String | False | | No | The Id of the contact this contact reports to. | | ReportToName | String | False | | No | | | Birthdate | String | False | | No | The birthdate of the contact. | | Accounts | String | True | | No | The accounts associated with the record | | ReportsToLink | String | True | | No | | | Opportunities | String | True | | No | The opportunities associated with the record. | | Bugs | String | True | | No | The bugs associated with the record. | | Calls | String | True | | No | The calls associated with the record | | Cases | String | True | | No | The cases associated with the record. | | DirectReports | String | True | | No | | | Emails | String | True | | No | The emails associated with the record | | Documents | String | True | | No | The documents associated with the record. | | Leads | String | True | | No | The leads associated with the record. | | Meetings | String | True | | No | The meetings associated with the record. | | Notes | String | True | | No | The notes associated with the record. | | Project | String | True | | No | The project associated with the record. | | ProjectResource | String | True | | No | | | AmProjecttemplatesResources | String | True | | No | | | AmProjecttemplatesContacts1 | String | True | | No | | | Tasks | String | True | | No | The tasks associated with the record. | | TasksParent | String | True | | No | | | NotesParent | String | True | | No | | | UserSync | String | True | | No | | | CampaignId | String | False | | No | The Id of the campaign associated with the record. | | CampaignName | String | True | | No | The name of the campaign associated with the record. | | Campaigns | String | True | | No | The campaigns associated with the account. | | CampaignContacts | String | True | | No | | | CAcceptStatusFields | String | True | | No | | | MAcceptStatusFields | String | True | | No | | | AcceptStatusId | String | False | | No | The Id of the accept status. | | AcceptStatusName | String | False | | No | The name of the accept status. | | ProspectLists | String | True | | No | | | SyncContact | Bool | False | | No | | | FpEventsContacts | String | True | | No | | | AosQuotes | String | True | | No | | | AosInvoices | String | True | | No | | | AosContracts | String | True | | No | | | EInviteStatusFields | String | True | | No | | | EventStatusName | String | False | | No | | | EventInviteId | String | False | | No | | | EAcceptStatusFields | String | True | | No | | | EventAcceptStatus | String | False | | No | | | EventStatusId | String | False | | No | | | ProjectContacts1 | String | True | | No | | | AopCaseUpdates | String | True | | No | | | JoomlaAccountId | String | False | | No | Id of the contact's Joomla account. | | PortalAccountDisabled | Bool | False | | No | | | JoomlaAccountAccess | String | False | | No | | | PortalUserType | String | False | | No | Type of the contact's portal account. | [Return to Top](#objects-supported) ## Contracts | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the contract. | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the contract | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the contract manager. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | ReferenceCode | String | False | | No | Reference code of the contract | | StartDate | String | False | | No | Date the contract is valid from | | EndDate | String | False | | No | Date until the contract expires | | TotalContractValue | String | False | | No | | | TotalContractValueUsdollar | String | False | | No | | | CurrencyId | String | False | | No | | | Status | String | False | | No | The status of the record. | | CustomerSignedDate | String | False | | No | Date the customer signed the contract | | CompanySignedDate | String | False | | No | Date the company signed the contract | | RenewalReminderDate | Datetime | False | | No | Date to remind for the contract renewal | | ContractType | String | False | | No | Type of the contract | | ContractAccountId | String | False | | No | Id of the Account linked to the contract | | ContractAccount | String | True | | No | | | OpportunityId | String | False | | No | Id of the opportunity linked to the contract | | Opportunity | String | True | | No | Name of the opportunity linked to the contract | | ContactId | String | False | | No | Id of the contact linked to the account | | Contact | String | True | | No | Name of the contact linked to the account | | CallId | String | False | | No | Id of the call linked to the contract | | LineItems | String | False | | No | Line items of the contract | | TotalAmt | String | False | | No | | | TotalAmtUsdollar | String | False | | No | | | SubtotalAmount | String | False | | No | | | SubtotalAmountUsdollar | String | False | | No | | | DiscountAmount | String | False | | No | | | DiscountAmountUsdollar | String | False | | No | | | TaxAmount | String | False | | No | | | TaxAmountUsdollar | String | False | | No | | | ShippingAmount | String | False | | No | | | ShippingAmountUsdollar | String | False | | No | | | ShippingTax | String | False | | No | Shipping tax costs | | ShippingTaxAmt | String | False | | No | | | ShippingTaxAmtUsdollar | String | False | | No | | | TotalAmount | String | False | | No | | | TotalAmountUsdollar | String | False | | No | | | Accounts | String | True | | No | The accounts associated with the record | | Contacts | String | True | | No | The contacts associated with the record | | Tasks | String | True | | No | The tasks associated with the record. | | Notes | String | True | | No | The notes associated with the record. | | Meetings | String | True | | No | The meetings associated with the record. | | Calls | String | True | | No | The calls associated with the record | | Emails | String | True | | No | The emails associated with the record | | AosQuotesAosContracts | String | True | | No | | | Documents | String | True | | No | The documents associated with the record. | | AosProductsQuotes | String | True | | No | | | AosLineItemGroups | String | True | | No | | [Return to Top](#objects-supported) ## Documents | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier for the record. | | Name | String | False | | No | The name of the document. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | The full text of the note. | | Deleted | Bool | False | | No | Record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | DocumentName | String | False | | No | The document name. | | DocId | String | False | | No | | | DocType | String | False | | No | | | DocUrl | String | False | | No | | | Filename | String | False | | No | The file name of the document attachment. | | ActiveDate | String | False | | No | | | ExpDate | String | False | | No | | | CategoryId | String | False | | No | | | SubcategoryId | String | False | | No | | | StatusId | String | False | | No | The Id of the document status. | | Status | String | False | | No | The status of the record. | | DocumentRevisionId | String | False | | No | The Id of the document revision. | | Revisions | String | True | | No | | | Revision | String | False | | No | The revision number. | | LastRevCreatedName | String | False | | No | | | LastRevMimeType | String | False | | No | | | LatestRevision | String | False | | No | The latest revision. | | LastRevCreateDate | String | False | | No | | | Contracts | String | True | | No | | | Leads | String | True | | No | The leads associated with the record. | | Accounts | String | True | | No | The accounts associated with the record | | Contacts | String | True | | No | The contacts associated with the record | | Opportunities | String | True | | No | The opportunities associated with the record. | | Cases | String | True | | No | The cases associated with the record. | | Bugs | String | True | | No | The bugs associated with the record. | | RelatedDocId | String | False | | No | | | RelatedDocName | String | True | | No | | | RelatedDocRevId | String | False | | No | | | RelatedDocRevNumber | String | False | | No | | | IsTemplate | Bool | False | | No | | | TemplateType | String | False | | No | | | LatestRevisionName | String | False | | No | | | SelectedRevisionName | String | False | | No | The name of the selected revision. | | ContractStatus | String | False | | No | The document's contract status. | | ContractName | String | False | | No | The name of the document's contract | | LinkedId | String | False | | No | The Id of the linked record. | | SelectedRevisionId | String | False | | No | The Id of the selected revision. | | LatestRevisionId | String | False | | No | The Id of the latest revision. | | SelectedRevisionFilename | String | False | | No | The filename of the selected revision. | | AosContracts | String | True | | No | | [Return to Top](#objects-supported) ## Emails | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------------------------------------------- | | Id [KEY] | String | False | | No | The unique identifier of the email. | | Name | String | False | | No | The subject of the email. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | The description for the email. | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Orphaned | Bool | False | | No | | | LastSynced | Datetime | False | | No | | | FromAddrName | String | False | | No | The from address in the email. | | ReplyToAddr | String | False | | No | The reply-to address in the email. | | ToAddrsNames | String | False | | No | The to addresses in the email. | | CcAddrsNames | String | False | | No | The cc addresses in the email. | | BccAddrsNames | String | False | | No | The bcc addresses in the email. | | ImapKeywords | String | False | | No | | | RawSource | String | False | | No | The raw source for the email. | | DescriptionHtml | String | False | | No | The HTML description for the email. | | DateSentReceived | Datetime | False | | No | | | MessageId | String | False | | No | The Id of the email item obtained from the email transport system. | | Type | String | False | | No | The type of the email (e.g., draft). | | Status | String | False | | No | The status of the record. | | Flagged | Bool | False | | No | The flagged status of the email. | | ReplyToStatus | Bool | False | | No | The reply-to status of the email. If you reply to an email then the reply-to status of original email is set. | | Intent | String | False | | No | The target of the action used in the Inbound Email assignment. | | MailboxId | String | False | | No | | | ParentName | String | True | | No | The name of the parent of this account. | | ParentType | String | False | | No | The type of the Sugar module associated with the email. (Deprecated as of 4.2.) | | ParentId | String | False | | No | The Id of the parent of this account. | | Indicator | String | False | | No | | | Subject | String | False | | No | | | Attachment | String | False | | No | | | Uid | String | False | | No | | | Msgno | String | False | | No | | | Folder | String | False | | No | | | FolderType | String | False | | No | | | InboundEmailRecord | String | False | | No | | | IsImported | String | False | | No | | | HasAttachment | String | False | | No | | | IsOnlyPlainText | Bool | False | | No | | | Accounts | String | True | | No | The accounts associated with the record | | Bugs | String | True | | No | The bugs associated with the record. | | Cases | String | True | | No | The cases associated with the record. | | Contacts | String | True | | No | The contacts associated with the record | | Leads | String | True | | No | The leads associated with the record. | | Opportunities | String | True | | No | The opportunities associated with the record. | | Project | String | True | | No | The project associated with the record. | | Projecttask | String | True | | No | | | Prospects | String | True | | No | | | AosContracts | String | True | | No | | | Tasks | String | True | | No | The tasks associated with the record. | | Users | String | True | | No | | | Notes | String | True | | No | The notes associated with the record. | | Meetings | String | True | | No | The meetings associated with the record. | | CategoryId | String | False | | No | | | EmailsEmailTemplates | String | True | | No | | | EmailsEmailTemplatesName | String | True | | No | | | EmailsEmailTemplatesIdb | String | True | | No | | | OptIn | String | False | | No | | [Return to Top](#objects-supported) ## EmailTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | SecurityGroups | String | True | | No | The security group associated with the record. | | Id [KEY] | String | False | | No | The unique identifier of the email template. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | Published | String | False | | No | The published status of the record. | | Name | String | False | | No | The name of the email template. | | Description | String | False | | No | The description for the email template. | | Subject | String | False | | No | The subject of the resulting email. | | Body | String | False | | No | Plaintext body of the resulting email. | | BodyHtml | String | False | | No | | | Deleted | Bool | False | | No | The record deletion indicator. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | The user name of the user assigned to the record. | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | TextOnly | Bool | False | | No | Whether the email template is to be sent in text only. | | Type | String | False | | No | The type of the email template. | [Return to Top](#objects-supported) ## Events | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the event. | | Name | String | False | | No | Name given to the event | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description given for the event | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | DurationHours | String | False | | No | Number of hours the event lasts | | DurationMinutes | String | False | | No | Number of minutes the event lasts | | DateStart | Datetime | False | | No | | | DateEnd | Datetime | False | | No | | | Link | String | False | | No | | | LinkDeclined | String | False | | No | | | Budget | String | False | | No | Budget set for the event | | CurrencyId | String | False | | No | | | Duration | String | False | | No | Complete duration of the event | | InviteTemplates | String | False | | No | | | AcceptRedirect | String | False | | No | | | DeclineRedirect | String | False | | No | | | FpEventsContacts | String | True | | No | | | FpEventsProspects1 | String | True | | No | | | FpEventsLeads1 | String | True | | No | | | FpEventLocationsFpEvents1 | String | True | | No | | | FpEventLocationsFpEvents1Name | String | True | | No | | | FpEventLocationsFpEvents1fpEventLocationsIda | String | True | | No | | | ActivityStatusType | String | False | | No | | [Return to Top](#objects-supported) ## Invoices | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------- | | Id [KEY] | String | False | | No | The unique identifier of the invoice. | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description provided for the | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | BillingAccountId | String | False | | No | Id of the billing account | | BillingAccount | String | True | | No | | | BillingContactId | String | False | | No | Id of the billing contact | | BillingContact | String | True | | No | | | BillingAddressStreet | String | False | | No | The first line of the billing address. | | BillingAddressCity | String | False | | No | The city used for the billing address. | | BillingAddressState | String | False | | No | The state used for the billing address. | | BillingAddressPostalcode | String | False | | No | The postal code used for the billing address. | | BillingAddressCountry | String | False | | No | The country used for the billing address. | | ShippingAddressStreet | String | False | | No | The first line of the shipping address. | | ShippingAddressCity | String | False | | No | The city used for the shipping address. | | ShippingAddressState | String | False | | No | The state used for the shipping address. | | ShippingAddressPostalcode | String | False | | No | The ZIP code used for the shipping address. | | ShippingAddressCountry | String | False | | No | The country used for the shipping address. | | Number | String | False | | No | | | LineItems | String | False | | No | The invoice's list of line items | | TotalAmt | String | False | | No | | | TotalAmtUsdollar | String | False | | No | | | SubtotalAmount | String | False | | No | | | SubtotalAmountUsdollar | String | False | | No | | | DiscountAmount | String | False | | No | | | DiscountAmountUsdollar | String | False | | No | | | TaxAmount | String | False | | No | | | TaxAmountUsdollar | String | False | | No | | | ShippingAmount | String | False | | No | | | ShippingAmountUsdollar | String | False | | No | | | ShippingTax | String | False | | No | Shipping tax costs | | ShippingTaxAmt | String | False | | No | | | ShippingTaxAmtUsdollar | String | False | | No | | | TotalAmount | String | False | | No | | | TotalAmountUsdollar | String | False | | No | | | CurrencyId | String | False | | No | | | QuoteNumber | String | False | | No | Number of the invoice quote | | QuoteDate | String | False | | No | Date of the invoice quote | | InvoiceDate | String | False | | No | Date the invoice was issued | | DueDate | String | False | | No | Due date of the invoice | | Status | String | False | | No | The status of the record. | | TemplateDdownC | String | False | | No | | | SubtotalTaxAmount | String | False | | No | Subtotal and tax amount in the invoice in the system's default currency | | SubtotalTaxAmountUsdollar | String | False | | No | | | Accounts | String | True | | No | The accounts associated with the record | | Contacts | String | True | | No | The contacts associated with the record | | AosQuotesAosInvoices | String | True | | No | | | AosProductsQuotes | String | True | | No | | | AosLineItemGroups | String | True | | No | | [Return to Top](#objects-supported) ## KBCategories | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | | | Deleted | Bool | False | | No | | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | AokKnowledgebaseCategories | String | True | | No | | [Return to Top](#objects-supported) ## KnowledgeBase | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | | | Deleted | Bool | False | | No | | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Status | String | False | | No | The status of the record. | | Revision | String | False | | No | | | AdditionalInfo | String | False | | No | | | UserIdC | String | False | | No | | | Author | String | True | | No | | | UserId1C | String | False | | No | | | Approver | String | True | | No | | | AokKnowledgebaseCategories | String | True | | No | | [Return to Top](#objects-supported) ## Leads | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------ | -------- | -------- | ---------- | ---------- | -------------------------------------------------------------------- | | Id [KEY] | String | False | | No | The unique identifier of the record. | | Name | String | False | | No | The name of the lead. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | Date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Full text of the note. | | Deleted | Bool | False | | No | Record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Salutation | String | False | | No | The lead salutation (e.g., Mr. or Ms.). | | FirstName | String | False | | No | The first name of the lead. | | LastName | String | False | | No | The last name of the lead. | | FullName | String | False | | No | The full name of the lead. | | Title | String | False | | No | The title of the lead. | | Photo | String | False | | No | The picture for the lead. | | Department | String | False | | No | The department of the lead. | | DoNotCall | Bool | False | | No | An indicator of whether the lead can be called. | | PhoneHome | String | False | | No | | | Email | String | False | | No | | | PhoneMobile | String | False | | No | | | PhoneWork | String | False | | No | | | PhoneOther | String | False | | No | | | PhoneFax | String | False | | No | | | Email1 | String | False | | No | Email address. | | Email2 | String | False | | No | | | InvalidEmail | Bool | False | | No | Whether the email address of the account has been marked as invalid. | | EmailOptOut | Bool | False | | No | Whether the lead has opted out of radio. | | LawfulBasis | String | False | | No | | | DateReviewed | String | False | | No | | | LawfulBasisSource | String | False | | No | | | PrimaryAddressStreet | String | False | | No | The street address used for the primary address. | | PrimaryAddressStreet2 | String | False | | No | The second line of the primary address. | | PrimaryAddressStreet3 | String | False | | No | The third line of the primary addrss. | | PrimaryAddressCity | String | False | | No | The city for the primary address. | | PrimaryAddressState | String | False | | No | The state for the primary address. | | PrimaryAddressPostalcode | String | False | | No | The postal code for the primary address. | | PrimaryAddressCountry | String | False | | No | The country for the primary address. | | AltAddressStreet | String | False | | No | The street address for the alternate address. | | AltAddressStreet2 | String | False | | No | The second line of the alternate address. | | AltAddressStreet3 | String | False | | No | The third line of the alternate address. | | AltAddressCity | String | False | | No | The city for the alternate address. | | AltAddressState | String | False | | No | The state for the alternate address. | | AltAddressPostalcode | String | False | | No | The postal code for the alternate address. | | AltAddressCountry | String | False | | No | The country for the alternate address. | | Assistant | String | False | | No | The name of the assistant of the lead. | | AssistantPhone | String | False | | No | The phone number of the assistant of the lead. | | EmailAddressesPrimary | String | True | | No | Primary email address. | | EmailAddresses | String | True | | No | Alternate Email address. | | EmailAddressesNonPrimary | String | False | | No | Non primary email address. | | Converted | Bool | False | | No | Whether the lead has been converted. | | ReferedBy | String | False | | No | | | LeadSource | String | False | | No | How the lead came to be known. | | LeadSourceDescription | String | False | | No | Description of the lead source. | | Status | String | False | | No | The status of the record. | | StatusDescription | String | False | | No | A description for the status | | ReportsToId | String | False | | No | The name the updates for the lead will be reported to | | ReportToName | String | False | | No | | | ReportsToLink | String | True | | No | | | Reportees | String | True | | No | | | Contacts | String | True | | No | The contacts associated with the record | | AccountName | String | False | | No | The name of the associated acocunt. | | Accounts | String | True | | No | The accounts associated with the record | | AccountDescription | String | False | | No | Description for the lead's account | | ContactId | String | False | | No | Main contact for the lead | | Contact | String | True | | No | | | AccountId | String | False | | No | Account the lead is linked to | | OpportunityId | String | False | | No | The Opportunity the lead was generated from | | Opportunity | String | True | | No | | | OpportunityName | String | False | | No | The name of the opportunity the lead was generated from | | OpportunityAmount | String | False | | No | The amount the opportunity yields | | CampaignId | String | False | | No | The Id of the campaign associated with the record. | | CampaignName | String | True | | No | The name of the campaign associated with the record. | | CampaignLeads | String | True | | No | | | CAcceptStatusFields | String | True | | No | | | MAcceptStatusFields | String | True | | No | | | AcceptStatusId | String | False | | No | The Id of the accept status. | | AcceptStatusName | String | False | | No | The name of the accept status. | | WebtoleadEmail1 | String | False | | No | | | WebtoleadEmail2 | String | False | | No | | | WebtoleadEmailOptOut | Bool | False | | No | | | WebtoleadInvalidEmail | Bool | False | | No | | | Birthdate | String | False | | No | The birthdate of the lead. | | PortalName | String | False | | No | The Joomla portal name of the lead | | PortalApp | String | False | | No | | | Website | String | False | | No | The lead's website | | Tasks | String | True | | No | The tasks associated with the record. | | Notes | String | True | | No | The notes associated with the record. | | Meetings | String | True | | No | The meetings associated with the record. | | Calls | String | True | | No | The calls associated with the record | | Oldmeetings | String | True | | No | | | Oldcalls | String | True | | No | | | Emails | String | True | | No | The emails associated with the record | | Campaigns | String | True | | No | The campaigns associated with the account. | | ProspectLists | String | True | | No | | | FpEventsLeads1 | String | True | | No | | | EInviteStatusFields | String | True | | No | | | EventStatusName | String | False | | No | | | EventInviteId | String | False | | No | | | EAcceptStatusFields | String | True | | No | | | EventAcceptStatus | String | False | | No | | | EventStatusId | String | False | | No | Id of the lead's event status. | [Return to Top](#objects-supported) ## Locations | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the location. | | Name | String | False | | No | Name assigned to the location | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the location | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | FpEventLocationsFpEvents1 | String | True | | No | | | Address | String | False | | No | Street address of the location | | AddressCity | String | False | | No | | | AddressCountry | String | False | | No | | | AddressPostalcode | String | False | | No | | | AddressState | String | False | | No | | | Capacity | String | False | | No | Capacity estimated for the location | [Return to Top](#objects-supported) ## Maps | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the map. | | Name | String | False | | No | Name assigned to the map | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the map | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Distance | Double | False | | No | | | UnitType | String | False | | No | Length unit expressing the radius | | ModuleType | String | False | | No | | | ParentName | String | True | | No | The name of the parent of this account. | | ParentType | String | False | | No | Type of the map's parent | | ParentId | String | False | | No | The Id of the parent of this account. | | Accounts | String | True | | No | The accounts associated with the record | | Contacts | String | True | | No | The contacts associated with the record | | Leads | String | True | | No | The leads associated with the record. | | Opportunities | String | True | | No | The opportunities associated with the record. | | Cases | String | True | | No | The cases associated with the record. | | Projects | String | True | | No | | | Meetings | String | True | | No | The meetings associated with the record. | | Prospects | String | True | | No | | [Return to Top](#objects-supported) ## MapsAddressCache | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the address cache. | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the cached address | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | Lat | Double | False | | No | | | Lng | Double | False | | No | | [Return to Top](#objects-supported) ## MapsAreas | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the map area. | | Name | String | False | | No | Name assigned to the line items group | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the map area | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | City | String | False | | No | City of the map area | | State | String | False | | No | State of the location | | Country | String | False | | No | Country of the map area | | Coordinates | String | False | | No | Geographical coordinates of the map area | | JjwgMapsJjwgAreas | String | True | | No | | [Return to Top](#objects-supported) ## MapsMarkers | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the map marker. | | Name | String | False | | No | Name assigned to the map marker | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the map marker | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | City | String | False | | No | City of the map marker | | State | String | False | | No | State of the map marker | | Country | String | False | | No | Country of the map marker | | JjwgMapsLat | Double | False | | No | | | JjwgMapsLng | Double | False | | No | | | MarkerImage | String | False | | No | | | JjwgMapsJjwgMarkers | String | True | | No | | [Return to Top](#objects-supported) ## Meetings | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier for the meeting. | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Full text of the note. | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | AcceptStatus | String | False | | No | | | SetAcceptLinks | String | False | | No | | | Location | String | False | | No | The location of the meeting. | | Password | String | False | | No | | | JoinUrl | String | False | | No | | | HostUrl | String | False | | No | The host URL. | | DisplayedUrl | String | False | | No | | | Creator | String | False | | No | | | ExternalId | String | False | | No | | | DurationHours | String | False | | No | The duration (hours). | | DurationMinutes | String | False | | No | The duration (minutes). | | DateStart | Datetime | False | | No | | | DateEnd | Datetime | False | | No | | | ParentType | String | False | | No | Module the meeting is associated with. | | Status | String | False | | No | The status of the record. | | Type | String | False | | No | Meeting type (e.g., WebEx, or Other). | | Direction | String | False | | No | Whether the meeting is inbound or outbound. | | ParentId | String | False | | No | The Id of the parent of this account. | | ReminderChecked | Bool | False | | No | Whether or not the reminder value is set. | | ReminderTime | String | False | | No | Specifies when a reminder alert should be issued: -1 means no alert; otherwise the number of seconds prior to the start. | | EmailReminderChecked | Bool | False | | No | | | EmailReminderTime | String | False | | No | Specifies when a email reminder alert should be issued: -1 means no alert; otherwise the number of seconds prior to the start. | | EmailReminderSent | Bool | False | | No | Whether the email reminder is already sent. | | Reminders | String | False | | No | List of reminders set for the meetings | | OutlookId | String | False | | No | When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id. | | Sequence | String | False | | No | | | ContactName | String | False | | No | | | Contacts | String | True | | No | The contacts associated with the record | | ParentName | String | True | | No | The name of the parent of this account. | | Users | String | True | | No | | | Accounts | String | True | | No | The accounts associated with the record | | Leads | String | True | | No | The leads associated with the record. | | Opportunity | String | True | | No | | | Case | String | True | | No | | | AosContracts | String | True | | No | | | Notes | String | True | | No | The notes associated with the record. | | ContactId | String | False | | No | The Id of the associated contact. | | RepeatType | String | False | | No | Type of a recurring meeting. | | RepeatInterval | String | False | | No | The interval of a recurring meeting. | | RepeatDow | String | False | | No | The day of week of a meeting. | | RepeatUntil | String | False | | No | Repeat until the specified date. | | RepeatCount | String | False | | No | Number of recurrences. | | RepeatParentId | String | False | | No | Id of the first element of recurring records. | | RecurringSource | String | False | | No | Source of recurring meeting. | | Duration | String | False | | No | Duration handler dropdown. | | GsyncId | String | False | | No | | | GsyncLastsync | String | False | | No | | | JjwgMapsLatC | Double | False | | No | | | JjwgMapsLngC | Double | False | | No | | | JjwgMapsGeocodeStatusC | String | False | | No | | | JjwgMapsAddressC | String | False | | No | | [Return to Top](#objects-supported) ## Notes | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Id [KEY] | String | False | | No | Unique identifier of the record. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Name | String | False | | No | | | FileMimeType | String | False | | No | | | FileUrl | String | False | | No | | | Filename | String | False | | No | | | ParentType | String | False | | No | Sugar module the Note is associated with. | | ParentId | String | False | | No | The Id of the parent of this account. | | ContactId | String | False | | No | The Id of the contact the note is associated with. | | PortalFlag | Bool | False | | No | | | EmbedFlag | Bool | False | | No | | | Description | String | False | | No | | | Deleted | Bool | False | | No | The record deletion indicator. | | ParentName | String | True | | No | The name of the parent of this account. | | ContactName | String | True | | No | | | ContactPhone | String | False | | No | | | ContactEmail | String | False | | No | | | AccountId | String | False | | No | The Id of the account associated with the note. | | OpportunityId | String | False | | No | The Id of the opportunity associated with the note. | | AcaseId | String | False | | No | | | LeadId | String | False | | No | The Id of the lead associated with the note. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | Contact | String | True | | No | The name of the contact associated with the note. | | Cases | String | True | | No | The cases associated with the record. | | Accounts | String | True | | No | The accounts associated with the record | | Opportunities | String | True | | No | The opportunities associated with the record. | | Leads | String | True | | No | The leads associated with the record. | | Bugs | String | True | | No | The bugs associated with the record. | | AosContracts | String | True | | No | | | Emails | String | True | | No | The emails associated with the record | | Projects | String | True | | No | | | ProjectTasks | String | True | | No | | | Meetings | String | True | | No | The meetings associated with the record. | | Calls | String | True | | No | The calls associated with the record | | Tasks | String | True | | No | The tasks associated with the record. | [Return to Top](#objects-supported) ## Opportunities | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the opportunity. | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Full text of the note. | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | OpportunityType | String | False | | No | | | AccountName | String | False | | No | The name of the associated account. | | AccountId | String | False | | No | The Id of the associated account. | | CampaignId | String | False | | No | The Id of the campaign associated with the record. | | CampaignName | String | True | | No | The name of the campaign associated with the record. | | CampaignOpportunities | String | True | | No | | | LeadSource | String | False | | No | Source of the opportunity. | | Amount | String | False | | No | Formatted amount of the opportunity. | | AmountUsdollar | String | False | | No | | | CurrencyId | String | False | | No | | | CurrencyName | String | True | | No | The name of the currency used for display purposes. | | CurrencySymbol | String | True | | No | The symbol of the currency used for display purposes. | | DateClosed | String | False | | No | | | NextStep | String | False | | No | The next step in the sales process. | | SalesStage | String | False | | No | Indication of progression towards closure. | | Probability | String | False | | No | | | Accounts | String | True | | No | The accounts associated with the record | | Contacts | String | True | | No | The contacts associated with the record | | Tasks | String | True | | No | The tasks associated with the record. | | Notes | String | True | | No | The notes associated with the record. | | Meetings | String | True | | No | The meetings associated with the record. | | Calls | String | True | | No | The calls associated with the record | | Emails | String | True | | No | The emails associated with the record | | Documents | String | True | | No | The documents associated with the record. | | Project | String | True | | No | The project associated with the record. | | Leads | String | True | | No | The leads associated with the record. | | Campaigns | String | True | | No | The campaigns associated with the account. | | CampaignLink | String | True | | No | | | Currencies | String | True | | No | | | AosQuotes | String | True | | No | | | AosContracts | String | True | | No | | | JjwgMapsLatC | Double | False | | No | | | JjwgMapsLngC | Double | False | | No | | | JjwgMapsGeocodeStatusC | String | False | | No | | | JjwgMapsAddressC | String | False | | No | | [Return to Top](#objects-supported) ## PDFTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier for the pdf template. | | Name | String | False | | No | The template's name. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | Date when the template was modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | | | Deleted | Bool | False | | No | Whether the template was deleted. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The unique identifier of the assignee. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Active | Bool | False | | No | Whether or not the template is active. | | Type | String | False | | No | The type of the template. | | Sample | String | False | | No | | | InsertFields | String | False | | No | The fields that can be inserted. | | Pdfheader | String | False | | No | | | Pdffooter | String | False | | No | | | MarginLeft | String | False | | No | Value of the left margin for the template. | | MarginRight | String | False | | No | Value of the right margin for the template. | | MarginTop | String | False | | No | Value of the top margin for the template. | | MarginBottom | String | False | | No | Value of the bottom margin for the template. | | MarginHeader | String | False | | No | Value of the margin for the template's header. | | MarginFooter | String | False | | No | Value of the margin for the template's footer. | | PageSize | String | False | | No | The size of the template. | | Orientation | String | False | | No | Orientation of the template. | [Return to Top](#objects-supported) ## Products | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the ACL Action. | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | The action description. | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | AosProductsPurchases | String | True | | No | | | Maincode | String | False | | No | | | PartNumber | String | False | | No | Part number of the product. | | Category | String | False | | No | Name of the product's category. | | Type | String | False | | No | Type of the product. | | Cost | String | False | | No | Cost of the product. | | CostUsdollar | String | False | | No | | | CurrencyId | String | False | | No | | | Price | String | False | | No | Price of the product. | | PriceUsdollar | String | False | | No | | | Url | String | False | | No | Url where the product can be seen. | | ContactId | String | False | | No | Product's point of contact id. | | Contact | String | True | | No | Product's point of contact name. | | ProductImage | String | False | | No | Image uploaded for the product. | | FileUrl | String | False | | No | | | AosProductCategory | String | True | | No | | | AosProductCategoryName | String | True | | No | | | AosProductCategoryId | String | False | | No | | [Return to Top](#objects-supported) ## ProductsCategories | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the inbound. | | Name | String | False | | No | Name assigned to the category | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the category | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | IsParent | Bool | False | | No | | | AosProducts | String | True | | No | | | SubCategories | String | True | | No | | | ParentCategory | String | True | | No | Name of the parent category | | ParentCategoryName | String | True | | No | | | ParentCategoryId | String | False | | No | Id of the category's parent category | [Return to Top](#objects-supported) ## Projects | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | SecurityGroups | String | True | | No | The security group associated with the record. | | Id [KEY] | String | False | | No | The unique identifier of the project. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | AssignedUserId | String | False | | No | | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Name | String | False | | No | Project name. | | Description | String | False | | No | Project description. | | Deleted | Bool | False | | No | The record deletion indicator. | | EstimatedStartDate | String | False | | No | | | EstimatedEndDate | String | False | | No | | | Status | String | False | | No | The status of the record. | | Priority | String | False | | No | The priority of the record. | | TotalEstimatedEffort | String | False | | No | | | TotalActualEffort | String | False | | No | | | Accounts | String | True | | No | The accounts associated with the record | | Quotes | String | True | | No | | | Contacts | String | True | | No | The contacts associated with the record | | Opportunities | String | True | | No | The opportunities associated with the record. | | Notes | String | True | | No | The notes associated with the record. | | Tasks | String | True | | No | The tasks associated with the record. | | Meetings | String | True | | No | The meetings associated with the record. | | Calls | String | True | | No | The calls associated with the record | | Emails | String | True | | No | The emails associated with the record | | Projecttask | String | True | | No | | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | AssignedUserName | String | False | | No | | | Cases | String | True | | No | The cases associated with the record. | | Bugs | String | True | | No | The bugs associated with the record. | | Products | String | True | | No | | | ProjectUsers1 | String | True | | No | | | AmProjecttemplatesProject1 | String | True | | No | | | AmProjecttemplatesProject1Name | String | True | | No | | | AmProjecttemplatesProject1amProjecttemplatesIda | String | True | | No | | | ProjectContacts1 | String | True | | No | | | AosQuotesProject | String | True | | No | | | OverrideBusinessHours | Bool | False | | No | | | JjwgMapsLatC | Double | False | | No | | | JjwgMapsLngC | Double | False | | No | | | JjwgMapsGeocodeStatusC | String | False | | No | | | JjwgMapsAddressC | String | False | | No | | [Return to Top](#objects-supported) ## ProjectsTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the project template. | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user the template has been assigned to. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | Status | String | False | | No | The status of the record. | | Priority | String | False | | No | The priority of the record. | | AmProjecttemplatesProject1 | String | True | | No | | | AmTasktemplatesAmProjecttemplates | String | True | | No | | | AmProjecttemplatesUsers1 | String | True | | No | | | AmProjecttemplatesContacts1 | String | True | | No | | | OverrideBusinessHours | Bool | False | | No | | [Return to Top](#objects-supported) ## Quotes | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------- | | Id [KEY] | String | False | | No | null | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the quote | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | null | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | ApprovalIssue | String | False | | No | | | BillingAccountId | String | False | | No | Id of the billing account | | BillingAccount | String | True | | No | | | BillingContactId | String | False | | No | Id of the billing contact | | BillingContact | String | True | | No | | | BillingAddressStreet | String | False | | No | The first line of the billing address. | | BillingAddressCity | String | False | | No | The city used for the billing address. | | BillingAddressState | String | False | | No | The state used for the billing address. | | BillingAddressPostalcode | String | False | | No | The postal code used for the billing address. | | BillingAddressCountry | String | False | | No | The country used for the billing address. | | ShippingAddressStreet | String | False | | No | The first line of the shipping address. | | ShippingAddressCity | String | False | | No | The city used for the shipping address. | | ShippingAddressState | String | False | | No | The state used for the shipping address. | | ShippingAddressPostalcode | String | False | | No | The ZIP code used for the shipping address. | | ShippingAddressCountry | String | False | | No | The country used for the shipping address. | | Expiration | String | False | | No | | | Number | String | False | | No | | | OpportunityId | String | False | | No | Opportunity Id of the quote | | Opportunity | String | True | | No | Opportunity name of the quote | | TemplateDdownC | String | False | | No | | | LineItems | String | False | | No | The list of the quote's line items | | TotalAmt | String | False | | No | | | TotalAmtUsdollar | String | False | | No | | | SubtotalAmount | String | False | | No | | | SubtotalAmountUsdollar | String | False | | No | | | DiscountAmount | String | False | | No | | | DiscountAmountUsdollar | String | False | | No | | | TaxAmount | String | False | | No | | | TaxAmountUsdollar | String | False | | No | | | ShippingAmount | String | False | | No | | | ShippingAmountUsdollar | String | False | | No | | | ShippingTax | String | False | | No | The quote's shipping tax costs | | ShippingTaxAmt | String | False | | No | | | ShippingTaxAmtUsdollar | String | False | | No | | | TotalAmount | String | False | | No | | | TotalAmountUsdollar | String | False | | No | | | CurrencyId | String | False | | No | | | Stage | String | False | | No | | | Term | String | False | | No | | | TermsC | String | False | | No | | | ApprovalStatus | String | False | | No | null | | InvoiceStatus | String | False | | No | Quote's invoice status | | SubtotalTaxAmount | String | False | | No | The quotes's subtotal and tax amount in the system's default currency | | SubtotalTaxAmountUsdollar | String | False | | No | | | Accounts | String | True | | No | The accounts associated with the record | | Contacts | String | True | | No | The contacts associated with the record | | Opportunities | String | True | | No | The opportunities associated with the record. | | AosQuotesProject | String | True | | No | | | AosQuotesAosInvoices | String | True | | No | | | AosQuotesAosContracts | String | True | | No | | | AosProductsQuotes | String | True | | No | | | AosLineItemGroups | String | True | | No | | [Return to Top](#objects-supported) ## Reports | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the report. | | Name | String | False | | No | Name assigned to the report | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the report | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | ReportModule | String | False | | No | The module the report has targeted | | GraphsPerRow | String | False | | No | | | FieldLines | String | False | | No | | | ConditionLines | String | False | | No | | | AorFields | String | True | | No | | | AorConditions | String | True | | No | | | AorCharts | String | True | | No | | | AorScheduledReports | String | True | | No | | [Return to Top](#objects-supported) ## Spots | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the record. | | Name | String | False | | No | The name of the spot. | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Full text of the note. | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Config | String | False | | No | The the configuration set of the spot. | | Type | String | False | | No | The field this spot is targeting. | | ConfigurationGUI | String | False | | No | | [Return to Top](#objects-supported) ## Surveys | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | | | Deleted | Bool | False | | No | | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Status | String | False | | No | The status of the record. | | SurveyQuestionsDisplay | String | False | | No | | | SurveyUrlDisplay | String | False | | No | | | SubmitText | String | False | | No | | | SatisfiedText | String | False | | No | | | NeitherText | String | False | | No | | | DissatisfiedText | String | False | | No | | | SurveysSurveyquestions | String | True | | No | | | SurveysSurveyresponses | String | True | | No | | [Return to Top](#objects-supported) ## Tasks | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | -------------------------------------------------------- | | Id [KEY] | String | False | | No | The unique identifier of the record. | | Name | String | False | | No | | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | The full text of the note. | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | Status | String | False | | No | The status of the record. | | DateDueFlag | Bool | False | | No | | | DateDue | Datetime | False | | No | | | TimeDue | Datetime | False | | No | | | DateStartFlag | Bool | False | | No | | | DateStart | Datetime | False | | No | | | ParentType | String | False | | No | The type of the Sugar item to which the call is related. | | ParentName | String | True | | No | The name of the parent of this account. | | ParentId | String | False | | No | The Id of the parent of this account. | | ContactId | String | False | | No | The Id of the associated contact. | | ContactName | String | True | | No | The name of the associated contact. | | ContactPhone | String | False | | No | The phone of the associated contact. | | ContactEmail | String | False | | No | | | Priority | String | False | | No | The priority of the record. | | Contacts | String | True | | No | The contacts associated with the record | | Accounts | String | True | | No | The accounts associated with the record | | Opportunities | String | True | | No | The opportunities associated with the record. | | Cases | String | True | | No | The cases associated with the record. | | Bugs | String | True | | No | The bugs associated with the record. | | Leads | String | True | | No | The leads associated with the record. | | Projects | String | True | | No | | | ProjectTasks | String | True | | No | | | AosContracts | String | True | | No | | | Notes | String | True | | No | The notes associated with the record. | | ContactParent | String | True | | No | | [Return to Top](#objects-supported) ## WorkFlow | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------ | | Id [KEY] | String | False | | No | The unique identifier of the inbound. | | Name | String | False | | No | Name assigned to the workflow | | DateEntered | Datetime | False | | No | The date the record was created. | | DateModified | Datetime | False | | No | The date the record was last modified. | | ModifiedUserId | String | False | | No | The Id of the user who last modified the record. | | ModifiedByName | String | True | | No | The name of the user who last modified the record. | | CreatedBy | String | False | | No | The Id of the user who created the record. | | CreatedByName | String | True | | No | The name of the user who created the record. | | Description | String | False | | No | Description for the worflow | | Deleted | Bool | False | | No | The record deletion indicator. | | CreatedByLink | String | True | | No | Link to the record who created it | | ModifiedUserLink | String | True | | No | Link to the record who modified it. | | AssignedUserId | String | False | | No | The Id of the user assigned to the record. | | AssignedUserName | String | True | | No | | | AssignedUserLink | String | True | | No | Link to the user which the record has been assigned to | | SecurityGroups | String | True | | No | The security group associated with the record. | | FlowModule | String | False | | No | | | FlowRunOn | String | False | | No | | | Status | String | False | | No | The status of the record. | | RunWhen | String | False | | No | | | MultipleRuns | Bool | False | | No | | | ConditionLines | String | False | | No | | | ActionLines | String | False | | No | | | AowConditions | String | True | | No | | | AowActions | String | True | | No | | | AowProcessed | String | True | | No | | [Return to Top](#objects-supported)