note: This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.
Objects Supported
| Name | Description |
|---|---|
| Accounts | The Accounts table. |
| ACLRoles | The ACLRoles table. |
| Activities | The Activities view. |
| ArchiveRuns | The ArchiveRuns table. |
| Audit | The Audit view. |
| Bugs | The Bugs table. |
| BusinessCenters | The BusinessCenters table. |
| Calendar | The Calendar table. |
| Calls | The Calls table. |
| CampaignLog | The CampaignLog table. |
| Campaigns | The Campaigns table. |
| CampaignTrackers | The CampaignTrackers table. |
| Cases | The Cases table. |
| Categories | The Categories table. |
| ChangeTimers | The ChangeTimers table. |
| CJForms | The CJ_Forms table. |
| CJWebHooks | The CJ_WebHooks table. |
| CloudDrivePaths | The CloudDrivePaths table. |
| CommentLog | The CommentLog table. |
| Comments | The Comments table. |
| ConsoleConfiguration | The ConsoleConfiguration table. |
| Contacts | The Contacts table. |
| Contracts | The Contracts table. |
| ContractTypes | The ContractTypes table. |
| Currencies | The Currencies table. |
| CustomQueries | The CustomQueries table. |
| Dashboards | The Dashboards table. |
| DataArchiver | The DataArchiver table. |
| DataPrivacy | The DataPrivacy table. |
| DataSets | The DataSets table. |
| DocumentMerges | The DocumentMerges table. |
| DocumentRevisions | The DocumentRevisions table. |
| Documents | The Documents table. |
| DocumentTemplates | The DocumentTemplates table. |
| DocuSignEnvelopes | The DocuSignEnvelopes table. |
| DRISubWorkflows | The DRI_SubWorkflows table. |
| DRISubWorkflowTemplates | The DRI_SubWorkflow_Templates table. |
| DRIWorkflows | The DRI_Workflows table. |
| DRIWorkflowTaskTemplates | The DRI_Workflow_Task_Templates table. |
| DRIWorkflowTemplates | The DRI_Workflow_Templates table. |
| DropDownValues | The DropDownValues View. This view provides information regarding the values of dropdowns from different fields and modules. |
| EAPM | The EAPM table. |
| EmailAddresses | The EmailAddresses table. |
| EmailMarketing | The EmailMarketing table. |
| EmailParticipants | The EmailParticipants table. |
| Emails | The Emails table. |
| EmailTemplates | The EmailTemplates table. |
| EmbeddedFiles | The EmbeddedFiles table. |
| Employees | The Employees table. |
| Escalations | The Escalations table. |
| ExternalUsers | The ExternalUsers table. |
| Filters | The Filters table. |
| ForecastManagerWorksheets | The ForecastManagerWorksheets table. |
| Forecasts | The Forecasts table. |
| ForecastWorksheets | The ForecastWorksheets table. |
| Geocode | The Geocode table. |
| HintAccountsets | The HintAccountsets table. |
| HintEnrichFieldConfigs | The HintEnrichFieldConfigs table. |
| HintNewsNotifications | The HintNewsNotifications table. |
| HintNotificationTargets | The HintNotificationTargets table. |
| Holidays | The Holidays table. |
| InboundEmail | The InboundEmail table. |
| KBArticles | The KBArticles table. |
| KBContents | The KBContents table. |
| KBContentTemplates | The KBContentTemplates table. |
| KBDocuments | The KBDocuments table. |
| Leads | The Leads table. |
| Manufacturers | The Manufacturers table. |
| Meetings | The Meetings table. |
| Messages | The Messages table. |
| Metrics | The Metrics table. |
| MobileDevices | The MobileDevices table. |
| Notes | The Notes table. |
| Notifications | The Notifications table. |
| OAuthKeys | The OAuthKeys table. |
| OAuthTokens | The OAuthTokens table. |
| Opportunities | The Opportunities table. |
| OutboundEmail | The OutboundEmail table. |
| PdfManager | The PdfManager table. |
| pmseBusinessRules | The pmse_Business_Rules table. |
| pmseEmailsTemplates | The pmse_Emails_Templates table. |
| pmseInbox | The pmse_Inbox table. |
| pmseProject | The pmse_Project table. |
| ProductBundleNotes | The ProductBundleNotes table. |
| ProductBundles | The ProductBundles table. |
| ProductCategories | The ProductCategories table. |
| Products | The Products table. |
| ProductTemplates | The ProductTemplates table. |
| ProductTypes | The ProductTypes table. |
| Project | The Project table. |
| ProjectTask | The ProjectTask table. |
| ProspectLists | The ProspectLists table. |
| PubSubModuleEventPushSubs | The PubSub_ModuleEvent_PushSubs table. |
| PurchasedLineItems | The PurchasedLineItems table. |
| Purchases | The Purchases table. |
| PushNotifications | The PushNotifications table. |
| Quotas | The Quotas table. |
| Quotes | The Quotes table. |
| Relationships | The Relationships View. This view provides information regarding different relationships between tables. |
| Releases | The Releases table. |
| ReportMaker | The ReportMaker table. |
| Reports | The Reports table. |
| ReportSchedules | The ReportSchedules table. |
| RevenueLineItems | The RevenueLineItems table. |
| SavedSearch | The SavedSearch table. |
| Schedulers | The Schedulers table. |
| ShiftExceptions | The ShiftExceptions table. |
| Shifts | The Shifts table. |
| Shippers | The Shippers table. |
| Styleguide | The Styleguide table. |
| Subscriptions | The Subscriptions table. |
| SugarFavorites | The SugarFavorites table. |
| SugarLive | The SugarLive table. |
| Tags | The Tags table. |
| Tasks | The Tasks table. |
| TaxRates | The TaxRates table. |
| TeamNotices | The TeamNotices table. |
| Teams | The Teams table. |
| TimePeriods | The TimePeriods table. |
| TrackerPerfs | The TrackerPerfs table. |
| TrackerQueries | The TrackerQueries table. |
| Trackers | The Trackers table. |
| TrackerSessions | The TrackerSessions table. |
| Users | The Users table. |
| UserSignatures | The UserSignatures table. |
| VisualPipeline | The VisualPipeline table. |
| WebLogicHooks | The WebLogicHooks table. |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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) |
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) |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | ||
| 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 | ||
| 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 | ||
| String | False | No | The twitter name of the user | ||
| Underwriting_Bulletins_C | Bool | False | No |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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. |
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 |
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 |
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 |
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 |
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) |
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 |
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 |
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 | ||
| 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 |
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 |
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 | |
| String | False | No | The facebook name of the user | ||
| 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 | |
| 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | ||
| 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 | ||
| 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 | |
| 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 |
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 |
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 |
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) |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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. |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | |
| String | False | No | |||
| Email_Addresses_Non_Primary | String | False | No | ||
| Email_Opt_Out | Bool | False | No | ||
| Email1 | String | False | No | ||
| Email2 | String | False | No | ||
| 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 | |
| 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | ||
| 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 |
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 |
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 |
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 |
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 |