--- schema_version: "1" id: d234a4253bd3898076ec92b22e36ec9b69072b0b71c90bb9058d8c1ae696db5b title: SugarCRM Connector Objects collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/sugarcrm/c360-a-sugarcrm-objects.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-sugarcrm-objects.html source_site: developer.salesforce.com content_type: documentation content_hash: fa1ccba4639768b7be7314a3f0b6c99154fa990c18ce8923a5cf8cef6b997469 products: - Data 360 Integration Guide - Data 360 Developer Documentation --- # SugarCRM Connector Objects **note:** This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at [Agreements and Terms.](https://www.salesforce.com/company/legal/agreements/) If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at [datacloud-connectors-beta@salesforce.com.](mailto:datacloud-connectors-beta@salesforce.com) ## Objects Supported | Name | Description | | ------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------- | | [Accounts](#accounts) | The Accounts table. | | [ACLRoles](#aclroles) | The ACLRoles table. | | [Activities](#activities) | The Activities view. | | [ArchiveRuns](#archiveruns) | The ArchiveRuns table. | | [Audit](#audit) | The Audit view. | | [Bugs](#bugs) | The Bugs table. | | [BusinessCenters](#businesscenters) | The BusinessCenters table. | | [Calendar](#calendar) | The Calendar table. | | [Calls](#calls) | The Calls table. | | [CampaignLog](#campaignlog) | The CampaignLog table. | | [Campaigns](#campaigns) | The Campaigns table. | | [CampaignTrackers](#campaigntrackers) | The CampaignTrackers table. | | [Cases](#cases) | The Cases table. | | [Categories](#categories) | The Categories table. | | [ChangeTimers](#changetimers) | The ChangeTimers table. | | [CJForms](#cjforms) | The CJ_Forms table. | | [CJWebHooks](#cjwebhooks) | The CJ_WebHooks table. | | [CloudDrivePaths](#clouddrivepaths) | The CloudDrivePaths table. | | [CommentLog](#commentlog) | The CommentLog table. | | [Comments](#comments) | The Comments table. | | [ConsoleConfiguration](#consoleconfiguration) | The ConsoleConfiguration table. | | [Contacts](#contacts) | The Contacts table. | | [Contracts](#contracts) | The Contracts table. | | [ContractTypes](#contracttypes) | The ContractTypes table. | | [Currencies](#currencies) | The Currencies table. | | [CustomQueries](#customqueries) | The CustomQueries table. | | [Dashboards](#dashboards) | The Dashboards table. | | [DataArchiver](#dataarchiver) | The DataArchiver table. | | [DataPrivacy](#dataprivacy) | The DataPrivacy table. | | [DataSets](#datasets) | The DataSets table. | | [DocumentMerges](#documentmerges) | The DocumentMerges table. | | [DocumentRevisions](#documentrevisions) | The DocumentRevisions table. | | [Documents](#documents) | The Documents table. | | [DocumentTemplates](#documenttemplates) | The DocumentTemplates table. | | [DocuSignEnvelopes](#docusignenvelopes) | The DocuSignEnvelopes table. | | [DRISubWorkflows](#drisubworkflows) | The DRI_SubWorkflows table. | | [DRISubWorkflowTemplates](#drisubworkflowtemplates) | The DRI_SubWorkflow_Templates table. | | [DRIWorkflows](#driworkflows) | The DRI_Workflows table. | | [DRIWorkflowTaskTemplates](#driworkflowtasktemplates) | The DRI_Workflow_Task_Templates table. | | [DRIWorkflowTemplates](#driworkflowtemplates) | The DRI_Workflow_Templates table. | | [DropDownValues](#dropdownvalues) | The DropDownValues View. This view provides information regarding the values of dropdowns from different fields and modules. | | [EAPM](#eapm) | The EAPM table. | | [EmailAddresses](#emailaddresses) | The EmailAddresses table. | | [EmailMarketing](#emailmarketing) | The EmailMarketing table. | | [EmailParticipants](#emailparticipants) | The EmailParticipants table. | | [Emails](#emails) | The Emails table. | | [EmailTemplates](#emailtemplates) | The EmailTemplates table. | | [EmbeddedFiles](#embeddedfiles) | The EmbeddedFiles table. | | [Employees](#employees) | The Employees table. | | [Escalations](#escalations) | The Escalations table. | | [ExternalUsers](#externalusers) | The ExternalUsers table. | | [Filters](#filters) | The Filters table. | | [ForecastManagerWorksheets](#forecastmanagerworksheets) | The ForecastManagerWorksheets table. | | [Forecasts](#forecasts) | The Forecasts table. | | [ForecastWorksheets](#forecastworksheets) | The ForecastWorksheets table. | | [Geocode](#geocode) | The Geocode table. | | [HintAccountsets](#hintaccountsets) | The HintAccountsets table. | | [HintEnrichFieldConfigs](#hintenrichfieldconfigs) | The HintEnrichFieldConfigs table. | | [HintNewsNotifications](#hintnewsnotifications) | The HintNewsNotifications table. | | [HintNotificationTargets](#hintnotificationtargets) | The HintNotificationTargets table. | | [Holidays](#holidays) | The Holidays table. | | [InboundEmail](#inboundemail) | The InboundEmail table. | | [KBArticles](#kbarticles) | The KBArticles table. | | [KBContents](#kbcontents) | The KBContents table. | | [KBContentTemplates](#kbcontenttemplates) | The KBContentTemplates table. | | [KBDocuments](#kbdocuments) | The KBDocuments table. | | [Leads](#leads) | The Leads table. | | [Manufacturers](#manufacturers) | The Manufacturers table. | | [Meetings](#meetings) | The Meetings table. | | [Messages](#messages) | The Messages table. | | [Metrics](#metrics) | The Metrics table. | | [MobileDevices](#mobiledevices) | The MobileDevices table. | | [Notes](#notes) | The Notes table. | | [Notifications](#notifications) | The Notifications table. | | [OAuthKeys](#oauthkeys) | The OAuthKeys table. | | [OAuthTokens](#oauthtokens) | The OAuthTokens table. | | [Opportunities](#opportunities) | The Opportunities table. | | [OutboundEmail](#outboundemail) | The OutboundEmail table. | | [PdfManager](#pdfmanager) | The PdfManager table. | | [pmseBusinessRules](#pmsebusinessrules) | The pmse_Business_Rules table. | | [pmseEmailsTemplates](#pmseemailstemplates) | The pmse_Emails_Templates table. | | [pmseInbox](#pmseinbox) | The pmse_Inbox table. | | [pmseProject](#pmseproject) | The pmse_Project table. | | [ProductBundleNotes](#productbundlenotes) | The ProductBundleNotes table. | | [ProductBundles](#productbundles) | The ProductBundles table. | | [ProductCategories](#productcategories) | The ProductCategories table. | | [Products](#products) | The Products table. | | [ProductTemplates](#producttemplates) | The ProductTemplates table. | | [ProductTypes](#producttypes) | The ProductTypes table. | | [Project](#project) | The Project table. | | [ProjectTask](#projecttask) | The ProjectTask table. | | [ProspectLists](#prospectlists) | The ProspectLists table. | | [PubSubModuleEventPushSubs](#pubsubmoduleeventpushsubs) | The PubSub_ModuleEvent_PushSubs table. | | [PurchasedLineItems](#purchasedlineitems) | The PurchasedLineItems table. | | [Purchases](#purchases) | The Purchases table. | | [PushNotifications](#pushnotifications) | The PushNotifications table. | | [Quotas](#quotas) | The Quotas table. | | [Quotes](#quotes) | The Quotes table. | | [Relationships](#relationships) | The Relationships View. This view provides information regarding different relationships between tables. | | [Releases](#releases) | The Releases table. | | [ReportMaker](#reportmaker) | The ReportMaker table. | | [Reports](#reports) | The Reports table. | | [ReportSchedules](#reportschedules) | The ReportSchedules table. | | [RevenueLineItems](#revenuelineitems) | The RevenueLineItems table. | | [SavedSearch](#savedsearch) | The SavedSearch table. | | [Schedulers](#schedulers) | The Schedulers table. | | [ShiftExceptions](#shiftexceptions) | The ShiftExceptions table. | | [Shifts](#shifts) | The Shifts table. | | [Shippers](#shippers) | The Shippers table. | | [Styleguide](#styleguide) | The Styleguide table. | | [Subscriptions](#subscriptions) | The Subscriptions table. | | [SugarFavorites](#sugarfavorites) | The SugarFavorites table. | | [SugarLive](#sugarlive) | The SugarLive table. | | [Tags](#tags) | The Tags table. | | [Tasks](#tasks) | The Tasks table. | | [TaxRates](#taxrates) | The TaxRates table. | | [TeamNotices](#teamnotices) | The TeamNotices table. | | [Teams](#teams) | The Teams table. | | [TimePeriods](#timeperiods) | The TimePeriods table. | | [TrackerPerfs](#trackerperfs) | The TrackerPerfs table. | | [TrackerQueries](#trackerqueries) | The TrackerQueries table. | | [Trackers](#trackers) | The Trackers table. | | [TrackerSessions](#trackersessions) | The TrackerSessions table. | | [Users](#users) | The Users table. | | [UserSignatures](#usersignatures) | The UserSignatures table. | | [VisualPipeline](#visualpipeline) | The VisualPipeline table. | | [WebLogicHooks](#weblogichooks) | The WebLogicHooks table. | | [WorkFlow](#workflow) | The WorkFlow table. | ## Accounts | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------------------- | -------- | -------- | ---------- | ---------- | ---------------------------------------------------------------------------------- | | Account_Type | String | False | | No | The Company is of this type | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Affiliated_Business_Or_Jv_C | Bool | False | | No | | | Affiliationothername_C | String | False | | No | | | Agentstarthistorydate_C | Date | False | | No | | | Agenttrax_User_C | Bool | False | | No | | | Agenttrax_User_Notes_C | String | False | | No | | | Agenttraxaccounttype_C | String | False | | No | | | Agenttraxaccttype_C | String | False | | No | | | Annual_Revenue | String | False | | No | Annual revenue for this company | | Area_C | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | Decimal | False | | No | | | Billing_Address_City | String | False | | No | The city used for billing address | | Billing_Address_Country | String | False | | No | The country used for the billing address | | Billing_Address_Postalcode | String | False | | No | The postal code used for billing address | | Billing_Address_State | String | False | | No | The state used for billing address | | Billing_Address_Street | String | False | | No | The street address used for billing address | | Business_Center_Id | String | False | | No | The business center to which the case is associated | | Business_Center_Name | String | True | | No | The name of the business center represented by the business_center_id field | | Campaign_Id | String | False | | No | Campaign that generated Account | | Campaign_Name | String | True | | No | The first campaign name for Account (Meta-data only) | | Cancellation_Date_C | Date | False | | No | | | Claimsratioytdloc_C | Decimal | False | | No | | | Commentlog | String | True | | No | | | Commission_C | Decimal | False | | No | | | Contact_To_Discuss_Audits_C | String | False | | No | | | Contact_To_Discuss_Claims_C | String | False | | No | | | Contact_To_Discuss_General_C | String | False | | No | | | Contact_To_Discuss_Premiums_C | String | False | | No | | | Contact_To_Discuss_Reporting_C | String | False | | No | | | Cplspriorytdloc_C | Int | False | | No | | | Cplsytdloc_C | Int | False | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Credit_Reports_Agent_Permiss_C | Bool | False | | No | | | Credit_Reports_Last_Run_Off_C | Date | False | | No | | | Currency_Id | String | False | | No | | | Currytdnetloc_C | Decimal | False | | No | | | Cyber_Insurance_Coverage_C | Bool | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Dba_C | String | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Doctype_C | String | False | | No | | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | True | | No | | | Duns_Num | String | False | | No | DUNS number of the account | | Ec_Purchasing_User_C | Bool | False | | No | | | Email | String | False | | No | | | Email_Addresses_Non_Primary | String | False | | No | | | Email_Opt_Out | Bool | False | | No | | | Email1 | String | False | | No | | | Email2 | String | False | | No | | | Employees | String | False | | No | Number of employees, varchar to accomodate for both number (100) or range (50-100) | | Epay_User_C | Bool | False | | No | | | Est_Total_Prem_Gen_At_Office_C | Decimal | False | | No | | | Estatement_User_C | Bool | False | | No | | | Estimated_Fntg_Wallet_Share_C | String | False | | No | | | Facebook | String | False | | No | The facebook name of the company | | Fidelity_Pak_User_C | Bool | False | | No | | | Fnf_Agencies_Accounts_1_Name | String | True | | No | | | Fnf_Agencies_Accounts_1fnf_Agencies_Ida | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Googleplus | String | False | | No | The Google Plus name of the company | | Hint_Account_Facebook_Handle | String | False | | No | company facebook | | Hint_Account_Fiscal_Year_End | String | False | | No | FY End | | Hint_Account_Founded_Year | String | False | | No | company founded year | | Hint_Account_Industry | String | False | | No | Company Industry | | Hint_Account_Industry_Tags | String | False | | No | industry tags | | Hint_Account_Location | String | False | | No | Company Location | | Hint_Account_Logo | String | False | | No | company logo | | Hint_Account_Naics_Code_Lbl | String | False | | No | NAICS Code | | Hint_Account_Pic | String | False | | No | Hint Account logo | | Hint_Account_Size | String | False | | No | Company Size | | Id [KEY] | String | True | | No | Unique identifier | | Industry | String | False | | No | The company belongs in this industry | | Invalid_Email | Bool | False | | No | | | Is_Escalated | Bool | True | | No | Is this escalated? | | Jacketsorderedytdloc_C | String | False | | No | | | Jv_Or_Afba_Partner_Name_C | String | False | | No | | | Lastaccountingperiod_C | String | False | | No | | | Lastupdatedate_C | Datetime | False | | No | | | Local_Tag_C | String | False | | No | | | Locked_Fields | String | True | | No | | | Maxliability_C | Decimal | False | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Mtcc_Modules_In_Use_C | String | False | | No | | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Name of the Company | | Name_City_State_C | String | False | | No | | | Nasid_C | String | False | | No | | | Next_Renewal_Date | Date | True | | No | | | Ownership | String | False | | No | | | Parent_Id | String | False | | No | Account ID of the parent of this account | | Parent_Name | String | True | | No | | | Perform_Sugar_Action | Bool | False | | No | | | Phone_Alternate | String | False | | No | An alternate phone number | | Phone_Fax | String | False | | No | The fax phone number of this company | | Phone_Office | String | False | | No | The office phone number | | Primarylocation_C | Bool | False | | No | | | Prior_Year_Total_Premium_C | Decimal | False | | No | | | Prioreoynetloc_C | Decimal | False | | No | | | Priorytdnetloc_C | Decimal | False | | No | | | Prospect_Numb_Sales_Calls_C | Int | False | | No | | | Prospecting_Next_Step_C | String | False | | No | | | Prospecting_Notes_C | String | False | | No | | | Rating | String | False | | No | An arbitrary rating for this company for use in comparisons with others | | Reportedpoliciesytdloc_C | Int | False | | No | | | Rynoh_Erecon_C | Bool | False | | No | | | Service_Level | String | False | | No | An indication of the service level of a company | | Shipping_Address_City | String | False | | No | The city used for the shipping address | | Shipping_Address_Country | String | False | | No | The country used for the shipping address | | Shipping_Address_Postalcode | String | False | | No | The zip code used for the shipping address | | Shipping_Address_State | String | False | | No | The state used for the shipping address | | Shipping_Address_Street | String | False | | No | The street address used for for shipping purposes | | Sic_Code | String | False | | No | SIC code of the account | | Software_Escrow_Title_C | String | False | | No | | | Status_C | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Test_Contact_For_Claims_C | String | False | | No | | | Ticker_Symbol | String | False | | No | The stock trading (ticker) symbol for the company | | Titlepoint_User_C | Bool | False | | No | | | Titlepoint_User_Notes_C | String | False | | No | | | Titlewave_User_C | Bool | False | | No | | | Twitter | String | False | | No | The twitter name of the company | | Website | String | False | | No | URL of website for the company | | Widget_Next_Renewal_Date | String | True | | No | | | Ytdvarianceloc_C | Decimal | False | | No | | [Return to Top](#objects-supported) ## ACLRoles | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Access_Override | Int | True | | No | | | Created_By | String | True | | No | User who created record | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | The role description | | Id [KEY] | String | True | | No | Unique identifier | | Modified_User_Id | String | True | | No | User who last modified record | | Name | String | False | | No | The role name | [Return to Top](#objects-supported) ## Activities | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Id [KEY] | String | False | | No | Unique identifier | | Name | String | False | | No | | | Date_Entered | Datetime | False | | No | Date record created | | Date_Modified | Datetime | False | | No | Date record last modified | | Modified_User_Id | String | False | | No | User who last modified record | | Modified_By_Name | String | False | | No | | | Created_By | String | False | | No | User who created record | | Created_By_Name | String | False | | No | | | Description | String | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Parent_Id | String | False | | No | | | Parent_Type | String | False | | No | | | Activity_Type | String | False | | No | | | Data | String | False | | No | | | Comment_Count | Int | False | | No | | | Last_Comment | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Locked_Fields | String | False | | No | | | Sync_Key | String | False | | No | | [Return to Top](#objects-supported) ## ArchiveRuns | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------- | | Archiver_Id | String | False | | No | ID associated with the Data Archiver | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Of_Archive | Datetime | False | | No | The date and time this archiver was run | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Filter_Def | String | False | | No | The filter definition associated with the run | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Ids_Processed | String | False | | No | The IDs that were processed in this run | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Num_Processed | Int | False | | No | The number of fields archived/deleted | | Process_Type | String | False | | No | Whether the data was deleted or archived | | Source_Module | String | False | | No | The source module | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## Audit | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------- | -------- | -------- | ---------- | ---------- | ----------- | | Parent_Id | String | False | | No | | | Date_Created | Datetime | False | | No | | | Created_By | String | False | | No | | | Created_By_Username | String | False | | No | | | Field_Name | String | False | | No | | | Data_Type | String | False | | No | | | Before_Value_String | String | False | | No | | | After_Value_String | String | False | | No | | | Before | String | False | | No | | | After | String | False | | No | | | Module | String | False | | Yes | | [Return to Top](#objects-supported) ## Bugs | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------ | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Bug_Number | Int | False | | No | Visual unique identifier | | Business_Hours_To_Resolution | Decimal | True | | No | How long it took to resolve this issue, in decimal business hours | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Fixed_In_Release | String | False | | No | The software or service release that corrected the bug | | Fixed_In_Release_Name | String | True | | No | | | Follow_Up_Datetime | Datetime | False | | No | Deadline for following up on an issue | | Following | Bool | False | | No | Is user following this record | | Found_In_Release | String | False | | No | The software or service release that manifested the bug | | Hours_To_Resolution | Decimal | True | | No | How long it took to resolve this issue, in decimal calendar hours | | Id [KEY] | String | True | | No | Unique identifier | | Is_Escalated | Bool | True | | No | Is this escalated? | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | The short description of the bug | | Pending_Processing | Bool | True | | No | | | Portal_Viewable | Bool | False | | No | | | Priority | String | False | | No | An indication of the priorty of the issue | | Product_Category | String | False | | No | Where the bug was discovered (ex: Accounts, Contacts, Leads) | | Release_Name | String | True | | No | | | Resolution | String | False | | No | An indication of how the issue was resolved | | Resolved_Datetime | Datetime | False | | No | Date when an issue is resolved | | Source | String | False | | No | An indicator of how the bug was entered (ex: via web, email, etc.) | | Source_Id | String | False | | No | | | Source_Meta | String | False | | No | | | Source_Type | String | False | | No | | | Status | String | False | | No | The status of the issue | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Type | String | False | | No | The type of issue (ex: issue, feature) | | Widget_Follow_Up_Datetime | String | True | | No | | | Work_Log | String | False | | No | Free-form text used to denote activities of interest | [Return to Top](#objects-supported) ## BusinessCenters | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------- | -------- | -------- | ---------- | ---------- | -------------------------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Address_City | String | False | | No | City of this Business Center | | Address_Country | String | False | | No | Country of this Business Center | | Address_Postalcode | String | False | | No | Postal Code of this Business Center | | Address_State | String | False | | No | State of this Business Center | | Address_Street | String | False | | No | Address of this Business Center | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Friday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Friday | | Friday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Friday | | Friday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Friday | | Friday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Friday | | Id [KEY] | String | True | | No | Unique identifier | | Is_Open_Friday | Bool | False | | No | Explicit marker for if this business center is open on Friday | | Is_Open_Monday | Bool | False | | No | Explicit marker for if this business center is open on Monday | | Is_Open_Saturday | Bool | False | | No | Explicit marker for if this business center is open on Saturday | | Is_Open_Sunday | Bool | False | | No | Explicit marker for if this business center is open on Sunday | | Is_Open_Thursday | Bool | False | | No | Explicit marker for if this business center is open on Thursday | | Is_Open_Tuesday | Bool | False | | No | Explicit marker for if this business center is open on Tuesday | | Is_Open_Wednesday | Bool | False | | No | Explicit marker for if this business center is open on Wednesday | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Monday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Monday | | Monday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Monday | | Monday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Monday | | Monday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Monday | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Saturday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Saturday | | Saturday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Saturday | | Saturday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Saturday | | Saturday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Saturday | | Sunday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Sunday | | Sunday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Sunday | | Sunday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Sunday | | Sunday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Sunday | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Thursday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Thursday | | Thursday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Thursday | | Thursday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Thursday | | Thursday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Thursday | | Timezone | String | False | | No | Time Zone in which this Business Center operates | | Tuesday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Tuesday | | Tuesday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Tuesday | | Tuesday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Tuesday | | Tuesday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Tuesday | | Wednesday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Wednesday | | Wednesday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Wednesday | | Wednesday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Wednesday | | Wednesday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Wednesday | [Return to Top](#objects-supported) ## Calendar | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Agenda_Event_Template | String | True | | No | | | Allow_Create | Bool | False | | No | | | Allow_Delete | Bool | False | | No | | | Allow_Update | Bool | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Calendar_Filter | String | True | | No | | | Calendar_Module | String | False | | No | | | Calendar_Type | String | True | | No | | | Color | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Day_Event_Template | String | True | | No | | | Dblclick_Event | String | True | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Duration_Days | String | True | | No | | | Duration_Hours | String | True | | No | | | Duration_Minutes | String | True | | No | | | Event_End | String | True | | No | | | Event_Start | String | False | | No | | | Event_Tooltip_Template | String | True | | No | | | Following | Bool | False | | No | Is user following this record | | Ical_Event_Template | String | True | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Month_Event_Template | String | True | | No | | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Schedulermonth_Event_Template | String | True | | No | | | Subject | String | True | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Timeline_Event_Template | String | True | | No | | | Week_Event_Template | String | True | | No | | [Return to Top](#objects-supported) ## Calls | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------------------------------------------------------------- | | Accept_Status | String | False | | No | | | Accept_Status_Users | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Auto_Invite_Parent | Bool | False | | No | Flag to allow for turning off auto invite of parent record - (Meta-data only) | | Aws_Contact_Id | String | True | | No | The AWS Connect Contact ID | | Aws_Lens_Data | String | False | | No | Raw data from the aws lens service | | Call_Differentiating_Value_C | String | False | | No | | | Call_Recording | String | True | | No | The friendly name for the call recording link | | Call_Recording_Url | String | False | | No | The URL for the call recording | | Cj_Activity_Tpl_Name | String | True | | No | | | Cj_Actual_Sort_Order | String | False | | No | | | Cj_Allow_Activity_By | String | False | | No | | | Cj_Blocked_By_Stages | String | False | | No | | | Cj_Momentum_End_Date | Datetime | False | | No | | | Cj_Momentum_Points | Int | True | | No | | | Cj_Momentum_Ratio | Double | True | | No | | | Cj_Momentum_Score | Int | True | | No | | | Cj_Momentum_Start_Date | Datetime | False | | No | | | Cj_Parent_Activity_Id | String | False | | No | | | Cj_Parent_Activity_Type | String | False | | No | | | Cj_Url | String | False | | No | | | Commentlog | String | True | | No | | | Contact_Id | String | True | | No | | | Contact_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Customer_Journey_Blocked_By | String | False | | No | | | Customer_Journey_Points | String | False | | No | | | Customer_Journey_Progress | Double | True | | No | | | Customer_Journey_Score | Int | True | | No | | | Date_End | Datetime | True | | No | Date is which call is scheduled to (or did) end | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Start | Datetime | False | | No | Date in which call is schedule to (or did) start | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Direction | String | False | | No | Indicates whether call is inbound or outbound | | Dri_Subworkflow_Id | String | False | | No | | | Dri_Subworkflow_Name | String | True | | No | | | Dri_Subworkflow_Template_Id | String | False | | No | | | Dri_Subworkflow_Template_Name | String | True | | No | | | Dri_Workflow_Id | String | False | | No | | | Dri_Workflow_Name | String | True | | No | | | Dri_Workflow_Sort_Order | String | False | | No | | | Dri_Workflow_Task_Template_Id | String | False | | No | | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | True | | No | | | Duration_Hours | Int | False | | No | Call duration, hours portion | | Duration_Minutes | String | False | | No | Call duration, minutes portion | | Email_Reminder_Checked | Bool | False | | No | checkbox indicating whether or not the email reminder value is set (Meta-data only) | | Email_Reminder_Sent | Bool | False | | No | Whether email reminder is already sent | | Email_Reminder_Time | 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 | | Fnf_Agencies_Calls_1_Name | String | True | | No | | | Fnf_Agencies_Calls_1fnf_Agencies_Ida | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Internal_Notes | String | False | | No | Internal notes for the call | | Invitees | String | True | | No | | | Is_Cj_Parent_Activity | Bool | False | | No | | | Is_Customer_Journey_Activity | Bool | False | | No | | | Lead_Id | String | True | | No | | | Lead_Name | String | True | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Brief description of the call | | Outlook_Id | String | False | | No | When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item ID | | Parent_Id | String | False | | No | The ID of the parent Sugar object identified by parent_type | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | The Sugar object to which the call is related | | Recurrence_Id | Datetime | False | | No | Recurrence ID of call. Original call start date | | Recurring_Source | String | False | | No | Source of recurring call | | Reminder_Checked | Bool | False | | No | checkbox indicating whether or not the reminder value is set (Meta-data only) | | Reminder_Time | String | False | | No | Specifies when a reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start | | Repeat_Count | Int | True | | No | Number of recurrence | | Repeat_Days | String | False | | No | Days of month | | Repeat_Dow | String | False | | No | Days of week in recurrence | | Repeat_Interval | Int | True | | No | Interval of recurrence | | Repeat_Ordinal | String | False | | No | Repeat ordinal value | | Repeat_Parent_Id | String | False | | No | Id of the first element of recurring records | | Repeat_Selector | String | False | | No | Repeat selector | | Repeat_Type | String | False | | No | Type of recurrence | | Repeat_Unit | String | False | | No | Repeat unit value | | Repeat_Until | Date | False | | No | Repeat until specified date | | Send_Invites | Bool | False | | No | checkbox indicating whether or not to send out invites (Meta-data only) | | Sentiment_Score_Agent | Decimal | True | | No | The sentiment score for the agent ranging from -5 to 5 | | Sentiment_Score_Agent_First_Quarter | Decimal | True | | No | The sentiment score for the agent during the first quarter ranging from -5 to 5 | | Sentiment_Score_Agent_Fourth_Quarter | Decimal | True | | No | The sentiment score for the agent during the fourth quarter ranging from -5 to 5 | | Sentiment_Score_Agent_Second_Quarter | Decimal | True | | No | The sentiment score for the agent during the second quarter ranging from -5 to 5 | | Sentiment_Score_Agent_String | String | True | | No | | | Sentiment_Score_Agent_Third_Quarter | Decimal | True | | No | The sentiment score for the agent during the third quarter ranging from -5 to 5 | | Sentiment_Score_Customer | Decimal | True | | No | The sentiment score for the customer ranging from -5 to 5 | | Sentiment_Score_Customer_First_Quarter | Decimal | True | | No | The sentiment score for the customer during the first quarter ranging from -5 to 5 | | Sentiment_Score_Customer_Fourth_Quarter | Decimal | True | | No | The sentiment score for the customer during the fourth quarter ranging from -5 to 5 | | Sentiment_Score_Customer_Second_Quarter | Decimal | True | | No | The sentiment score for the customer during the second quarter ranging from -5 to 5 | | Sentiment_Score_Customer_String | String | True | | No | | | Sentiment_Score_Customer_Third_Quarter | Decimal | True | | No | The sentiment score for the customer during the third quarter ranging from -5 to 5 | | Set_Accept_Links | String | False | | No | | | Start_Next_Journey_Id | String | False | | No | | | Status | String | False | | No | The status of the call (Held, Not Held, etc.) | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Transcript | String | True | | No | | | Type_Of_Call_C | String | False | | No | | [Return to Top](#objects-supported) ## CampaignLog | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ---------------------------------------------------------------------- | | Activity_Date | Datetime | False | | No | The date the activity occurred | | Activity_Type | String | False | | No | The activity that occurred (e.g., Viewed Message, Bounced, Opted out) | | Archived | Bool | False | | No | Indicates if item has been archived | | Campaign_Content | String | False | | No | | | Campaign_Id | String | False | | No | Campaign identifier | | Campaign_Name | String | False | | No | | | Campaign_Name1 | String | True | | No | | | Campaign_Objective | String | False | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Hits | Int | True | | No | Number of times the item has been invoked (e.g., multiple click-thrus) | | Id [KEY] | String | True | | No | Unique identifier | | List_Id | String | False | | No | The target list from which item originated | | Marketing_Id | String | False | | No | ID of marketing email this entry is associated with | | Marketing_Name | String | False | | No | | | More_Information | String | False | | No | | | Recipient_Email | String | False | | No | | | Recipient_Name | String | True | | No | | | Related_Id | String | False | | No | | | Related_Name | String | True | | No | | | Related_Type | String | False | | No | | | Target_Id | String | False | | No | Identifier of target record | | Target_Tracker_Key | String | False | | No | Identifier of Tracker URL | | Target_Type | String | False | | No | Descriptor of the target record type (e.g., Contact, Lead) | [Return to Top](#objects-supported) ## Campaigns | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------------------------------ | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Actual_Cost | Decimal | True | | No | Actual cost of the campaign | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Budget | Decimal | True | | No | Budgeted amount for the campaign | | Campaign_Type | String | False | | No | The type of campaign | | Commentlog | String | True | | No | | | Content | String | False | | No | The campaign description | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | True | | No | inhertied but not used | | End_Date | Date | False | | No | Ending date of the campaign | | Expected_Cost | Decimal | True | | No | Expected cost of the campaign | | Expected_Revenue | Decimal | True | | No | Expected revenue stemming from the campaign | | Following | Bool | False | | No | Is user following this record | | Frequency | String | False | | No | Frequency of the campaign | | Id [KEY] | String | True | | No | Unique identifier | | Impressions | Int | True | | No | Expected Click throughs manually entered by Campaign Manager | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | The name of the campaign | | Objective | String | False | | No | The objective of the campaign | | Start_Date | Date | False | | No | Starting date of the campaign | | Status | String | False | | No | Status of the campaign | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Tracker_Count | Int | True | | No | The number of accesses made to the tracker URL; no longer used as of 4.2 (see campaign_trkrs) | | Tracker_Key | Int | False | | No | The internal ID of the tracker used in a campaign; no longer used as of 4.2 (see campaign_trkrs) | | Tracker_Text | String | False | | No | The text that appears in the tracker URL; no longer used as of 4.2 (see campaign_trkrs) | [Return to Top](#objects-supported) ## CampaignTrackers | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ---------------------------------------------------------------------------------------------- | | Campaign_Id | String | False | | No | The ID of the campaign | | Created_By | String | True | | No | User ID who created record | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Id [KEY] | String | True | | No | Unique identifier | | Is_Optout | Bool | False | | No | Indicator whether tracker URL represents an opt-out link | | Modified_User_Id | String | True | | No | User who last modified record | | Tracker_Key | Int | False | | No | Internal key to uniquely identifier the tracker URL | | Tracker_Name | String | False | | No | The name of the campaign tracker | | Tracker_Url | String | False | | No | The URL that represents the landing page when the tracker URL in the campaign email is clicked | [Return to Top](#objects-supported) ## Cases | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------ | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------------- | | Account_Id | String | False | | No | The account to which the case is associated | | Account_Name | String | False | | No | The name of the account represented by the account_id field | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Action_Claim | String | True | | No | | | Action_Close | String | True | | No | | | Action_Unassign | String | True | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Attachment_List | String | True | | No | | | Business_Center_Id | String | False | | No | The business center to which the case is associated | | Business_Center_Name | String | True | | No | The name of the business center represented by the business_center_id field | | Business_Hours_To_Resolution | Decimal | True | | No | How long it took to resolve this issue, in decimal business hours | | Business_Hrs_To_First_Response | Decimal | True | | No | | | Case_Number | Int | False | | No | Visual unique identifier | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | True | | No | | | First_Response_Actual_Datetime | Datetime | True | | No | | | First_Response_Sent | Bool | False | | No | | | First_Response_Sla_Met | String | False | | No | | | First_Response_Target_Datetime | Datetime | True | | No | | | First_Response_User_Id | String | False | | No | | | First_Response_User_Name | String | True | | No | | | First_Response_Var_From_Target | Decimal | True | | No | | | Follow_Up_Datetime | Datetime | False | | No | Deadline for following up on an issue | | Following | Bool | False | | No | Is user following this record | | Hours_To_First_Response | Decimal | True | | No | | | Hours_To_Resolution | Decimal | True | | No | How long it took to resolve this issue, in decimal calendar hours | | Id [KEY] | String | True | | No | Unique identifier | | Is_Escalated | Bool | True | | No | Is this escalated? | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | The short description of the bug | | Pending_Processing | Bool | True | | No | | | Perform_Sugar_Action | Bool | False | | No | | | Portal_Viewable | Bool | False | | No | | | Primary_Contact_Id | String | False | | No | | | Primary_Contact_Name | String | True | | No | | | Priority | String | False | | No | The priority of the case | | Request_Close | Bool | True | | No | The request close status of the case | | Request_Close_Date | Datetime | True | | No | The date/time that the request close was initiated | | Resolution | String | False | | No | The resolution of the case | | Resolved_Datetime | Datetime | False | | No | Date when an issue is resolved | | Service_Level | String | True | | No | Service level of the associated account of case | | Source | String | False | | No | An indicator of how the case was entered (ex: via web, email, etc.) | | Source_Id | String | False | | No | | | Source_Meta | String | False | | No | | | Source_Type | String | False | | No | | | Status | String | False | | No | The status of the case | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Type | String | False | | No | The type of issue (ex: issue, feature) | | Widget_Follow_Up_Datetime | String | True | | No | | | Widget_Status | String | True | | No | | | Work_Log | String | False | | No | Free-form text used to denote activities of interest | [Return to Top](#objects-supported) ## Categories | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | | | Is_External | Bool | False | | No | External category flag | | Lft | Int | False | | No | Left node index | | Locked_Fields | String | True | | No | | | Lvl | Int | False | | No | Node level | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Category name | | Rgt | Int | False | | No | Right node index | | Root | String | False | | No | Root ID | | Source_Id | String | False | | No | | | Source_Meta | String | False | | No | | | Source_Type | String | False | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## ChangeTimers | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Id [KEY] | String | False | | No | Unique identifier | | Name | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Modified_User_Id | String | True | | No | User who last modified record | | Modified_By_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Description | String | False | | No | Full text of the note | | Deleted | Bool | False | | No | Record deletion indicator | | Parent_Type | String | False | | No | | | Parent_Id | String | False | | No | | | Field_Name | String | False | | No | | | Value_String | String | False | | No | | | From_Datetime | Datetime | False | | No | | | To_Datetime | Datetime | False | | No | | | Hours | Decimal | True | | No | | | Business_Hours | Decimal | True | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## CJForms | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Id [KEY] | String | False | | No | Unique identifier | | Name | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Modified_User_Id | String | True | | No | User who last modified record | | Modified_By_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Description | String | False | | No | Full text of the note | | Deleted | Bool | False | | No | Record deletion indicator | | Trigger_Event | String | False | | No | | | Action_Type | String | False | | No | | | Action_Trigger_Type | String | False | | No | | | Relationship | String | False | | No | | | Activity_Module | String | False | | No | | | Active | Bool | False | | No | | | Ignore_Errors | Bool | False | | No | | | Populate_Fields | String | False | | No | | | Select_To_Email_Address | String | False | | No | | | Parent_Id | String | False | | No | | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | | | Display_Activity_Rsa_Icon | String | False | | No | | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | False | | No | | | Email_Templates_Id | String | False | | No | | | Email_Templates_Name | String | True | | No | | | Main_Trigger_Type | String | False | | No | | | Module_Trigger | String | False | | No | | | Field_Trigger | String | False | | No | | | Smart_Guide_Template_Id | String | False | | No | | | Smart_Guide_Template_Name | String | False | | No | | | Target_Action | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Tag | String | False | | No | | | Commentlog | String | True | | No | | | Locked_Fields | String | True | | No | | | Sync_Key | String | True | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Team_Count | String | False | | No | | | Team_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | [Return to Top](#objects-supported) ## CJWebHooks | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Id [KEY] | String | False | | No | Unique identifier | | Name | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Modified_User_Id | String | True | | No | User who last modified record | | Modified_By_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Description | String | False | | No | Full text of the note | | Deleted | Bool | False | | No | Record deletion indicator | | Url | String | False | | No | | | Error_Message_Path | String | False | | No | | | Sort_Order | Int | False | | No | | | Request_Method | String | False | | No | | | Request_Format | String | False | | No | | | Response_Format | String | False | | No | | | Trigger_Event | String | False | | No | | | Request_Body | String | False | | No | | | Headers | String | False | | No | | | Custom_Post_Body | String | False | | No | | | Ignore_Errors | Bool | False | | No | | | Active | Bool | False | | No | | | Parent_Id | String | False | | No | | | Parent_Name | String | False | | No | | | Parent_Type | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Tag | String | False | | No | | | Commentlog | String | True | | No | | | Locked_Fields | String | True | | No | | | Sync_Key | String | True | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Team_Count | String | False | | No | | | Team_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | [Return to Top](#objects-supported) ## CloudDrivePaths | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Drive_Id | String | True | | No | | | Folder_Id | String | True | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Is_Root | Bool | False | | No | | | Is_Shared | Bool | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Path | String | True | | No | | | Path_Module | String | True | | No | | | Record_Id | String | True | | No | | | Site_Id | String | True | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Type | String | True | | No | | [Return to Top](#objects-supported) ## CommentLog | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Entry | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## Comments | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Data | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Parent_Id | String | False | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## ConsoleConfiguration | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------- | -------- | -------- | ---------- | ---------- | -------------------------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Enabled_Modules | String | False | | No | | | Filter_Def | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Freeze_First_Column | Bool | False | | No | Decides if the first column should be frozen | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Order_By_Primary | String | False | | No | | | Order_By_Secondary | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## Contacts | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------------------- | | Accept_Status_Calls | String | False | | No | | | Accept_Status_Id | String | False | | No | | | Accept_Status_Meetings | String | False | | No | | | Accept_Status_Messages | String | False | | No | | | Accept_Status_Name | String | False | | No | | | Account_Id | String | False | | No | | | Account_Name | String | True | | No | | | Accounting_Bulletins_C | Bool | False | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Alt_Address_City | String | False | | No | City for alternate address | | Alt_Address_Country | String | False | | No | Country for alternate address | | Alt_Address_Postalcode | String | False | | No | Postal code for alternate address | | Alt_Address_State | String | False | | No | State for alternate address | | Alt_Address_Street | String | False | | No | Street address for alternate address | | Alt_Address_Street_2 | String | False | | No | | | Alt_Address_Street_3 | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Assistant | String | False | | No | Name of the assistant of the contact | | Assistant_Phone | String | False | | No | Phone number of the assistant of the contact | | Birthdate | Date | False | | No | The birthdate of the contact | | Business_Center_Id | String | False | | No | The business center to which the case is associated | | Business_Center_Name | String | True | | No | The name of the business center represented by the business_center_id field | | C_Accept_Status_Fields | String | True | | No | | | Campaign_Id | String | False | | No | Campaign that generated lead | | Campaign_Name | String | True | | No | The first campaign name for Contact (Meta-data only) | | Commentlog | String | True | | No | | | Contact_Type_C | String | False | | No | | | Contactid_C | String | False | | No | | | Cookie_Consent | Bool | False | | No | Indicator whether this portal user accepts cookies | | Cookie_Consent_Received_On | Datetime | False | | No | Date cookie consent received on | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Day_Of_Birth_Yr_Optional_C | String | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Department | String | False | | No | The department of the contact | | Description | String | False | | No | Full text of the note | | Dnb_Principal_Id | String | False | | No | Unique Id For DB Contact | | Do_Not_Call | Bool | False | | No | An indicator of whether contact can be called | | Dp_Business_Purpose | String | True | | No | Business purposes consented for | | Dp_Consent_Last_Updated | Date | False | | No | Date consent last updated | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | True | | No | | | Email | String | False | | No | | | Email_Addresses_Non_Primary | String | False | | No | | | Email_And_Name1 | String | False | | No | | | Email_Opt_Out | Bool | False | | No | | | Email1 | String | False | | No | | | Email2 | String | False | | No | | | Entry_Source | String | True | | No | Determines if a record was created internal to the system or external to the system | | Escrow_Bulletins_C | Bool | False | | No | | | Facebook | String | False | | No | The facebook name of the user | | First_Name | String | False | | No | First name of the contact | | Fnf_Agencies_Contacts_1_Name | String | True | | No | | | Fnf_Agencies_Contacts_1fnf_Agencies_Ida | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Full_Name | String | True | | No | | | General_Bulletins_C | Bool | False | | No | | | Googleplus | String | False | | No | The google plus id of the user | | Hint_Account_Annual_Revenue | String | False | | No | Annual Rev | | Hint_Account_Description | String | False | | No | Company Description | | Hint_Account_Facebook_Handle | String | False | | No | company facebook | | Hint_Account_Fiscal_Year_End | String | False | | No | FY End | | Hint_Account_Founded_Year | String | False | | No | company founded year | | Hint_Account_Industry | String | False | | No | Company Industry | | Hint_Account_Location | String | False | | No | Company Location | | Hint_Account_Logo | String | False | | No | company logo | | Hint_Account_Naics_Code_Lbl | String | False | | No | NAICS Code | | Hint_Account_Sic_Code_Label | String | False | | No | SIC Code | | Hint_Account_Size | String | False | | No | Company Size | | Hint_Account_Twitter_Handle | String | False | | No | company twitter | | Hint_Account_Website | String | False | | No | company website | | Hint_Contact_Pic | String | False | | No | Hint Contact logo | | Hint_Education | String | False | | No | Education | | Hint_Education_2 | String | False | | No | Education 2 | | Hint_Facebook | String | False | | No | | | Hint_Industry_Tags | String | False | | No | industry tags | | Hint_Job_2 | String | False | | No | Job 2 | | Hint_Phone_1 | String | False | | No | extra phone field | | Hint_Phone_2 | String | False | | No | extra phone field | | Hint_Photo | String | False | | No | person photo | | Hint_Twitter | String | False | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Invalid_Email | Bool | False | | No | | | Last_Name | String | False | | No | Last name of the contact | | Lead_Registered_User_C | Bool | False | | No | | | Lead_Source | String | False | | No | How did the contact come about | | Locked_Fields | String | True | | No | | | M_Accept_Status_Fields | String | True | | No | | | Market_Interest_Prediction_Score | String | True | | No | | | Market_Score | Int | True | | No | | | Mkto_Id | Int | True | | No | Associated Marketo Lead ID | | Mkto_Lead_Score | Int | True | | No | | | Mkto_Sync | Bool | False | | No | Should the Lead be synced to Marketo | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | True | | No | | | No_Longer_At_Account_C | Bool | False | | No | | | Opportunity_Role | String | False | | No | | | Opportunity_Role_Fields | String | True | | No | | | Opportunity_Role_Id | String | False | | No | | | Owner_Only_Bulletins_C | Bool | False | | No | | | Perform_Sugar_Action | Bool | False | | No | | | Phone_Fax | String | False | | No | Contact fax number | | Phone_Home | String | False | | No | Home phone number of the contact | | Phone_Mobile | String | False | | No | Mobile phone number of the contact | | Phone_Other | String | False | | No | Other phone number for the contact | | Phone_Work | String | False | | No | Work phone number of the contact | | Picture | String | False | | No | Avatar | | Portal_Active | Bool | False | | No | Indicator whether this contact is a portal user | | Portal_App | String | False | | No | Reference to the portal | | Portal_Name | String | True | | No | Name as it appears in the portal | | Portal_Password | String | True | | No | | | Portal_Password1 | String | True | | No | | | Portal_User_Company_Name | String | False | | No | User company name in the portal | | Preferred_Language | String | False | | No | | | Primary_Address_City | String | False | | No | City for primary address | | Primary_Address_Country | String | False | | No | Country for primary address | | Primary_Address_Postalcode | String | False | | No | Postal code for primary address | | Primary_Address_State | String | False | | No | State for primary address | | Primary_Address_Street | String | False | | No | The street address used for primary address | | Primary_Address_Street_2 | String | False | | No | | | Primary_Address_Street_3 | String | False | | No | | | Report_To_Name | String | True | | No | | | Reports_To_Id | String | False | | No | The contact this contact reports to | | Salutation | String | False | | No | Contact salutation (e.g., Mr, Ms) | | Site_User_Id | String | True | | No | | | Source_Id | String | False | | No | | | Source_Meta | String | False | | No | | | Source_Type | String | False | | No | | | Sync_Contact | Bool | False | | No | Synch to outlook? (Meta-Data only) | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Title | String | False | | No | The title of the contact | | Title_Wave_User_C | Bool | False | | No | | | Twitter | String | False | | No | The twitter name of the user | | Underwriting_Bulletins_C | Bool | False | | No | | [Return to Top](#objects-supported) ## Contracts | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------------- | -------- | -------- | ---------- | ---------- | -------------------------------------------------------------------------------------------------------------------------------------------- | | Account_Id | String | False | | No | The account ID to which the contract is associated | | Account_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Commentlog | String | True | | No | | | Company_Signed_Date | Date | False | | No | Date in which the company using Sugar signed the contract | | Contract_Term | Int | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Customer_Signed_Date | Date | False | | No | Date in which the ultimate customer signed the contract | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | End_Date | Date | False | | No | The date in which the contract is no longer effective | | Expiration_Notice | Datetime | False | | No | Date to issue an expiration notice (useful for workflow rules) | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | The name of the contract | | Opportunity_Id | String | False | | No | | | Opportunity_Name | String | True | | No | | | Parent_Name | String | True | | No | parent_name of contract, added to prevent ability to add flex relate field to module because of relationship in linked_documentsMetaData.php | | Reference_Code | String | False | | No | The reference code used by the organization to refer to this contract | | Start_Date | Date | False | | No | The effective date of the contract | | Status | String | False | | No | The contract status | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Time_To_Expiry | Int | True | | No | | | Total_Contract_Value | Decimal | True | | No | The overall value of the contract | | Total_Contract_Value_Usdollar | Decimal | True | | No | The overall contract value expressed in USD | | Type | String | False | | No | The dropdown options for Contract types | | Type_Name | String | True | | No | The contract type | [Return to Top](#objects-supported) ## ContractTypes | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | -------------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | List_Order | Int | True | | No | Relative order in drop down list | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## Currencies | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------- | | Conversion_Rate | Decimal | False | | No | Conversion rate factor (relative to stored value) | | Created_By | String | True | | No | User ID who created record | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Id [KEY] | String | True | | No | Unique identifer | | Iso4217 | String | False | | No | 3-letter identifier specified by ISO 4217 (ex: USD) | | Name | String | False | | No | Name of the currency | | Status | String | False | | No | Currency status | | Symbol | String | False | | No | Symbol representing the currency | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## CustomQueries | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Created_By | String | True | | No | User ID who created record | | Custom_Query | String | False | | No | The SQL statement | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full description of the custom query | | Id [KEY] | String | True | | No | Unique identifer | | List_Order | Int | True | | No | The relative order of this query (unused) | | Modified_User_Id | String | True | | No | User who last modified record | | Name | String | False | | No | Name of the custom query | | Query_Locked | Bool | False | | No | Indicates whether query body (the SQL statement) can be changed | | Query_Type | String | False | | No | The type of query (unused) | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## Dashboards | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Dashboard_Module | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Default_Dashboard | Bool | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Metadata | String | False | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | View_Name | String | False | | No | | [Return to Top](#objects-supported) ## DataArchiver | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------ | | Active | Bool | False | | No | Whether the definition is active or not | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Filter_Def | String | False | | No | The filter definitions defined for the archive | | Filter_Module_Name | String | False | | No | Module associated with the archived data | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Process_Type | String | False | | No | Whether the data should be truncated or archived | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## DataPrivacy | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Business_Hours_To_Resolution | Decimal | True | | No | How long it took to resolve this issue, in decimal business hours | | Business_Purpose | String | True | | No | Business purpose | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Dataprivacy_Number | Int | False | | No | Visual unique identifier | | Date_Closed | Date | False | | No | Date closed | | Date_Due | Date | False | | No | Due date | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Opened | Date | False | | No | Date opened | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Fields_To_Erase | String | False | | No | | | Follow_Up_Datetime | Datetime | False | | No | Deadline for following up on an issue | | Following | Bool | False | | No | Is user following this record | | Hours_To_Resolution | Decimal | True | | No | How long it took to resolve this issue, in decimal calendar hours | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | The short description of the bug | | Pending_Processing | Bool | True | | No | | | Priority | String | False | | No | An indication of the priorty of the issue | | Requested_By | String | False | | No | Requested by | | Resolution | String | False | | No | The resolution of the request | | Resolved_Datetime | Datetime | False | | No | Date when an issue is resolved | | Source | String | False | | No | The source of the request | | Status | String | False | | No | The status of the request | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Type | String | False | | No | The type of request | | Widget_Follow_Up_Datetime | String | True | | No | | | Work_Log | String | False | | No | Free-form text used to denote activities of interest | [Return to Top](#objects-supported) ## DataSets | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------- | -------- | -------- | ---------- | ---------- | -------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Body_Back_Color | String | False | | No | | | Body_Text_Color | String | False | | No | | | Created_By | String | True | | No | | | Custom_Layout | String | False | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | Description | String | False | | No | | | Exportable | Bool | False | | No | | | Font_Size | String | False | | No | | | Header | Bool | False | | No | | | Header_Back_Color | String | False | | No | | | Header_Text_Color | String | False | | No | | | Id [KEY] | String | True | | No | | | List_Order_Y | Int | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | False | | No | | | Output_Default | String | False | | No | | | Parent_Id | String | False | | No | | | Parent_Name | String | True | | No | Parent data sets for the data set (Meta-data only) | | Prespace_Y | Bool | False | | No | | | Query_Id | String | False | | No | | | Query_Name | String | False | | No | Custom Queries for the data sets (Meta-data only) | | Report_Id | String | False | | No | | | Report_Name | String | False | | No | Custom Queries for the data sets (Meta-data only) | | Table_Width | String | False | | No | | | Table_Width_Type | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Use_Prev_Header | Bool | False | | No | | [Return to Top](#objects-supported) ## DocumentMerges | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Dismissed | Bool | False | | No | | | File_Type | String | True | | No | | | Flow_Data | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Generated_Document_Id | String | True | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Merge_Type | String | True | | No | | | Message | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Parent_Id | String | True | | No | | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | | | Record_Ids | String | True | | No | store the record ids for the multimerge | | Seen | Bool | False | | No | | | Status | String | True | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Template | String | True | | No | | | Template_Id | String | True | | No | | [Return to Top](#objects-supported) ## DocumentRevisions | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------- | | Change_Log | String | False | | No | | | Created_By | String | True | | No | | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | Doc_Id | String | False | | No | Document ID from documents web server provider | | Doc_Type | String | False | | No | Document type (ex: Google, box.net, IBM SmartCloud) | | Doc_Url | String | False | | No | Document URL from documents web server provider | | Document_Id | String | False | | No | | | Document_Name | String | False | | No | | | File_Ext | String | False | | No | | | File_Mime_Type | String | False | | No | | | File_Size | Int | True | | No | The size of the file | | Filename | String | False | | No | | | Id [KEY] | String | True | | No | | | Latest_Revision | String | False | | No | | | Latest_Revision_Id | String | False | | No | | | Related_Document_Name | String | True | | No | | | Revision | String | False | | No | | [Return to Top](#objects-supported) ## Documents | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------ | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Active_Date | Date | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Category_Id | String | False | | No | | | Commentlog | String | True | | No | | | Contract_Name | String | False | | No | | | Contract_Status | String | False | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Doc_Id | String | False | | No | Document ID from documents web server provider | | Doc_Type | String | True | | No | Document type (ex: Google, box.net, IBM SmartCloud) | | Doc_Url | String | False | | No | Document URL from documents web server provider | | Document_Name | String | False | | No | | | Document_Revision_Id | String | False | | No | | | Exp_Date | Date | False | | No | | | Filename | String | False | | No | The filename of the document attachment | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Is_Shared | Bool | False | | No | | | Is_Template | Bool | False | | No | | | Last_Rev_Create_Date | String | True | | No | | | Last_Rev_Created_Name | String | False | | No | | | Last_Rev_Mime_Type | String | False | | No | | | Latest_Revision | String | False | | No | | | Latest_Revision_File_Ext | String | True | | No | | | Latest_Revision_File_Mime_Type | String | True | | No | | | Latest_Revision_File_Size | String | True | | No | | | Latest_Revision_Id | String | False | | No | | | Latest_Revision_Name | String | False | | No | | | Linked_Id | String | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Related_Doc_Id | String | False | | No | | | Related_Doc_Name | String | True | | No | The related document name for Meta-Data framework | | Related_Doc_Rev_Id | String | False | | No | | | Related_Doc_Rev_Number | String | True | | No | The related document version number for Meta-Data framework | | Revision | String | False | | No | | | Selected_Revision_Filename | String | False | | No | | | Selected_Revision_Id | String | False | | No | | | Selected_Revision_Name | String | False | | No | | | Status | String | False | | No | Document status for Meta-Data framework | | Status_Id | String | False | | No | | | Subcategory_Id | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Template_Type | String | False | | No | | [Return to Top](#objects-supported) ## DocumentTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | File_Ext | String | False | | No | | | File_Mime_Type | String | False | | No | | | File_Size | Int | True | | No | The size of the file | | Filename | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Label_Merging | Bool | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Postfix | String | False | | No | | | Prefix | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Template_Module | String | False | | No | | | Use_Revisions | Bool | False | | No | | [Return to Top](#objects-supported) ## DocuSignEnvelopes | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ---------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Cloud_Path | String | False | | No | | | Cloud_Service_Type | String | False | | No | | | Commentlog | String | True | | No | | | Completed_Document | String | True | | No | The document completed in DocuSign | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Document_Id | String | False | | No | | | Driveid | String | False | | No | | | Envelope_Id | String | True | | No | The id of the envelope in DocuSign | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Last_Audit | Datetime | False | | No | The last time the envelope was fetched from DocuSign | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Parent_Id | String | False | | No | | | Parent_Name | String | True | | No | The parent record | | Parent_Type | String | True | | No | | | Status | String | True | | No | The status of the envelope | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## DRISubWorkflows | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Id [KEY] | String | False | | No | Unique identifier | | Name | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Modified_User_Id | String | True | | No | User who last modified record | | Modified_By_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Description | String | False | | No | Full text of the note | | Deleted | Bool | False | | No | Record deletion indicator | | Label | String | False | | No | | | State | String | False | | No | | | Start_Next_Journey_Id | String | False | | No | | | Progress | Double | True | | No | | | Momentum_Ratio | Double | True | | No | | | Score | Int | True | | No | | | Points | Int | True | | No | | | Momentum_Points | Int | True | | No | | | Momentum_Score | Int | True | | No | | | Sort_Order | Int | False | | No | | | Date_Started | Datetime | True | | No | | | Date_Completed | Datetime | True | | No | | | Is_Journey_Saved | Bool | False | | No | | | Dri_Subworkflow_Template_Id | String | False | | No | | | Dri_Subworkflow_Template_Name | String | True | | No | | | Dri_Workflow_Id | String | False | | No | | | Dri_Workflow_Name | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Tag | String | False | | No | | | Commentlog | String | True | | No | | | Locked_Fields | String | True | | No | | | Sync_Key | String | True | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Team_Count | String | False | | No | | | Team_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | [Return to Top](#objects-supported) ## DRISubWorkflowTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Id [KEY] | String | False | | No | Unique identifier | | Name | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Modified_User_Id | String | True | | No | User who last modified record | | Modified_By_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Description | String | False | | No | Full text of the note | | Deleted | Bool | False | | No | Record deletion indicator | | Label | String | False | | No | | | Sort_Order | Int | True | | No | | | Points | Int | True | | No | | | Related_Activities | Int | True | | No | | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | False | | No | | | Start_Next_Journey_Id | String | False | | No | | | Start_Next_Journey_Name | String | True | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Tag | String | False | | No | | | Commentlog | String | True | | No | | | Locked_Fields | String | True | | No | | | Sync_Key | String | True | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Team_Count | String | False | | No | | | Team_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | [Return to Top](#objects-supported) ## DRIWorkflows | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Id [KEY] | String | False | | No | Unique identifier | | Name | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Modified_User_Id | String | True | | No | User who last modified record | | Modified_By_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Description | String | True | | No | Full text of the note | | Deleted | Bool | False | | No | Record deletion indicator | | Available_Modules | String | True | | No | | | Enabled_Modules | String | True | | No | | | State | String | False | | No | | | Assignee_Rule | String | False | | No | | | Target_Assignee | String | False | | No | | | Stage_Numbering | String | True | | No | | | Progress | Double | True | | No | | | Momentum_Ratio | Double | True | | No | | | Score | Int | True | | No | | | Points | Int | True | | No | | | Momentum_Points | Int | True | | No | | | Momentum_Score | Int | True | | No | | | Date_Started | Datetime | True | | No | | | Date_Completed | Datetime | True | | No | | | Archived | Bool | False | | No | | | Is_Cancelled | Bool | False | | No | | | Is_Deleted | Bool | False | | No | | | Current_Stage_Id | String | False | | No | | | Current_Stage_Name | String | True | | No | | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | False | | No | | | Parent_Id | String | True | | No | | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Tag | String | False | | No | | | Commentlog | String | True | | No | | | Locked_Fields | String | True | | No | | | Sync_Key | String | True | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Team_Count | String | False | | No | | | Team_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Contact_Id | String | False | | No | | | Contact_Name | String | True | | No | | | Account_Id | String | False | | No | | | Account_Name | String | True | | No | | | Opportunity_Id | String | False | | No | | | Opportunity_Name | String | True | | No | | | Case_Id | String | False | | No | | | Case_Name | String | True | | No | | | Lead_Id | String | False | | No | | | Lead_Name | String | True | | No | | [Return to Top](#objects-supported) ## DRIWorkflowTaskTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Id [KEY] | String | False | | No | Unique identifier | | Name | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Modified_User_Id | String | True | | No | User who last modified record | | Modified_By_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Description | String | False | | No | Full text of the note | | Deleted | Bool | False | | No | Record deletion indicator | | Task_Start_Date_Type | String | False | | No | | | Task_Due_Date_Type | String | False | | No | | | Momentum_Start_Type | String | False | | No | | | Start_Date_Module | String | False | | No | | | Due_Date_Module | String | False | | No | | | Start_Date_Field | String | False | | No | | | Due_Date_Field | String | False | | No | | | Due_Date_Criteria | String | False | | No | | | Momentum_Start_Module | String | False | | No | | | Momentum_Start_Field | String | False | | No | | | Priority | String | False | | No | | | Type | String | False | | No | | | Activity_Type | String | False | | No | | | Duration_Minutes | String | False | | No | | | Direction | String | False | | No | | | Points | String | False | | No | | | Momentum_Points | String | False | | No | | | Send_Invite_Type | String | False | | No | | | Target_Assignee | String | False | | No | | | Assignee_Rule | String | False | | No | | | Populate_Fields | String | False | | No | | | Select_To_Guests | String | False | | No | | | Allow_Activity_By | String | False | | No | | | Time_Of_Day | String | False | | No | | | Sort_Order | String | False | | No | | | Task_Start_Days | Int | False | | No | | | Task_Due_Days | Int | False | | No | | | Momentum_Due_Days | Int | False | | No | | | Momentum_Due_Hours | Int | False | | No | | | Duration_Hours | Int | True | | No | | | Duration | Int | True | | No | | | Is_Parent | Bool | True | | No | | | Blocked_By | String | False | | No | | | Blocked_By_Stages | String | False | | No | | | Url | String | False | | No | | | Stage_Template_Label | String | True | | No | | | Stage_Template_Sort_Order | String | True | | No | | | Assignee_Rule_Activity_Id | String | False | | No | | | Assignee_Rule_Activity_Name | String | False | | No | | | Start_Date_Activity_Id | String | False | | No | | | Start_Date_Activity_Name | String | False | | No | | | Due_Date_Activity_Id | String | False | | No | | | Due_Date_Activity_Name | String | False | | No | | | Momentum_Start_Activity_Id | String | False | | No | | | Momentum_Start_Activity_Name | String | False | | No | | | Parent_Id | String | False | | No | | | Parent_Name | String | True | | No | | | Dri_Subworkflow_Template_Id | String | False | | No | | | Dri_Subworkflow_Template_Name | String | False | | No | | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | False | | No | | | Start_Next_Journey_Id | String | False | | No | | | Start_Next_Journey_Name | String | True | | No | | | Target_Assignee_User_Id | String | False | | No | | | Target_Assignee_User_Name | String | False | | No | | | Target_Assignee_Team_Id | String | False | | No | | | Target_Assignee_Team_Name | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Tag | String | False | | No | | | Commentlog | String | True | | No | | | Locked_Fields | String | True | | No | | | Sync_Key | String | True | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Team_Count | String | False | | No | | | Team_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | [Return to Top](#objects-supported) ## DRIWorkflowTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Id [KEY] | String | False | | No | Unique identifier | | Name | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Modified_User_Id | String | True | | No | User who last modified record | | Modified_By_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Description | String | False | | No | Full text of the note | | Deleted | Bool | False | | No | Record deletion indicator | | Available_Modules | String | False | | No | | | Disabled_Stage_Actions | String | True | | No | | | Disabled_Activity_Actions | String | True | | No | | | Active_Limit | Int | True | | No | | | Points | Int | True | | No | | | Related_Activities | Int | True | | No | | | Active | Bool | False | | No | | | Update_Assignees | Bool | False | | No | | | Assignee_Rule | String | False | | No | | | Target_Assignee | String | False | | No | | | Stage_Numbering | String | True | | No | | | Cancel_Action | String | False | | No | | | Not_Applicable_Action | String | False | | No | | | Copied_Template_Id | String | False | | No | | | Copied_Template_Name | String | True | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Tag | String | False | | No | | | Commentlog | String | True | | No | | | Locked_Fields | String | True | | No | | | Sync_Key | String | True | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Team_Count | String | False | | No | | | Team_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | [Return to Top](#objects-supported) ## DropDownValues | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------ | ------ | -------- | ---------- | ---------- | ----------------------------------------- | | Module | String | True | | No | The module containing this dropdown item. | | Field | String | True | | No | The field containing this dropdown item. | | ItemName | String | True | | No | The name of the dropdown item. | | DisplayLabel | String | True | | No | The display label of the dropdown item. | [Return to Top](#objects-supported) ## EAPM | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------ | | Api_Data | String | False | | No | Any API data that the external API may wish to store on a per-user basis | | Application | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Consumer_Key | String | False | | No | | | Consumer_Secret | String | False | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Note | String | False | | No | | | Oauth_Secret | String | False | | No | | | Oauth_Token | String | False | | No | | | Password | String | False | | No | | | Sync_Key | String | True | | No | | | Url | String | False | | No | | | Validated | Bool | False | | No | | [Return to Top](#objects-supported) ## EmailAddresses | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------- | -------- | -------- | ---------- | ---------- | ----------- | | Confirmation_Requested_On | Datetime | False | | No | | | Date_Created | Datetime | False | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | Email_Address | String | False | | No | | | Email_Address_Caps | String | False | | No | | | Id [KEY] | String | True | | No | | | Invalid_Email | Bool | False | | No | | | Opt_Out | Bool | False | | No | | [Return to Top](#objects-supported) ## EmailMarketing | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------- | | All_Prospect_Lists | Bool | False | | No | | | Campaign_Id | String | False | | No | | | Created_By | String | True | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Date_Start | Datetime | False | | No | | | Deleted | Bool | False | | No | | | From_Addr | String | False | | No | | | From_Name | String | False | | No | | | Id [KEY] | String | True | | No | | | Inbound_Email_Id | String | False | | No | | | Modified_User_Id | String | True | | No | | | Name | String | False | | No | | | Prospect_List_Name | String | False | | No | | | Reply_To_Addr | String | False | | No | | | Reply_To_Name | String | False | | No | | | Status | String | False | | No | | | Template_Id | String | False | | No | | | Template_Name | String | True | | No | | [Return to Top](#objects-supported) ## EmailParticipants | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | -------------------------------------------------------------- | | Address_Type | String | False | | No | The role (from, to, cc, bcc) that the entry plays in the email | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | Email_Address | String | True | | No | | | Email_Address_Id | String | False | | No | | | Email_Id | String | False | | No | | | Id [KEY] | String | True | | No | | | Invalid_Email | String | True | | No | | | Opt_Out | String | True | | No | | | Parent_Id | String | False | | No | The bean's ID | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | | [Return to Top](#objects-supported) ## Emails | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID that last modified record | | Assigned_User_Name | String | True | | No | | | Attachments_Collection | String | True | | No | | | Bcc_Addrs_Names | String | False | | No | | | Bcc_Collection | String | True | | No | | | Cc_Addrs_Names | String | False | | No | | | Cc_Collection | String | True | | No | | | Created_By | String | True | | No | User name who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Sent | Datetime | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | | | Description_Html | String | True | | No | | | Direction | String | False | | No | Email direction is one of Unknown, Outbound, Inbound, Internal | | Flagged | Bool | False | | No | flagged status | | Following | Bool | False | | No | Is user following this record | | From_Addr_Name | String | False | | No | | | From_Collection | String | True | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Intent | String | False | | No | Target of action used in Inbound Email assignment | | Mailbox_Id | String | False | | No | | | Mailbox_Name | String | True | | No | | | Message_Id | String | False | | No | ID of the email item obtained from the email transport system | | Message_Uid | String | False | | No | UID of the email item obtained from the email transport system | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User ID that last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | The subject of the email | | Outbound_Email_Id | String | False | | No | The configuration used to send an email, only used for emails sent using SugarCRM | | Parent_Id | String | False | | No | ID of Sugar object referenced by parent_type | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | Identifier of Sugar module to which this email is associated | | Raw_Source | String | False | | No | | | Reply_To_Addr | String | False | | No | | | Reply_To_Id | String | False | | No | Identifier of email record that this email was a reply to | | Reply_To_Status | Bool | False | | No | If you reply to an email then reply to status of original email is set | | State | String | False | | No | An email is either a draft or archived | | Status | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | To_Addrs_Names | String | False | | No | | | To_Collection | String | True | | No | | | Total_Attachments | Int | True | | No | | | Type | String | False | | No | Type of email (ex: draft) | [Return to Top](#objects-supported) ## EmailTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | ---------------------------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Attachments_Collection | String | True | | No | | | Base_Module | String | False | | No | In Workflow alert templates, the module to which this template is associated | | Body | String | False | | No | Plain text body to be used in resulting email | | Body_Html | String | True | | No | HTML formatted email body to be used in resulting email | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Email template description | | From_Address | String | False | | No | | | From_Name | String | False | | No | | | Has_Variables | Bool | True | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Name | String | False | | No | Email template name | | Published | String | False | | No | | | Subject | String | False | | No | Email subject to be used in resulting email | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Text_Only | Bool | False | | No | Should be checked if email template is to be sent in text only | | Type | String | False | | No | Type of the email template | [Return to Top](#objects-supported) ## EmbeddedFiles | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | File_Mime_Type | String | False | | No | | | Filename | String | True | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## Employees | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------------- | | Accept_Status_Calls | String | False | | No | | | Accept_Status_Id | String | False | | No | | | Accept_Status_Meetings | String | False | | No | | | Accept_Status_Messages | String | False | | No | | | Accept_Status_Name | String | False | | No | | | Acl_Role_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Address_City | String | False | | No | | | Address_Country | String | False | | No | | | Address_Postalcode | String | False | | No | | | Address_State | String | False | | No | | | Address_Street | String | False | | No | | | Authenticate_Id | String | False | | No | | | Business_Center_Id | String | False | | No | The business center to which the case is associated | | Business_Center_Name | String | True | | No | The name of the business center represented by the business_center_id field | | C_Accept_Status_Fields | String | True | | No | | | Cookie_Consent | Bool | False | | No | Indicator whether this user accepts cookies | | Cookie_Consent_Received_On | Datetime | False | | No | Date cookie consent received on | | Created_By | String | True | | No | | | Created_By_Name | String | True | | No | | | Customer_Journey_Access | Bool | True | | No | | | Customer_Journey_Last_Active | Datetime | True | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Default_Team | String | False | | No | | | Deleted | Bool | False | | No | | | Department | String | False | | No | | | Description | String | False | | No | | | Email | String | False | | No | | | Email_Link_Type | String | False | | No | | | Email1 | String | False | | No | | | Employee_Status | String | False | | No | | | External_Auth_Only | Bool | False | | No | | | First_Name | String | False | | No | | | Full_Name | String | True | | No | | | Id [KEY] | String | True | | No | | | Is_Admin | Bool | False | | No | | | Is_Group | Bool | False | | No | | | Last_Login | Datetime | True | | No | | | Last_Name | String | False | | No | | | License_Type | String | False | | No | | | M_Accept_Status_Fields | String | True | | No | | | Messenger_Id | String | False | | No | | | Messenger_Type | String | False | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | True | | No | | | Phone_Fax | String | False | | No | | | Phone_Home | String | False | | No | | | Phone_Mobile | String | False | | No | | | Phone_Other | String | False | | No | | | Phone_Work | String | False | | No | | | Picture | String | False | | No | | | Portal_Only | Bool | False | | No | | | Preferred_Language | String | False | | No | | | Pwd_Last_Changed | Datetime | False | | No | | | Receive_Notifications | Bool | False | | No | | | Reports_To_Id | String | False | | No | | | Reports_To_Name | String | True | | No | | | Send_Email_On_Mention | Bool | False | | No | | | Show_On_Employees | Bool | False | | No | | | Site_User_Id | String | True | | No | | | Status | String | False | | No | | | Sugar_Login | Bool | False | | No | | | Sync_Key | String | True | | No | | | System_Generated_Password | Bool | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Title | String | False | | No | | | User_Hash | String | True | | No | | | User_Name | String | False | | No | | | Usertype | String | False | | No | | [Return to Top](#objects-supported) ## Escalations | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Escalation_Number | Int | False | | No | Visual unique identifier | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Parent_Id | String | False | | No | The ID of the parent Sugar object identified by parent_type | | Parent_Name | String | False | | No | | | Parent_Type | String | False | | No | The Sugar object to which the call is related | | Reason | String | False | | No | The reason given for the escalation | | Source | String | False | | No | The source of the escalation | | Status | String | False | | No | The status of the escalation | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## ExternalUsers | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------- | -------- | -------- | ---------- | ---------- | ---------------------------------------------------- | | Salutation | String | False | | No | Contact salutation (e.g., Mr, Ms) | | First_Name | String | False | | No | First name of the contact | | Last_Name | String | False | | No | Last name of the contact | | Name | String | False | | No | | | Full_Name | String | True | | No | | | Title | String | False | | No | The title of the contact | | Facebook | String | False | | No | The facebook name of the user | | Twitter | String | False | | No | The twitter name of the user | | Googleplus | String | False | | No | The google plus id of the user | | Department | String | False | | No | The department of the contact | | Do_Not_Call | Bool | False | | No | An indicator of whether contact can be called | | Phone_Home | String | False | | No | Home phone number of the contact | | Phone_Mobile | String | False | | No | Mobile phone number of the contact | | Phone_Work | String | False | | No | Work phone number of the contact | | Phone_Other | String | False | | No | Other phone number for the contact | | Phone_Fax | String | False | | No | Contact fax number | | Primary_Address_Street | String | False | | No | The street address used for primary address | | Primary_Address_Street_2 | String | False | | No | | | Primary_Address_Street_3 | String | False | | No | | | Primary_Address_City | String | False | | No | City for primary address | | Primary_Address_State | String | False | | No | State for primary address | | Primary_Address_Postalcode | String | False | | No | Postal code for primary address | | Primary_Address_Country | String | False | | No | Country for primary address | | Alt_Address_Street | String | False | | No | Street address for alternate address | | Alt_Address_Street_2 | String | False | | No | | | Alt_Address_Street_3 | String | False | | No | | | Alt_Address_City | String | False | | No | City for alternate address | | Alt_Address_State | String | False | | No | State for alternate address | | Alt_Address_Postalcode | String | False | | No | Postal code for alternate address | | Alt_Address_Country | String | False | | No | Country for alternate address | | Assistant | String | False | | No | Name of the assistant of the contact | | Assistant_Phone | String | False | | No | Phone number of the assistant of the contact | | Picture | String | False | | No | Avatar | | Id [KEY] | String | False | | No | Unique identifier | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Modified_User_Id | String | True | | No | User who last modified record | | Modified_By_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Description | String | False | | No | Full text of the note | | Deleted | Bool | False | | No | Record deletion indicator | | User_Name | String | False | | No | Username of the external user | | Status | String | False | | No | Status of the external user | | External_App | String | False | | No | External application which creates the external user | | External_Id | String | False | | No | External id of the external user | | Contact_Name | String | True | | No | | | Contact_Id | String | False | | No | Contact ID the external user is associated with | | Email | String | False | | No | | | Email1 | String | False | | No | | | Email2 | String | False | | No | | | Invalid_Email | Bool | False | | No | | | Email_Opt_Out | Bool | False | | No | | | Email_Addresses_Non_Primary | String | False | | No | | | Tag | String | False | | No | | | Source_Id | String | False | | No | | | Source_Type | String | False | | No | | | Source_Meta | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Team_Count | String | False | | No | | | Team_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Following | Bool | False | | No | Is user following this record | | My_Favorite | Bool | False | | No | Favorite for the user | | Commentlog | String | True | | No | | | Locked_Fields | String | True | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## Filters | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | App | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Filter_Definition | String | False | | No | | | Filter_Template | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Module_Name | String | False | | No | | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## ForecastManagerWorksheets | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Best_Case | Decimal | True | | No | | | Best_Case_Adjusted | Decimal | True | | No | | | Closed_Amount | Decimal | True | | No | Total of closed won items in the forecast | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Draft | Bool | False | | No | | | Draft_Save_Type | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Is_Manager | Bool | False | | No | needed for commitLog field logic | | Likely_Case | Decimal | True | | No | | | Likely_Case_Adjusted | Decimal | True | | No | | | Locked_Fields | String | True | | No | | | Manager_Saved | Bool | False | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Opp_Count | Int | True | | No | Number of opportunities represented by this forecast | | Pipeline_Amount | Decimal | True | | No | Total of opportunities minus closed won/closed lost represented by this forecast | | Pipeline_Opp_Count | Int | True | | No | Number of opportunities minus closed won/closed lost represented by this forecast | | Quota | Decimal | True | | No | | | Show_History_Log | Int | True | | No | | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Timeperiod_Id | String | False | | No | | | User_Id | String | False | | No | | | Worst_Case | Decimal | True | | No | | | Worst_Case_Adjusted | Decimal | True | | No | | [Return to Top](#objects-supported) ## Forecasts | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------------------------------- | | Base_Rate | String | False | | No | | | Best_Case | Decimal | True | | No | Best case forecast amount | | Closed_Amount | Decimal | True | | No | Total of closed won items in the forecast | | Closed_Count | Int | True | | No | This is used by the commit code to determine how many closed opps exist for the pipeline calc | | Commit_Type | String | True | | No | This is used by the commit code to figure out what type of worksheet we are committing | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record modified | | Deleted | Bool | False | | No | Record deletion indicator | | End_Date | Date | False | | No | | | Forecast_Type | String | False | | No | Indicator of whether forecast is direct or rollup | | Id [KEY] | String | True | | No | Unique identifier | | Likely_Case | Decimal | True | | No | Likely case forecast amount | | Name | String | False | | No | | | Opp_Count | Int | True | | No | Number of opportunities represented by this forecast | | Opp_Weigh_Value | Int | True | | No | Weighted amount of all opportunities represented by this forecast | | Pipeline_Amount | Decimal | True | | No | Total of opportunities minus closed won/closed lost represented by this forecast | | Pipeline_Opp_Count | Int | True | | No | Number of opportunities minus closed won/closed lost represented by this forecast | | Reports_To_User_Name | String | True | | No | | | Start_Date | Date | False | | No | | | Timeperiod_Id | String | False | | No | ID of the associated time period for this forecast | | User_Id | String | False | | No | User to which this forecast pertains | | User_Name | String | True | | No | | | Worst_Case | Decimal | True | | No | Worst case likely amount | [Return to Top](#objects-supported) ## ForecastWorksheets | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------ | | Account_Id | String | False | | No | | | Account_Name | String | True | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Best_Case | Decimal | True | | No | | | Campaign_Id | String | False | | No | | | Campaign_Name | String | True | | No | | | Category_Id | String | False | | No | | | Category_Name | String | True | | No | | | Commit_Stage | String | False | | No | Forecast commit ranges: Include, Likely, Omit etc. | | Cost_Price | Decimal | True | | No | Product cost ( | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Closed | Date | False | | No | Expected or actual date the oppportunity will close | | Date_Closed_Timestamp | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Discount_Amount | Decimal | True | | No | Discounted amount | | Discount_Price | Decimal | True | | No | Discounted price ( | | Draft | Int | True | | No | Is A Draft Version | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Lead_Source | String | False | | No | Source of the product | | Likely_Case | Decimal | True | | No | | | List_Price | Decimal | True | | No | List price of product ( | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Next_Step | String | False | | No | The next step in the sales process | | Opportunity_Id | String | False | | No | | | Opportunity_Name | String | True | | No | | | Parent_Deleted | Int | True | | No | Is Parent Deleted | | Parent_Id | String | False | | No | Account ID of the parent of this account | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | Sugar module the Worksheet is associated with | | Probability | Int | True | | No | The probability of closure | | Product_Template_Id | String | False | | No | | | Product_Template_Name | String | True | | No | | | Product_Type | String | False | | No | Type of product ( from opportunities opportunity_type ex: Existing, New) | | Quantity | Int | True | | No | Quantity in use | | Sales_Stage | String | False | | No | Indication of progression towards closure | | Sales_Status | String | False | | No | | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Total_Amount | Decimal | True | | No | | | Worst_Case | Decimal | True | | No | | [Return to Top](#objects-supported) ## Geocode | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ------------------------- | | Address | String | False | | No | | | Country | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Error_Message | String | False | | No | | | Geocoded | Bool | False | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Latitude | Decimal | True | | No | | | Longitude | Decimal | True | | No | | | Parent_Id | String | False | | No | | | Parent_Name | String | False | | No | | | Parent_Type | String | False | | No | | | Parent_User_Name | String | False | | No | | | Postalcode | String | False | | No | | | Status | String | False | | No | | [Return to Top](#objects-supported) ## HintAccountsets | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Category | String | False | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Targets | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Type | String | False | | No | | [Return to Top](#objects-supported) ## HintEnrichFieldConfigs | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Config_Data | String | False | | No | | | Created | Datetime | False | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Synced | Bool | False | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## HintNewsNotifications | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Article_Date | Datetime | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Category | String | False | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Photo_Url | String | False | | No | | | Publisher | String | False | | No | | | Source_Url | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Title | String | False | | No | | [Return to Top](#objects-supported) ## HintNotificationTargets | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Credentials | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Type | String | False | | No | | [Return to Top](#objects-supported) ## Holidays | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------- | -------- | -------- | ---------- | ---------- | ------------------------- | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | | | Description | String | False | | No | | | Holiday_Date | Date | False | | No | | | Id [KEY] | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | False | | No | | | Person_Id | String | False | | No | | | Person_Type | String | False | | No | | | Related_Module | String | False | | No | | | Related_Module_Id | String | False | | No | | | Resource_Name | String | False | | No | | [Return to Top](#objects-supported) ## InboundEmail | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------ | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Auth_Type | String | True | | No | | | Authorized_Account | String | True | | No | | | Created_By | String | True | | No | User who created record | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Delete_Seen | Bool | False | | No | Delete email from server once read (seen) | | Deleted | Bool | False | | No | Record deltion indicator | | Eapm_Id | String | True | | No | | | Email_Password | String | False | | No | Password of user identified by email_user | | Email_Provider | String | False | | No | | | Email_User | String | False | | No | User name allowed access to mail server | | Group_Id | String | False | | No | Group ID (unused) | | Groupfolder_Id | String | False | | No | Unique identifier | | Id [KEY] | String | True | | No | Unique identifier | | Is_Personal | Bool | False | | No | Personal account flag | | Mailbox | String | False | | No | | | Mailbox_Type | String | False | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Name | String | False | | No | Name given to the inbound email mailbox | | Port | Int | False | | No | Port used to access mail server | | Server_Url | String | False | | No | Mail server URL | | Service | String | False | | No | | | Status | String | False | | No | Status of the inbound email mailbox (ex: Active or Inactive) | | Stored_Options | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Template_Id | String | False | | No | Template used for auto-reply | [Return to Top](#objects-supported) ## KBArticles | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Kbdocument_Id | String | False | | No | | | Kbdocument_Name | String | True | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## KBContents | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Active_Date | Date | False | | No | | | Active_Rev | String | True | | No | Active revision flag | | Approved | Bool | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Attachment_List | String | True | | No | | | Category_Id | String | False | | No | Category ID | | Category_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Exp_Date | Date | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Is_External | String | True | | No | External article flag | | Kbarticle_Id | String | False | | No | | | Kbarticle_Name | String | True | | No | | | Kbdocument_Body | String | True | | No | Article body | | Kbdocument_Id | String | False | | No | | | Kbdocument_Name | String | True | | No | | | Kbsapprover_Id | String | False | | No | User who approved article | | Kbsapprover_Name | String | True | | No | | | Kbscase_Id | String | False | | No | Related case | | Kbscase_Name | String | True | | No | | | Language | String | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Notuseful | Int | True | | No | | | Related_Languages | String | False | | No | | | Revision | Int | True | | No | | | Status | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Useful | Int | True | | No | | | Usefulness_User_Vote | String | True | | No | | | Viewcount | Int | True | | No | | [Return to Top](#objects-supported) ## KBContentTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Body | String | True | | No | Template body | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## KBDocuments | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## Leads | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------------- | | Accept_Status_Calls | String | False | | No | | | Accept_Status_Id | String | False | | No | | | Accept_Status_Meetings | String | False | | No | | | Accept_Status_Messages | String | False | | No | | | Accept_Status_Name | String | False | | No | | | Account_Description | String | False | | No | Description of lead account | | Account_Id | String | False | | No | If converted, Account ID resulting from the conversion | | Account_Name | String | False | | No | Account name for lead | | Account_To_Lead | String | True | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Ai_Conv_Bin_Accuracy | Decimal | True | | No | | | Ai_Conv_Multiplier | Decimal | True | | No | | | Ai_Conv_Score_Absolute | Decimal | True | | No | | | Ai_Conv_Score_Classification | String | True | | No | | | Ai_Icp_Fit_Bin_Accuracy | Decimal | True | | No | | | Ai_Icp_Fit_Multiplier | Decimal | True | | No | | | Ai_Icp_Fit_Score_Absolute | Decimal | True | | No | | | Ai_Icp_Fit_Score_Classification | String | True | | No | | | Alt_Address_City | String | False | | No | City for alternate address | | Alt_Address_Country | String | False | | No | Country for alternate address | | Alt_Address_Postalcode | String | False | | No | Postal code for alternate address | | Alt_Address_State | String | False | | No | State for alternate address | | Alt_Address_Street | String | False | | No | Street address for alternate address | | Alt_Address_Street_2 | String | False | | No | | | Alt_Address_Street_3 | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Assistant | String | False | | No | Name of the assistant of the contact | | Assistant_Phone | String | False | | No | Phone number of the assistant of the contact | | Base_Rate | Decimal | False | | No | | | Birthdate | Date | False | | No | The birthdate of the contact | | Brand_C | String | False | | No | | | Business_Center_Id | String | False | | No | The business center to which the case is associated | | Business_Center_Name | String | True | | No | The name of the business center represented by the business_center_id field | | C_Accept_Status_Fields | String | True | | No | | | Campaign_Id | String | False | | No | Campaign that generated lead | | Campaign_Name | String | True | | No | | | Classification_C | String | False | | No | | | Commentlog | String | True | | No | | | Contact_Id | String | False | | No | If converted, Contact ID resulting from the conversion | | Contact_Name | String | True | | No | | | Converted | Bool | False | | No | Has Lead been converted to a Contact (and other Sugar objects) | | Converted_Opp_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Dead_End_Other_C | String | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Department | String | False | | No | Department the lead belongs to | | Description | String | False | | No | Full text of the note | | Dnb_Principal_Id | String | False | | No | Unique Id For DB Contact | | Do_Not_Call | Bool | False | | No | An indicator of whether contact can be called | | Dp_Business_Purpose | String | True | | No | Business purposes consented for | | Dp_Consent_Last_Updated | Date | False | | No | Date consent last updated | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | True | | No | | | Email | String | False | | No | | | Email_Addresses_Non_Primary | String | False | | No | | | Email_Opt_Out | Bool | False | | No | | | Email1 | String | False | | No | | | Email2 | String | False | | No | | | Estimate_Remittance_C | Decimal | False | | No | | | Facebook | String | False | | No | The facebook name of the user | | First_Name | String | False | | No | First name of the contact | | Following | Bool | False | | No | Is user following this record | | Full_Name | String | True | | No | | | Googleplus | String | False | | No | The google plus id of the user | | Hint_Account_Annual_Revenue | String | False | | No | Annual Rev | | Hint_Account_Description | String | False | | No | Company Description | | Hint_Account_Facebook_Handle | String | False | | No | company facebook | | Hint_Account_Fiscal_Year_End | String | False | | No | FY End | | Hint_Account_Founded_Year | String | False | | No | company founded year | | Hint_Account_Industry | String | False | | No | Company Industry | | Hint_Account_Location | String | False | | No | Company Location | | Hint_Account_Logo | String | False | | No | company logo | | Hint_Account_Naics_Code_Lbl | String | False | | No | NAICS Code | | Hint_Account_Sic_Code_Label | String | False | | No | SIC Code | | Hint_Account_Size | String | False | | No | Company Size | | Hint_Account_Twitter_Handle | String | False | | No | company twitter | | Hint_Account_Website | String | False | | No | company website | | Hint_Contact_Pic | String | False | | No | Hint Contact logo | | Hint_Education | String | False | | No | Education | | Hint_Education_2 | String | False | | No | Education 2 | | Hint_Facebook | String | False | | No | | | Hint_Industry_Tags | String | False | | No | industry tags | | Hint_Job_2 | String | False | | No | Job 2 | | Hint_Phone_1 | String | False | | No | extra phone field | | Hint_Phone_2 | String | False | | No | extra phone field | | Hint_Photo | String | False | | No | person photo | | Hint_Twitter | String | False | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Invalid_Email | Bool | False | | No | | | Last_Name | String | False | | No | Last name of the contact | | Lead_Source | String | False | | No | Lead source (ex: Web, print) | | Lead_Source_Description | String | False | | No | Description of the lead source | | Locked_Fields | String | True | | No | | | M_Accept_Status_Fields | String | True | | No | | | Market_Interest_Prediction_Score | String | True | | No | | | Market_Score | Int | True | | No | | | Mkto_Id | Int | True | | No | Associated Marketo Lead ID | | Mkto_Lead_Score | Int | True | | No | | | Mkto_Sync | Bool | False | | No | Should the Lead be synced to Marketo | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | True | | No | | | Opportunity_Amount | String | False | | No | Amount of the opportunity | | Opportunity_Id | String | False | | No | If converted, Opportunity ID resulting from the conversion | | Opportunity_Name | String | False | | No | Opportunity name associated with lead | | Other_Underwriter_Notes_C | String | False | | No | | | Perform_Sugar_Action | Bool | False | | No | | | Phone_Fax | String | False | | No | Contact fax number | | Phone_Home | String | False | | No | Home phone number of the contact | | Phone_Mobile | String | False | | No | Mobile phone number of the contact | | Phone_Other | String | False | | No | Other phone number for the contact | | Phone_Work | String | False | | No | Work phone number of the contact | | Picture | String | False | | No | Avatar | | Portal_App | String | False | | No | Portal application that resulted in created of lead | | Portal_Name | String | False | | No | Portal user name when lead created via lead portal | | Preferred_Language | String | False | | No | | | Primary_Address_City | String | False | | No | City for primary address | | Primary_Address_Country | String | False | | No | Country for primary address | | Primary_Address_Postalcode | String | False | | No | Postal code for primary address | | Primary_Address_State | String | False | | No | State for primary address | | Primary_Address_Street | String | False | | No | The street address used for primary address | | Primary_Address_Street_2 | String | False | | No | | | Primary_Address_Street_3 | String | False | | No | | | Refered_By | String | False | | No | Identifies who refered the lead | | Report_To_Name | String | True | | No | | | Reports_To_Id | String | False | | No | ID of Contact the Lead reports to | | Salutation | String | False | | No | Contact salutation (e.g., Mr, Ms) | | Status | String | False | | No | Status of the lead | | Status_Description | String | False | | No | Description of the status of the lead | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Title | String | False | | No | The title of the contact | | Twitter | String | False | | No | The twitter name of the user | | Underwriters_Non_Fntg_C | String | False | | No | | | Website | String | False | | No | URL of website for the company | | Webtolead_Email_Opt_Out | Bool | False | | No | Indicator signaling if lead elects to opt out of email campaigns | | Webtolead_Email1 | String | False | | No | Main email address of lead | | Webtolead_Email2 | String | False | | No | Secondary email address of lead | | Webtolead_Invalid_Email | Bool | False | | No | Indicator that email address for lead is invalid | [Return to Top](#objects-supported) ## Manufacturers | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | List_Order | Int | True | | No | Order within list | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Status | String | False | | No | Manufacturer status | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## Meetings | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------------------------------------------------------------- | | Accept_Status | String | False | | No | | | Accept_Status_Users | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Auto_Invite_Parent | Bool | False | | No | Flag to allow for turning off auto invite of parent record - (Meta-data only) | | Base_Rate | Decimal | False | | No | | | Cj_Activity_Tpl_Name | String | True | | No | | | Cj_Actual_Sort_Order | String | False | | No | | | Cj_Allow_Activity_By | String | False | | No | | | Cj_Blocked_By_Stages | String | False | | No | | | Cj_Momentum_End_Date | Datetime | False | | No | | | Cj_Momentum_Points | Int | True | | No | | | Cj_Momentum_Ratio | Double | True | | No | | | Cj_Momentum_Score | Int | True | | No | | | Cj_Momentum_Start_Date | Datetime | False | | No | | | Cj_Parent_Activity_Id | String | False | | No | | | Cj_Parent_Activity_Type | String | False | | No | | | Cj_Url | String | False | | No | | | Commentlog | String | True | | No | | | Contact_Id | String | True | | No | | | Contact_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Creator | String | False | | No | Meeting creator | | Currency_Id | String | False | | No | | | Customer_Journey_Blocked_By | String | False | | No | | | Customer_Journey_Points | String | False | | No | | | Customer_Journey_Progress | Double | True | | No | | | Customer_Journey_Score | Int | True | | No | | | Date_End | Datetime | True | | No | Date meeting ends | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Start | Datetime | False | | No | Date of start of meeting | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Differentiating_Value_C | String | False | | No | | | Direction | String | False | | No | Indicates whether call is inbound or outbound | | Displayed_Url | String | False | | No | Meeting URL | | Dri_Subworkflow_Id | String | False | | No | | | Dri_Subworkflow_Name | String | True | | No | | | Dri_Subworkflow_Template_Id | String | False | | No | | | Dri_Subworkflow_Template_Name | String | True | | No | | | Dri_Workflow_Id | String | False | | No | | | Dri_Workflow_Name | String | True | | No | | | Dri_Workflow_Sort_Order | String | False | | No | | | Dri_Workflow_Task_Template_Id | String | False | | No | | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | True | | No | | | Duration_Hours | Int | False | | No | Duration (hours) | | Duration_Minutes | String | False | | No | Duration (minutes) | | Email_Reminder_Checked | Bool | False | | No | checkbox indicating whether or not the email reminder value is set (Meta-data only) | | Email_Reminder_Sent | Bool | False | | No | Whether email reminder is already sent | | Email_Reminder_Time | 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 | | Expense_To_Operation_C | Decimal | False | | No | | | External_Id | String | False | | No | Meeting ID for external app API | | Fnf_Agencies_Meetings_1_Name | String | True | | No | | | Fnf_Agencies_Meetings_1fnf_Agencies_Ida | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Host_Url | String | False | | No | Host URL | | Id [KEY] | String | True | | No | Unique identifier | | Internal_Notes | String | False | | No | Internal notes for the meeting | | Invitees | String | True | | No | | | Is_Cj_Parent_Activity | Bool | False | | No | | | Is_Customer_Journey_Activity | Bool | False | | No | | | Join_Url | String | False | | No | Join URL | | Location | String | False | | No | Meeting location | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Meeting name | | Outlook_Id | String | False | | No | When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item ID | | Parent_Id | String | False | | No | ID of item indicated by parent_type | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | Module meeting is associated with | | Password | String | False | | No | Meeting password | | Recurrence_Id | Datetime | False | | No | Recurrence ID of meeting. Original meeting start date | | Recurring_Source | String | False | | No | Source of recurring meeting | | Reminder_Checked | Bool | False | | No | checkbox indicating whether or not the reminder value is set (Meta-data only) | | Reminder_Time | String | False | | No | Specifies when a reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start | | Repeat_Count | Int | True | | No | Number of recurrence | | Repeat_Days | String | False | | No | Days of month | | Repeat_Dow | String | False | | No | Days of week in recurrence | | Repeat_Interval | Int | True | | No | Interval of recurrence | | Repeat_Ordinal | String | False | | No | Repeat ordinal value | | Repeat_Parent_Id | String | False | | No | Id of the first element of recurring records | | Repeat_Selector | String | False | | No | Repeat selector | | Repeat_Type | String | False | | No | Type of recurrence | | Repeat_Unit | String | False | | No | Repeat unit value | | Repeat_Until | Date | False | | No | Repeat until specified date | | Send_Invites | Bool | False | | No | checkbox indicating whether or not to send out invites (Meta-data only) | | Sequence | Int | True | | No | Meeting update sequence for meetings as per iCalendar standards | | Set_Accept_Links | String | False | | No | | | Start_Next_Journey_Id | String | False | | No | | | Status | String | False | | No | Meeting status (ex: Planned, Held, Not held) | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Type | String | False | | No | Meeting type (ex: WebEx, Other) | | Type_Of_Meeting_C | String | False | | No | | [Return to Top](#objects-supported) ## Messages | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------- | | Accept_Status | String | False | | No | | | Accept_Status_Users | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Aws_Comprehend_Data | String | False | | No | Raw data from the aws comprehend service | | Aws_Contact_Id | String | True | | No | The AWS Connect Contact ID | | Channel_Type | String | False | | No | | | Commentlog | String | True | | No | | | Contact_Id | String | False | | No | | | Contact_Name | String | True | | No | | | Conversation | String | True | | No | | | Conversation_Link | String | False | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_End | Datetime | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Start | Datetime | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Direction | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Invitee_Contact_Id | String | True | | No | | | Invitee_Contact_Name | String | True | | No | | | Invitee_Lead_Id | String | True | | No | | | Invitee_Lead_Name | String | True | | No | | | Invitees | String | True | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Parent_Id | String | False | | No | The ID of the Sugar item specified in parent_type | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | Sugar module the Message is associated with | | Sentiment | String | False | | No | The sentiment string value (e.g POSITIVE, NEGATIVE, NEUTRAL, MIXED) | | Status | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Sentiment | String | False | | No | The sentiment string value (e.g POSITIVE, NEGATIVE, NEUTRAL, MIXED) | [Return to Top](#objects-supported) ## Metrics | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------------- | -------- | -------- | ---------- | ---------- | -------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Filter_Def | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Freeze_First_Column | Bool | False | | No | Decides if the first column should be frozen | | Id [KEY] | String | True | | No | Unique identifier | | Labels | String | False | | No | | | Metric_Context | String | False | | No | | | Metric_Module | String | False | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Order_By_Primary | String | False | | No | | | Order_By_Primary_Direction | String | False | | No | | | Order_By_Secondary | String | False | | No | | | Order_By_Secondary_Direction | String | False | | No | | | Status | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Viewdefs | String | False | | No | | [Return to Top](#objects-supported) ## MobileDevices | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Device_Id | String | False | | No | | | Device_Platform | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## Notes | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------------------------- | | Acase_Id | String | False | | No | | | Account_Id | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Attachment_Flag | Bool | True | | No | Identify this note as an attachment to another record | | Attachment_List | String | True | | No | | | Base_Rate | Decimal | False | | No | | | Commentlog | String | True | | No | | | Contact_Email | String | False | | No | | | Contact_Id | String | False | | No | Contact ID note is associated with | | Contact_Name | String | True | | No | | | Contact_Phone | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Email_Id | String | False | | No | Email or EmailTemplate ID to which this note is attached | | Email_Type | String | False | | No | The module of the record to which this note's file is attached (Emails or EmailTemplates) | | Embed_Flag | Bool | False | | No | Embed flag indicator determines if note embedded in email | | Entry_Source | String | True | | No | Determines if a record was created internal to the system or external to the system | | Expense_To_Operation_C | Decimal | False | | No | | | External_Id | String | False | | No | External id of the external user | | File_Ext | String | False | | No | | | File_Mime_Type | String | False | | No | Attachment MIME type | | File_Size | Int | True | | No | Attachment File Size | | File_Source | String | False | | No | The name of the module where the attachment originated | | File_Url | String | False | | No | Path to file (can be URL) | | Filename | String | True | | No | File name associated with the note (attachment) | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Lead_Id | String | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Name of the note | | Note_Parent_Id | String | False | | No | The parent Note ID | | Opportunity_Id | String | False | | No | | | Parent_Id | String | False | | No | The ID of the Sugar item specified in parent_type | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | Sugar module the Note is associated with | | Portal_Flag | Bool | False | | No | Portal flag indicator determines if note created via portal | | Product_Id | String | False | | No | | | Quote_Id | String | False | | No | | | Source_Id | String | False | | No | | | Source_Meta | String | False | | No | | | Source_Type | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Upload_Id | String | False | | No | File id under uploads/ dir. Set only for email attachments | | User_Name | String | True | | No | | [Return to Top](#objects-supported) ## Notifications | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | --------------------------------------- | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | True | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Is_Read | Bool | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Parent_Id | String | False | | No | ID of item indicated by parent_type. | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | Module notification is associated with. | | Severity | String | False | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## OAuthKeys | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------- | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | C_Key | String | False | | No | Consumer public key | | C_Secret | String | False | | No | Consumer secret key | | Client_Type | String | False | | No | What type of client does this key belong to, mobile, portal, UI or other. | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Oauth_Type | String | False | | No | Is this client an OAuth1 or OAuth2 client | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## OAuthTokens | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | ------ | -------- | ---------- | ---------- | ----------------------------------------------------------- | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Callback_Url | String | False | | No | Callback URL for Authorization | | Consumer | String | False | | No | Token related to the consumer | | Consumer_Name | String | True | | No | | | Contact_Id | String | False | | No | Contact ID this oauth token is associated with (via portal) | | Contact_Name | String | True | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Download_Token | String | False | | No | A token used to download images and files. | | Expire_Ts | String | False | | No | Token expiration, defaults to -1 for no expiration date | | Id [KEY] | String | True | | No | Unique identifier | | Platform | String | False | | No | Which platform is this token attached to | | Secret | String | False | | No | Secret key | | Token_Ts | String | False | | No | Token timestamp | | Tstate | String | False | | No | Token state | | Verify | String | False | | No | Token verification info | [Return to Top](#objects-supported) ## Opportunities | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------------- | | Account_Id | String | False | | No | | | Account_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Ai_Opp_Close_Week_Scores | String | True | | No | | | Ai_Opp_Conv_Bin_Accuracy | Decimal | True | | No | | | Ai_Opp_Conv_Multiplier | Decimal | True | | No | | | Ai_Opp_Conv_Score_Absolute | Decimal | True | | No | | | Ai_Opp_Conv_Score_Enum | String | True | | No | | | Amount | Decimal | True | | No | Unconverted amount of the opportunity | | Amount_Usdollar | Decimal | True | | No | Formatted amount of the opportunity | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | True | | No | | | Best_Case | Decimal | True | | No | | | Campaign_Id | String | False | | No | Campaign that generated lead | | Campaign_Name | String | True | | No | | | Closed_Revenue_Line_Items | Int | True | | No | | | Closed_Won_Revenue_Line_Items | Int | True | | No | | | Commentlog | String | True | | No | | | Commit_Stage | String | False | | No | Forecast commit ranges: Include, Likely, Omit etc. | | Commit_Stage_Cascade | String | False | | No | | | Contact_Role | String | False | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Closed | Date | False | | No | Expected or actual date the oppportunity will close | | Date_Closed_Cascade | Date | False | | No | | | Date_Closed_Timestamp | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | True | | No | | | Following | Bool | False | | No | Is user following this record | | Forecasted_Likely | Decimal | True | | No | Rollup of included RLIs on the Opportunity | | Id [KEY] | String | True | | No | Unique identifier | | Included_Revenue_Line_Items | Int | True | | No | | | Is_Escalated | Bool | True | | No | Is this escalated? | | Lead_Source | String | False | | No | Source of the opportunity | | Locked_Fields | String | True | | No | | | Lost | Decimal | True | | No | Rollup of lost RLIs on the Opportunity | | Mkto_Id | Int | True | | No | Associated Marketo Lead ID | | Mkto_Sync | Bool | False | | No | Should the Lead be synced to Marketo | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Name of the opportunity | | Next_Step | String | False | | No | The next step in the sales process | | Opportunity_Type | String | False | | No | Type of opportunity (ex: Existing, New) | | Perform_Sugar_Action | Bool | False | | No | | | Probability | Int | True | | No | The probability of closure | | Renewal | Bool | False | | No | Indicates whether the opportunity is a renewal | | Renewal_Parent_Id | String | False | | No | | | Renewal_Parent_Name | String | True | | No | | | Sales_Stage | String | False | | No | Indication of progression towards closure | | Sales_Stage_Cascade | String | False | | No | | | Sales_Status | String | True | | No | | | Service_Duration_Unit | String | False | | No | Service duration unit: day, month, or year | | Service_Duration_Unit_Cascade | String | False | | No | | | Service_Duration_Value | Int | True | | No | Value of the service duration, if service duration is 4 Months the value is 4 | | Service_Duration_Value_Cascade | Int | True | | No | | | Service_Open_Flex_Duration_Rlis | Int | True | | No | | | Service_Open_Revenue_Line_Items | Int | True | | No | | | Service_Start_Date | Date | False | | No | Service start date field. | | Service_Start_Date_Cascade | Date | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Total_Revenue_Line_Items | Int | True | | No | | | Widget_Amount | String | True | | No | | | Widget_Date_Closed | String | True | | No | | | Widget_Sales_Stage | String | True | | No | | | Worst_Case | Decimal | True | | No | | [Return to Top](#objects-supported) ## OutboundEmail | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------- | ------ | -------- | ---------- | ---------- | ----------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Authorized_Account | String | True | | No | | | Deleted | Bool | False | | No | | | Eapm_Id | String | True | | No | | | Email_Address | String | False | | No | | | Email_Address_Id | String | False | | No | | | Id [KEY] | String | True | | No | | | Mail_Authtype | String | True | | No | | | Mail_Sendtype | String | False | | No | | | Mail_Smtpauth_Req | Bool | False | | No | | | Mail_Smtppass | String | True | | No | | | Mail_Smtpport | Int | True | | No | | | Mail_Smtpserver | String | False | | No | | | Mail_Smtpssl | String | False | | No | | | Mail_Smtptype | String | False | | No | | | Mail_Smtpuser | String | False | | No | | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Preferred_Sending_Account | Bool | False | | No | | | Reply_To_Email_Address | String | True | | No | | | Reply_To_Email_Address_Id | String | False | | No | | | Reply_To_Name | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Type | String | False | | No | | | User_Id | String | False | | No | | [Return to Top](#objects-supported) ## PdfManager | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Author | String | False | | No | | | Base_Module | String | False | | No | | | Body_Html | String | False | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Field | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Footer_Text | String | False | | No | | | Header_Logo | String | True | | No | PDF header logo | | Header_Text | String | False | | No | | | Header_Title | String | False | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Keywords | String | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Published | String | False | | No | | | Subject | String | False | | No | | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Template_Name | String | False | | No | | | Title | String | False | | No | | [Return to Top](#objects-supported) ## pmseBusinessRules | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Rst_Create_Date | Datetime | False | | No | | | Rst_Definition | String | False | | No | | | Rst_Editable | Int | True | | No | | | Rst_Filename | String | False | | No | | | Rst_Module | String | False | | No | | | Rst_Source | String | False | | No | | | Rst_Source_Definition | String | True | | No | | | Rst_Type | String | False | | No | | | Rst_Uid | String | False | | No | | | Rst_Update_Date | Datetime | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## pmseEmailsTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Module | String | False | | No | | | Body | String | False | | No | | | Body_Html | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | From_Address | String | False | | No | | | From_Name | String | False | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Published | String | False | | No | | | Subject | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Text_Only | String | True | | No | | | Type | String | False | | No | | [Return to Top](#objects-supported) ## pmseInbox | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Act_Name | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Cas_Assigned_Status | String | False | | No | | | Cas_Create_Date | Datetime | False | | No | | | Cas_Custom_Status | String | False | | No | | | Cas_Finish_Date | Datetime | False | | No | | | Cas_Id | Int | False | | No | | | Cas_Init_User | String | False | | No | | | Cas_Module | String | False | | No | | | Cas_Parent | Int | False | | No | | | Cas_Pin | String | False | | No | | | Cas_Status | String | False | | No | | | Cas_Title | String | False | | No | | | Cas_Update_Date | Datetime | False | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Pro_Id | String | False | | No | | | Pro_Title | String | False | | No | | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## pmseProject | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Prj_Author | String | False | | No | | | Prj_Author_Version | String | False | | No | | | Prj_Exporter | String | False | | No | | | Prj_Exporter_Version | String | False | | No | | | Prj_Expression_Language | String | False | | No | | | Prj_Module | String | False | | No | | | Prj_Original_Source | String | False | | No | | | Prj_Run_Order | Int | True | | No | | | Prj_Status | String | False | | No | Process Definition status (ex: Enabled, Disabled) | | Prj_Target_Namespace | String | False | | No | | | Prj_Type_Language | String | False | | No | | | Prj_Uid | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## ProductBundleNotes | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Created_By | String | True | | No | User who created record | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | True | | No | Note content | | Id [KEY] | String | True | | No | Unique identifier | | Modified_User_Id | String | True | | No | User who last modified record | | Position | Int | True | | No | | [Return to Top](#objects-supported) ## ProductBundles | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Base_Rate | String | False | | No | | | Bundle_Stage | String | False | | No | Processing stage of the group (ex: Draft) | | Created_By | String | True | | No | User who created record | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deal_Tot | Decimal | True | | No | discount amount | | Deal_Tot_Usdollar | Decimal | True | | No | discount amount | | Default_Group | Bool | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Group description | | Id [KEY] | String | True | | No | Unique identifier | | Modified_User_Id | String | True | | No | User who last modified record | | Name | String | False | | No | Name of the group | | New_Sub | Decimal | True | | No | Group total minus discount and tax and shipping | | New_Sub_Usdollar | Decimal | True | | No | Group total minus discount and tax and shipping | | Position | Int | True | | No | | | Product_Bundle_Items | String | True | | No | | | Shipping | Decimal | True | | No | Shipping charge for group | | Shipping_Usdollar | Decimal | True | | No | Shipping charge for group in USD | | Subtotal | Decimal | True | | No | Group total minus tax and shipping | | Subtotal_Usdollar | Decimal | True | | No | Group total minus tax and shipping in USD | | Sync_Key | String | True | | No | | | Tax | Decimal | True | | No | Tax rate applied to items in the group | | Tax_Usdollar | Decimal | True | | No | Total tax for all items in group in USD | | Taxable_Subtotal | Decimal | True | | No | Rollup of all products marked as Taxable | | Taxrate_Id | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Total | Decimal | True | | No | Total amount for all items in the group | | Total_Usdollar | Decimal | True | | No | Total amount for all items in the group in USD | [Return to Top](#objects-supported) ## ProductCategories | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------ | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | List_Order | Int | True | | No | Order within list | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Parent_Id | String | False | | No | Parent category of this item; used for multi-tiered categorization | | Parent_Name | String | True | | No | | | Sync_Key | String | True | | No | | | Type | String | False | | No | | [Return to Top](#objects-supported) ## Products | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------ | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------------------------------------------------------- | | Account_Id | String | True | | No | Account this product is associated with | | Account_Name | String | True | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Add_On_To_Id | String | False | | No | Purchased line item that this is an add-on to | | Add_On_To_Name | String | True | | No | | | Asset_Number | String | False | | No | Asset tag number of sales item in use | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Book_Value | Decimal | True | | No | Book value of sales item in use | | Book_Value_Date | Date | False | | No | Date of book value for sales item in use | | Book_Value_Usdollar | Decimal | True | | No | Book value expressed in USD | | Campaign_Id | String | False | | No | Campaign that generated lead | | Campaign_Name | String | True | | No | | | Catalog_Service_Duration_Unit | String | True | | No | Stores a Product Catalog item's Service Duration Unit, used for duration comparisons | | Catalog_Service_Duration_Value | Int | True | | No | Stores a Product Catalog item's Service Duration Value, used for duration comparisons | | Category_Id | String | False | | No | Product category | | Category_Name | String | True | | No | | | Commentlog | String | True | | No | | | Contact_Id | String | False | | No | Contact this product is associated with | | Contact_Name | String | True | | No | | | Cost_Price | Decimal | True | | No | Product cost ( | | Cost_Usdollar | Decimal | True | | No | Cost expressed in USD | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Closed | Date | False | | No | Expected or actual date the product (for opportunity) will close | | Date_Closed_Timestamp | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Purchased | Date | False | | No | Date sales item purchased | | Date_Support_Expires | Date | False | | No | Support expiration date | | Date_Support_Starts | Date | False | | No | Support start date | | Deal_Calc | Decimal | True | | No | deal_calc | | Deal_Calc_Usdollar | Decimal | True | | No | deal_calc_usdollar | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Discount_Amount | String | True | | No | Discounted amount | | Discount_Amount_Signed | Decimal | True | | No | Discounted Amount Signed | | Discount_Amount_Usdollar | Decimal | True | | No | | | Discount_Price | Decimal | True | | No | Discounted price ( | | Discount_Rate_Percent | Decimal | True | | No | | | Discount_Select | Bool | False | | No | | | Discount_Usdollar | Decimal | True | | No | Discount price expressed in USD | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | List_Price | Decimal | True | | No | List price of sales item | | List_Usdollar | Decimal | True | | No | List price expressed in USD | | Lock_Duration | Bool | False | | No | Turn on or off a user ability to directly edit the duration field | | Locked_Fields | String | True | | No | | | Manufacturer_Id | String | False | | No | Manufacturer of product | | Manufacturer_Name | String | True | | No | | | Mft_Part_Num | String | False | | No | Manufacturer part number | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Name of the product | | Next_Step | String | False | | No | The next step in the sales process | | Opportunity_Id | String | False | | No | The opportunity id for the line item entry | | Opportunity_Name | String | True | | No | The opportunity name associated with the opportunity_id | | Parent_Rli_Id | String | False | | No | RLI this product was generated from | | Parent_Rli_Name | String | True | | No | | | Position | Int | True | | No | | | Pricing_Factor | Int | True | | No | Variable pricing factor depending on pricing_formula | | Pricing_Formula | String | False | | No | Pricing formula (ex: Fixed, Markup over Cost) | | Product_Template_Id | String | False | | No | Product (in Admin Products) from which this product is derived (in user Products) | | Product_Template_Name | String | True | | No | | | Quantity | Decimal | True | | No | Quantity in use | | Quote_Id | String | False | | No | If product created via Quote, this is quote ID | | Quote_Name | String | True | | No | Quote Name | | Renewable | Bool | False | | No | Indicates whether the sales item is renewable (e.g. a service) | | Renewal | Bool | True | | No | Indicates whether this line item is a renewal | | Revenuelineitem_Id | String | False | | No | Associated Revenue Line Item that served as the source. | | Revenuelineitem_Name | String | True | | No | | | Serial_Number | String | False | | No | Serial number of sales item in use | | Service | Bool | False | | No | Indicates whether the sales item is a service or a product | | Service_Duration_Multiplier | Decimal | True | | No | Stores a multiplier based on the ratio of this sales item's duration to another duration (such as a Product Template's) | | Service_Duration_Unit | String | False | | No | Service Duration unit like Year(s), Month(s) or Day(s) | | Service_Duration_Value | Int | True | | No | Value of the service duration, if service duration is 4 Months the value is 4 | | Service_End_Date | String | True | | No | End date of the service | | Service_Start_Date | Date | False | | No | Start date of the service | | Status | String | False | | No | Product status (ex: Quoted, Ordered, Shipped) | | Subtotal | Decimal | True | | No | The total of the line item before any discounts are applied, taking proration into consideration | | Support_Contact | String | False | | No | Contact for support purposes | | Support_Description | String | False | | No | Description of sales item for support purposes | | Support_Name | String | False | | No | Name of sales item for support purposes | | Support_Term | String | False | | No | Term (length) of support contract | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Tax_Class | String | False | | No | Tax classification (ex: Taxable, Non-taxable) | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Total_Amount | Decimal | True | | No | | | Type_Id | String | False | | No | Product type (ex: hardware, software) | | Type_Name | String | True | | No | | | Vendor_Part_Num | String | False | | No | Vendor part number | | Website | String | False | | No | Sales item URL | | Weight | Decimal | True | | No | Weight of the sales item | [Return to Top](#objects-supported) ## ProductTemplates | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Active_Status | String | False | | No | Active status (ex: Active, Inactive or Retired) | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Category_Id | String | False | | No | Category of the product | | Category_Name | String | True | | No | | | Commentlog | String | True | | No | | | Cost_Price | Decimal | False | | No | Product cost ( | | Cost_Usdollar | Decimal | True | | No | Cost expressed in USD | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Available | Date | False | | No | Availability date | | Date_Cost_Price | Date | False | | No | Starting date cost price is valid | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Discount_Price | Decimal | False | | No | Discounted price ( | | Discount_Usdollar | Decimal | True | | No | Discount price expressed in USD | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | List_Price | Decimal | False | | No | List price of product ( | | List_Usdollar | Decimal | True | | No | List price expressed in USD | | Lock_Duration | Bool | False | | No | Indicates whether the duration can be manually changed | | Locked_Fields | String | True | | No | | | Manufacturer_Id | String | False | | No | Manufacturer of the product | | Manufacturer_Name | String | True | | No | | | Mft_Part_Num | String | False | | No | Manufacturer part number | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Pricing_Factor | Decimal | True | | No | Variable pricing factor depending on pricing_formula | | Pricing_Formula | String | True | | No | Pricing formula (ex: Fixed, Markup over Cost) | | Qty_In_Stock | Int | True | | No | Quantity on hand | | Renewable | Bool | False | | No | Indicates whether the sales item is renewable (e.g. a service) | | Service | Bool | False | | No | Indicates whether the sales item is a service or a product | | Service_Duration_Unit | String | False | | No | Service Duration unit like Year(s), Month(s) or Day(s) | | Service_Duration_Value | Int | True | | No | Value of the service duration, if service duration is 4 Months the value is 4 | | Status | String | False | | No | Product status (not used in product Catalog) | | Support_Contact | String | False | | No | Contact for support purposes | | Support_Description | String | False | | No | Description of product for support purposes | | Support_Name | String | False | | No | Name of product for support purposes | | Support_Term | String | False | | No | Term (length) of support contract | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Tax_Class | String | False | | No | Tax classification (ex: Taxable, Non-taxable) | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Type_Id | String | False | | No | Product type (ex: hardware, software) | | Type_Name | String | True | | No | | | Vendor_Part_Num | String | False | | No | Vendor part number | | Website | String | False | | No | Product URL | | Weight | Decimal | True | | No | Weight of the product | [Return to Top](#objects-supported) ## ProductTypes | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Product type description | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | List_Order | Int | False | | No | Order within list | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## Project | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------- | -------- | -------- | ---------- | ---------- | ---------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User assigned to this record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Project description | | Estimated_End_Date | Date | False | | No | | | Estimated_Start_Date | Date | False | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Is_Template | Bool | False | | No | Should be checked if the project is a template | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Name | String | False | | No | Project name | | Priority | String | False | | No | | | Status | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Total_Actual_Effort | Int | True | | No | | | Total_Estimated_Effort | Int | True | | No | | [Return to Top](#objects-supported) ## ProjectTask | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Actual_Duration | Int | True | | No | | | Actual_Effort | Int | True | | No | | | Assigned_User_Id | String | False | | No | | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | | | Created_By_Name | String | True | | No | | | Date_Due | Date | False | | No | | | Date_Entered | Datetime | True | | No | | | Date_Finish | Date | False | | No | | | Date_Modified | Datetime | True | | No | | | Date_Start | Date | False | | No | | | Deleted | Bool | False | | No | | | Description | String | False | | No | | | Duration | Int | False | | No | | | Duration_Unit | String | False | | No | | | Estimated_Effort | Int | True | | No | | | Id [KEY] | String | True | | No | | | Milestone_Flag | Bool | False | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | False | | No | | | Order_Number | Int | True | | No | | | Parent_Task_Id | Int | True | | No | | | Percent_Complete | Int | True | | No | | | Predecessors | String | False | | No | | | Priority | String | False | | No | | | Project_Id | String | False | | No | | | Project_Name | String | True | | No | | | Project_Task_Id | Int | True | | No | | | Resource_Id | String | False | | No | | | Resource_Name | String | False | | No | | | Status | String | False | | No | | | Task_Number | Int | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Time_Due | String | True | | No | | | Time_Finish | Int | True | | No | | | Time_Start | Int | True | | No | | | Utilization | Int | True | | No | | [Return to Top](#objects-supported) ## ProspectLists | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | -------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | Description | String | False | | No | | | Domain_Name | String | False | | No | | | Entry_Count | Int | True | | No | | | Id [KEY] | String | True | | No | | | List_Type | String | False | | No | | | Marketing_Id | String | False | | No | | | Marketing_Name | String | False | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | False | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## PubSubModuleEventPushSubs | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Expiration_Date | Datetime | False | | No | Subscriptions last 7 days and must be updated to be extended | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Target_Module | String | False | | No | Send notifications regarding this module | | Token | String | False | | No | An arbitrary string delivered to the destination with each notification | | Webhook_Url | String | False | | No | Send notifications to this webhook | [Return to Top](#objects-supported) ## PurchasedLineItems | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------ | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------------------------------------------------------- | | Account_Id | String | False | | No | Account related to the parent Purchase of this PLI | | Account_Name | String | True | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Annual_Revenue | Decimal | True | | No | | | Asset_Number | String | False | | No | Asset tag number of sales item in use | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Book_Value | Decimal | True | | No | Book value of sales item in use | | Book_Value_Date | Date | False | | No | Date of book value for sales item in use | | Book_Value_Usdollar | Decimal | True | | No | Book value expressed in USD | | Catalog_Service_Duration_Unit | String | True | | No | Stores a Product Catalog item's Service Duration Unit, used for duration comparisons | | Catalog_Service_Duration_Value | Int | True | | No | Stores a Product Catalog item's Service Duration Value, used for duration comparisons | | Category_Id | String | False | | No | Product category | | Category_Name | String | True | | No | | | Commentlog | String | True | | No | | | Cost_Price | Decimal | True | | No | Product cost | | Cost_Usdollar | Decimal | True | | No | Cost expressed in USD | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Closed | Date | False | | No | Expected or actual date the purchased line item will close | | Date_Closed_Timestamp | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Purchased | Date | False | | No | Date sales item purchased | | Date_Support_Expires | Date | False | | No | Support expiration date | | Date_Support_Starts | Date | False | | No | Support start date | | Deal_Calc | Decimal | True | | No | Calculated Revenue or Loss | | Deal_Calc_Usdollar | Decimal | True | | No | Calculated Revenue or Loss in US Dollars | | Deleted | Bool | False | | No | Record deletion indicator | | Denorm_Account_Name | String | False | | No | Name of the Company | | Description | String | False | | No | Full text of the note | | Discount_Amount | String | True | | No | Discounted amount (Displayed as Total Discount Amount) | | Discount_Amount_Signed | Decimal | True | | No | Discounted Amount Signed | | Discount_Amount_Usdollar | Decimal | True | | No | | | Discount_Price | Decimal | False | | No | Discounted price ( | | Discount_Select | Bool | False | | No | | | Discount_Usdollar | Decimal | True | | No | Discount price expressed in USD | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | List_Price | Decimal | True | | No | List price of sales item | | List_Usdollar | Decimal | True | | No | List price expressed in USD | | Lock_Duration | Bool | False | | No | Turn on or off a user ability to directly edit the duration field | | Locked_Fields | String | True | | No | | | Manufacturer_Id | String | False | | No | Manufacturer of product | | Manufacturer_Name | String | True | | No | | | Mft_Part_Num | String | False | | No | Manufacturer part number | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Name of the product | | Pricing_Factor | Int | True | | No | Variable pricing factor depending on pricing_formula | | Pricing_Formula | String | False | | No | Pricing formula (ex: Fixed, Markup over Cost) | | Product_Template_Id | String | False | | No | Product (in Admin Products) from which this purchased item is derived. | | Product_Template_Name | String | True | | No | | | Product_Type_Id | String | False | | No | Product type (ex: hardware, software) | | Product_Type_Name | String | True | | No | | | Purchase_Id | String | False | | No | Purchase which spawned this PLI | | Purchase_Name | String | False | | No | | | Quantity | Decimal | True | | No | Quantity in use | | Renewable | Bool | False | | No | Indicates whether the sales item is renewable (e.g. a service) | | Renewal | Bool | True | | No | Indicates whether this line item is a renewal | | Renewal_Opp_Id | String | False | | No | Renewal opportunity of this PLI | | Renewal_Opp_Name | String | True | | No | | | Revenue | Decimal | False | | No | | | Revenue_Usdollar | Decimal | True | | No | Revenue expressed in USD | | Revenuelineitem_Id | String | False | | No | If PLI was created from RLI, this is that RLIs ID | | Revenuelineitem_Name | String | True | | No | RLI Name | | Serial_Number | String | False | | No | Serial number of sales item in use | | Service | Bool | False | | No | Indicates whether the sales item is a service or a product | | Service_Duration_Multiplier | Decimal | True | | No | Stores a multiplier based on the ratio of this sales item's duration to another duration (such as a Product Template's) | | Service_Duration_Unit | String | False | | No | Service Duration unit like Year(s), Month(s) or Day(s) | | Service_Duration_Value | Int | True | | No | Value of the service duration, if service duration is 4 Months the value is 4 | | Service_End_Date | String | True | | No | End date of the service | | Service_Start_Date | Date | False | | No | Start date of the service | | Status | String | False | | No | | | Subtotal | Decimal | True | | No | The total of the line item before any discounts are applied, taking any proration into consideration | | Support_Contact | String | False | | No | Contact for support purposes | | Support_Description | String | False | | No | Description of sales item for support purposes | | Support_Name | String | False | | No | Name of sales item for support purposes | | Support_Term | String | False | | No | Term (length) of support contract | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Tax_Class | String | False | | No | Tax classification (ex: Taxable, Non-taxable) | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Total_Amount | Decimal | True | | No | | | Vendor_Part_Num | String | False | | No | Vendor part number | | Website | String | False | | No | Sales item URL | | Weight | Decimal | True | | No | Weight of the sales item | [Return to Top](#objects-supported) ## Purchases | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------- | | Account_Id | String | False | | No | | | Account_Name | String | False | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Category_Id | String | False | | No | Product category | | Category_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | End_Date | Date | True | | No | End date of the purchase | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Pli_Collection | String | True | | No | | | Pli_Count | Int | True | | No | | | Product_Template_Id | String | False | | No | | | Product_Template_Name | String | True | | No | | | Renewable | Bool | False | | No | Indicates whether the purchase is renewable | | Service | Bool | False | | No | Indicates whether the purchase is a service | | Start_Date | Date | True | | No | Start date of the purchase | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Total_Quantity | Decimal | True | | No | | | Total_Revenue | Decimal | True | | No | | | Type_Id | String | False | | No | Product type (ex: hardware, software] | | Type_Name | String | True | | No | | [Return to Top](#objects-supported) ## PushNotifications | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | -------------------------------------------- | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Extra_Data | String | False | | No | JSON encoded string containing extra data. | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Is_Sent | Bool | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Notification_Type | String | False | | No | Type of notification, eg, record_assignment. | | Parent_Id | String | False | | No | ID of item indicated by parent_type. | | Parent_Type | String | True | | No | Module notification is associated with. | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## Quotas | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Amount | Decimal | False | | No | | | Amount_Base_Currency | Decimal | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Commentlog | String | True | | No | | | Committed | Bool | False | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Quota_Type | String | False | | No | | | Sync_Key | String | True | | No | | | Timeperiod_Id | String | False | | No | | | User_Full_Name | String | False | | No | | | User_Id | String | False | | No | | | User_Name | String | False | | No | | [Return to Top](#objects-supported) ## Quotes | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------- | | Account_Id | String | True | | No | | | Account_Name | String | True | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | False | | No | | | Billing_Account_Id | String | True | | No | | | Billing_Account_Name | String | False | | No | | | Billing_Address_City | String | False | | No | | | Billing_Address_Country | String | False | | No | | | Billing_Address_Postalcode | String | False | | No | | | Billing_Address_State | String | False | | No | | | Billing_Address_Street | String | False | | No | | | Billing_Contact_Id | String | True | | No | | | Billing_Contact_Name | String | True | | No | | | Bundles | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Order_Shipped | Date | False | | No | | | Date_Quote_Closed | Date | False | | No | | | Date_Quote_Expected_Closed | Date | False | | No | | | Deal_Tot | Decimal | True | | No | | | Deal_Tot_Discount_Percentage | Double | True | | No | | | Deal_Tot_Usdollar | Decimal | True | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Denorm_Billing_Account_Name | String | False | | No | Name of the Company | | Description | String | False | | No | Full text of the note | | Discount | Decimal | True | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | New_Sub | Decimal | True | | No | | | New_Sub_Usdollar | Decimal | True | | No | | | Opportunity_Id | String | True | | No | | | Opportunity_Name | String | True | | No | | | Order_Stage | String | False | | No | | | Original_Po_Date | Date | False | | No | | | Payment_Terms | String | False | | No | | | Purchase_Order_Num | String | False | | No | | | Quote_Num | Int | False | | No | | | Quote_Stage | String | False | | No | | | Quote_Type | String | False | | No | | | Renewal | Bool | True | | No | Indicates whether this quote is a renewal | | Shipper_Id | String | False | | No | | | Shipper_Name | String | True | | No | Shipper Name | | Shipping | Decimal | True | | No | | | Shipping_Account_Id | String | True | | No | | | Shipping_Account_Name | String | True | | No | | | Shipping_Address_City | String | False | | No | | | Shipping_Address_Country | String | False | | No | | | Shipping_Address_Postalcode | String | False | | No | | | Shipping_Address_State | String | False | | No | | | Shipping_Address_Street | String | False | | No | | | Shipping_Contact_Id | String | True | | No | | | Shipping_Contact_Name | String | True | | No | | | Shipping_Usdollar | Decimal | True | | No | | | Show_Line_Nums | Bool | False | | No | | | Subtotal | Decimal | True | | No | | | Subtotal_Usdollar | Decimal | True | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Tax | Decimal | True | | No | | | Tax_Usdollar | Decimal | True | | No | | | Taxable_Subtotal | Decimal | True | | No | Rollup of product bundles taxable_subtotal values | | Taxrate_Id | String | False | | No | | | Taxrate_Name | String | True | | No | Tax Rate Name | | Taxrate_Value | Decimal | True | | No | Tax Rate Value | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Total | Decimal | True | | No | | | Total_Usdollar | Decimal | True | | No | | [Return to Top](#objects-supported) ## Relationships | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------- | ------ | -------- | ---------- | ---------- | ------------------------------------------ | | Name | String | True | | No | The name of the relationship. | | DynamicSubpanel | String | True | | No | The dynamic subpanel of the relationship. | | JoinKeyLhs | String | True | | No | The lhs join key of the relationship. | | JoinKeyRhs | String | True | | No | The rhs join key of the relationship. | | JoinTable | String | True | | No | The name of join table. | | LhsKey | String | True | | No | The lhs key of the relationship. | | LhsModule | String | True | | No | The lhs module of the relationship. | | LhsTable | String | True | | No | The lhs table of the relationship. | | RelationshipRoleColumn | String | True | | No | The name of the relationship role column. | | RelationshipRoleColumnValue | String | True | | No | The value of the relationship role column. | | RelationshipType | String | True | | No | The type of the relationship. | | PrimaryFlagColumn | String | True | | No | The name of the primary flag column. | | PrimaryFlagDefault | String | True | | No | The default value of the primary flag. | | PrimaryFlagSide | String | True | | No | The side of the primary flag. | | RhsKey | String | True | | No | The rhs key of the relationship. | | RhsModule | String | True | | No | The rhs module of the relationship. | | RhsTable | String | True | | No | The rhs table of the relationship. | | TrueRelationshipType | String | True | | No | The true type of the relationship. | | UserField | String | True | | No | The name of the user field. | [Return to Top](#objects-supported) ## Releases | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------- | | Created_By | String | True | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | Id [KEY] | String | True | | No | | | List_Order | Int | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | False | | No | | | Status | String | False | | No | | [Return to Top](#objects-supported) ## ReportMaker | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Created_By | String | True | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | Description | String | False | | No | | | Id [KEY] | String | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | False | | No | | | Report_Align | String | False | | No | | | Scheduled | Bool | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Title | String | False | | No | | [Return to Top](#objects-supported) ## Reports | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Chart_Type | String | False | | No | | | Content | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Favorite | Bool | False | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Is_Published | Bool | False | | No | | | Last_Run_Date | Datetime | False | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Module | String | False | | No | | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Report_Cache_Id | String | False | | No | | | Report_Type | String | False | | No | | | Schedule_Type | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## ReportSchedules | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Active | Bool | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Start | Datetime | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Embed_Report | String | False | | No | Embed report in email | | File_Type | String | False | | No | File type for scheduled report attachment | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Next_Run | Datetime | False | | No | | | Report_Id | String | False | | No | | | Report_Name | String | False | | No | | | Schedule_Type | String | False | | No | Legacy field. ent for advanced reports, pro for regular reports | | Sync_Key | String | True | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Time_Interval | String | False | | No | | | User_Id | String | False | | No | | [Return to Top](#objects-supported) ## RevenueLineItems | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------ | -------- | -------- | ---------- | ---------- | ----------------------------------------------------------------------------------------------------------------------- | | Account_Id | String | False | | No | Account this product is associated with | | Account_Name | String | True | | No | | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Add_On_To_Id | String | False | | No | Purchased line item that this is an add-on to | | Add_On_To_Name | String | True | | No | | | Asset_Number | String | False | | No | Asset tag number of sales item in use | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Base_Rate | String | True | | No | | | Best_Case | Decimal | True | | No | | | Book_Value | Decimal | True | | No | Book value of sales item in use | | Book_Value_Date | Date | False | | No | Date of book value for sales item in use | | Book_Value_Usdollar | Decimal | True | | No | Book value expressed in USD | | Campaign_Id | String | False | | No | Campaign that generated lead | | Campaign_Name | String | True | | No | | | Catalog_Service_Duration_Unit | String | True | | No | Stores a Product Catalog item's Service Duration Unit, used for duration comparisons | | Catalog_Service_Duration_Value | Int | True | | No | Stores a Product Catalog item's Service Duration Value, used for duration comparisons | | Category_Id | String | False | | No | Product category | | Category_Name | String | True | | No | | | Commentlog | String | True | | No | | | Commit_Stage | String | False | | No | Forecast commit category: Include, Likely, Omit etc. | | Cost_Price | Decimal | True | | No | Product cost ( | | Cost_Usdollar | Decimal | True | | No | Cost expressed in USD | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | | | Currency_Name | String | True | | No | | | Currency_Symbol | String | True | | No | | | Date_Closed | Date | False | | No | Expected or actual date the product (for opportunity) will close | | Date_Closed_Timestamp | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Purchased | Date | False | | No | Date sales item purchased | | Date_Support_Expires | Date | False | | No | Support expiration date | | Date_Support_Starts | Date | False | | No | Support start date | | Deal_Calc | Decimal | True | | No | deal_calc | | Deal_Calc_Usdollar | Decimal | True | | No | deal_calc_usdollar | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Discount_Amount | String | True | | No | Discounted amount | | Discount_Amount_Signed | Decimal | True | | No | Discounted Amount Signed | | Discount_Amount_Usdollar | Decimal | True | | No | | | Discount_Price | Decimal | True | | No | Discounted price ( | | Discount_Rate_Percent | Decimal | True | | No | | | Discount_Select | Bool | False | | No | | | Discount_Usdollar | Decimal | True | | No | Discount price expressed in USD | | Following | Bool | False | | No | Is user following this record | | Forecasted_Likely | Decimal | True | | No | Rollup of included RLIs on the Opportunity | | Generate_Purchase | String | False | | No | Generate Purchase Options (ex: Yes, No, Completed) | | Id [KEY] | String | True | | No | Unique identifier | | Lead_Source | String | False | | No | Source of the product | | Likely_Case | Decimal | False | | No | | | List_Price | Decimal | True | | No | List price of sales item | | List_Usdollar | Decimal | True | | No | List price expressed in USD | | Lock_Duration | Bool | False | | No | Turn on or off a user ability to directly edit the duration field | | Locked_Fields | String | True | | No | | | Manufacturer_Id | String | False | | No | Manufacturer of product | | Manufacturer_Name | String | True | | No | | | Mft_Part_Num | String | False | | No | Manufacturer part number | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Name of the product | | Next_Step | String | False | | No | The next step in the sales process | | Opportunity_Id | String | False | | No | The opportunity id for the line item entry | | Opportunity_Name | String | False | | No | The opportunity name associated with the opportunity_id | | Pricing_Factor | Int | True | | No | Variable pricing factor depending on pricing_formula | | Pricing_Formula | String | False | | No | Pricing formula (ex: Fixed, Markup over Cost) | | Probability | Int | True | | No | The probability of closure | | Product_Template_Id | String | False | | No | Product (in Admin Products) from which this product is derived (in user Products) | | Product_Template_Name | String | True | | No | | | Product_Type | String | False | | No | Type of product ( from opportunities opportunity_type ex: Existing, New) | | Purchasedlineitem_Id | String | False | | No | If PLI was created from this RLI, this is that PLIs ID | | Purchasedlineitem_Name | String | True | | No | PLI Name | | Quantity | Decimal | True | | No | Quantity in use | | Quote_Id | String | False | | No | If product created via Quote, this is quote ID | | Quote_Name | String | True | | No | Quote Name | | Renewable | Bool | False | | No | Indicates whether the sales item is renewable (e.g. a service) | | Renewal | Bool | True | | No | Indicates whether this line item is a renewal | | Renewal_Rli_Id | String | False | | No | Renewal RLI of this RLI, set during renewal generation | | Renewal_Rli_Name | String | True | | No | | | Sales_Stage | String | False | | No | Indication of progression towards closure | | Serial_Number | String | False | | No | Serial number of sales item in use | | Service | Bool | False | | No | Indicates whether the sales item is a service or a product | | Service_Duration_Multiplier | Decimal | True | | No | Stores a multiplier based on the ratio of this sales item's duration to another duration (such as a Product Template's) | | Service_Duration_Unit | String | False | | No | Service Duration unit like Year(s), Month(s) or Day(s) | | Service_Duration_Value | Int | True | | No | Value of the service duration, if service duration is 4 Months the value is 4 | | Service_End_Date | String | True | | No | End date of the service | | Service_Start_Date | Date | False | | No | Start date of the service | | Status | String | False | | No | Product status (ex: Quoted, Ordered, Shipped) | | Subtotal | Decimal | True | | No | Stores the total of the line item before any discounts are applied, taking proration into consideration | | Support_Contact | String | False | | No | Contact for support purposes | | Support_Description | String | False | | No | Description of sales item for support purposes | | Support_Name | String | False | | No | Name of sales item for support purposes | | Support_Term | String | False | | No | Term (length) of support contract | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Tax_Class | String | False | | No | Tax classification (ex: Taxable, Non-taxable) | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Total_Amount | Decimal | True | | No | | | Type_Id | String | False | | No | Product type (ex: hardware, software) | | Type_Name | String | True | | No | | | Vendor_Part_Num | String | False | | No | Vendor part number | | Website | String | False | | No | Sales item URL | | Weight | Decimal | True | | No | Weight of the sales item | | Worst_Case | Decimal | True | | No | | [Return to Top](#objects-supported) ## SavedSearch | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | | | Assigned_User_Name | String | False | | No | | | Contents | String | False | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | Description | String | False | | No | | | Id [KEY] | String | True | | No | | | Name | String | False | | No | | | Search_Module | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | [Return to Top](#objects-supported) ## Schedulers | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Adv_Interval | Bool | False | | No | | | Catch_Up | Bool | False | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Time_End | Datetime | False | | No | | | Date_Time_Start | Datetime | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Job | String | False | | No | | | Job_Function | String | False | | No | | | Job_Interval | String | False | | No | | | Job_Url | String | False | | No | | | Last_Run | Datetime | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Status | String | False | | No | | | Sync_Key | String | True | | No | | | System_Job | Bool | False | | No | | | Time_From | String | True | | No | | | Time_To | String | True | | No | | [Return to Top](#objects-supported) ## ShiftExceptions | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | ---------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | All_Day | Bool | False | | No | The Shift Exception is all day or not | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Enabled | Bool | False | | No | An indicator of whether shift exception is enabled | | End_Date | Date | False | | No | The end date of the shift exception | | End_Hour | String | False | | No | The hour portion of the time this shift exception ends | | End_Minutes | String | False | | No | The minute portion of the time this shift exception ends | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Shift_Exception_Type | String | False | | No | The Shift Exception is of this type | | Start_Date | Date | False | | No | The start date of the shift exception | | Start_Hour | String | False | | No | The hour portion of the time this shift exception starts | | Start_Minutes | String | False | | No | The minute portion of the time this shift exception starts | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Timezone | String | False | | No | Time Zone in which this Shift Exception operates | [Return to Top](#objects-supported) ## Shifts | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------- | -------- | -------- | ---------- | ---------- | -------------------------------------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_End | Date | False | | No | Date is which shift is scheduled to (or did) end | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Start | Date | False | | No | Date in which shift is schedule to (or did) start | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Friday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Friday | | Friday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Friday | | Friday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Friday | | Friday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Friday | | Id [KEY] | String | True | | No | Unique identifier | | Is_Open_Friday | Bool | False | | No | Explicit marker for if this business center is open on Friday | | Is_Open_Monday | Bool | False | | No | Explicit marker for if this business center is open on Monday | | Is_Open_Saturday | Bool | False | | No | Explicit marker for if this business center is open on Saturday | | Is_Open_Sunday | Bool | False | | No | Explicit marker for if this business center is open on Sunday | | Is_Open_Thursday | Bool | False | | No | Explicit marker for if this business center is open on Thursday | | Is_Open_Tuesday | Bool | False | | No | Explicit marker for if this business center is open on Tuesday | | Is_Open_Wednesday | Bool | False | | No | Explicit marker for if this business center is open on Wednesday | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Monday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Monday | | Monday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Monday | | Monday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Monday | | Monday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Monday | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Saturday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Saturday | | Saturday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Saturday | | Saturday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Saturday | | Saturday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Saturday | | Sunday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Sunday | | Sunday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Sunday | | Sunday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Sunday | | Sunday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Sunday | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Thursday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Thursday | | Thursday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Thursday | | Thursday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Thursday | | Thursday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Thursday | | Timezone | String | False | | No | Time Zone in which this Shift operates | | Tuesday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Tuesday | | Tuesday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Tuesday | | Tuesday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Tuesday | | Tuesday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Tuesday | | Wednesday_Close_Hour | String | False | | No | The hour portion of the time this business center is closed on Wednesday | | Wednesday_Close_Minutes | String | False | | No | The minute portion of the time this business center is closed on Wednesday | | Wednesday_Open_Hour | String | False | | No | The hour portion of the time this business center is open on Wednesday | | Wednesday_Open_Minutes | String | False | | No | The minute portion of the time this business center is open on Wednesday | [Return to Top](#objects-supported) ## Shippers | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Default_Cost | Decimal | True | | No | Default cost (Shown) | | Default_Cost_Usdollar | Decimal | True | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | List_Order | Int | True | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Status | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## Styleguide | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------- | -------- | -------- | ---------- | ---------- | ---------------------------------------------------------------------------------- | | Alt_Address_City | String | False | | No | City for alternate address | | Alt_Address_Country | String | False | | No | Country for alternate address | | Alt_Address_Postalcode | String | False | | No | Postal code for alternate address | | Alt_Address_State | String | False | | No | State for alternate address | | Alt_Address_Street | String | False | | No | Street address for alternate address | | Alt_Address_Street_2 | String | False | | No | | | Alt_Address_Street_3 | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Assistant | String | False | | No | Name of the assistant of the contact | | Assistant_Phone | String | False | | No | Phone number of the assistant of the contact | | Birthdate | Date | False | | No | The birthdate of the contact | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Currency_Id | String | False | | No | Currency of the product | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Start | Datetime | False | | No | Date of start of meeting | | Deleted | Bool | False | | No | Record deletion indicator | | Department | String | False | | No | The department of the contact | | Description | String | False | | No | Full text of the styleguide page | | Do_Not_Call | Bool | False | | No | Whether or not to allow calls to contact | | Email | String | False | | No | | | Email_Addresses_Non_Primary | String | False | | No | | | Email_Opt_Out | Bool | False | | No | | | Email1 | String | False | | No | | | Email2 | String | False | | No | | | Facebook | String | False | | No | The facebook name of the user | | File_Mime_Type | String | False | | No | Attachment MIME type | | File_Url | String | False | | No | Path to file (can be URL) | | Filename | String | True | | No | File name associated with the note (attachment) | | First_Name | String | False | | No | First name of the contact | | Following | Bool | False | | No | Is user following this record | | Full_Name | String | True | | No | | | Googleplus | String | False | | No | The google plus id of the user | | Id [KEY] | String | True | | No | Unique identifier | | Invalid_Email | Bool | False | | No | | | Last_Name | String | False | | No | Last name of the contact | | List_Price | Decimal | True | | No | List price of product ( | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | True | | No | | | Parent_Id | String | False | | No | The ID of the Sugar item specified in parent_type | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | Sugar module the Note is associated with | | Phone_Fax | String | False | | No | Contact fax number | | Phone_Home | String | False | | No | Don't call to this number | | Phone_Mobile | String | False | | No | Mobile phone number of the contact | | Phone_Other | String | False | | No | Other phone number for the contact | | Phone_Work | String | False | | No | Work phone number of the contact | | Picture | String | False | | No | Image to be used as an avatar | | Primary_Address_City | String | False | | No | City for primary address | | Primary_Address_Country | String | False | | No | Country for primary address | | Primary_Address_Postalcode | String | False | | No | Postal code for primary address | | Primary_Address_State | String | False | | No | State for primary address | | Primary_Address_Street | String | False | | No | The street address used for primary address | | Primary_Address_Street_2 | String | False | | No | | | Primary_Address_Street_3 | String | False | | No | | | Radio_Button_Group | String | True | | No | | | Salutation | String | False | | No | Contact salutation (e.g., Mr, Ms) | | Secret_Password | String | True | | No | Your password will be saved securely | | Sync_Key | String | True | | No | | | Title | String | True | | No | Title of the Styleguide page | | Twitter | String | False | | No | The twitter name of the user | | User_Email | String | False | | No | Emails can also have a big help description to further enhance the user experience | | Website | String | False | | No | URL of website for the company | [Return to Top](#objects-supported) ## Subscriptions | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Parent_Id | String | False | | No | | | Parent_Type | String | False | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## SugarFavorites | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Name of the feed | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | Module | String | False | | No | | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Record_Id | String | False | | No | | | Record_Name | String | True | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## SugarLive | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Enabled_Modules | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | [Return to Top](#objects-supported) ## Tags | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Name_Lower | String | False | | No | | | Source_Id | String | False | | No | | | Source_Meta | String | False | | No | | | Source_Type | String | False | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## Tasks | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Assigned_User_Id | String | False | | No | User ID assigned to record | | Assigned_User_Name | String | True | | No | | | Cj_Activity_Completion_Date | Datetime | True | | No | | | Cj_Activity_Start_Date | Datetime | True | | No | | | Cj_Activity_Tpl_Name | String | True | | No | | | Cj_Actual_Sort_Order | String | False | | No | | | Cj_Allow_Activity_By | String | False | | No | | | Cj_Blocked_By_Stages | String | False | | No | | | Cj_Days_To_Complete | String | True | | No | | | Cj_Momentum_End_Date | Datetime | False | | No | | | Cj_Momentum_Points | Int | True | | No | | | Cj_Momentum_Ratio | Double | True | | No | | | Cj_Momentum_Score | Int | True | | No | | | Cj_Momentum_Start_Date | Datetime | False | | No | | | Cj_Parent_Activity_Id | String | False | | No | | | Cj_Parent_Activity_Type | String | False | | No | | | Cj_Url | String | False | | No | | | Commentlog | String | True | | No | | | Contact_Email | String | False | | No | | | Contact_Id | String | False | | No | | | Contact_Name | String | True | | No | | | Contact_Phone | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Customer_Journey_Blocked_By | String | False | | No | | | Customer_Journey_Points | String | False | | No | | | Customer_Journey_Progress | Double | True | | No | | | Customer_Journey_Score | Int | True | | No | | | Customer_Journey_Type | String | False | | No | | | Date_Due | Datetime | False | | No | | | Date_Due_Flag | Bool | False | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Date_Start | Datetime | False | | No | | | Date_Start_Flag | Bool | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Dri_Subworkflow_Id | String | False | | No | | | Dri_Subworkflow_Name | String | True | | No | | | Dri_Subworkflow_Template_Id | String | False | | No | | | Dri_Subworkflow_Template_Name | String | True | | No | | | Dri_Workflow_Id | String | False | | No | | | Dri_Workflow_Name | String | True | | No | | | Dri_Workflow_Sort_Order | String | False | | No | | | Dri_Workflow_Task_Template_Id | String | False | | No | | | Dri_Workflow_Template_Id | String | False | | No | | | Dri_Workflow_Template_Name | String | True | | No | | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Is_Cj_Parent_Activity | Bool | False | | No | | | Is_Customer_Journey_Activity | Bool | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Parent_Id | String | False | | No | | | Parent_Name | String | True | | No | | | Parent_Type | String | True | | No | The Sugar object to which the call is related | | Priority | String | False | | No | | | Start_Next_Journey_Id | String | False | | No | | | Status | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Time_Due | Datetime | False | | No | | [Return to Top](#objects-supported) ## TaxRates | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | List_Order | Int | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Status | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | Value | Decimal | False | | No | | [Return to Top](#objects-supported) ## TeamNotices | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------- | | Acl_Team_Names | String | True | | No | | | Acl_Team_Set_Id | String | False | | No | | | Created_By | String | True | | No | | | Date_End | Date | False | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Date_Start | Date | False | | No | | | Deleted | Bool | False | | No | | | Description | String | False | | No | | | Id [KEY] | String | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | False | | No | | | Status | String | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | Team ID for the account | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Url | String | False | | No | | | Url_Title | String | False | | No | | [Return to Top](#objects-supported) ## Teams | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ----------------------------- | | Associated_User_Id | String | False | | No | | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Name_2 | String | False | | No | | | Private | Bool | False | | No | | | Sync_Key | String | True | | No | | [Return to Top](#objects-supported) ## TimePeriods | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | ------------------------------- | | Created_By | String | True | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | End_Date | Date | False | | No | | | End_Date_Timestamp | Int | False | | No | | | Id [KEY] | String | True | | No | | | Is_Fiscal | Bool | False | | No | | | Is_Fiscal_Year | Bool | False | | No | | | Leaf_Cycle | Int | True | | No | | | Name | String | True | | No | | | Parent_Id | String | False | | No | | | Start_Date | Date | False | | No | | | Start_Date_Timestamp | Int | False | | No | | | Type | String | False | | No | Time Period to be Forecast over | [Return to Top](#objects-supported) ## TrackerPerfs | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | ---------- | ---------- | ------------------------- | | Date_Modified | Datetime | True | | No | | | Db_Round_Trips | Int | True | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Files_Opened | Int | True | | No | | | Id [KEY] | Int | True | | No | | | Memory_Usage | Int | True | | No | | | Monitor_Id | String | False | | No | | | Server_Response_Time | Double | True | | No | | [Return to Top](#objects-supported) ## TrackerQueries | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------- | -------- | -------- | ---------- | ---------- | ------------------------- | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Id [KEY] | Int | True | | No | | | Query_Hash | String | False | | No | | | Query_Id | String | False | | No | | | Run_Count | Int | True | | No | | | Sec_Avg | Double | True | | No | | | Sec_Total | Double | True | | No | | | Text | String | False | | No | | [Return to Top](#objects-supported) ## Trackers | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------- | -------- | -------- | ---------- | ---------- | ------------------------- | | Action | String | False | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Id [KEY] | Int | True | | No | | | Item_Id | String | False | | No | | | Item_Summary | String | False | | No | | | Module_Name | String | False | | No | | | Monitor_Id | String | False | | No | | | Session_Id | String | False | | No | | | Team_Id | String | False | | No | | | User_Id | String | False | | No | | | Visible | Bool | False | | No | | [Return to Top](#objects-supported) ## TrackerSessions | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------- | -------- | -------- | ---------- | ---------- | ------------------------- | | Active | Bool | False | | No | | | Client_Ip | String | False | | No | | | Date_End | Datetime | False | | No | | | Date_Start | Datetime | False | | No | | | Deleted | Bool | False | | No | Record deletion indicator | | Id [KEY] | Int | True | | No | | | Seconds | Int | True | | No | | | Session_Id | String | False | | No | | | User_Id | String | False | | No | | [Return to Top](#objects-supported) ## Users | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------------- | | Accept_Status_Calls | String | False | | No | | | Accept_Status_Id | String | False | | No | | | Accept_Status_Meetings | String | False | | No | | | Accept_Status_Messages | String | False | | No | | | Accept_Status_Name | String | False | | No | | | Acl_Role_Set_Id | String | False | | No | | | Acl_Team_Set_Id | String | False | | No | | | Address_City | String | False | | No | | | Address_Country | String | False | | No | | | Address_Postalcode | String | False | | No | | | Address_State | String | False | | No | | | Address_Street | String | False | | No | | | Authenticate_Id | String | False | | No | | | Business_Center_Id | String | False | | No | The business center to which the case is associated | | Business_Center_Name | String | True | | No | The name of the business center represented by the business_center_id field | | C_Accept_Status_Fields | String | True | | No | | | Cookie_Consent | Bool | False | | No | Indicator whether this user accepts cookies | | Cookie_Consent_Received_On | Datetime | False | | No | Date cookie consent received on | | Created_By | String | True | | No | | | Created_By_Name | String | True | | No | | | Customer_Journey_Access | Bool | True | | No | | | Customer_Journey_Last_Active | Datetime | True | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Default_Team | String | False | | No | | | Deleted | Bool | False | | No | | | Department | String | False | | No | | | Description | String | False | | No | | | Email | String | False | | No | | | Email_Link_Type | String | False | | No | | | Email1 | String | False | | No | | | Employee_Status | String | False | | No | | | External_Auth_Only | Bool | False | | No | | | First_Name | String | False | | No | | | Full_Name | String | True | | No | | | Id [KEY] | String | True | | No | | | Is_Admin | Bool | False | | No | | | Is_Group | Bool | False | | No | | | Last_Login | Datetime | True | | No | | | Last_Name | String | False | | No | | | License_Type | String | False | | No | | | M_Accept_Status_Fields | String | True | | No | | | Messenger_Id | String | False | | No | | | Messenger_Type | String | False | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | True | | No | | | Phone_Fax | String | False | | No | | | Phone_Home | String | False | | No | | | Phone_Mobile | String | False | | No | | | Phone_Other | String | False | | No | | | Phone_Work | String | False | | No | | | Picture | String | False | | No | | | Portal_Only | Bool | False | | No | | | Preferred_Language | String | False | | No | | | Pwd_Last_Changed | Datetime | False | | No | | | Receive_Notifications | Bool | False | | No | | | Reports_To_Id | String | False | | No | | | Reports_To_Name | String | True | | No | | | Send_Email_On_Mention | Bool | False | | No | | | Show_On_Employees | Bool | False | | No | | | Site_User_Id | String | True | | No | | | Status | String | False | | No | | | Sugar_Login | Bool | False | | No | | | Sync_Key | String | True | | No | | | System_Generated_Password | Bool | False | | No | | | Team_Count | String | False | | No | | | Team_Id | String | False | | No | | | Team_Name | String | False | | No | | | Team_Set_Id | String | False | | No | | | Title | String | False | | No | | | User_Hash | String | True | | No | | | User_Name | String | False | | No | | | Usertype | String | False | | No | | [Return to Top](#objects-supported) ## UserSignatures | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------------------------- | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Is_Default | Bool | False | | No | | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Signature | String | False | | No | | | Signature_Html | String | False | | No | | | Sync_Key | String | True | | No | | | Tag | String | False | | No | | | User_Id | String | False | | No | | [Return to Top](#objects-supported) ## VisualPipeline | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------ | -------- | -------- | ---------- | ---------- | ------------------------------------- | | Available_Columns | String | False | | No | An array of white-listed column names | | Commentlog | String | True | | No | | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Enabled_Module | String | False | | No | | | Following | Bool | False | | No | Is user following this record | | Hidden_Values | String | False | | No | | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | | | Records_Per_Column | String | False | | No | | | Show_Column_Count | Bool | False | | No | | | Show_Column_Total | Bool | False | | No | | | Sync_Key | String | True | | No | | | Table_Header | String | False | | No | | | Tag | String | False | | No | | | Tile_Body_Fields | String | False | | No | | | Tile_Header | String | False | | No | | | Total_Field | String | False | | No | | [Return to Top](#objects-supported) ## WebLogicHooks | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------- | -------- | -------- | ---------- | ---------- | ------------------------------ | | Created_By | String | True | | No | User who created record | | Created_By_Name | String | True | | No | | | Date_Entered | Datetime | True | | No | Date record created | | Date_Modified | Datetime | True | | No | Date record last modified | | Deleted | Bool | False | | No | Record deletion indicator | | Description | String | False | | No | Full text of the note | | Following | Bool | False | | No | Is user following this record | | Id [KEY] | String | True | | No | Unique identifier | | Locked_Fields | String | True | | No | | | Modified_By_Name | String | True | | No | | | Modified_User_Id | String | True | | No | User who last modified record | | My_Favorite | Bool | False | | No | Favorite for the user | | Name | String | False | | No | Hook name | | Request_Method | String | False | | No | | | Sync_Key | String | True | | No | | | Trigger_Event | String | False | | No | | | Url | String | False | | No | URL of website for the company | | Webhook_Target_Module | String | False | | No | | [Return to Top](#objects-supported) ## WorkFlow | Name | Type | ReadOnly | References | FilterOnly | Description | | ---------------- | -------- | -------- | ---------- | ---------- | ----------- | | Base_Module | String | False | | No | | | Created_By | String | True | | No | | | Date_Entered | Datetime | True | | No | | | Date_Modified | Datetime | True | | No | | | Deleted | Bool | False | | No | | | Description | String | False | | No | | | Fire_Order | String | False | | No | | | Id [KEY] | String | True | | No | | | List_Order_Y | Int | True | | No | | | Modified_User_Id | String | True | | No | | | Name | String | False | | No | | | Parent_Id | String | False | | No | | | Record_Type | String | False | | No | | | Status | Bool | False | | No | | | Type | String | False | | No | | [Return to Top](#objects-supported)