SugarCRM Connector Objects
This Data 360 connector is a beta service that is subject to the Beta Services Terms at Agreements - Salesforce.com or a written Unified Pilot Agreement if executed by Customer, and applicable terms in the Product Terms Directory. Use of this pilot or beta service is at the Customer's sole discretion.
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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) |
| 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) |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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) |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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) |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |