Salesforce Data Model (Tables)

  1. AcceptedEventRelation
  2. Account
  3. AccountContactRole
  4. AccountFeed
  5. AccountHistory
  6. AccountPartner
  7. AccountShare
  8. ActivityHistory
  9. AdditionalNumber
  10. ApexClass
  11. ApexComponent
  12. ApexLog
  13. ApexPage
  14. ApexTestQueueItem
  15. ApexTestResult
  16. ApexTrigger
  17. AppMenuItem
  18. Approval
  19. Asset
  20. AssetFeed
  21. AssignmentRule
  22. AsyncApexJob
  23. Attachment
  24. AuthProvider
  25. AuthSession
  26. BrandTemplate
  27. BusinessHours
  28. BusinessProcess
  29. CallCenter
  30. Campaign
  31. CampaignFeed
  32. CampaignMember
  33. CampaignMemberStatus
  34. CampaignShare
  35. Case
  36. CaseComment
  37. CaseContactRole
  38. CaseFeed
  39. CaseHistory
  40. CaseShare
  41. CaseSolution
  42. CaseStatus
  43. CaseTeamMember
  44. CaseTeamRole
  45. CaseTeamTemplate
  46. CaseTeamTemplateMember
  47. CaseTeamTemplateRecord
  48. CategoryData
  49. CategoryNode
  50. ChatterActivity
  51. ClientBrowser
  52. CollaborationGroup
  53. CollaborationGroupFeed
  54. CollaborationGroupMember
  55. CollaborationGroupMemberRequest
  56. CollaborationInvitation
  57. Community
  58. Contact
  59. ContactFeed
  60. ContactHistory
  61. ContactShare
  62. ContentDocument
  63. ContentDocumentFeed
  64. ContentDocumentHistory
  65. ContentDocumentLink
  66. ContentVersion
  67. ContentVersionHistory
  68. Contract
  69. ContractContactRole
  70. ContractFeed
  71. ContractHistory
  72. ContractStatus
  73. CronJobDetail
  74. CronTrigger
  75. Dashboard
  76. DashboardComponent
  77. DashboardComponentFeed
  78. DashboardFeed
  79. DeclinedEventRelation
  80. Document
  81. DocumentAttachmentMap
  82. Domain
  83. DomainSite
  84. EmailServicesAddress
  85. EmailServicesFunction
  86. EmailStatus
  87. EmailTemplate
  88. EntitySubscription
  89. Event
  90. EventFeed
  91. EventRelation
  92. FeedComment
  93. FeedItem
  94. FeedPollChoice
  95. FeedPollVote
  96. FieldPermissions
  97. FiscalYearSettings
  98. Folder
  99. ForecastShare
  100. Group
  101. GroupMember
  102. HashtagDefinition
  103. Holiday
  104. Lead
  105. LeadFeed
  106. LeadHistory
  107. LeadShare
  108. LeadStatus
  109. LoginHistory
  110. LoginIp
  111. MailmergeTemplate
  112. MobileDeviceRegistrar
  113. Name
  114. Note
  115. NoteAndAttachment
  116. ObjectPermissions
  117. OpenActivity
  118. Opportunity
  119. OpportunityCompetitor
  120. OpportunityContactRole
  121. OpportunityFeed
  122. OpportunityFieldHistory
  123. OpportunityHistory
  124. OpportunityLineItem
  125. OpportunityPartner
  126. OpportunityShare
  127. OpportunityStage
  128. Organization
  129. OrgWideEmailAddress
  130. Partner
  131. PartnerRole
  132. Period
  133. PermissionSet
  134. PermissionSetAssignment
  135. PermissionSetLicense
  136. PermissionSetLicenseAssign
  137. Pricebook2
  138. Pricebook2History
  139. PricebookEntry
  140. ProcessDefinition
  141. ProcessInstance
  142. ProcessInstanceHistory
  143. ProcessInstanceStep
  144. ProcessInstanceWorkitem
  145. ProcessNode
  146. Product2
  147. Product2Feed
  148. Profile
  149. PushTopic
  150. QueueSobject
  151. Quote
  152. QuoteDocument
  153. QuoteFeed
  154. QuoteLineItem
  155. RecentlyViewed
  156. RecordType
  157. Report
  158. ReportFeed
  159. Scontrol
  160. SelfServiceUser
  161. SetupEntityAccess
  162. Site
  163. SiteFeed
  164. SiteHistory
  165. Solution
  166. SolutionFeed
  167. SolutionHistory
  168. SolutionStatus
  169. StaticResource
  170. Task
  171. TaskFeed
  172. TaskPriority
  173. TaskStatus
  174. Topic
  175. TopicAssignment
  176. TopicFeed
  177. UndecidedEventRelation
  178. User
  179. UserFeed
  180. UserLicense
  181. UserLogin
  182. UserPreference
  183. UserProfile
  184. UserRecordAccess
  185. UserRole
  186. Vote
  187. WebLink

AcceptedEventRelation

This is a table representing the AcceptedEventRelation entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AcceptedEventRelation.

RelationId String True  

Label Relation ID corresponds to this field.

EventId String True

Event.Id

Label Event ID corresponds to this field.

RespondedDate Datetime True  

Label Response Date corresponds to this field.

Response String True  

Label Response corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Type String True  

Label Type corresponds to this field.

 

 

Account

This is a table representing the Account entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Account.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

MasterRecordId String True

Account.Id

Label Master Record ID corresponds to this field.

Name String False  

Label Account Name corresponds to this field.

Type String False  

Label Account Type corresponds to this field.

ParentId String False

Account.Id

Label Parent Account ID corresponds to this field.

BillingStreet String False  

Label Billing Street corresponds to this field.

BillingCity String False  

Label Billing City corresponds to this field.

BillingState String False  

Label Billing State/Province corresponds to this field.

BillingPostalCode String False  

Label Billing Zip/Postal Code corresponds to this field.

BillingCountry String False  

Label Billing Country corresponds to this field.

BillingLatitude Double False  

Label Billing Latitude corresponds to this field.

BillingLongitude Double False  

Label Billing Longitude corresponds to this field.

ShippingStreet String False  

Label Shipping Street corresponds to this field.

ShippingCity String False  

Label Shipping City corresponds to this field.

ShippingState String False  

Label Shipping State/Province corresponds to this field.

ShippingPostalCode String False  

Label Shipping Zip/Postal Code corresponds to this field.

ShippingCountry String False  

Label Shipping Country corresponds to this field.

ShippingLatitude Double False  

Label Shipping Latitude corresponds to this field.

ShippingLongitude Double False  

Label Shipping Longitude corresponds to this field.

Phone String False  

Label Account Phone corresponds to this field.

Fax String False  

Label Account Fax corresponds to this field.

AccountNumber String False  

Label Account Number corresponds to this field.

Website String False  

Label Website corresponds to this field.

Sic String False  

Label SIC Code corresponds to this field.

Industry String False  

Label Industry corresponds to this field.

AnnualRevenue Double False  

Label Annual Revenue corresponds to this field.

NumberOfEmployees Int False  

Label Employees corresponds to this field.

Ownership String False  

Label Ownership corresponds to this field.

TickerSymbol String False  

Label Ticker Symbol corresponds to this field.

Description String False  

Label Account Description corresponds to this field.

Rating String False  

Label Account Rating corresponds to this field.

Site String False  

Label Account Site corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastActivityDate Datetime True  

Label Last Activity corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

Jigsaw String False  

Label Data.com Key corresponds to this field.

JigsawCompanyId String True  

Label Jigsaw Company ID corresponds to this field.

AccountSource String False  

Label Account Source corresponds to this field.

SicDesc String False  

Label SIC Description corresponds to this field.

NumberofLocations__c Double False  

Label Number of Locations corresponds to this field.

SLAExpirationDate__c Datetime False  

Label SLA Expiration Date corresponds to this field.

UpsellOpportunity__c String False  

Label Upsell Opportunity corresponds to this field.

SLASerialNumber__c String False  

Label SLA Serial Number corresponds to this field.

SLA__c String False  

Label SLA corresponds to this field.

CustomerPriority__c String False  

Label Customer Priority corresponds to this field.

Active__c String False  

Label Active corresponds to this field.

MyAutoNumber__c String True  

Label MyAutoNumber corresponds to this field.

MyFormula__c String True  

Label MyFormula corresponds to this field.

MyRollupSummary__c Double True  

Label MyRollupSummary corresponds to this field.

MyCheckBox__c Boolean False  

Label MyCheckBox corresponds to this field.

MyEmail__c String False  

Label MyEmail corresponds to this field.

MyPercent__c Double False  

Label MyPercent corresponds to this field.

Custom_Date_Time__c Datetime False  

Label Custom Date Time corresponds to this field.

New_Currency_Field__c Double False  

Label New_Currency_Field corresponds to this field.

New_Currency_Field_2__c Double False  

Label New_Currency_Field_2 corresponds to this field.

DO_NOT_USE__c Boolean False  

Label DO_NOT_USE corresponds to this field.

CustomNumber__c Double False  

Label CustomNumber corresponds to this field.

FiveChar_TextField__c String False  

Label FiveChar_TextField corresponds to this field.

FiveChar_CurrencyField__c Double False  

Label FiveChar_CurrencyField corresponds to this field.

FiveChar_NumberField__c Double False  

Label FiveChar_NumberField corresponds to this field.

FiveChar_PercentField__c Double False  

Label FiveChar_PercentField corresponds to this field.

FiveChar_TextAreaMasked__c String False  

Label FiveChar_TextAreaMasked corresponds to this field.

NewField__c Double False  

Label NewField corresponds to this field.

 

 

 

AccountContactRole

This is a table representing the AccountContactRole entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AccountContactRole.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

AccountId String False

Account.Id

Label Account ID corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

Role String False  

Label Role corresponds to this field.

IsPrimary Boolean False  

Label Primary corresponds to this field.

 

 

 

AccountFeed

This is a table representing the AccountFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AccountFeed.

ParentId String True

Account.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

AccountHistory

This is a table representing the AccountHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AccountHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

AccountId String True

Account.Id

Label Account ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

AccountPartner

This is a table representing the AccountPartner entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AccountPartner.

AccountFromId String True

Account.Id

Label Account ID corresponds to this field.

AccountToId String True

Account.Id

Label Account ID corresponds to this field.

OpportunityId String True

Opportunity.Id

Label Opportunity ID corresponds to this field.

Role String True  

Label Role corresponds to this field.

IsPrimary Boolean True  

Label Primary corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ReversePartnerId String True

AccountPartner.Id

Label Reverse Partner ID corresponds to this field.

 

 

 

AccountShare

This is a table representing the AccountShare entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AccountShare.

AccountId String True

Account.Id

Label Account ID corresponds to this field.

UserOrGroupId String True  

Label User/Group ID corresponds to this field.

AccountAccessLevel String True  

Label Account Access corresponds to this field.

OpportunityAccessLevel String True  

Label Opportunity Access corresponds to this field.

CaseAccessLevel String True  

Label Case Access corresponds to this field.

ContactAccessLevel String True  

Label Contact Access corresponds to this field.

RowCause String True  

Label Row Cause corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

ActivityHistory

This is a table representing the ActivityHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Label 'Activity ID' corresponds to this field.

AccountId String True  

Label 'Account ID' corresponds to this field.

WhoId String True  

Label 'Contact/Lead ID' corresponds to this field.

WhatId String True  

Label 'Opportunity/Account ID' corresponds to this field.

Subject String True  

Label 'Subject' corresponds to this field.

IsTask Boolean True  

Label 'Task' corresponds to this field.

ActivityDate String True  

Label 'Date' corresponds to this field.

OwnerId String True  

Label 'Assigned To ID' corresponds to this field.

Status String True  

Label 'Status' corresponds to this field.

Priority String True  

Label 'Priority' corresponds to this field.

ActivityType String True  

Label 'Type' corresponds to this field.

IsClosed Boolean True  

Label 'Closed' corresponds to this field.

IsAllDayEvent Boolean True  

Label 'All Day Event' corresponds to this field.

DurationInMinutes Integer True  

Label 'Duration' corresponds to this field.

Location String True  

Label 'Location' corresponds to this field.

Description String True  

Label 'Comments' corresponds to this field.

IsDeleted Boolean True  

Label 'Deleted' corresponds to this field.

CreatedDate DateTime True  

Label 'Created Date' corresponds to this field.

CreatedById String True  

Label 'Created By ID' corresponds to this field.

LastModifiedDate DateTime True  

Label 'Last Modified Date' corresponds to this field.

LastModifiedById String True  

Label 'Last Modified By ID' corresponds to this field.

SystemModstamp DateTime True  

Label 'System Modstamp' corresponds to this field.

CallDurationInSeconds Integer True  

Label 'Call Duration' corresponds to this field.

CallType String True  

Label 'Call Type' corresponds to this field.

CallDisposition String True  

Label 'Call Result' corresponds to this field.

CallObject String True  

Label 'Call Object Identifier' corresponds to this field.

ReminderDateTime DateTime True  

Label 'Reminder Date/Time' corresponds to this field.

IsReminderSet Boolean True  

Label 'Reminder Set' corresponds to this field.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
SOQL String

Specifies the Where clause of the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precendence over any other input.

 

 

 

AdditionalNumber

This is a table representing the AdditionalNumber entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AdditionalNumber.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CallCenterId String False

CallCenter.Id

Label Call Center ID corresponds to this field.

Name String False  

Label Name corresponds to this field.

Description String False  

Label Description corresponds to this field.

Phone String False  

Label Phone corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ApexClass

This is a table representing the ApexClass entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ApexClass.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

Name String False  

Label Name corresponds to this field.

ApiVersion Double False  

Label Api Version corresponds to this field.

Status String False  

Label Status corresponds to this field.

IsValid Boolean False  

Label Is Valid corresponds to this field.

BodyCrc Double False  

Label Body CRC corresponds to this field.

Body String False  

Label Body corresponds to this field.

LengthWithoutComments Int False  

Label Size Without Comments corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ApexComponent

This is a table representing the ApexComponent entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ApexComponent.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

Name String False  

Label Name corresponds to this field.

ApiVersion Double False  

Label Api Version corresponds to this field.

MasterLabel String False  

Label Label corresponds to this field.

Description String False  

Label Description corresponds to this field.

ControllerType String False  

Label Controller Type corresponds to this field.

ControllerKey String False  

Label Controller Key corresponds to this field.

Markup String False  

Label Markup corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ApexLog

This is a table representing the ApexLog entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ApexLog.

LogUserId String True  

Label Log User ID corresponds to this field.

LogLength Int True  

Label Log Size (bytes) corresponds to this field.

LastModifiedDate Datetime True  

Label Date corresponds to this field.

Request String True  

Label Request Type corresponds to this field.

Operation String True  

Label Operation corresponds to this field.

Application String True  

Label Application corresponds to this field.

Status String True  

Label Status corresponds to this field.

DurationMilliseconds Int True  

Label Duration (ms) corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

StartTime Datetime True  

Label Start Time corresponds to this field.

Location String True  

Label Location corresponds to this field.

 

 

 

ApexPage

This is a table representing the ApexPage entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ApexPage.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

Name String False  

Label Name corresponds to this field.

ApiVersion Double False  

Label Api Version corresponds to this field.

MasterLabel String False  

Label Label corresponds to this field.

Description String False  

Label Description corresponds to this field.

ControllerType String False  

Label Controller Type corresponds to this field.

ControllerKey String False  

Label Controller Key corresponds to this field.

IsAvailableInTouch Boolean False  

Label Available for Salesforce mobile apps corresponds to this field.

IsConfirmationTokenRequired Boolean False  

Label Require CSRF protection on GET requests corresponds to this field.

Markup String False  

Label Markup corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ApexTestQueueItem

This is a table representing the ApexTestQueueItem entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ApexTestQueueItem.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

ApexClassId String False

ApexClass.Id

Label Class ID corresponds to this field.

Status String True  

Label Status corresponds to this field.

ExtendedStatus String True  

Label Status Detail corresponds to this field.

ParentJobId String True

AsyncApexJob.Id

Label Apex Job ID corresponds to this field.

 

 

 

ApexTestResult

This is a table representing the ApexTestResult entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ApexTestResult.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

TestTimestamp Datetime True  

Label Time Started corresponds to this field.

Outcome String True  

Label Pass/Fail corresponds to this field.

ApexClassId String True

ApexClass.Id

Label Class ID corresponds to this field.

MethodName String True  

Label Method Name corresponds to this field.

Message String True  

Label Error Message corresponds to this field.

StackTrace String True  

Label Stack Trace corresponds to this field.

AsyncApexJobId String True

AsyncApexJob.Id

Label Apex Job ID corresponds to this field.

QueueItemId String True

ApexTestQueueItem.Id

Label Apex Test Queue Item ID corresponds to this field.

ApexLogId String True

ApexLog.Id

Label Log ID corresponds to this field.

 

 

 

ApexTrigger

This is a table representing the ApexTrigger entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ApexTrigger.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

Name String False  

Label Name corresponds to this field.

TableEnumOrId String False  

Label Custom Object Definition ID corresponds to this field.

UsageBeforeInsert Boolean False  

Label BeforeInsert corresponds to this field.

UsageAfterInsert Boolean False  

Label AfterInsert corresponds to this field.

UsageBeforeUpdate Boolean False  

Label BeforeUpdate corresponds to this field.

UsageAfterUpdate Boolean False  

Label AfterUpdate corresponds to this field.

UsageBeforeDelete Boolean False  

Label BeforeDelete corresponds to this field.

UsageAfterDelete Boolean False  

Label AfterDelete corresponds to this field.

UsageIsBulk Boolean False  

Label IsBulk corresponds to this field.

UsageAfterUndelete Boolean False  

Label AfterUndelete corresponds to this field.

ApiVersion Double False  

Label Api Version corresponds to this field.

Status String False  

Label Status corresponds to this field.

IsValid Boolean False  

Label Is Valid corresponds to this field.

BodyCrc Double False  

Label Body CRC corresponds to this field.

Body String False  

Label Body corresponds to this field.

LengthWithoutComments Int False  

Label Size Without Comments corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

AppMenuItem

This is a table representing the AppMenuItem entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AppMenuItem.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

Name String True  

Label Developer Name corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

Label String True  

Label Label corresponds to this field.

Description String True  

Label Description corresponds to this field.

StartUrl String True  

Label Start Url corresponds to this field.

MobileStartUrl String True  

Label Mobile Start Url corresponds to this field.

LogoUrl String True  

Label Logo Image URL corresponds to this field.

IconUrl String True  

Label Icon Url corresponds to this field.

InfoUrl String True  

Label Info URL corresponds to this field.

IsUsingAdminAuthorization Boolean True  

Label IsUsingAdminAuthorization corresponds to this field.

MobilePlatform String True  

Label Mobile device OS platform corresponds to this field.

MobileMinOsVer String True  

Label Minimum required mobile device OS version corresponds to this field.

MobileDeviceType String True  

Label Type of mobile device corresponds to this field.

IsRegisteredDeviceOnly Boolean True  

Label App requires a registered mobile device corresponds to this field.

MobileAppVer String True  

Label Version of the mobile app corresponds to this field.

MobileAppInstalledDate Datetime True  

Label Date the mobile app was most recently installed corresponds to this field.

MobileAppInstalledVersion String True  

Label Most recently installed version of the mobile app corresponds to this field.

MobileAppBinaryId String True  

Label ID for the related mobile app binary corresponds to this field.

MobileAppInstallUrl String True  

Label URL to install the mobile app corresponds to this field.

Type String True  

Label App Type corresponds to this field.

 

 

 

Approval

This is a table representing the Approval entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Approval.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ParentId String False

Contract.Id

Label Parent ID corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

Status String False  

Label Status corresponds to this field.

RequestComment String False  

Label Request Comment corresponds to this field.

ApproveComment String False  

Label Approve/Reject Comment corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Asset

This is a table representing the Asset entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Asset.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

AccountId String False

Account.Id

Label Account ID corresponds to this field.

Product2Id String False

Product2.Id

Label Product ID corresponds to this field.

IsCompetitorProduct Boolean False  

Label Competitor Asset corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Name String False  

Label Asset Name corresponds to this field.

SerialNumber String False  

Label Serial Number corresponds to this field.

InstallDate Datetime False  

Label Install Date corresponds to this field.

PurchaseDate Datetime False  

Label Purchase Date corresponds to this field.

UsageEndDate Datetime False  

Label Usage End Date corresponds to this field.

Status String False  

Label Status corresponds to this field.

Price Double False  

Label Price corresponds to this field.

Quantity Double False  

Label Quantity corresponds to this field.

Description String False  

Label Description corresponds to this field.

 

 

 

AssetFeed

This is a table representing the AssetFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AssetFeed.

ParentId String True

Asset.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

AssignmentRule

This is a table representing the AssignmentRule entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AssignmentRule.

Name String True  

Label Name corresponds to this field.

SobjectType String True  

Label SObject Type corresponds to this field.

Active Boolean True  

Label Active corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

AsyncApexJob

This is a table representing the AsyncApexJob entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AsyncApexJob.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

JobType String True  

Label Job Type corresponds to this field.

ApexClassId String True

ApexClass.Id

Label Class ID corresponds to this field.

Status String True  

Label Status corresponds to this field.

JobItemsProcessed Int True  

Label Batches Processed corresponds to this field.

TotalJobItems Int True  

Label Total Batches corresponds to this field.

NumberOfErrors Int True  

Label Failures corresponds to this field.

CompletedDate Datetime True  

Label Completion Date corresponds to this field.

MethodName String True  

Label Apex Method corresponds to this field.

ExtendedStatus String True  

Label Status Detail corresponds to this field.

ParentJobId String True

AsyncApexJob.Id

Label Apex Job ID corresponds to this field.

LastProcessed String True  

Label Last ID processed and committed corresponds to this field.

LastProcessedOffset Int True  

Label Offset of last ID processed and committed corresponds to this field.

 

 

 

Attachment

This is a table representing the Attachment entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Attachment.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ParentId String False  

Label Parent ID corresponds to this field.

Name String False  

Label File Name corresponds to this field.

IsPrivate Boolean False  

Label Private corresponds to this field.

ContentType String False  

Label Content Type corresponds to this field.

BodyLength Int True  

Label Body Length corresponds to this field.

Body String False  

Label Body corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True  

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

Description String False  

Label Description corresponds to this field.

 

 

 

AuthProvider

This is a table representing the AuthProvider entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AuthProvider.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

ProviderType String False  

Label Provider Type corresponds to this field.

FriendlyName String False  

Label Name corresponds to this field.

DeveloperName String False  

Label URL Suffix corresponds to this field.

RegistrationHandlerId String False

ApexClass.Id

Label Class ID corresponds to this field.

ExecutionUserId String False

User.Id

Label User ID corresponds to this field.

ConsumerKey String False  

Label Consumer Key corresponds to this field.

ConsumerSecret String False  

Label Consumer Secret corresponds to this field.

ErrorUrl String False  

Label Custom Error URL corresponds to this field.

AuthorizeUrl String False  

Label Authorize Endpoint URL corresponds to this field.

TokenUrl String False  

Label Token Endpoint URL corresponds to this field.

UserInfoUrl String False  

Label User Info Endpoint URL corresponds to this field.

DefaultScopes String False  

Label Default Scopes corresponds to this field.

 

 

 

AuthSession

This is a table representing the AuthSession entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the AuthSession.

UsersId String True

User.Id

Label User ID corresponds to this field.

CreatedDate Datetime True  

Label Created corresponds to this field.

LastModifiedDate Datetime True  

Label Updated corresponds to this field.

NumSecondsValid Int True  

Label Valid For corresponds to this field.

UserType String True  

Label User Type corresponds to this field.

SourceIp String True  

Label Source IP corresponds to this field.

LoginType String True  

Label Login corresponds to this field.

SessionType String True  

Label Session Type corresponds to this field.

SessionSecurityLevel String True  

Label Session Security Level corresponds to this field.

 

 

 

BrandTemplate

This is a table representing the BrandTemplate entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the BrandTemplate.

Name String False  

Label Brand Template Name corresponds to this field.

DeveloperName String False  

Label Letterhead Unique Name corresponds to this field.

IsActive Boolean False  

Label Active corresponds to this field.

Description String False  

Label Description corresponds to this field.

Value String False  

Label Value corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

BusinessHours

This is a table representing the BusinessHours entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the BusinessHours.

Name String False  

Label Business Hours Name corresponds to this field.

IsActive Boolean False  

Label Active corresponds to this field.

IsDefault Boolean False  

Label Default Business Hours corresponds to this field.

SundayStartTime String False  

Label Sunday Start corresponds to this field.

SundayEndTime String False  

Label Sunday End corresponds to this field.

MondayStartTime String False  

Label Monday Start corresponds to this field.

MondayEndTime String False  

Label Monday End corresponds to this field.

TuesdayStartTime String False  

Label Tuesday Start corresponds to this field.

TuesdayEndTime String False  

Label Tuesday End corresponds to this field.

WednesdayStartTime String False  

Label Wednesday Start corresponds to this field.

WednesdayEndTime String False  

Label Wednesday End corresponds to this field.

ThursdayStartTime String False  

Label Thursday Start corresponds to this field.

ThursdayEndTime String False  

Label Thursday End corresponds to this field.

FridayStartTime String False  

Label Friday Start corresponds to this field.

FridayEndTime String False  

Label Friday End corresponds to this field.

SaturdayStartTime String False  

Label Saturday Start corresponds to this field.

SaturdayEndTime String False  

Label Saturday End corresponds to this field.

TimeZoneSidKey String False  

Label Time Zone corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

 

 

 

BusinessProcess

This is a table representing the BusinessProcess entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the BusinessProcess.

Name String False  

Label Name corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

Description String False  

Label Description corresponds to this field.

TableEnumOrId String False  

Label Entity Enumeration Or ID corresponds to this field.

IsActive Boolean True  

Label Active corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CallCenter

This is a table representing the CallCenter entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CallCenter.

Name String False  

Label Name corresponds to this field.

InternalName String False  

Label Internal Name corresponds to this field.

Version Double False  

Label Version corresponds to this field.

AdapterUrl String False  

Label CTI Adapter URL corresponds to this field.

CustomSettings String False  

Label Custom Settings corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

 

 

 

Campaign

This is a table representing the Campaign entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Campaign.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Name String False  

Label Name corresponds to this field.

Type String False  

Label Type corresponds to this field.

Status String False  

Label Status corresponds to this field.

StartDate Datetime False  

Label Start Date corresponds to this field.

EndDate Datetime False  

Label End Date corresponds to this field.

ExpectedRevenue Double False  

Label Expected Revenue corresponds to this field.

BudgetedCost Double False  

Label Budgeted Cost corresponds to this field.

ActualCost Double False  

Label Actual Cost corresponds to this field.

ExpectedResponse Double False  

Label Expected Response (%) corresponds to this field.

NumberSent Double False  

Label Num Sent corresponds to this field.

IsActive Boolean False  

Label Active corresponds to this field.

Description String False  

Label Description corresponds to this field.

NumberOfLeads Int True  

Label Total Leads corresponds to this field.

NumberOfConvertedLeads Int True  

Label Converted Leads corresponds to this field.

NumberOfContacts Int True  

Label Total Contacts corresponds to this field.

NumberOfResponses Int True  

Label Total Responses corresponds to this field.

NumberOfOpportunities Int True  

Label Num Total Opportunities corresponds to this field.

NumberOfWonOpportunities Int True  

Label Num Won Opportunities corresponds to this field.

AmountAllOpportunities Double True  

Label Total Value Opportunities corresponds to this field.

AmountWonOpportunities Double True  

Label Total Value Won Opportunities corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastActivityDate Datetime True  

Label Last Activity corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

CampaignMemberRecordTypeId String False

RecordType.Id

Label Record Type ID corresponds to this field.

Myfield__c String False  

Label Myfield Nothing to do here corresponds to this field.

 

 

 

CampaignFeed

This is a table representing the CampaignFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CampaignFeed.

ParentId String True

Campaign.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

CampaignMember

This is a table representing the CampaignMember entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CampaignMember.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CampaignId String False

Campaign.Id

Label Campaign ID corresponds to this field.

LeadId String False

Lead.Id

Label Lead ID corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

Status String False  

Label Status corresponds to this field.

HasResponded Boolean True  

Label Responded corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

FirstRespondedDate Datetime True  

Label First Responded Date corresponds to this field.

 

 

 

CampaignMemberStatus

This is a table representing the CampaignMemberStatus entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CampaignMemberStatus.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CampaignId String False

Campaign.Id

Label Campaign ID corresponds to this field.

Label String False  

Label Label corresponds to this field.

SortOrder Int False  

Label Sort Order corresponds to this field.

IsDefault Boolean False  

Label Is Default corresponds to this field.

HasResponded Boolean False  

Label Responded corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CampaignShare

This is a table representing the CampaignShare entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CampaignShare.

CampaignId String True

Campaign.Id

Label Campaign ID corresponds to this field.

UserOrGroupId String True  

Label User/Group ID corresponds to this field.

CampaignAccessLevel String True  

Label Campaign Access corresponds to this field.

RowCause String True  

Label Row Cause corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

Case

This is a table representing the Case entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Case.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CaseNumber String True  

Label Case Number corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

AccountId String False

Account.Id

Label Account ID corresponds to this field.

AssetId String False

Asset.Id

Label Asset ID corresponds to this field.

SuppliedName String False  

Label Name corresponds to this field.

SuppliedEmail String False  

Label Email Address corresponds to this field.

SuppliedPhone String False  

Label Phone corresponds to this field.

SuppliedCompany String False  

Label Company corresponds to this field.

Type String False  

Label Case Type corresponds to this field.

RecordTypeId String False

RecordType.Id

Label Record Type ID corresponds to this field.

Status String False  

Label Status corresponds to this field.

Reason String False  

Label Case Reason corresponds to this field.

Origin String False  

Label Case Origin corresponds to this field.

Subject String False  

Label Subject corresponds to this field.

Priority String False  

Label Priority corresponds to this field.

Description String False  

Label Description corresponds to this field.

IsClosed Boolean True  

Label Closed corresponds to this field.

ClosedDate Datetime True  

Label Closed Date corresponds to this field.

IsEscalated Boolean False  

Label Escalated corresponds to this field.

HasCommentsUnreadByOwner Boolean True  

Label New Self-Service Comment corresponds to this field.

HasSelfServiceComments Boolean True  

Label Self-Service Commented corresponds to this field.

OwnerId String False  

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

EngineeringReqNumber__c String False  

Label Engineering Req Number corresponds to this field.

Product__c String False  

Label Product corresponds to this field.

SLAViolation__c String False  

Label SLA Violation corresponds to this field.

PotentialLiability__c String False  

Label Potential Liability corresponds to this field.

TCO_Presentation__c Datetime False  

Label TCO_Presentation corresponds to this field.

 

 

 

CaseComment

This is a table representing the CaseComment entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseComment.

ParentId String False

Case.Id

Label Parent ID corresponds to this field.

IsPublished Boolean False  

Label Published corresponds to this field.

CommentBody String False  

Label Body corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True  

Label Last Modified By ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

CaseContactRole

This is a table representing the CaseContactRole entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseContactRole.

CasesId String False

Case.Id

Label Case ID corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

Role String False  

Label Role corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

CaseFeed

This is a table representing the CaseFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseFeed.

ParentId String True

Case.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

CaseHistory

This is a table representing the CaseHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CaseId String True

Case.Id

Label Case ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

CaseShare

This is a table representing the CaseShare entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseShare.

CaseId String True

Case.Id

Label Case ID corresponds to this field.

UserOrGroupId String True  

Label User/Group ID corresponds to this field.

CaseAccessLevel String True  

Label Case Access corresponds to this field.

RowCause String True  

Label Row Cause corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

CaseSolution

This is a table representing the CaseSolution entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseSolution.

CaseId String False

Case.Id

Label Case ID corresponds to this field.

SolutionId String False

Solution.Id

Label Solution ID corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

CaseStatus

This is a table representing the CaseStatus entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseStatus.

MasterLabel String True  

Label Master Label corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

IsDefault Boolean True  

Label Is Default corresponds to this field.

IsClosed Boolean True  

Label Is Closed corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CaseTeamMember

This is a table representing the CaseTeamMember entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseTeamMember.

ParentId String False

Case.Id

Label Case ID corresponds to this field.

MemberId String False  

Label Member ID corresponds to this field.

TeamTemplateMemberId String True

CaseTeamTemplateMember.Id

Label Team Template Member ID corresponds to this field.

TeamRoleId String False

CaseTeamRole.Id

Label Team Role ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CaseTeamRole

This is a table representing the CaseTeamRole entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseTeamRole.

Name String False  

Label Name corresponds to this field.

AccessLevel String False  

Label Access Level corresponds to this field.

PreferencesVisibleInCSP Boolean False  

Label Visible in Customer Portal corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CaseTeamTemplate

This is a table representing the CaseTeamTemplate entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseTeamTemplate.

Name String False  

Label Name corresponds to this field.

Description String False  

Label Description corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CaseTeamTemplateMember

This is a table representing the CaseTeamTemplateMember entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseTeamTemplateMember.

TeamTemplateId String False

CaseTeamTemplate.Id

Label Team Template ID corresponds to this field.

MemberId String False  

Label Member ID corresponds to this field.

TeamRoleId String False

CaseTeamRole.Id

Label Team Role ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CaseTeamTemplateRecord

This is a table representing the CaseTeamTemplateRecord entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CaseTeamTemplateRecord.

ParentId String False

Case.Id

Label Case ID corresponds to this field.

TeamTemplateId String False

CaseTeamTemplate.Id

Label Team Template ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CategoryData

This is a table representing the CategoryData entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CategoryData.

CategoryNodeId String False

CategoryNode.Id

Label Category Node ID corresponds to this field.

RelatedSobjectId String False

Solution.Id

Label SObject ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CategoryNode

This is a table representing the CategoryNode entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CategoryNode.

ParentId String False

CategoryNode.Id

Label Parent Category Node ID corresponds to this field.

MasterLabel String False  

Label Name corresponds to this field.

SortOrder Int False  

Label Sort Order corresponds to this field.

SortStyle String False  

Label Subcategory Sort Style corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ChatterActivity

This is a table representing the ChatterActivity entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ChatterActivity.

ParentId String True  

Label Parent ID corresponds to this field.

PostCount Int True  

Label Post Count corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

CommentReceivedCount Int True  

Label Comment Received Count corresponds to this field.

LikeReceivedCount Int True  

Label Like Received Count corresponds to this field.

InfluenceRawRank Int True  

Label Influence Raw Rank corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ClientBrowser

This is a table representing the ClientBrowser entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ClientBrowser.

UsersId String True

User.Id

Label User ID corresponds to this field.

FullUserAgent String True  

Label Full User Agent corresponds to this field.

ProxyInfo String True  

Label Proxy Info corresponds to this field.

LastUpdate Datetime True  

Label Last Update corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

 

 

 

CollaborationGroup

This is a table representing the CollaborationGroup entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CollaborationGroup.

Name String False  

Label Name corresponds to this field.

MemberCount Int True  

Label Member Count corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CollaborationType String False  

Label Access Type corresponds to this field.

Description String False  

Label Description corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

FullPhotoUrl String True  

Label Url for full-sized Photo corresponds to this field.

SmallPhotoUrl String True  

Label Url for Thumbnail sized Photo corresponds to this field.

LastFeedModifiedDate Datetime True  

Label Last Feed Modified Date corresponds to this field.

InformationTitle String False  

Label Information Title corresponds to this field.

InformationBody String False  

Label Information corresponds to this field.

HasPrivateFieldsAccess Boolean True  

Label Has Private Fields Access corresponds to this field.

CanHaveGuests Boolean False  

Label Allow Customers corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

IsArchived Boolean False  

Label Is Archived corresponds to this field.

IsAutoArchiveDisabled Boolean False  

Label Is Auto Archive Disabled corresponds to this field.

 

 

 

CollaborationGroupFeed

This is a table representing the CollaborationGroupFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CollaborationGroupFeed.

ParentId String True

CollaborationGroup.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

CollaborationGroupMember

This is a table representing the CollaborationGroupMember entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CollaborationGroupMember.

CollaborationGroupId String False

CollaborationGroup.Id

Label CollaborationGroup ID corresponds to this field.

MemberId String False

User.Id

Label Member ID corresponds to this field.

CollaborationRole String False  

Label Group Member Role corresponds to this field.

NotificationFrequency String False  

Label Notification Frequency corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CollaborationGroupMemberRequest

This is a table representing the CollaborationGroupMemberRequest entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CollaborationGroupMemberRequest.

CollaborationGroupId String False

CollaborationGroup.Id

Label CollaborationGroup ID corresponds to this field.

RequesterId String False

User.Id

Label User ID corresponds to this field.

ResponseMessage String True  

Label Response Message corresponds to this field.

Status String True  

Label Status corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CollaborationInvitation

This is a table representing the CollaborationInvitation entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CollaborationInvitation.

ParentId String True

CollaborationInvitation.Id

Label Parent ID corresponds to this field.

SharedEntityId String False  

Label Shared Entity ID corresponds to this field.

InviterId String True

User.Id

Label Inviter User ID corresponds to this field.

InvitedUserEmail String False  

Label Invited Email corresponds to this field.

InvitedUserEmailNormalized String True  

Label Invited Email (Normalized) corresponds to this field.

Status String True  

Label Invitation Status corresponds to this field.

OptionalMessage String False  

Label Optional Message corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Community

This is a table representing the Community entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Community.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

Name String True  

Label Name corresponds to this field.

Description String True  

Label Description corresponds to this field.

IsActive Boolean True  

Label Active corresponds to this field.

 

 

 

Contact

This is a table representing the Contact entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Contact.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

MasterRecordId String True

Contact.Id

Label Master Record ID corresponds to this field.

AccountId String False

Account.Id

Label Account ID corresponds to this field.

LastName String False  

Label Last Name corresponds to this field.

FirstName String False  

Label First Name corresponds to this field.

Salutation String False  

Label Salutation corresponds to this field.

Name String True  

Label Full Name corresponds to this field.

OtherStreet String False  

Label Other Street corresponds to this field.

OtherCity String False  

Label Other City corresponds to this field.

OtherState String False  

Label Other State/Province corresponds to this field.

OtherPostalCode String False  

Label Other Zip/Postal Code corresponds to this field.

OtherCountry String False  

Label Other Country corresponds to this field.

OtherLatitude Double False  

Label Other Latitude corresponds to this field.

OtherLongitude Double False  

Label Other Longitude corresponds to this field.

MailingStreet String False  

Label Mailing Street corresponds to this field.

MailingCity String False  

Label Mailing City corresponds to this field.

MailingState String False  

Label Mailing State/Province corresponds to this field.

MailingPostalCode String False  

Label Mailing Zip/Postal Code corresponds to this field.

MailingCountry String False  

Label Mailing Country corresponds to this field.

MailingLatitude Double False  

Label Mailing Latitude corresponds to this field.

MailingLongitude Double False  

Label Mailing Longitude corresponds to this field.

Phone String False  

Label Business Phone corresponds to this field.

Fax String False  

Label Business Fax corresponds to this field.

MobilePhone String False  

Label Mobile Phone corresponds to this field.

HomePhone String False  

Label Home Phone corresponds to this field.

OtherPhone String False  

Label Other Phone corresponds to this field.

AssistantPhone String False  

Label Asst. Phone corresponds to this field.

ReportsToId String False

Contact.Id

Label Reports To ID corresponds to this field.

Email String False  

Label Email corresponds to this field.

Title String False  

Label Title corresponds to this field.

Department String False  

Label Department corresponds to this field.

AssistantName String False  

Label Assistant's Name corresponds to this field.

LeadSource String False  

Label Lead Source corresponds to this field.

Birthdate Datetime False  

Label Birthdate corresponds to this field.

Description String False  

Label Contact Description corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastActivityDate Datetime True  

Label Last Activity corresponds to this field.

LastCURequestDate Datetime True  

Label Last Stay-in-Touch Request Date corresponds to this field.

LastCUUpdateDate Datetime True  

Label Last Stay-in-Touch Save Date corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

EmailBouncedReason String False  

Label Email Bounced Reason corresponds to this field.

EmailBouncedDate Datetime False  

Label Email Bounced Date corresponds to this field.

IsEmailBounced Boolean True  

Label Is Email Bounced corresponds to this field.

Jigsaw String False  

Label Data.com Key corresponds to this field.

JigsawContactId String True  

Label Jigsaw Contact ID corresponds to this field.

Languages__c String False  

Label Languages corresponds to this field.

Level__c String False  

Label Level corresponds to this field.

MyNote__c String False  

Label MyNote corresponds to this field.

MyExternalId__c String False  

Label MyExternalId corresponds to this field.

MyExternalId2__c String False  

Label MyExternalId2 corresponds to this field.

AcctLookup__c String False

Account.Id

Label Account corresponds to this field.

 

 

 

ContactFeed

This is a table representing the ContactFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContactFeed.

ParentId String True

Contact.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

ContactHistory

This is a table representing the ContactHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContactHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ContactId String True

Contact.Id

Label Contact ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

ContactShare

This is a table representing the ContactShare entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContactShare.

ContactId String True

Contact.Id

Label Contact ID corresponds to this field.

UserOrGroupId String True  

Label User/Group ID corresponds to this field.

ContactAccessLevel String True  

Label Contact Access corresponds to this field.

RowCause String True  

Label Row Cause corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

ContentDocument

This is a table representing the ContentDocument entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContentDocument.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

IsArchived Boolean True  

Label Is Archived corresponds to this field.

ArchivedById String True

User.Id

Label User ID corresponds to this field.

ArchivedDate Datetime True  

Label Archived Date corresponds to this field.

IsDeleted Boolean True  

Label Is Deleted corresponds to this field.

OwnerId String True

User.Id

Label Owner ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

Title String True  

Label Title corresponds to this field.

PublishStatus String True  

Label Publish Status corresponds to this field.

LatestPublishedVersionId String True

ContentVersion.Id

Label Latest Published Version ID corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

 

 

 

ContentDocumentFeed

This is a table representing the ContentDocumentFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContentDocumentFeed.

ParentId String True

ContentDocument.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

ContentDocumentHistory

This is a table representing the ContentDocumentHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContentDocumentHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ContentDocumentId String True

ContentDocument.Id

Label ContentDocument ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

ContentDocumentLink

This is a table representing the ContentDocumentLink entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContentDocumentLink.

LinkedEntityId String False  

Label Linked Entity ID corresponds to this field.

ContentDocumentId String False

ContentDocument.Id

Label ContentDocument ID corresponds to this field.

IsDeleted Boolean True  

Label Is Deleted corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

ShareType String False  

Label Share Type corresponds to this field.

 

 

 

ContentVersion

This is a table representing the ContentVersion entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContentVersion.

ContentDocumentId String False

ContentDocument.Id

Label ContentDocument ID corresponds to this field.

IsLatest Boolean True  

Label Is Latest corresponds to this field.

ContentUrl String False  

Label Content URL corresponds to this field.

VersionNumber String True  

Label Version Number corresponds to this field.

Title String False  

Label Title corresponds to this field.

Description String False  

Label Description corresponds to this field.

ReasonForChange String False  

Label Reason For Change corresponds to this field.

PathOnClient String False  

Label Path On Client corresponds to this field.

RatingCount Int True  

Label Rating Count corresponds to this field.

IsDeleted Boolean True  

Label Is Deleted corresponds to this field.

ContentModifiedDate Datetime True  

Label Content Modified Date corresponds to this field.

ContentModifiedById String True

User.Id

Label User ID corresponds to this field.

PositiveRatingCount Int True  

Label Positive Rating Count corresponds to this field.

NegativeRatingCount Int True  

Label Negative Rating Count corresponds to this field.

FeaturedContentBoost Int True  

Label Featured Content Boost corresponds to this field.

FeaturedContentDate Datetime True  

Label Featured Content Date corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

TagCsv String False  

Label Tags corresponds to this field.

FileType String True  

Label File Type corresponds to this field.

PublishStatus String True  

Label Publish Status corresponds to this field.

VersionData String False  

Label Version Data corresponds to this field.

ContentSize Int True  

Label Size corresponds to this field.

FirstPublishLocationId String False  

Label First Publish Location ID corresponds to this field.

Origin String False  

Label Content Origin corresponds to this field.

Checksum String True  

Label Checksum corresponds to this field.

 

 

 

ContentVersionHistory

This is a table representing the ContentVersionHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContentVersionHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ContentVersionId String True

ContentVersion.Id

Label ContentVersion ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

Contract

This is a table representing the Contract entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Contract.

AccountId String False

Account.Id

Label Account ID corresponds to this field.

OwnerExpirationNotice String False  

Label Owner Expiration Notice corresponds to this field.

StartDate Datetime False  

Label Contract Start Date corresponds to this field.

EndDate Datetime True  

Label Contract End Date corresponds to this field.

BillingStreet String False  

Label Billing Street corresponds to this field.

BillingCity String False  

Label Billing City corresponds to this field.

BillingState String False  

Label Billing State/Province corresponds to this field.

BillingPostalCode String False  

Label Billing Zip/Postal Code corresponds to this field.

BillingCountry String False  

Label Billing Country corresponds to this field.

BillingLatitude Double False  

Label Billing Latitude corresponds to this field.

BillingLongitude Double False  

Label Billing Longitude corresponds to this field.

ContractTerm Int False  

Label Contract Term corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

Status String False  

Label Status corresponds to this field.

CompanySignedId String False

User.Id

Label Company Signed By ID corresponds to this field.

CompanySignedDate Datetime False  

Label Company Signed Date corresponds to this field.

CustomerSignedId String False

Contact.Id

Label Customer Signed By ID corresponds to this field.

CustomerSignedTitle String False  

Label Customer Signed Title corresponds to this field.

CustomerSignedDate Datetime False  

Label Customer Signed Date corresponds to this field.

SpecialTerms String False  

Label Special Terms corresponds to this field.

ActivatedById String True

User.Id

Label Activated By ID corresponds to this field.

ActivatedDate Datetime True  

Label Activated Date corresponds to this field.

StatusCode String True  

Label Status Category corresponds to this field.

Description String False  

Label Description corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ContractNumber String True  

Label Contract Number corresponds to this field.

LastApprovedDate Datetime True  

Label Last Approved Date corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastActivityDate Datetime True  

Label Last Activity corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

 

 

 

ContractContactRole

This is a table representing the ContractContactRole entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContractContactRole.

ContractId String False

Contract.Id

Label Contract ID corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

Role String False  

Label Role corresponds to this field.

IsPrimary Boolean False  

Label Primary corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

ContractFeed

This is a table representing the ContractFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContractFeed.

ParentId String True

Contract.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

ContractHistory

This is a table representing the ContractHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContractHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ContractId String True

Contract.Id

Label Contract ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

ContractStatus

This is a table representing the ContractStatus entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ContractStatus.

MasterLabel String True  

Label Master Label corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

IsDefault Boolean True  

Label Is Default corresponds to this field.

StatusCode String True  

Label Status Code corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

CronJobDetail

This is a table representing the CronJobDetail entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CronJobDetail.

Name String True  

Label Job Name corresponds to this field.

JobType String True  

Label Type corresponds to this field.

 

 

 

CronTrigger

This is a table representing the CronTrigger entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the CronTrigger.

CronJobDetailId String True

CronJobDetail.Id

Label Job ID corresponds to this field.

NextFireTime Datetime True  

Label Next Run Time corresponds to this field.

PreviousFireTime Datetime True  

Label Previous Run Time corresponds to this field.

State String True  

Label Job State corresponds to this field.

StartTime Datetime True  

Label Start Time corresponds to this field.

EndTime Datetime True  

Label End Time corresponds to this field.

CronExpression String True  

Label Cron Expression corresponds to this field.

TimeZoneSidKey String True  

Label Java Time Zone Id corresponds to this field.

OwnerId String True

User.Id

Label User ID corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

TimesTriggered Int True  

Label Job Fired Count corresponds to this field.

 

 

 

Dashboard

This is a table representing the Dashboard entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Dashboard.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

FolderId String True  

Label Folder ID corresponds to this field.

Title String True  

Label Title corresponds to this field.

DeveloperName String True  

Label Dashboard Unique Name corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

Description String True  

Label Description corresponds to this field.

LeftSize String True  

Label Left Size corresponds to this field.

MiddleSize String True  

Label Middle Size corresponds to this field.

RightSize String True  

Label Right Size corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

RunningUserId String True

User.Id

Label Running User ID corresponds to this field.

TitleColor Int True  

Label Title Color corresponds to this field.

TitleSize Int True  

Label Title Size corresponds to this field.

TextColor Int True  

Label Text Color corresponds to this field.

BackgroundStart Int True  

Label Starting Color corresponds to this field.

BackgroundEnd Int True  

Label Ending Color corresponds to this field.

BackgroundDirection String True  

Label Background Fade Direction corresponds to this field.

Type String True  

Label Dashboard Running User corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

 

 

 

DashboardComponent

This is a table representing the DashboardComponent entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the DashboardComponent.

Name String True  

Label Dashboard Component Name corresponds to this field.

DashboardId String True

Dashboard.Id

Label Dashboard ID corresponds to this field.

 

 

 

DashboardComponentFeed

This is a table representing the DashboardComponentFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the DashboardComponentFeed.

ParentId String True

DashboardComponent.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

DashboardFeed

This is a table representing the DashboardFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the DashboardFeed.

ParentId String True

Dashboard.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

DeclinedEventRelation

This is a table representing the DeclinedEventRelation entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the DeclinedEventRelation.

RelationId String True  

Label Relation ID corresponds to this field.

EventId String True

Event.Id

Label Event ID corresponds to this field.

RespondedDate Datetime True  

Label Response Date corresponds to this field.

Response String True  

Label Response corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Type String True  

Label Type corresponds to this field.

 

 

 

Document

This is a table representing the Document entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Document.

FolderId String False  

Label Folder ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Name String False  

Label Document Name corresponds to this field.

DeveloperName String False  

Label Document Unique Name corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

ContentType String False  

Label MIME Type corresponds to this field.

Type String False  

Label File Extension corresponds to this field.

IsPublic Boolean False  

Label Externally Available corresponds to this field.

BodyLength Int True  

Label Body Length corresponds to this field.

Body String False  

Label Body corresponds to this field.

Url String False  

Label Url corresponds to this field.

Description String False  

Label Description corresponds to this field.

Keywords String False  

Label Keywords corresponds to this field.

IsInternalUseOnly Boolean False  

Label Internal Use Only corresponds to this field.

AuthorId String False

User.Id

Label Author ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsBodySearchable Boolean True  

Label Document Content Searchable corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

 

 

 

DocumentAttachmentMap

This is a table representing the DocumentAttachmentMap entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the DocumentAttachmentMap.

ParentId String False

EmailTemplate.Id

Label Entity ID corresponds to this field.

DocumentId String False

Document.Id

Label Document ID corresponds to this field.

DocumentSequence Int False  

Label Attachment Sequence corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

 

 

 

Domain

This is a table representing the Domain entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Domain.

DomainType String True  

Label Domain Type corresponds to this field.

Domain String True  

Label Domain Name corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

DomainSite

This is a table representing the DomainSite entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the DomainSite.

DomainId String True

Domain.Id

Label Domain ID corresponds to this field.

SiteId String True

Site.Id

Label Site ID corresponds to this field.

PathPrefix String True  

Label Path corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

EmailServicesAddress

This is a table representing the EmailServicesAddress entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the EmailServicesAddress.

IsActive Boolean False  

Label Active corresponds to this field.

LocalPart String False  

Label Email address corresponds to this field.

EmailDomainName String True  

Label Email address domain corresponds to this field.

AuthorizedSenders String False  

Label Accept Email From corresponds to this field.

RunAsUserId String False

User.Id

Label User ID corresponds to this field.

FunctionId String False

EmailServicesFunction.Id

Label Service ID corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

EmailServicesFunction

This is a table representing the EmailServicesFunction entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the EmailServicesFunction.

IsActive Boolean False  

Label Active corresponds to this field.

FunctionName String False  

Label Email Service Name corresponds to this field.

AuthorizedSenders String False  

Label Accept Email From corresponds to this field.

IsAuthenticationRequired Boolean False  

Label Advanced Email Security Settings corresponds to this field.

IsTlsRequired Boolean False  

Label TLS Required corresponds to this field.

AttachmentOption String False  

Label Accept Attachments corresponds to this field.

ApexClassId String False

ApexClass.Id

Label Class ID corresponds to this field.

OverLimitAction String False  

Label Over Email Rate Limit Action corresponds to this field.

FunctionInactiveAction String False  

Label Deactivated Email Service Action corresponds to this field.

AddressInactiveAction String False  

Label Deactivated Email Address Action corresponds to this field.

AuthenticationFailureAction String False  

Label Unauthenticated Sender Action corresponds to this field.

AuthorizationFailureAction String False  

Label Unauthorized Sender Action corresponds to this field.

IsErrorRoutingEnabled Boolean False  

Label Enable Error Routing corresponds to this field.

ErrorRoutingAddress String False  

Label Route Error Emails to This Email Address corresponds to this field.

IsTextAttachmentsAsBinary Boolean False  

Label Convert Text Attachments to Binary Attachments corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

EmailStatus

This is a table representing the EmailStatus entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Label 'Email Status ID' corresponds to this field.

TaskId String True  

Label 'Activity ID' corresponds to this field.

WhoId String True  

Label 'Contact/Lead ID' corresponds to this field.

CreatedDate DateTime True  

Label 'Created Date' corresponds to this field.

CreatedById String True  

Label 'Created By ID' corresponds to this field.

LastModifiedDate DateTime True  

Label 'Last Modified Date' corresponds to this field.

LastModifiedById String True  

Label 'Last Modified By ID' corresponds to this field.

TimesOpened Integer True  

Label '# Times Opened' corresponds to this field.

FirstOpenDate DateTime True  

Label 'Date Opened' corresponds to this field.

LastOpenDate DateTime True  

Label 'Last Opened' corresponds to this field.

EmailTemplateName String True  

Label 'Email Template Name' corresponds to this field.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
SOQL String

Specifies the Where clause of the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precendence over any other input.

 

 

 

EmailTemplate

This is a table representing the EmailTemplate entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the EmailTemplate.

Name String False  

Label Email Template Name corresponds to this field.

DeveloperName String False  

Label Template Unique Name corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

FolderId String False  

Label Folder ID corresponds to this field.

BrandTemplateId String False

BrandTemplate.Id

Label Letterhead ID corresponds to this field.

TemplateStyle String False  

Label Style corresponds to this field.

IsActive Boolean False  

Label Available For Use corresponds to this field.

TemplateType String False  

Label Template Type corresponds to this field.

Encoding String False  

Label Encoding corresponds to this field.

Description String False  

Label Description corresponds to this field.

Subject String False  

Label Subject corresponds to this field.

HtmlValue String False  

Label HTML Value corresponds to this field.

Body String False  

Label Email Body corresponds to this field.

TimesUsed Int True  

Label Times Used corresponds to this field.

LastUsedDate Datetime True  

Label Last Used Date corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

ApiVersion Double False  

Label API Version corresponds to this field.

Markup String False  

Label Markup corresponds to this field.

 

 

 

EntitySubscription

This is a table representing the EntitySubscription entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the EntitySubscription.

ParentId String False  

Label Parent ID corresponds to this field.

SubscriberId String False

User.Id

Label Subscriber ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

Event

This is a table representing the Event entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Event.

WhoId String False  

Label Contact/Lead ID corresponds to this field.

WhatId String False  

Label Opportunity/Account ID corresponds to this field.

Subject String False  

Label Subject corresponds to this field.

Location String False  

Label Location corresponds to this field.

IsAllDayEvent Boolean False  

Label All-Day Event corresponds to this field.

ActivityDateTime Datetime False  

Label Due Date Time corresponds to this field.

ActivityDate Datetime False  

Label Due Date Only corresponds to this field.

DurationInMinutes Int False  

Label Duration corresponds to this field.

StartDateTime Datetime False  

Label Start Date Time corresponds to this field.

EndDateTime Datetime False  

Label End Date Time corresponds to this field.

Description String False  

Label Description corresponds to this field.

AccountId String True

Account.Id

Label Account ID corresponds to this field.

OwnerId String False

User.Id

Label Assigned To ID corresponds to this field.

IsPrivate Boolean False  

Label Private corresponds to this field.

ShowAs String False  

Label Show Time As corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

IsChild Boolean True  

Label Is Child corresponds to this field.

IsGroupEvent Boolean True  

Label Is Group Event corresponds to this field.

GroupEventType String True  

Label Group Event Type corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsArchived Boolean True  

Label Archived corresponds to this field.

RecurrenceActivityId String True

Event.Id

Label Recurrence Activity ID corresponds to this field.

IsRecurrence Boolean False  

Label Create Recurring Series of Events corresponds to this field.

RecurrenceStartDateTime Datetime False  

Label Start Date corresponds to this field.

RecurrenceEndDateOnly Datetime False  

Label End Date corresponds to this field.

RecurrenceTimeZoneSidKey String False  

Label Recurrence Time Zone corresponds to this field.

RecurrenceType String False  

Label Recurrence Type corresponds to this field.

RecurrenceInterval Int False  

Label Recurrence Interval corresponds to this field.

RecurrenceDayOfWeekMask Int False  

Label Recurrence Day of Week Mask corresponds to this field.

RecurrenceDayOfMonth Int False  

Label Recurrence Day of Month corresponds to this field.

RecurrenceInstance String False  

Label Recurrence Instance corresponds to this field.

RecurrenceMonthOfYear String False  

Label Recurrence Month of Year corresponds to this field.

ReminderDateTime Datetime False  

Label Reminder Date/Time corresponds to this field.

IsReminderSet Boolean False  

Label Reminder Set corresponds to this field.

 

 

 

EventFeed

This is a table representing the EventFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the EventFeed.

ParentId String True

Event.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

EventRelation

This is a table representing the EventRelation entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the EventRelation.

RelationId String False  

Label Relation ID corresponds to this field.

EventId String False

Event.Id

Label Event ID corresponds to this field.

Status String False  

Label Status corresponds to this field.

RespondedDate Datetime False  

Label Response Date corresponds to this field.

Response String False  

Label Response corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

FeedComment

This is a table representing the FeedComment entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the FeedComment.

FeedItemId String False  

Label Feed Item ID corresponds to this field.

ParentId String True  

Label Parent ID corresponds to this field.

CreatedById String False  

Label Created By ID corresponds to this field.

CreatedDate Datetime False  

Label Created Date corresponds to this field.

CommentBody String False  

Label Comment Body corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

InsertedById String True

User.Id

Label InsertedBy ID corresponds to this field.

CommentType String False  

Label Comment Type corresponds to this field.

RelatedRecordId String False

ContentVersion.Id

Label Related Record ID corresponds to this field.

 

 

 

FeedItem

This is a table representing the FeedItem entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the FeedItem.

ParentId String False  

Label Parent ID corresponds to this field.

Type String False  

Label Feed Item Type corresponds to this field.

CreatedById String False  

Label Created By ID corresponds to this field.

CreatedDate Datetime False  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String False  

Label Title corresponds to this field.

Body String False  

Label Body corresponds to this field.

LinkUrl String False  

Label Link Url corresponds to this field.

RelatedRecordId String False

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String False  

Label Content Data corresponds to this field.

ContentFileName String False  

Label Content File Name corresponds to this field.

ContentDescription String False  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

FeedPollChoice

This is a table representing the FeedPollChoice entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the FeedPollChoice.

FeedItemId String True  

Label Feed Item ID corresponds to this field.

Position Int True  

Label Position corresponds to this field.

ChoiceBody String True  

Label ChoiceBody corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

FeedPollVote

This is a table representing the FeedPollVote entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the FeedPollVote.

FeedItemId String True  

Label Feed Item ID corresponds to this field.

ChoiceId String True

FeedPollChoice.Id

Label Feed Poll Choice ID corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

FieldPermissions

This is a table representing the FieldPermissions entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the FieldPermissions.

ParentId String False

PermissionSet.Id

Label Parent ID corresponds to this field.

SobjectType String False  

Label Sobject Type Name corresponds to this field.

Field String False  

Label Field Name corresponds to this field.

PermissionsEdit Boolean False  

Label Edit Field corresponds to this field.

PermissionsRead Boolean False  

Label Read Field corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

FiscalYearSettings

This is a table representing the FiscalYearSettings entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the FiscalYearSettings.

PeriodId String True

Period.Id

Label Period ID corresponds to this field.

StartDate Datetime True  

Label Start Date corresponds to this field.

EndDate Datetime True  

Label End Date corresponds to this field.

Name String True  

Label Name corresponds to this field.

IsStandardYear Boolean True  

Label Is Standard Year corresponds to this field.

YearType String True  

Label Year Type corresponds to this field.

QuarterLabelScheme String True  

Label Quarter Name Scheme corresponds to this field.

PeriodLabelScheme String True  

Label Period Name Scheme corresponds to this field.

WeekLabelScheme String True  

Label Week Name Scheme corresponds to this field.

QuarterPrefix String True  

Label Quarter Prefix corresponds to this field.

PeriodPrefix String True  

Label Period Prefix corresponds to this field.

WeekStartDay Int True  

Label Week Start Day corresponds to this field.

Description String True  

Label Description corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Folder

This is a table representing the Folder entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Folder.

Name String False  

Label Name corresponds to this field.

DeveloperName String False  

Label Folder Unique Name corresponds to this field.

AccessType String False  

Label Access Type corresponds to this field.

IsReadonly Boolean False  

Label Read Only corresponds to this field.

Type String False  

Label Type corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ForecastShare

This is a table representing the ForecastShare entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ForecastShare.

UserRoleId String True

UserRole.Id

Label User Role ID corresponds to this field.

UserOrGroupId String True  

Label User/Group ID corresponds to this field.

AccessLevel String True  

Label Forecast Access corresponds to this field.

CanSubmit Boolean True  

Label Submit Allowed corresponds to this field.

RowCause String True  

Label Row Cause corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

 

 

 

Group

This is a table representing the Group entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Group.

Name String False  

Label Name corresponds to this field.

DeveloperName String False  

Label Developer Name corresponds to this field.

RelatedId String True  

Label Related ID corresponds to this field.

Type String False  

Label Type corresponds to this field.

Email String False  

Label Email corresponds to this field.

OwnerId String True  

Label Owner ID corresponds to this field.

DoesSendEmailToMembers Boolean False  

Label Send Email to Members corresponds to this field.

DoesIncludeBosses Boolean False  

Label Include Bosses corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

GroupMember

This is a table representing the GroupMember entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the GroupMember.

GroupId String False

Group.Id

Label Group ID corresponds to this field.

UserOrGroupId String False  

Label User/Group ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

HashtagDefinition

This is a table representing the HashtagDefinition entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the HashtagDefinition.

NameNorm String True  

Label Normalized Hashtag Text corresponds to this field.

Name String True  

Label Hashtag Text corresponds to this field.

HashtagCount Int True  

Label Hashtag Count corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Holiday

This is a table representing the Holiday entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Holiday.

Name String False  

Label Holiday Name corresponds to this field.

Description String False  

Label Description corresponds to this field.

IsAllDay Boolean False  

Label All Day corresponds to this field.

ActivityDate Datetime False  

Label Holiday Date corresponds to this field.

StartTimeInMinutes Int False  

Label Start Time In Minutes From Midnight corresponds to this field.

EndTimeInMinutes Int False  

Label End Time In Minutes From Midnight corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsRecurrence Boolean False  

Label Recurring Holiday corresponds to this field.

RecurrenceStartDate Datetime False  

Label Start Date corresponds to this field.

RecurrenceEndDateOnly Datetime False  

Label End Date corresponds to this field.

RecurrenceType String False  

Label Recurrence Type corresponds to this field.

RecurrenceInterval Int False  

Label Recurrence Interval corresponds to this field.

RecurrenceDayOfWeekMask Int False  

Label Recurrence Day of Week Mask corresponds to this field.

RecurrenceDayOfMonth Int False  

Label Recurrence Day of Month corresponds to this field.

RecurrenceInstance String False  

Label Recurrence Instance corresponds to this field.

RecurrenceMonthOfYear String False  

Label Recurrence Month of Year corresponds to this field.

 

 

 

Lead

This is a table representing the Lead entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Lead.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

MasterRecordId String True

Lead.Id

Label Master Record ID corresponds to this field.

LastName String False  

Label Last Name corresponds to this field.

FirstName String False  

Label First Name corresponds to this field.

Salutation String False  

Label Salutation corresponds to this field.

Name String True  

Label Full Name corresponds to this field.

Title String False  

Label Title corresponds to this field.

Company String False  

Label Company corresponds to this field.

Street String False  

Label Street corresponds to this field.

City String False  

Label City corresponds to this field.

State String False  

Label State/Province corresponds to this field.

PostalCode String False  

Label Zip/Postal Code corresponds to this field.

Country String False  

Label Country corresponds to this field.

Latitude Double False  

Label Latitude corresponds to this field.

Longitude Double False  

Label Longitude corresponds to this field.

Phone String False  

Label Phone corresponds to this field.

MobilePhone String False  

Label Mobile Phone corresponds to this field.

Fax String False  

Label Fax corresponds to this field.

Email String False  

Label Email corresponds to this field.

Website String False  

Label Website corresponds to this field.

Description String False  

Label Description corresponds to this field.

LeadSource String False  

Label Lead Source corresponds to this field.

Status String False  

Label Status corresponds to this field.

Industry String False  

Label Industry corresponds to this field.

Rating String False  

Label Rating corresponds to this field.

AnnualRevenue Double False  

Label Annual Revenue corresponds to this field.

NumberOfEmployees Int False  

Label Employees corresponds to this field.

OwnerId String False  

Label Owner ID corresponds to this field.

IsConverted Boolean False  

Label Converted corresponds to this field.

ConvertedDate Datetime True  

Label Converted Date corresponds to this field.

ConvertedAccountId String True

Account.Id

Label Converted Account ID corresponds to this field.

ConvertedContactId String True

Contact.Id

Label Converted Contact ID corresponds to this field.

ConvertedOpportunityId String True

Opportunity.Id

Label Converted Opportunity ID corresponds to this field.

IsUnreadByOwner Boolean False  

Label Unread By Owner corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastActivityDate Datetime True  

Label Last Activity corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

Jigsaw String False  

Label Data.com Key corresponds to this field.

JigsawContactId String True  

Label Jigsaw Contact ID corresponds to this field.

EmailBouncedReason String True  

Label Email Bounced Reason corresponds to this field.

EmailBouncedDate Datetime True  

Label Email Bounced Date corresponds to this field.

SICCode__c String False  

Label SIC Code corresponds to this field.

Primary__c String False  

Label Primary corresponds to this field.

NumberofLocations__c Double False  

Label Number of Locations corresponds to this field.

ProductInterest__c String False  

Label Product Interest corresponds to this field.

CurrentGenerators__c String False  

Label Current Generator(s) corresponds to this field.

New_Text_Field__c String False  

Label New Text Field corresponds to this field.

External_Id_Field__c String False  

Label External Id Field corresponds to this field.

External_Id_2__c String False  

Label External_Id_2 corresponds to this field.

AutoNumberTest__c String True  

Label AutoNumberTest corresponds to this field.

Formula__c Datetime True  

Label Formula corresponds to this field.

 

 

 

LeadFeed

This is a table representing the LeadFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the LeadFeed.

ParentId String True

Lead.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

LeadHistory

This is a table representing the LeadHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the LeadHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LeadId String True

Lead.Id

Label Lead ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

LeadShare

This is a table representing the LeadShare entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the LeadShare.

LeadId String True

Lead.Id

Label Lead ID corresponds to this field.

UserOrGroupId String True  

Label User/Group ID corresponds to this field.

LeadAccessLevel String True  

Label Lead Access corresponds to this field.

RowCause String True  

Label Row Cause corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

LeadStatus

This is a table representing the LeadStatus entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the LeadStatus.

MasterLabel String True  

Label Master Label corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

IsDefault Boolean True  

Label Is Default corresponds to this field.

IsConverted Boolean True  

Label Is Converted corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

LoginHistory

This is a table representing the LoginHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the LoginHistory.

UserId String True  

Label User ID corresponds to this field.

LoginTime Datetime True  

Label Login Time corresponds to this field.

LoginType String True  

Label Login Type corresponds to this field.

SourceIp String True  

Label Source IP corresponds to this field.

LoginUrl String True  

Label Login URL corresponds to this field.

Browser String True  

Label Browser corresponds to this field.

Platform String True  

Label Platform corresponds to this field.

Status String True  

Label Status corresponds to this field.

Application String True  

Label Application corresponds to this field.

ClientVersion String True  

Label Client Version corresponds to this field.

ApiType String True  

Label API Type corresponds to this field.

ApiVersion String True  

Label API Version corresponds to this field.

 

 

 

LoginIp

This is a table representing the LoginIp entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the LoginIp.

UsersId String True

User.Id

Label User ID corresponds to this field.

SourceIp String True  

Label Source IP corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsAuthenticated Boolean True  

Label IsAuthenticated corresponds to this field.

ChallengeSentDate Datetime True  

Label Challenge SentDate corresponds to this field.

ChallengeMethod String True  

Label Challenge Method corresponds to this field.

 

 

 

MailmergeTemplate

This is a table representing the MailmergeTemplate entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the MailmergeTemplate.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Name String False  

Label Name corresponds to this field.

Description String False  

Label Description corresponds to this field.

Filename String False  

Label File corresponds to this field.

BodyLength Int True  

Label Body Length corresponds to this field.

Body String False  

Label Body corresponds to this field.

LastUsedDate Datetime True  

Label Last Used Date corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

MobileDeviceRegistrar

This is a table representing the MobileDeviceRegistrar entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the MobileDeviceRegistrar.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

DeveloperName String False  

Label Name corresponds to this field.

Language String False  

Label Master Language corresponds to this field.

MasterLabel String False  

Label Label corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

Provider String False  

Label Provider corresponds to this field.

MdmProviderEnrollEndpoint String False  

Label Mdm Provider Enroll Endpoint corresponds to this field.

MdmProviderPushAppEndpoint String False  

Label Mdm Provider Push App Endpoint corresponds to this field.

MdmProviderApiAccessToken String False  

Label Mdm Provider Api Access Token corresponds to this field.

MdmProviderApiUsername String False  

Label Mdm Provider Api Username corresponds to this field.

MdmProviderApiPassword String False  

Label Mdm Provider Api Password corresponds to this field.

 

 

 

Name

This is a table representing the Name entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Label 'ID' corresponds to this field.

Name String True  

Label 'Name' corresponds to this field.

LastName String True  

Label 'Last Name' corresponds to this field.

FirstName String True  

Label 'First Name' corresponds to this field.

Type String True  

Label 'Type' corresponds to this field.

Alias String True  

Label 'Alias' corresponds to this field.

UserRoleId String True  

Label 'Role ID' corresponds to this field.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
Where String

Specifies the Where clause of the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precendence over any other input.

 

 

 

Note

This is a table representing the Note entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Note.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ParentId String False  

Label Parent ID corresponds to this field.

Title String False  

Label Title corresponds to this field.

IsPrivate Boolean False  

Label Private corresponds to this field.

Body String False  

Label Body corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

NoteAndAttachment

This is a table representing the NoteAndAttachment entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Label 'Note or Attachment Id' corresponds to this field.

IsDeleted Boolean True  

Label 'Deleted' corresponds to this field.

IsNote Boolean True  

Label 'Is Note' corresponds to this field.

ParentId String True  

Label 'Parent ID' corresponds to this field.

Title String True  

Label 'Title' corresponds to this field.

IsPrivate Boolean True  

Label 'Private' corresponds to this field.

OwnerId String True  

Label 'Owner ID' corresponds to this field.

CreatedDate DateTime True  

Label 'Created Date' corresponds to this field.

CreatedById String True  

Label 'Created By ID' corresponds to this field.

LastModifiedDate DateTime True  

Label 'Last Modified Date' corresponds to this field.

LastModifiedById String True  

Label 'Last Modified By ID' corresponds to this field.

SystemModstamp DateTime True  

Label 'System Modstamp' corresponds to this field.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
SOQL String

Specifies the Where clause of the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precendence over any other input.

 

 

 

ObjectPermissions

This is a table representing the ObjectPermissions entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ObjectPermissions.

ParentId String False

PermissionSet.Id

Label Parent ID corresponds to this field.

SobjectType String False  

Label Sobject Type Name corresponds to this field.

PermissionsCreate Boolean False  

Label Create Records corresponds to this field.

PermissionsRead Boolean False  

Label Read Records corresponds to this field.

PermissionsEdit Boolean False  

Label Edit Records corresponds to this field.

PermissionsDelete Boolean False  

Label Delete Records corresponds to this field.

PermissionsViewAllRecords Boolean False  

Label Read All Records corresponds to this field.

PermissionsModifyAllRecords Boolean False  

Label Edit All Records corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

OpenActivity

This is a table representing the OpenActivity entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] System.String True  

Label 'Activity ID' corresponds to this field.

AccountId System.String True  

Label 'Account ID' corresponds to this field.

WhoId System.String True  

Label 'Contact/Lead ID' corresponds to this field.

WhatId System.String True  

Label 'Opportunity/Account ID' corresponds to this field.

Subject System.String True  

Label 'Subject' corresponds to this field.

IsTask System.Boolean True  

Label 'Task' corresponds to this field.

ActivityDate System.String True  

Label 'Date' corresponds to this field.

OwnerId System.String True  

Label 'Assigned To ID' corresponds to this field.

Status System.String True  

Label 'Status' corresponds to this field.

Priority System.String True  

Label 'Priority' corresponds to this field.

ActivityType System.String True  

Label 'Type' corresponds to this field.

IsClosed System.Boolean True  

Label 'Closed' corresponds to this field.

IsAllDayEvent System.Boolean True  

Label 'All Day Event' corresponds to this field.

DurationInMinutes System.Integer True  

Label 'Duration' corresponds to this field.

Location System.String True  

Label 'Location' corresponds to this field.

Description System.String True  

Label 'Comments' corresponds to this field.

IsDeleted System.Boolean True  

Label 'Deleted' corresponds to this field.

CreatedDate System.DateTime True  

Label 'Created Date' corresponds to this field.

CreatedById System.String True  

Label 'Created By ID' corresponds to this field.

LastModifiedDate System.DateTime True  

Label 'Last Modified Date' corresponds to this field.

LastModifiedById System.String True  

Label 'Last Modified By ID' corresponds to this field.

SystemModstamp System.DateTime True  

Label 'System Modstamp' corresponds to this field.

CallDurationInSeconds System.Integer True  

Label 'Call Duration' corresponds to this field.

CallType System.String True  

Label 'Call Type' corresponds to this field.

CallDisposition System.String True  

Label 'Call Result' corresponds to this field.

CallObject System.String True  

Label 'Call Object Identifier' corresponds to this field.

ReminderDateTime System.DateTime True  

Label 'Reminder Date/Time' corresponds to this field.

IsReminderSet System.Boolean True  

Label 'Reminder Set' corresponds to this field.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
SOQL String

Specifies the Where clause of the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precendence over any other input.

 

 

 

Opportunity

This is a table representing the Opportunity entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Opportunity.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

AccountId String False

Account.Id

Label Account ID corresponds to this field.

IsPrivate Boolean False  

Label Private corresponds to this field.

Name String False  

Label Name corresponds to this field.

Description String False  

Label Description corresponds to this field.

StageName String False  

Label Stage corresponds to this field.

Amount Double False  

Label Amount corresponds to this field.

Probability Double False  

Label Probability (%) corresponds to this field.

ExpectedRevenue Double True  

Label Expected Amount corresponds to this field.

TotalOpportunityQuantity Double False  

Label Quantity corresponds to this field.

CloseDate Datetime False  

Label Close Date corresponds to this field.

Type String False  

Label Opportunity Type corresponds to this field.

NextStep String False  

Label Next Step corresponds to this field.

LeadSource String False  

Label Lead Source corresponds to this field.

IsClosed Boolean True  

Label Closed corresponds to this field.

IsWon Boolean True  

Label Won corresponds to this field.

ForecastCategory String True  

Label Forecast Category corresponds to this field.

ForecastCategoryName String False  

Label Forecast Category corresponds to this field.

CampaignId String False

Campaign.Id

Label Campaign ID corresponds to this field.

HasOpportunityLineItem Boolean True  

Label Has Line Item corresponds to this field.

Pricebook2Id String False

Pricebook2.Id

Label Price Book ID corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastActivityDate Datetime True  

Label Last Activity corresponds to this field.

FiscalQuarter Int True  

Label Fiscal Quarter corresponds to this field.

FiscalYear Int True  

Label Fiscal Year corresponds to this field.

Fiscal String True  

Label Fiscal Period corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

SyncedQuoteId String False

Quote.Id

Label Quote ID corresponds to this field.

DeliveryInstallationStatus__c String False  

Label Delivery/Installation Status corresponds to this field.

CurrentGenerators__c String False  

Label Current Generator(s) corresponds to this field.

TrackingNumber__c String False  

Label Tracking Number corresponds to this field.

MainCompetitors__c String False  

Label Main Competitor(s) corresponds to this field.

OrderNumber__c String False  

Label Order Number corresponds to this field.

SomeNumber__c Double False  

Label SomeNumber corresponds to this field.

ZeroDecimal__c Double False  

Label ZeroDecimal corresponds to this field.

AutoNumber__c String True  

Label AutoNumber corresponds to this field.

FloatTest__c Double False  

Label FloatTest corresponds to this field.

Don_t_Test__c String False  

Label Don?t_Test corresponds to this field.

 

 

 

OpportunityCompetitor

This is a table representing the OpportunityCompetitor entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OpportunityCompetitor.

OpportunityId String False

Opportunity.Id

Label Opportunity ID corresponds to this field.

CompetitorName String False  

Label Competitor Name corresponds to this field.

Strengths String False  

Label Strengths corresponds to this field.

Weaknesses String False  

Label Weaknesses corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

OpportunityContactRole

This is a table representing the OpportunityContactRole entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OpportunityContactRole.

OpportunityId String False

Opportunity.Id

Label Opportunity ID corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

Role String False  

Label Role corresponds to this field.

IsPrimary Boolean False  

Label Primary corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

OpportunityFeed

This is a table representing the OpportunityFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OpportunityFeed.

ParentId String True

Opportunity.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

OpportunityFieldHistory

This is a table representing the OpportunityFieldHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OpportunityFieldHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

OpportunityId String True

Opportunity.Id

Label Opportunity ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

OpportunityHistory

This is a table representing the OpportunityHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OpportunityHistory.

OpportunityId String True

Opportunity.Id

Label Opportunity ID corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

StageName String True  

Label Stage Name corresponds to this field.

Amount Double True  

Label Amount corresponds to this field.

ExpectedRevenue Double True  

Label Expected Revenue corresponds to this field.

CloseDate Datetime True  

Label Close Date corresponds to this field.

Probability Double True  

Label Probability corresponds to this field.

ForecastCategory String True  

Label To ForecastCategory corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

OpportunityLineItem

This is a table representing the OpportunityLineItem entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OpportunityLineItem.

OpportunityId String False

Opportunity.Id

Label Opportunity ID corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

PricebookEntryId String False

PricebookEntry.Id

Label Price Book Entry ID corresponds to this field.

Quantity Double False  

Label Quantity corresponds to this field.

TotalPrice Double False  

Label Total Price corresponds to this field.

UnitPrice Double False  

Label Sales Price corresponds to this field.

ListPrice Double True  

Label List Price corresponds to this field.

ServiceDate Datetime False  

Label Date corresponds to this field.

Description String False  

Label Line Description corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

OpportunityPartner

This is a table representing the OpportunityPartner entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OpportunityPartner.

OpportunityId String True

Opportunity.Id

Label Opportunity ID corresponds to this field.

AccountToId String True

Account.Id

Label Account ID corresponds to this field.

Role String True  

Label Role corresponds to this field.

IsPrimary Boolean True  

Label Primary corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ReversePartnerId String True

OpportunityPartner.Id

Label Reverse Partner ID corresponds to this field.

 

 

 

OpportunityShare

This is a table representing the OpportunityShare entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OpportunityShare.

OpportunityId String True

Opportunity.Id

Label Opportunity ID corresponds to this field.

UserOrGroupId String True  

Label User/Group ID corresponds to this field.

OpportunityAccessLevel String True  

Label Opportunity Access corresponds to this field.

RowCause String True  

Label Row Cause corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

OpportunityStage

This is a table representing the OpportunityStage entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OpportunityStage.

MasterLabel String True  

Label Master Label corresponds to this field.

IsActive Boolean True  

Label Is Active corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

IsClosed Boolean True  

Label Closed corresponds to this field.

IsWon Boolean True  

Label Won corresponds to this field.

ForecastCategory String True  

Label Forecast Category corresponds to this field.

ForecastCategoryName String True  

Label Forecast Category Name corresponds to this field.

DefaultProbability Double True  

Label Probability (%) corresponds to this field.

Description String True  

Label Description corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Organization

This is a table representing the Organization entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Organization.

Name String True  

Label Name corresponds to this field.

Division String True  

Label Division corresponds to this field.

Street String True  

Label Street corresponds to this field.

City String True  

Label City corresponds to this field.

State String True  

Label State/Province corresponds to this field.

PostalCode String True  

Label Zip/Postal Code corresponds to this field.

Country String True  

Label Country corresponds to this field.

Latitude Double True  

Label Latitude corresponds to this field.

Longitude Double True  

Label Longitude corresponds to this field.

Phone String True  

Label Phone corresponds to this field.

Fax String True  

Label Fax corresponds to this field.

PrimaryContact String True  

Label Primary Contact corresponds to this field.

DefaultLocaleSidKey String True  

Label Locale corresponds to this field.

LanguageLocaleKey String True  

Label Language corresponds to this field.

ReceivesInfoEmails Boolean True  

Label Info Emails corresponds to this field.

ReceivesAdminInfoEmails Boolean True  

Label Info Emails Admin corresponds to this field.

PreferencesRequireOpportunityProducts Boolean True  

Label RequireOpportunityProducts corresponds to this field.

FiscalYearStartMonth Int True  

Label Fiscal Year Starts In corresponds to this field.

UsesStartDateAsFiscalYearName Boolean True  

Label Fiscal Year Name by Start corresponds to this field.

DefaultAccountAccess String True  

Label Default Account Access corresponds to this field.

DefaultContactAccess String True  

Label Default Contact Access corresponds to this field.

DefaultOpportunityAccess String True  

Label Default Opportunity Access corresponds to this field.

DefaultLeadAccess String True  

Label Default Lead Access corresponds to this field.

DefaultCaseAccess String True  

Label Default Case Access corresponds to this field.

DefaultCalendarAccess String True  

Label Default Calendar Access corresponds to this field.

DefaultPricebookAccess String True  

Label Default Price Book Access corresponds to this field.

DefaultCampaignAccess String True  

Label Default Campaign Access corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

ComplianceBccEmail String True  

Label Compliance BCC Email corresponds to this field.

UiSkin String True  

Label UI Skin corresponds to this field.

TrialExpirationDate Datetime True  

Label Trial Expiration Date corresponds to this field.

OrganizationType String True  

Label Edition corresponds to this field.

WebToCaseDefaultOrigin String True  

Label Web to Cases Default Origin corresponds to this field.

MonthlyPageViewsUsed Int True  

Label Monthly Page Views Used corresponds to this field.

MonthlyPageViewsEntitlement Int True  

Label Monthly Page Views Allowed corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

 

 

 

OrgWideEmailAddress

This is a table representing the OrgWideEmailAddress entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the OrgWideEmailAddress.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

Address String False  

Label Email Address corresponds to this field.

DisplayName String False  

Label Display Name corresponds to this field.

IsAllowAllProfiles Boolean False  

Label Allow All Profiles corresponds to this field.

 

 

 

Partner

This is a table representing the Partner entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Partner.

OpportunityId String False

Opportunity.Id

Label Opportunity ID corresponds to this field.

AccountFromId String False

Account.Id

Label Account From ID corresponds to this field.

AccountToId String False

Account.Id

Label Account To ID corresponds to this field.

Role String False  

Label Role corresponds to this field.

IsPrimary Boolean False  

Label Primary corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ReversePartnerId String True

Partner.Id

Label Reverse Partner ID corresponds to this field.

 

 

 

PartnerRole

This is a table representing the PartnerRole entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the PartnerRole.

MasterLabel String True  

Label Master Label corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

ReverseRole String True  

Label Reverse Role corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Period

This is a table representing the Period entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Period.

FiscalYearSettingsId String True

FiscalYearSettings.Id

Label Fiscal Year Settings ID corresponds to this field.

Type String True  

Label Type corresponds to this field.

StartDate Datetime True  

Label Start Date corresponds to this field.

EndDate Datetime True  

Label End Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsForecastPeriod Boolean True  

Label Is Forecast Period corresponds to this field.

QuarterLabel String True  

Label Quarter Name corresponds to this field.

PeriodLabel String True  

Label Period Name corresponds to this field.

Number Int True  

Label Number corresponds to this field.

 

 

 

PermissionSet

This is a table representing the PermissionSet entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the PermissionSet.

Name String False  

Label Permission Set Name corresponds to this field.

Label String False  

Label Permission Set Label corresponds to this field.

UserLicenseId String False

UserLicense.Id

Label User License ID corresponds to this field.

ProfileId String True

Profile.Id

Label Profile ID corresponds to this field.

IsOwnedByProfile Boolean True  

Label Is Owned By Profile corresponds to this field.

PermissionsEmailSingle Boolean False  

Label Send Email corresponds to this field.

PermissionsEmailMass Boolean False  

Label Mass Email corresponds to this field.

PermissionsEditTask Boolean False  

Label Edit Tasks corresponds to this field.

PermissionsEditEvent Boolean False  

Label Edit Events corresponds to this field.

PermissionsExportReport Boolean False  

Label Export Reports corresponds to this field.

PermissionsImportPersonal Boolean False  

Label Import Personal Contacts corresponds to this field.

PermissionsManageUsers Boolean False  

Label Manage Users corresponds to this field.

PermissionsEditPublicTemplates Boolean False  

Label Manage Public Templates corresponds to this field.

PermissionsModifyAllData Boolean False  

Label Modify All Data corresponds to this field.

PermissionsManageCases Boolean False  

Label Manage Cases corresponds to this field.

PermissionsEditKnowledge Boolean False  

Label Manage Articles corresponds to this field.

PermissionsManageKnowledge Boolean False  

Label Manage Salesforce Knowledge corresponds to this field.

PermissionsManageSolutions Boolean False  

Label Manage Published Solutions corresponds to this field.

PermissionsCustomizeApplication Boolean False  

Label Customize Application corresponds to this field.

PermissionsEditReadonlyFields Boolean False  

Label Edit Read Only Fields corresponds to this field.

PermissionsRunReports Boolean False  

Label Run Reports corresponds to this field.

PermissionsViewSetup Boolean False  

Label View Setup and Configuration corresponds to this field.

PermissionsTransferAnyEntity Boolean False  

Label Transfer Record corresponds to this field.

PermissionsNewReportBuilder Boolean False  

Label Report Builder corresponds to this field.

PermissionsManageSelfService Boolean False  

Label Manage Self-Service Portal corresponds to this field.

PermissionsManageCssUsers Boolean False  

Label Edit Self-Service Users corresponds to this field.

PermissionsActivateContract Boolean False  

Label Activate Contracts corresponds to this field.

PermissionsImportLeads Boolean False  

Label Import Leads corresponds to this field.

PermissionsManageLeads Boolean False  

Label Manage Leads corresponds to this field.

PermissionsTransferAnyLead Boolean False  

Label Transfer Leads corresponds to this field.

PermissionsViewAllData Boolean False  

Label View All Data corresponds to this field.

PermissionsEditPublicDocuments Boolean False  

Label Manage Public Documents corresponds to this field.

PermissionsEditBrandTemplates Boolean False  

Label Manage Letterheads corresponds to this field.

PermissionsEditHtmlTemplates Boolean False  

Label Edit HTML Templates corresponds to this field.

PermissionsChatterInternalUser Boolean False  

Label Chatter Internal User corresponds to this field.

PermissionsManageDashboards Boolean False  

Label Manage Dashboards corresponds to this field.

PermissionsDeleteActivatedContract Boolean False  

Label Delete Activated Contracts corresponds to this field.

PermissionsChatterInviteExternalUsers Boolean False  

Label Invite Customers To Chatter corresponds to this field.

PermissionsSendSitRequests Boolean False  

Label Send Stay-in-Touch Requests corresponds to this field.

PermissionsManageRemoteAccess Boolean False  

Label Manage Connected Apps corresponds to this field.

PermissionsCanUseNewDashboardBuilder Boolean False  

Label Drag-and-Drop Dashboard Builder corresponds to this field.

PermissionsManageCategories Boolean False  

Label Manage Categories corresponds to this field.

PermissionsConvertLeads Boolean False  

Label Convert Leads corresponds to this field.

PermissionsPasswordNeverExpires Boolean False  

Label Password Never Expires corresponds to this field.

PermissionsUseTeamReassignWizards Boolean False  

Label Use Team Reassignment Wizards corresponds to this field.

PermissionsInstallPackaging Boolean False  

Label Download AppExchange Packages corresponds to this field.

PermissionsPublishPackaging Boolean False  

Label Upload AppExchange Packages corresponds to this field.

PermissionsChatterOwnGroups Boolean False  

Label Create and Own New Chatter Groups corresponds to this field.

PermissionsEditOppLineItemUnitPrice Boolean False  

Label Edit Opportunity Product Sales Price corresponds to this field.

PermissionsCreatePackaging Boolean False  

Label Create AppExchange Packages corresponds to this field.

PermissionsBulkApiHardDelete Boolean False  

Label Bulk API Hard Delete corresponds to this field.

PermissionsSolutionImport Boolean False  

Label Import Solutions corresponds to this field.

PermissionsManageCallCenters Boolean False  

Label Manage Call Centers corresponds to this field.

PermissionsEditReports Boolean False  

Label Create and Customize Reports corresponds to this field.

PermissionsManageSynonyms Boolean False  

Label Manage Synonyms corresponds to this field.

PermissionsViewContent Boolean False  

Label View Content in Portals corresponds to this field.

PermissionsManageEmailClientConfig Boolean False  

Label Manage Email Client Configurations corresponds to this field.

PermissionsEnableNotifications Boolean False  

Label Send Outbound Messages corresponds to this field.

PermissionsManageDataIntegrations Boolean False  

Label Manage Data Integrations corresponds to this field.

PermissionsViewDataCategories Boolean False  

Label View Data Categories corresponds to this field.

PermissionsManageDataCategories Boolean False  

Label Manage Data Categories corresponds to this field.

PermissionsAuthorApex Boolean False  

Label Author Apex corresponds to this field.

PermissionsManageMobile Boolean False  

Label Manage Mobile Configurations corresponds to this field.

PermissionsApiEnabled Boolean False  

Label API Enabled corresponds to this field.

PermissionsManageCustomReportTypes Boolean False  

Label Manage Custom Report Types corresponds to this field.

PermissionsEditCaseComments Boolean False  

Label Edit Case Comments corresponds to this field.

PermissionsTransferAnyCase Boolean False  

Label Transfer Cases corresponds to this field.

PermissionsContentAdministrator Boolean False  

Label Manage Salesforce CRM Content corresponds to this field.

PermissionsCreateWorkspaces Boolean False  

Label Create Libraries corresponds to this field.

PermissionsManageContentPermissions Boolean False  

Label Manage Content Permissions corresponds to this field.

PermissionsManageContentProperties Boolean False  

Label Manage Content Properties corresponds to this field.

PermissionsManageContentTypes Boolean False  

Label Manage Content Types corresponds to this field.

PermissionsManageAnalyticSnapshots Boolean False  

Label Manage Analytic Snapshots corresponds to this field.

PermissionsScheduleReports Boolean False  

Label Schedule Reports corresponds to this field.

PermissionsManageBusinessHourHolidays Boolean False  

Label Manage Business Hours Holidays corresponds to this field.

PermissionsManageDynamicDashboards Boolean False  

Label Manage Dynamic Dashboards corresponds to this field.

PermissionsCustomSidebarOnAllPages Boolean False  

Label Show Custom Sidebar On All Pages corresponds to this field.

PermissionsManageInteraction Boolean False  

Label Manage Force.com Flow corresponds to this field.

PermissionsViewMyTeamsDashboards Boolean False  

Label View My Team's Dashboards corresponds to this field.

PermissionsModerateChatter Boolean False  

Label Moderate Chatter corresponds to this field.

PermissionsResetPasswords Boolean False  

Label Reset User Passwords and Unlock Users corresponds to this field.

PermissionsFlowUFLRequired Boolean False  

Label Require Force.com Flow User Feature License corresponds to this field.

PermissionsCanInsertFeedSystemFields Boolean False  

Label Insert System Field Values for Chatter Feeds corresponds to this field.

PermissionsManageKnowledgeImportExport Boolean False  

Label Manage Knowledge Article Import/Export corresponds to this field.

PermissionsEmailTemplateManagement Boolean False  

Label Manage Email Templates corresponds to this field.

PermissionsEmailAdministration Boolean False  

Label Email Administration corresponds to this field.

PermissionsManageChatterMessages Boolean False  

Label Manage Chatter Messages corresponds to this field.

PermissionsForceTwoFactor Boolean False  

Label Two-Factor Authentication for User Interface Logins corresponds to this field.

PermissionsManageNetworks Boolean False  

Label Create and Set Up Communities corresponds to this field.

PermissionsManageAuthProviders Boolean False  

Label Manage Auth. Providers corresponds to this field.

PermissionsRunFlow Boolean False  

Label Run Flows corresponds to this field.

PermissionsViewAllUsers Boolean False  

Label View All Users corresponds to this field.

PermissionsAllowUniversalSearch Boolean False  

Label Knowledge One corresponds to this field.

PermissionsConnectOrgToEnvironmentHub Boolean False  

Label Connect Organization to Environment Hub corresponds to this field.

PermissionsSalesConsole Boolean False  

Label Sales Console corresponds to this field.

PermissionsTwoFactorApi Boolean False  

Label Two-Factor Authentication for API Logins corresponds to this field.

PermissionsDeleteTopics Boolean False  

Label Delete Topics corresponds to this field.

PermissionsEditTopics Boolean False  

Label Edit Topics corresponds to this field.

PermissionsCreateTopics Boolean False  

Label Create Topics corresponds to this field.

PermissionsAssignTopics Boolean False  

Label Assign Topics corresponds to this field.

PermissionsIdentityEnabled Boolean False  

Label Use Identity Features corresponds to this field.

PermissionsIdentityConnect Boolean False  

Label Use Identity Connect corresponds to this field.

PermissionsAllowViewKnowledge Boolean False  

Label Allow View Knowledge corresponds to this field.

Description String False  

Label Description corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

 

 

 

PermissionSetAssignment

This is a table representing the PermissionSetAssignment entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the PermissionSetAssignment.

PermissionSetId String False

PermissionSet.Id

Label PermissionSet ID corresponds to this field.

AssigneeId String False

User.Id

Label Assignee ID corresponds to this field.

SystemModstamp Datetime True  

Label Date Assigned corresponds to this field.

 

 

 

PermissionSetLicense

This is a table representing the PermissionSetLicense entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the PermissionSetLicense.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

DeveloperName String True  

Label Developer Name corresponds to this field.

Language String True  

Label Master Language corresponds to this field.

MasterLabel String True  

Label Permission Set License Label corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

PermissionSetLicenseKey String True  

Label Permission Set License Key corresponds to this field.

TotalLicenses Int True  

Label Total Licenses corresponds to this field.

Status String True  

Label Status corresponds to this field.

ExpirationDate Datetime True  

Label Expiration Date corresponds to this field.

MaximumPermissionsEmailSingle Boolean True  

Label Send Email corresponds to this field.

MaximumPermissionsEmailMass Boolean True  

Label Mass Email corresponds to this field.

MaximumPermissionsEditTask Boolean True  

Label Edit Tasks corresponds to this field.

MaximumPermissionsEditEvent Boolean True  

Label Edit Events corresponds to this field.

MaximumPermissionsExportReport Boolean True  

Label Export Reports corresponds to this field.

MaximumPermissionsImportPersonal Boolean True  

Label Import Personal Contacts corresponds to this field.

MaximumPermissionsManageUsers Boolean True  

Label Manage Users corresponds to this field.

MaximumPermissionsEditPublicTemplates Boolean True  

Label Manage Public Templates corresponds to this field.

MaximumPermissionsModifyAllData Boolean True  

Label Modify All Data corresponds to this field.

MaximumPermissionsManageCases Boolean True  

Label Manage Cases corresponds to this field.

MaximumPermissionsEditKnowledge Boolean True  

Label Manage Articles corresponds to this field.

MaximumPermissionsManageKnowledge Boolean True  

Label Manage Salesforce Knowledge corresponds to this field.

MaximumPermissionsManageSolutions Boolean True  

Label Manage Published Solutions corresponds to this field.

MaximumPermissionsCustomizeApplication Boolean True  

Label Customize Application corresponds to this field.

MaximumPermissionsEditReadonlyFields Boolean True  

Label Edit Read Only Fields corresponds to this field.

MaximumPermissionsRunReports Boolean True  

Label Run Reports corresponds to this field.

MaximumPermissionsViewSetup Boolean True  

Label View Setup and Configuration corresponds to this field.

MaximumPermissionsTransferAnyEntity Boolean True  

Label Transfer Record corresponds to this field.

MaximumPermissionsNewReportBuilder Boolean True  

Label Report Builder corresponds to this field.

MaximumPermissionsManageSelfService Boolean True  

Label Manage Self-Service Portal corresponds to this field.

MaximumPermissionsManageCssUsers Boolean True  

Label Edit Self-Service Users corresponds to this field.

MaximumPermissionsActivateContract Boolean True  

Label Activate Contracts corresponds to this field.

MaximumPermissionsImportLeads Boolean True  

Label Import Leads corresponds to this field.

MaximumPermissionsManageLeads Boolean True  

Label Manage Leads corresponds to this field.

MaximumPermissionsTransferAnyLead Boolean True  

Label Transfer Leads corresponds to this field.

MaximumPermissionsViewAllData Boolean True  

Label View All Data corresponds to this field.

MaximumPermissionsEditPublicDocuments Boolean True  

Label Manage Public Documents corresponds to this field.

MaximumPermissionsEditBrandTemplates Boolean True  

Label Manage Letterheads corresponds to this field.

MaximumPermissionsEditHtmlTemplates Boolean True  

Label Edit HTML Templates corresponds to this field.

MaximumPermissionsChatterInternalUser Boolean True  

Label Chatter Internal User corresponds to this field.

MaximumPermissionsManageDashboards Boolean True  

Label Manage Dashboards corresponds to this field.

MaximumPermissionsDeleteActivatedContract Boolean True  

Label Delete Activated Contracts corresponds to this field.

MaximumPermissionsChatterInviteExternalUsers Boolean True  

Label Invite Customers To Chatter corresponds to this field.

MaximumPermissionsSendSitRequests Boolean True  

Label Send Stay-in-Touch Requests corresponds to this field.

MaximumPermissionsManageRemoteAccess Boolean True  

Label Manage Connected Apps corresponds to this field.

MaximumPermissionsCanUseNewDashboardBuilder Boolean True  

Label Drag-and-Drop Dashboard Builder corresponds to this field.

MaximumPermissionsManageCategories Boolean True  

Label Manage Categories corresponds to this field.

MaximumPermissionsConvertLeads Boolean True  

Label Convert Leads corresponds to this field.

MaximumPermissionsPasswordNeverExpires Boolean True  

Label Password Never Expires corresponds to this field.

MaximumPermissionsUseTeamReassignWizards Boolean True  

Label Use Team Reassignment Wizards corresponds to this field.

MaximumPermissionsInstallPackaging Boolean True  

Label Download AppExchange Packages corresponds to this field.

MaximumPermissionsPublishPackaging Boolean True  

Label Upload AppExchange Packages corresponds to this field.

MaximumPermissionsChatterOwnGroups Boolean True  

Label Create and Own New Chatter Groups corresponds to this field.

MaximumPermissionsEditOppLineItemUnitPrice Boolean True  

Label Edit Opportunity Product Sales Price corresponds to this field.

MaximumPermissionsCreatePackaging Boolean True  

Label Create AppExchange Packages corresponds to this field.

MaximumPermissionsBulkApiHardDelete Boolean True  

Label Bulk API Hard Delete corresponds to this field.

MaximumPermissionsSolutionImport Boolean True  

Label Import Solutions corresponds to this field.

MaximumPermissionsManageCallCenters Boolean True  

Label Manage Call Centers corresponds to this field.

MaximumPermissionsEditReports Boolean True  

Label Create and Customize Reports corresponds to this field.

MaximumPermissionsManageSynonyms Boolean True  

Label Manage Synonyms corresponds to this field.

MaximumPermissionsViewContent Boolean True  

Label View Content in Portals corresponds to this field.

MaximumPermissionsManageEmailClientConfig Boolean True  

Label Manage Email Client Configurations corresponds to this field.

MaximumPermissionsEnableNotifications Boolean True  

Label Send Outbound Messages corresponds to this field.

MaximumPermissionsManageDataIntegrations Boolean True  

Label Manage Data Integrations corresponds to this field.

MaximumPermissionsViewDataCategories Boolean True  

Label View Data Categories corresponds to this field.

MaximumPermissionsManageDataCategories Boolean True  

Label Manage Data Categories corresponds to this field.

MaximumPermissionsAuthorApex Boolean True  

Label Author Apex corresponds to this field.

MaximumPermissionsManageMobile Boolean True  

Label Manage Mobile Configurations corresponds to this field.

MaximumPermissionsApiEnabled Boolean True  

Label API Enabled corresponds to this field.

MaximumPermissionsManageCustomReportTypes Boolean True  

Label Manage Custom Report Types corresponds to this field.

MaximumPermissionsEditCaseComments Boolean True  

Label Edit Case Comments corresponds to this field.

MaximumPermissionsTransferAnyCase Boolean True  

Label Transfer Cases corresponds to this field.

MaximumPermissionsContentAdministrator Boolean True  

Label Manage Salesforce CRM Content corresponds to this field.

MaximumPermissionsCreateWorkspaces Boolean True  

Label Create Libraries corresponds to this field.

MaximumPermissionsManageContentPermissions Boolean True  

Label Manage Content Permissions corresponds to this field.

MaximumPermissionsManageContentProperties Boolean True  

Label Manage Content Properties corresponds to this field.

MaximumPermissionsManageContentTypes Boolean True  

Label Manage Content Types corresponds to this field.

MaximumPermissionsManageAnalyticSnapshots Boolean True  

Label Manage Analytic Snapshots corresponds to this field.

MaximumPermissionsScheduleReports Boolean True  

Label Schedule Reports corresponds to this field.

MaximumPermissionsManageBusinessHourHolidays Boolean True  

Label Manage Business Hours Holidays corresponds to this field.

MaximumPermissionsManageDynamicDashboards Boolean True  

Label Manage Dynamic Dashboards corresponds to this field.

MaximumPermissionsCustomSidebarOnAllPages Boolean True  

Label Show Custom Sidebar On All Pages corresponds to this field.

MaximumPermissionsManageInteraction Boolean True  

Label Manage Force.com Flow corresponds to this field.

MaximumPermissionsViewMyTeamsDashboards Boolean True  

Label View My Team's Dashboards corresponds to this field.

MaximumPermissionsModerateChatter Boolean True  

Label Moderate Chatter corresponds to this field.

MaximumPermissionsResetPasswords Boolean True  

Label Reset User Passwords and Unlock Users corresponds to this field.

MaximumPermissionsFlowUFLRequired Boolean True  

Label Require Force.com Flow User Feature License corresponds to this field.

MaximumPermissionsCanInsertFeedSystemFields Boolean True  

Label Insert System Field Values for Chatter Feeds corresponds to this field.

MaximumPermissionsManageKnowledgeImportExport Boolean True  

Label Manage Knowledge Article Import/Export corresponds to this field.

MaximumPermissionsEmailTemplateManagement Boolean True  

Label Manage Email Templates corresponds to this field.

MaximumPermissionsEmailAdministration Boolean True  

Label Email Administration corresponds to this field.

MaximumPermissionsManageChatterMessages Boolean True  

Label Manage Chatter Messages corresponds to this field.

MaximumPermissionsForceTwoFactor Boolean True  

Label Two-Factor Authentication for User Interface Logins corresponds to this field.

MaximumPermissionsManageNetworks Boolean True  

Label Create and Set Up Communities corresponds to this field.

MaximumPermissionsManageAuthProviders Boolean True  

Label Manage Auth. Providers corresponds to this field.

MaximumPermissionsRunFlow Boolean True  

Label Run Flows corresponds to this field.

MaximumPermissionsViewAllUsers Boolean True  

Label View All Users corresponds to this field.

MaximumPermissionsAllowUniversalSearch Boolean True  

Label Knowledge One corresponds to this field.

MaximumPermissionsConnectOrgToEnvironmentHub Boolean True  

Label Connect Organization to Environment Hub corresponds to this field.

MaximumPermissionsSalesConsole Boolean True  

Label Sales Console corresponds to this field.

MaximumPermissionsTwoFactorApi Boolean True  

Label Two-Factor Authentication for API Logins corresponds to this field.

MaximumPermissionsDeleteTopics Boolean True  

Label Delete Topics corresponds to this field.

MaximumPermissionsEditTopics Boolean True  

Label Edit Topics corresponds to this field.

MaximumPermissionsCreateTopics Boolean True  

Label Create Topics corresponds to this field.

MaximumPermissionsAssignTopics Boolean True  

Label Assign Topics corresponds to this field.

MaximumPermissionsIdentityEnabled Boolean True  

Label Use Identity Features corresponds to this field.

MaximumPermissionsIdentityConnect Boolean True  

Label Use Identity Connect corresponds to this field.

MaximumPermissionsAllowViewKnowledge Boolean True  

Label Allow View Knowledge corresponds to this field.

UsedLicenses Int True  

Label Used Licenses corresponds to this field.

 

 

 

PermissionSetLicenseAssign

This is a table representing the PermissionSetLicenseAssign entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the PermissionSetLicenseAssign.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label Date Assigned corresponds to this field.

PermissionSetLicenseId String False

PermissionSetLicense.Id

Label Permission Set License ID corresponds to this field.

AssigneeId String False

User.Id

Label User ID corresponds to this field.

 

 

 

Pricebook2

This is a table representing the Pricebook2 entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Pricebook2.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Name String False  

Label Price Book Name corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

IsActive Boolean False  

Label Active corresponds to this field.

Description String False  

Label Description corresponds to this field.

IsStandard Boolean True  

Label Is Standard Price Book corresponds to this field.

Factory_Code__c String False  

Label Factory_Code corresponds to this field.

Old_Factory_Codes__c String False  

Label Old_Factory_Codes corresponds to this field.

 

 

 

Pricebook2History

This is a table representing the Pricebook2History entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Pricebook2History.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Pricebook2Id String True

Pricebook2.Id

Label Price Book ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

PricebookEntry

This is a table representing the PricebookEntry entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the PricebookEntry.

Name String True  

Label Product Name corresponds to this field.

Pricebook2Id String False

Pricebook2.Id

Label Price Book ID corresponds to this field.

Product2Id String False

Product2.Id

Label Product ID corresponds to this field.

UnitPrice Double False  

Label List Price corresponds to this field.

IsActive Boolean False  

Label Active corresponds to this field.

UseStandardPrice Boolean False  

Label Use Standard Price corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

ProductCode String True  

Label Product Code corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

 

 

 

ProcessDefinition

This is a table representing the ProcessDefinition entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ProcessDefinition.

Name String True  

Label Name corresponds to this field.

DeveloperName String True  

Label Unique Name corresponds to this field.

Type String True  

Label Process Definition Type corresponds to this field.

Description String True  

Label Description corresponds to this field.

TableEnumOrId String True  

Label Custom Object Definition ID corresponds to this field.

LockType String True  

Label Lock Type corresponds to this field.

State String True  

Label State corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ProcessInstance

This is a table representing the ProcessInstance entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ProcessInstance.

ProcessDefinitionId String True

ProcessDefinition.Id

Label Approval Process ID corresponds to this field.

TargetObjectId String True  

Label Target Object ID corresponds to this field.

Status String True  

Label Status corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ProcessInstanceHistory

This is a table representing the ProcessInstanceHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] System.String True  

Label 'Process Instance History ID' corresponds to this field.

IsPending System.Boolean True  

Label 'Is Pending' corresponds to this field.

ProcessInstanceId System.String True  

Label 'Process Instance ID' corresponds to this field.

TargetObjectId System.String True  

Label 'Target Object ID' corresponds to this field.

StepStatus System.String True  

Label 'Status' corresponds to this field.

OriginalActorId System.String True  

Label 'Original Actor ID' corresponds to this field.

ActorId System.String True  

Label 'Actor ID' corresponds to this field.

RemindersSent System.Integer True  

Label 'RemindersSent' corresponds to this field.

Comments System.String True  

Label 'Comments' corresponds to this field.

IsDeleted System.Boolean True  

Label 'Deleted' corresponds to this field.

CreatedDate System.DateTime True  

Label 'Created Date' corresponds to this field.

CreatedById System.String True  

Label 'Created By ID' corresponds to this field.

SystemModstamp System.DateTime True  

Label 'System Modstamp' corresponds to this field.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
SOQL String

Specifies the Where clause of the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precendence over any other input.

 

 

 

ProcessInstanceStep

This is a table representing the ProcessInstanceStep entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ProcessInstanceStep.

ProcessInstanceId String True

ProcessInstance.Id

Label Process Instance ID corresponds to this field.

StepStatus String True  

Label Step Status corresponds to this field.

OriginalActorId String True  

Label Original Actor ID corresponds to this field.

ActorId String True  

Label Actor ID corresponds to this field.

Comments String True  

Label Comments corresponds to this field.

StepNodeId String True

ProcessNode.Id

Label Process Node ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ProcessInstanceWorkitem

This is a table representing the ProcessInstanceWorkitem entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ProcessInstanceWorkitem.

ProcessInstanceId String True

ProcessInstance.Id

Label Process Instance ID corresponds to this field.

OriginalActorId String True  

Label Original Actor ID corresponds to this field.

ActorId String True  

Label Actor ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

ProcessNode

This is a table representing the ProcessNode entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ProcessNode.

Name String True  

Label Name corresponds to this field.

DeveloperName String True  

Label Unique Name corresponds to this field.

ProcessDefinitionId String True

ProcessDefinition.Id

Label Approval Process ID corresponds to this field.

Description String True  

Label Description corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Product2

This is a table representing the Product2 entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Product2.

Name String False  

Label Product Name corresponds to this field.

ProductCode String False  

Label Product Code corresponds to this field.

Description String False  

Label Product Description corresponds to this field.

IsActive Boolean False  

Label Active corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

Family String False  

Label Product Family corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Old_Factory_Codes__c String False  

Label Old_Factory_Codes corresponds to this field.

TextLong2__c String False  

Label TextLong2 corresponds to this field.

Factory_Code__c String False  

Label Factory_Code corresponds to this field.

 

 

 

Product2Feed

This is a table representing the Product2Feed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Product2Feed.

ParentId String True

Product2.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

Profile

This is a table representing the Profile entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Profile.

Name String True  

Label Name corresponds to this field.

PermissionsEmailSingle Boolean True  

Label Send Email corresponds to this field.

PermissionsEmailMass Boolean True  

Label Mass Email corresponds to this field.

PermissionsEditTask Boolean True  

Label Edit Tasks corresponds to this field.

PermissionsEditEvent Boolean True  

Label Edit Events corresponds to this field.

PermissionsExportReport Boolean True  

Label Export Reports corresponds to this field.

PermissionsImportPersonal Boolean True  

Label Import Personal Contacts corresponds to this field.

PermissionsManageUsers Boolean True  

Label Manage Users corresponds to this field.

PermissionsEditPublicTemplates Boolean True  

Label Manage Public Templates corresponds to this field.

PermissionsModifyAllData Boolean True  

Label Modify All Data corresponds to this field.

PermissionsManageCases Boolean True  

Label Manage Cases corresponds to this field.

PermissionsEditKnowledge Boolean True  

Label Manage Articles corresponds to this field.

PermissionsManageKnowledge Boolean True  

Label Manage Salesforce Knowledge corresponds to this field.

PermissionsManageSolutions Boolean True  

Label Manage Published Solutions corresponds to this field.

PermissionsCustomizeApplication Boolean True  

Label Customize Application corresponds to this field.

PermissionsEditReadonlyFields Boolean True  

Label Edit Read Only Fields corresponds to this field.

PermissionsRunReports Boolean True  

Label Run Reports corresponds to this field.

PermissionsViewSetup Boolean True  

Label View Setup and Configuration corresponds to this field.

PermissionsTransferAnyEntity Boolean True  

Label Transfer Record corresponds to this field.

PermissionsNewReportBuilder Boolean True  

Label Report Builder corresponds to this field.

PermissionsManageSelfService Boolean True  

Label Manage Self-Service Portal corresponds to this field.

PermissionsManageCssUsers Boolean True  

Label Edit Self-Service Users corresponds to this field.

PermissionsActivateContract Boolean True  

Label Activate Contracts corresponds to this field.

PermissionsImportLeads Boolean True  

Label Import Leads corresponds to this field.

PermissionsManageLeads Boolean True  

Label Manage Leads corresponds to this field.

PermissionsTransferAnyLead Boolean True  

Label Transfer Leads corresponds to this field.

PermissionsViewAllData Boolean True  

Label View All Data corresponds to this field.

PermissionsEditPublicDocuments Boolean True  

Label Manage Public Documents corresponds to this field.

PermissionsEditBrandTemplates Boolean True  

Label Manage Letterheads corresponds to this field.

PermissionsEditHtmlTemplates Boolean True  

Label Edit HTML Templates corresponds to this field.

PermissionsChatterInternalUser Boolean True  

Label Chatter Internal User corresponds to this field.

PermissionsManageDashboards Boolean True  

Label Manage Dashboards corresponds to this field.

PermissionsDeleteActivatedContract Boolean True  

Label Delete Activated Contracts corresponds to this field.

PermissionsChatterInviteExternalUsers Boolean True  

Label Invite Customers To Chatter corresponds to this field.

PermissionsSendSitRequests Boolean True  

Label Send Stay-in-Touch Requests corresponds to this field.

PermissionsManageRemoteAccess Boolean True  

Label Manage Connected Apps corresponds to this field.

PermissionsCanUseNewDashboardBuilder Boolean True  

Label Drag-and-Drop Dashboard Builder corresponds to this field.

PermissionsManageCategories Boolean True  

Label Manage Categories corresponds to this field.

PermissionsConvertLeads Boolean True  

Label Convert Leads corresponds to this field.

PermissionsPasswordNeverExpires Boolean True  

Label Password Never Expires corresponds to this field.

PermissionsUseTeamReassignWizards Boolean True  

Label Use Team Reassignment Wizards corresponds to this field.

PermissionsInstallMultiforce Boolean True  

Label Download AppExchange Packages corresponds to this field.

PermissionsPublishMultiforce Boolean True  

Label Upload AppExchange Packages corresponds to this field.

PermissionsChatterOwnGroups Boolean True  

Label Create and Own New Chatter Groups corresponds to this field.

PermissionsEditOppLineItemUnitPrice Boolean True  

Label Edit Opportunity Product Sales Price corresponds to this field.

PermissionsCreateMultiforce Boolean True  

Label Create AppExchange Packages corresponds to this field.

PermissionsBulkApiHardDelete Boolean True  

Label Bulk API Hard Delete corresponds to this field.

PermissionsSolutionImport Boolean True  

Label Import Solutions corresponds to this field.

PermissionsManageCallCenters Boolean True  

Label Manage Call Centers corresponds to this field.

PermissionsEditReports Boolean True  

Label Create and Customize Reports corresponds to this field.

PermissionsManageSynonyms Boolean True  

Label Manage Synonyms corresponds to this field.

PermissionsViewContent Boolean True  

Label View Content in Portals corresponds to this field.

PermissionsManageEmailClientConfig Boolean True  

Label Manage Email Client Configurations corresponds to this field.

PermissionsEnableNotifications Boolean True  

Label Send Outbound Messages corresponds to this field.

PermissionsManageDataIntegrations Boolean True  

Label Manage Data Integrations corresponds to this field.

PermissionsViewDataCategories Boolean True  

Label View Data Categories corresponds to this field.

PermissionsManageDataCategories Boolean True  

Label Manage Data Categories corresponds to this field.

PermissionsAuthorApex Boolean True  

Label Author Apex corresponds to this field.

PermissionsManageMobile Boolean True  

Label Manage Mobile Configurations corresponds to this field.

PermissionsApiEnabled Boolean True  

Label API Enabled corresponds to this field.

PermissionsManageCustomReportTypes Boolean True  

Label Manage Custom Report Types corresponds to this field.

PermissionsEditCaseComments Boolean True  

Label Edit Case Comments corresponds to this field.

PermissionsTransferAnyCase Boolean True  

Label Transfer Cases corresponds to this field.

PermissionsContentAdministrator Boolean True  

Label Manage Salesforce CRM Content corresponds to this field.

PermissionsCreateWorkspaces Boolean True  

Label Create Libraries corresponds to this field.

PermissionsManageContentPermissions Boolean True  

Label Manage Content Permissions corresponds to this field.

PermissionsManageContentProperties Boolean True  

Label Manage Content Properties corresponds to this field.

PermissionsManageContentTypes Boolean True  

Label Manage Content Types corresponds to this field.

PermissionsManageAnalyticSnapshots Boolean True  

Label Manage Analytic Snapshots corresponds to this field.

PermissionsScheduleReports Boolean True  

Label Schedule Reports corresponds to this field.

PermissionsManageBusinessHourHolidays Boolean True  

Label Manage Business Hours Holidays corresponds to this field.

PermissionsManageDynamicDashboards Boolean True  

Label Manage Dynamic Dashboards corresponds to this field.

PermissionsCustomSidebarOnAllPages Boolean True  

Label Show Custom Sidebar On All Pages corresponds to this field.

PermissionsManageInteraction Boolean True  

Label Manage Force.com Flow corresponds to this field.

PermissionsViewMyTeamsDashboards Boolean True  

Label View My Team's Dashboards corresponds to this field.

PermissionsModerateChatter Boolean True  

Label Moderate Chatter corresponds to this field.

PermissionsResetPasswords Boolean True  

Label Reset User Passwords and Unlock Users corresponds to this field.

PermissionsFlowUFLRequired Boolean True  

Label Require Force.com Flow User Feature License corresponds to this field.

PermissionsCanInsertFeedSystemFields Boolean True  

Label Insert System Field Values for Chatter Feeds corresponds to this field.

PermissionsManageKnowledgeImportExport Boolean True  

Label Manage Knowledge Article Import/Export corresponds to this field.

PermissionsEmailTemplateManagement Boolean True  

Label Manage Email Templates corresponds to this field.

PermissionsEmailAdministration Boolean True  

Label Email Administration corresponds to this field.

PermissionsManageChatterMessages Boolean True  

Label Manage Chatter Messages corresponds to this field.

PermissionsForceTwoFactor Boolean True  

Label Two-Factor Authentication for User Interface Logins corresponds to this field.

PermissionsManageNetworks Boolean True  

Label Create and Set Up Communities corresponds to this field.

PermissionsManageAuthProviders Boolean True  

Label Manage Auth. Providers corresponds to this field.

PermissionsRunFlow Boolean True  

Label Run Flows corresponds to this field.

PermissionsViewAllUsers Boolean True  

Label View All Users corresponds to this field.

PermissionsAllowUniversalSearch Boolean True  

Label Knowledge One corresponds to this field.

PermissionsConnectOrgToEnvironmentHub Boolean True  

Label Connect Organization to Environment Hub corresponds to this field.

PermissionsSalesConsole Boolean True  

Label Sales Console corresponds to this field.

PermissionsTwoFactorApi Boolean True  

Label Two-Factor Authentication for API Logins corresponds to this field.

PermissionsDeleteTopics Boolean True  

Label Delete Topics corresponds to this field.

PermissionsEditTopics Boolean True  

Label Edit Topics corresponds to this field.

PermissionsCreateTopics Boolean True  

Label Create Topics corresponds to this field.

PermissionsAssignTopics Boolean True  

Label Assign Topics corresponds to this field.

PermissionsIdentityEnabled Boolean True  

Label Use Identity Features corresponds to this field.

PermissionsIdentityConnect Boolean True  

Label Use Identity Connect corresponds to this field.

PermissionsAllowViewKnowledge Boolean True  

Label Allow View Knowledge corresponds to this field.

UserLicenseId String True

UserLicense.Id

Label User License ID corresponds to this field.

UserType String True  

Label User Type corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

Description String True  

Label Description corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

 

 

 

PushTopic

This is a table representing the PushTopic entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the PushTopic.

Name String False  

Label Topic Name corresponds to this field.

Query String False  

Label SOQL Query corresponds to this field.

ApiVersion Double False  

Label API Version corresponds to this field.

IsActive Boolean False  

Label Is Active corresponds to this field.

NotifyForFields String False  

Label Notify For Fields corresponds to this field.

NotifyForOperations String True  

Label Notify For Operations corresponds to this field.

Description String False  

Label Description corresponds to this field.

NotifyForOperationCreate Boolean False  

Label Create corresponds to this field.

NotifyForOperationUpdate Boolean False  

Label Update corresponds to this field.

NotifyForOperationDelete Boolean False  

Label Delete corresponds to this field.

NotifyForOperationUndelete Boolean False  

Label Undelete corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

QueueSobject

This is a table representing the QueueSobject entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the QueueSobject.

QueueId String False

Group.Id

Label Group ID corresponds to this field.

SobjectType String False  

Label Sobject Type corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Quote

This is a table representing the Quote entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Quote.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Name String False  

Label Quote Name corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

OpportunityId String False

Opportunity.Id

Label Opportunity ID corresponds to this field.

Pricebook2Id String False

Pricebook2.Id

Label Price Book ID corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

QuoteNumber String True  

Label Quote Number corresponds to this field.

IsSyncing Boolean True  

Label Syncing corresponds to this field.

ShippingHandling Double False  

Label Shipping and Handling corresponds to this field.

Tax Double False  

Label Tax corresponds to this field.

Status String False  

Label Status corresponds to this field.

ExpirationDate Datetime False  

Label Expiration Date corresponds to this field.

Description String False  

Label Description corresponds to this field.

Subtotal Double True  

Label Subtotal corresponds to this field.

TotalPrice Double True  

Label Total Price corresponds to this field.

LineItemCount Int True  

Label Line Items corresponds to this field.

BillingStreet String False  

Label Bill To Street corresponds to this field.

BillingCity String False  

Label Bill To City corresponds to this field.

BillingState String False  

Label Bill To State/Province corresponds to this field.

BillingPostalCode String False  

Label Bill To Zip/Postal Code corresponds to this field.

BillingCountry String False  

Label Bill To Country corresponds to this field.

BillingLatitude Double False  

Label Bill To Latitude corresponds to this field.

BillingLongitude Double False  

Label Bill To Longitude corresponds to this field.

ShippingStreet String False  

Label Ship To Street corresponds to this field.

ShippingCity String False  

Label Ship To City corresponds to this field.

ShippingState String False  

Label Ship To State/Province corresponds to this field.

ShippingPostalCode String False  

Label Ship To Zip/Postal Code corresponds to this field.

ShippingCountry String False  

Label Ship To Country corresponds to this field.

ShippingLatitude Double False  

Label Ship To Latitude corresponds to this field.

ShippingLongitude Double False  

Label Ship To Longitude corresponds to this field.

QuoteToStreet String False  

Label Quote To Street corresponds to this field.

QuoteToCity String False  

Label Quote To City corresponds to this field.

QuoteToState String False  

Label Quote To State/Province corresponds to this field.

QuoteToPostalCode String False  

Label Quote To Zip/Postal Code corresponds to this field.

QuoteToCountry String False  

Label Quote To Country corresponds to this field.

QuoteToLatitude Double False  

Label Quote To Latitude corresponds to this field.

QuoteToLongitude Double False  

Label Quote To Longitude corresponds to this field.

AdditionalStreet String False  

Label Additional To Street corresponds to this field.

AdditionalCity String False  

Label Additional To City corresponds to this field.

AdditionalState String False  

Label Additional To State/Province corresponds to this field.

AdditionalPostalCode String False  

Label Additional To Zip/Postal Code corresponds to this field.

AdditionalCountry String False  

Label Additional To Country corresponds to this field.

AdditionalLatitude Double False  

Label Additional To Latitude corresponds to this field.

AdditionalLongitude Double False  

Label Additional To Longitude corresponds to this field.

BillingName String False  

Label Bill To Name corresponds to this field.

ShippingName String False  

Label Ship To Name corresponds to this field.

QuoteToName String False  

Label Quote To Name corresponds to this field.

AdditionalName String False  

Label Additional To Name corresponds to this field.

Email String False  

Label Email corresponds to this field.

Phone String False  

Label Phone corresponds to this field.

Fax String False  

Label Fax corresponds to this field.

Discount Double True  

Label Discount corresponds to this field.

GrandTotal Double True  

Label Grand Total corresponds to this field.

 

 

 

QuoteDocument

This is a table representing the QuoteDocument entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the QuoteDocument.

Name String True  

Label Name corresponds to this field.

QuoteId String False

Quote.Id

Label Quote ID corresponds to this field.

Document String False  

Label PDF Document corresponds to this field.

GrandTotal Double True  

Label Grand Total corresponds to this field.

Discount Double True  

Label Discount corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

QuoteFeed

This is a table representing the QuoteFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the QuoteFeed.

ParentId String True

Quote.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

QuoteLineItem

This is a table representing the QuoteLineItem entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the QuoteLineItem.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LineNumber String True  

Label Line Item Number corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

QuoteId String False

Quote.Id

Label Quote ID corresponds to this field.

PricebookEntryId String False

PricebookEntry.Id

Label Price Book Entry ID corresponds to this field.

Quantity Double False  

Label Quantity corresponds to this field.

UnitPrice Double False  

Label Sales Price corresponds to this field.

Discount Double False  

Label Discount corresponds to this field.

Description String False  

Label Line Item Description corresponds to this field.

ServiceDate Datetime False  

Label Date corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

ListPrice Double True  

Label List Price corresponds to this field.

Subtotal Double True  

Label Subtotal corresponds to this field.

TotalPrice Double True  

Label Total Price corresponds to this field.

 

 

 

RecentlyViewed

This is a table representing the RecentlyViewed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the RecentlyViewed.

Name String True  

Label Name corresponds to this field.

LastName String True  

Label Last Name corresponds to this field.

FirstName String True  

Label First Name corresponds to this field.

Type String True  

Label Type corresponds to this field.

Alias String True  

Label Alias corresponds to this field.

UserRoleId String True

UserRole.Id

Label Role ID corresponds to this field.

RecordTypeId String True

RecordType.Id

Label Record Type ID corresponds to this field.

IsActive Boolean True  

Label Active corresponds to this field.

ProfileId String True

Profile.Id

Label Profile ID corresponds to this field.

Title String True  

Label Title corresponds to this field.

Email String True  

Label E-mail corresponds to this field.

Phone String True  

Label Phone corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

 

 

 

RecordType

This is a table representing the RecordType entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the RecordType.

Name String False  

Label Name corresponds to this field.

DeveloperName String False  

Label Record Type Name corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

Description String False  

Label Description corresponds to this field.

BusinessProcessId String False

BusinessProcess.Id

Label Business Process ID corresponds to this field.

SobjectType String False  

Label Sobject Type Name corresponds to this field.

IsActive Boolean True  

Label Active corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Report

This is a table representing the Report entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Report.

OwnerId String True  

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Name String True  

Label Report Name corresponds to this field.

Description String True  

Label Description corresponds to this field.

DeveloperName String True  

Label Report Unique Name corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

LastRunDate Datetime True  

Label Last Run corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

Format String True  

Label Format corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

 

 

 

ReportFeed

This is a table representing the ReportFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the ReportFeed.

ParentId String True

Report.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

Scontrol

This is a table representing the Scontrol entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Scontrol.

Name String True  

Label Label corresponds to this field.

DeveloperName String True  

Label S-Control Name corresponds to this field.

Description String True  

Label Description corresponds to this field.

EncodingKey String True  

Label Encoding corresponds to this field.

HtmlWrapper String True  

Label HTML Body corresponds to this field.

Filename String True  

Label Filename corresponds to this field.

BodyLength Int True  

Label Binary Length corresponds to this field.

Binary String True  

Label Binary corresponds to this field.

ContentSource String True  

Label Type corresponds to this field.

SupportsCaching Boolean True  

Label Prebuild In Page corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

SelfServiceUser

This is a table representing the SelfServiceUser entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the SelfServiceUser.

LastName String False  

Label Last Name corresponds to this field.

FirstName String False  

Label First Name corresponds to this field.

Name String True  

Label Name corresponds to this field.

Username String False  

Label Username corresponds to this field.

Email String False  

Label Email corresponds to this field.

IsActive Boolean False  

Label Active corresponds to this field.

TimeZoneSidKey String False  

Label TimeZoneSidKey corresponds to this field.

LocaleSidKey String False  

Label LocaleSidKey corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

LanguageLocaleKey String False  

Label LanguageLocaleKey corresponds to this field.

SuperUser Boolean True  

Label Super User corresponds to this field.

LastLoginDate Datetime True  

Label Last Login corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

SetupEntityAccess

This is a table representing the SetupEntityAccess entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the SetupEntityAccess.

ParentId String False

PermissionSet.Id

Label Parent ID corresponds to this field.

SetupEntityId String False  

Label Setup Entity ID corresponds to this field.

SetupEntityType String True  

Label Setup Entity Type corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Site

This is a table representing the Site entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Site.

Name String True  

Label Site Name corresponds to this field.

Subdomain String True  

Label Site Subdomain Prefix corresponds to this field.

UrlPathPrefix String True  

Label Default Web Address corresponds to this field.

Status String True  

Label Site Status corresponds to this field.

AdminId String True

User.Id

Label User ID corresponds to this field.

OptionsEnableFeeds Boolean True  

Label Enable Feeds corresponds to this field.

OptionsAllowHomePage Boolean True  

Label Enable Standard Home Page corresponds to this field.

OptionsAllowStandardIdeasPages Boolean True  

Label Enable Standard Ideas Pages corresponds to this field.

OptionsAllowStandardSearch Boolean True  

Label Enable Standard Lookup Pages corresponds to this field.

OptionsAllowStandardLookups Boolean True  

Label Enable Standard Search Pages corresponds to this field.

OptionsAllowStandardAnswersPages Boolean True  

Label Enable Standard Answers Pages corresponds to this field.

Description String True  

Label Site Description corresponds to this field.

MasterLabel String True  

Label Site Label corresponds to this field.

AnalyticsTrackingCode String True  

Label Analytics Tracking Code corresponds to this field.

SiteType String True  

Label Site Type corresponds to this field.

DailyBandwidthLimit Int True  

Label Daily Bandwidth Limit (MB) corresponds to this field.

DailyBandwidthUsed Int True  

Label Daily Bandwidth Used corresponds to this field.

DailyRequestTimeLimit Int True  

Label Daily Request Time Limit (min) corresponds to this field.

DailyRequestTimeUsed Int True  

Label Daily Request Time Used corresponds to this field.

MonthlyPageViewsEntitlement Int True  

Label Monthly Page Views Allowed corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

SiteFeed

This is a table representing the SiteFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the SiteFeed.

ParentId String True

Site.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

SiteHistory

This is a table representing the SiteHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the SiteHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

SiteId String True

Site.Id

Label Site ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

Solution

This is a table representing the Solution entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Solution.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

SolutionNumber String True  

Label Solution Number corresponds to this field.

SolutionName String False  

Label Title corresponds to this field.

IsPublished Boolean False  

Label Public corresponds to this field.

IsPublishedInPublicKb Boolean False  

Label Visible in Public Knowledge Base corresponds to this field.

Status String False  

Label Status corresponds to this field.

IsReviewed Boolean True  

Label Reviewed corresponds to this field.

SolutionNote String False  

Label Description corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

TimesUsed Int True  

Label Num Related Cases corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

IsHtml Boolean True  

Label Is Html corresponds to this field.

 

 

 

SolutionFeed

This is a table representing the SolutionFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the SolutionFeed.

ParentId String True

Solution.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

SolutionHistory

This is a table representing the SolutionHistory entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the SolutionHistory.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

SolutionId String True

Solution.Id

Label Solution ID corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

Field String True  

Label Changed Field corresponds to this field.

OldValue String True  

Label Old Value corresponds to this field.

NewValue String True  

Label New Value corresponds to this field.

 

 

 

SolutionStatus

This is a table representing the SolutionStatus entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the SolutionStatus.

MasterLabel String True  

Label Master Label corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

IsDefault Boolean True  

Label Is Default corresponds to this field.

IsReviewed Boolean True  

Label Is Reviewed corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

StaticResource

This is a table representing the StaticResource entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the StaticResource.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

Name String False  

Label Name corresponds to this field.

ContentType String False  

Label MIME Type corresponds to this field.

BodyLength Int True  

Label Size corresponds to this field.

Body String False  

Label Body corresponds to this field.

Description String False  

Label Description corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CacheControl String False  

Label Cache Control corresponds to this field.

 

 

 

Task

This is a table representing the Task entities in Salesforce. To retrieve archived tasks, you must explicitly query for records with IsArchived set to True.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Task.

WhoId String False  

Label Contact/Lead ID corresponds to this field.

WhatId String False  

Label Opportunity/Account ID corresponds to this field.

Subject String False  

Label Subject corresponds to this field.

ActivityDate Datetime False  

Label Due Date Only corresponds to this field.

Status String False  

Label Status corresponds to this field.

Priority String False  

Label Priority corresponds to this field.

OwnerId String False

User.Id

Label Assigned To ID corresponds to this field.

Description String False  

Label Description corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

AccountId String True

Account.Id

Label Account ID corresponds to this field.

IsClosed Boolean True  

Label Closed corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsArchived Boolean True  

Label Archived corresponds to this field.

CallDurationInSeconds Int False  

Label Call Duration corresponds to this field.

CallType String False  

Label Call Type corresponds to this field.

CallDisposition String False  

Label Call Result corresponds to this field.

CallObject String False  

Label Call Object Identifier corresponds to this field.

ReminderDateTime Datetime False  

Label Reminder Date/Time corresponds to this field.

IsReminderSet Boolean False  

Label Reminder Set corresponds to this field.

RecurrenceActivityId String True

Task.Id

Label Recurrence Activity ID corresponds to this field.

IsRecurrence Boolean False  

Label Create Recurring Series of Tasks corresponds to this field.

RecurrenceStartDateOnly Datetime False  

Label Start Date corresponds to this field.

RecurrenceEndDateOnly Datetime False  

Label End Date corresponds to this field.

RecurrenceTimeZoneSidKey String False  

Label Recurrence Time Zone corresponds to this field.

RecurrenceType String False  

Label Recurrence Type corresponds to this field.

RecurrenceInterval Int False  

Label Recurrence Interval corresponds to this field.

RecurrenceDayOfWeekMask Int False  

Label Recurrence Day of Week Mask corresponds to this field.

RecurrenceDayOfMonth Int False  

Label Recurrence Day of Month corresponds to this field.

RecurrenceInstance String False  

Label Recurrence Instance corresponds to this field.

RecurrenceMonthOfYear String False  

Label Recurrence Month of Year corresponds to this field.

 

 

 

TaskFeed

This is a table representing the TaskFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the TaskFeed.

ParentId String True

Task.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

TaskPriority

This is a table representing the TaskPriority entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the TaskPriority.

MasterLabel String True  

Label Master Label corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

IsDefault Boolean True  

Label Is Default corresponds to this field.

IsHighPriority Boolean True  

Label Is High Priority corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

TaskStatus

This is a table representing the TaskStatus entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the TaskStatus.

MasterLabel String True  

Label Master Label corresponds to this field.

SortOrder Int True  

Label Sort Order corresponds to this field.

IsDefault Boolean True  

Label Is Default corresponds to this field.

IsClosed Boolean True  

Label Is Closed corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

Topic

This is a table representing the Topic entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Topic.

Name String False  

Label Name corresponds to this field.

Description String False  

Label Description corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

TalkingAbout Int True  

Label Talking About corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

TopicAssignment

This is a table representing the TopicAssignment entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the TopicAssignment.

TopicId String False

Topic.Id

Label Topic ID corresponds to this field.

EntityId String False  

Label Entity ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

TopicFeed

This is a table representing the TopicFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the TopicFeed.

ParentId String True

Topic.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

UndecidedEventRelation

This is a table representing the UndecidedEventRelation entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the UndecidedEventRelation.

RelationId String True  

Label Relation ID corresponds to this field.

EventId String True

Event.Id

Label Event ID corresponds to this field.

RespondedDate Datetime True  

Label Response Date corresponds to this field.

Response String True  

Label Response corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

Type String True  

Label Type corresponds to this field.

 

 

 

User

This is a table representing the User entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the User.

Username String False  

Label Username corresponds to this field.

LastName String False  

Label Last Name corresponds to this field.

FirstName String False  

Label First Name corresponds to this field.

Name String True  

Label Full Name corresponds to this field.

CompanyName String False  

Label Company Name corresponds to this field.

Division String False  

Label Division corresponds to this field.

Department String False  

Label Department corresponds to this field.

Title String False  

Label Title corresponds to this field.

Street String False  

Label Street corresponds to this field.

City String False  

Label City corresponds to this field.

State String False  

Label State/Province corresponds to this field.

PostalCode String False  

Label Zip/Postal Code corresponds to this field.

Country String False  

Label Country corresponds to this field.

Latitude Double False  

Label Latitude corresponds to this field.

Longitude Double False  

Label Longitude corresponds to this field.

Email String False  

Label E-mail corresponds to this field.

EmailPreferencesAutoBcc Boolean False  

Label AutoBcc corresponds to this field.

EmailPreferencesAutoBccStayInTouch Boolean False  

Label AutoBccStayInTouch corresponds to this field.

EmailPreferencesStayInTouchReminder Boolean False  

Label StayInTouchReminder corresponds to this field.

SenderEmail String False  

Label Email Sender Address corresponds to this field.

SenderName String False  

Label Email Sender Name corresponds to this field.

Signature String False  

Label Email Signature corresponds to this field.

StayInTouchSubject String False  

Label Stay-in-Touch Email Subject corresponds to this field.

StayInTouchSignature String False  

Label Stay-in-Touch Email Signature corresponds to this field.

StayInTouchNote String False  

Label Stay-in-Touch Email Note corresponds to this field.

Phone String False  

Label Phone corresponds to this field.

Fax String False  

Label Fax corresponds to this field.

MobilePhone String False  

Label Cell corresponds to this field.

Alias String False  

Label Alias corresponds to this field.

CommunityNickname String False  

Label Nickname corresponds to this field.

IsActive Boolean False  

Label Active corresponds to this field.

TimeZoneSidKey String False  

Label Time Zone corresponds to this field.

UserRoleId String False

UserRole.Id

Label Role ID corresponds to this field.

LocaleSidKey String False  

Label Locale corresponds to this field.

ReceivesInfoEmails Boolean False  

Label Info Emails corresponds to this field.

ReceivesAdminInfoEmails Boolean False  

Label Admin Info Emails corresponds to this field.

EmailEncodingKey String False  

Label Email Encoding corresponds to this field.

ProfileId String False

Profile.Id

Label Profile ID corresponds to this field.

UserType String True  

Label User Type corresponds to this field.

LanguageLocaleKey String False  

Label Language corresponds to this field.

EmployeeNumber String False  

Label Employee Number corresponds to this field.

DelegatedApproverId String False  

Label Delegated Approver ID corresponds to this field.

ManagerId String False

User.Id

Label Manager ID corresponds to this field.

LastLoginDate Datetime True  

Label Last Login corresponds to this field.

LastPasswordChangeDate Datetime True  

Label Last Password Change or Reset corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

OfflineTrialExpirationDate Datetime True  

Label Offline Edition Trial Expiration Date corresponds to this field.

OfflinePdaTrialExpirationDate Datetime True  

Label Sales Anywhere Trial Expiration Date corresponds to this field.

UserPermissionsMarketingUser Boolean False  

Label Marketing User corresponds to this field.

UserPermissionsOfflineUser Boolean False  

Label Offline User corresponds to this field.

UserPermissionsCallCenterAutoLogin Boolean False  

Label Auto-login To Call Center corresponds to this field.

UserPermissionsMobileUser Boolean False  

Label Apex Mobile User corresponds to this field.

UserPermissionsSFContentUser Boolean False  

Label Salesforce CRM Content User corresponds to this field.

UserPermissionsKnowledgeUser Boolean False  

Label Knowledge User corresponds to this field.

UserPermissionsInteractionUser Boolean False  

Label Force.com Flow User corresponds to this field.

UserPermissionsSupportUser Boolean False  

Label Service Cloud User corresponds to this field.

UserPermissionsSiteforceContributorUser Boolean False  

Label Site.com Contributor User corresponds to this field.

UserPermissionsSiteforcePublisherUser Boolean False  

Label Site.com Publisher User corresponds to this field.

UserPermissionsChatterAnswersUser Boolean False  

Label Chatter Answers User corresponds to this field.

ForecastEnabled Boolean False  

Label Allow Forecasting corresponds to this field.

UserPreferencesActivityRemindersPopup Boolean False  

Label ActivityRemindersPopup corresponds to this field.

UserPreferencesEventRemindersCheckboxDefault Boolean False  

Label EventRemindersCheckboxDefault corresponds to this field.

UserPreferencesTaskRemindersCheckboxDefault Boolean False  

Label TaskRemindersCheckboxDefault corresponds to this field.

UserPreferencesReminderSoundOff Boolean False  

Label ReminderSoundOff corresponds to this field.

UserPreferencesDisableAllFeedsEmail Boolean False  

Label DisableAllFeedsEmail corresponds to this field.

UserPreferencesDisableFollowersEmail Boolean False  

Label DisableFollowersEmail corresponds to this field.

UserPreferencesDisableProfilePostEmail Boolean False  

Label DisableProfilePostEmail corresponds to this field.

UserPreferencesDisableChangeCommentEmail Boolean False  

Label DisableChangeCommentEmail corresponds to this field.

UserPreferencesDisableLaterCommentEmail Boolean False  

Label DisableLaterCommentEmail corresponds to this field.

UserPreferencesDisProfPostCommentEmail Boolean False  

Label DisProfPostCommentEmail corresponds to this field.

UserPreferencesApexPagesDeveloperMode Boolean False  

Label ApexPagesDeveloperMode corresponds to this field.

UserPreferencesHideCSNGetChatterMobileTask Boolean False  

Label HideCSNGetChatterMobileTask corresponds to this field.

UserPreferencesDisableMentionsPostEmail Boolean False  

Label DisableMentionsPostEmail corresponds to this field.

UserPreferencesDisMentionsCommentEmail Boolean False  

Label DisMentionsCommentEmail corresponds to this field.

UserPreferencesHideCSNDesktopTask Boolean False  

Label HideCSNDesktopTask corresponds to this field.

UserPreferencesHideChatterOnboardingSplash Boolean False  

Label HideChatterOnboardingSplash corresponds to this field.

UserPreferencesHideSecondChatterOnboardingSplash Boolean False  

Label HideSecondChatterOnboardingSplash corresponds to this field.

UserPreferencesDisCommentAfterLikeEmail Boolean False  

Label DisCommentAfterLikeEmail corresponds to this field.

UserPreferencesDisableLikeEmail Boolean False  

Label DisableLikeEmail corresponds to this field.

UserPreferencesDisableMessageEmail Boolean False  

Label DisableMessageEmail corresponds to this field.

UserPreferencesOptOutOfTouch Boolean False  

Label OptOutOfTouch corresponds to this field.

UserPreferencesDisableBookmarkEmail Boolean False  

Label DisableBookmarkEmail corresponds to this field.

UserPreferencesDisableSharePostEmail Boolean False  

Label DisableSharePostEmail corresponds to this field.

UserPreferencesEnableAutoSubForFeeds Boolean False  

Label EnableAutoSubForFeeds corresponds to this field.

UserPreferencesDisableFileShareNotificationsForApi Boolean False  

Label DisableFileShareNotificationsForApi corresponds to this field.

UserPreferencesShowTitleToExternalUsers Boolean False  

Label ShowTitleToExternalUsers corresponds to this field.

UserPreferencesShowManagerToExternalUsers Boolean False  

Label ShowManagerToExternalUsers corresponds to this field.

UserPreferencesShowEmailToExternalUsers Boolean False  

Label ShowEmailToExternalUsers corresponds to this field.

UserPreferencesShowWorkPhoneToExternalUsers Boolean False  

Label ShowWorkPhoneToExternalUsers corresponds to this field.

UserPreferencesShowMobilePhoneToExternalUsers Boolean False  

Label ShowMobilePhoneToExternalUsers corresponds to this field.

UserPreferencesShowFaxToExternalUsers Boolean False  

Label ShowFaxToExternalUsers corresponds to this field.

UserPreferencesShowStreetAddressToExternalUsers Boolean False  

Label ShowStreetAddressToExternalUsers corresponds to this field.

UserPreferencesShowCityToExternalUsers Boolean False  

Label ShowCityToExternalUsers corresponds to this field.

UserPreferencesShowStateToExternalUsers Boolean False  

Label ShowStateToExternalUsers corresponds to this field.

UserPreferencesShowPostalCodeToExternalUsers Boolean False  

Label ShowPostalCodeToExternalUsers corresponds to this field.

UserPreferencesShowCountryToExternalUsers Boolean False  

Label ShowCountryToExternalUsers corresponds to this field.

UserPreferencesShowProfilePicToGuestUsers Boolean False  

Label ShowProfilePicToGuestUsers corresponds to this field.

UserPreferencesShowTitleToGuestUsers Boolean False  

Label ShowTitleToGuestUsers corresponds to this field.

UserPreferencesShowCityToGuestUsers Boolean False  

Label ShowCityToGuestUsers corresponds to this field.

UserPreferencesShowStateToGuestUsers Boolean False  

Label ShowStateToGuestUsers corresponds to this field.

UserPreferencesShowPostalCodeToGuestUsers Boolean False  

Label ShowPostalCodeToGuestUsers corresponds to this field.

UserPreferencesShowCountryToGuestUsers Boolean False  

Label ShowCountryToGuestUsers corresponds to this field.

UserPreferencesHideS1BrowserUI Boolean False  

Label HideS1BrowserUI corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

AccountId String True

Account.Id

Label Account ID corresponds to this field.

CallCenterId String False

CallCenter.Id

Label Call Center ID corresponds to this field.

Extension String False  

Label Extension corresponds to this field.

FederationIdentifier String False  

Label SAML Federation ID corresponds to this field.

AboutMe String False  

Label About Me corresponds to this field.

FullPhotoUrl String True  

Label Url for full-sized Photo corresponds to this field.

SmallPhotoUrl String True  

Label Url for Thumbnail sized Photo corresponds to this field.

DigestFrequency String False  

Label Chatter Email Highlights Frequency corresponds to this field.

DefaultGroupNotificationFrequency String False  

Label Default Notification Frequency when Joining Groups corresponds to this field.

LastViewedDate Datetime True  

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True  

Label Last Referenced Date corresponds to this field.

GeoLoc__Latitude__s Double False  

Label GeoLoc (Latitude) corresponds to this field.

GeoLoc__Longitude__s Double False  

Label GeoLoc (Longitude) corresponds to this field.

GeoLoc__c String True  

Label GeoLoc corresponds to this field.

TextLong__c String False  

Label TextLong corresponds to this field.

ExternId__c String False  

Label ExternId corresponds to this field.

 

 

 

UserFeed

This is a table representing the UserFeed entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the UserFeed.

ParentId String True

User.Id

Label Parent ID corresponds to this field.

Type String True  

Label Feed Item Type corresponds to this field.

CreatedById String True  

Label Created By ID corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

CommentCount Int True  

Label Comment Count corresponds to this field.

LikeCount Int True  

Label Like Count corresponds to this field.

Title String True  

Label Title corresponds to this field.

Body String True  

Label Body corresponds to this field.

LinkUrl String True  

Label Link Url corresponds to this field.

RelatedRecordId String True

ContentVersion.Id

Label Related Record ID corresponds to this field.

ContentData String True  

Label Content Data corresponds to this field.

ContentFileName String True  

Label Content File Name corresponds to this field.

ContentDescription String True  

Label Content Description corresponds to this field.

ContentType String True  

Label Content File Type corresponds to this field.

ContentSize Int True  

Label Content Size corresponds to this field.

InsertedById String True  

Label InsertedBy ID corresponds to this field.

 

 

 

UserLicense

This is a table representing the UserLicense entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the UserLicense.

LicenseDefinitionKey String True  

Label License Def. ID corresponds to this field.

Name String True  

Label Name corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

UserLogin

This is a table representing the UserLogin entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the UserLogin.

UserId String True

User.Id

Label User ID corresponds to this field.

IsFrozen Boolean True  

Label Is Frozen corresponds to this field.

IsPasswordLocked Boolean True  

Label Is Password Locked corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

 

 

 

UserPreference

This is a table representing the UserPreference entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the UserPreference.

UserId String True

User.Id

Label User ID corresponds to this field.

Preference String True  

Label Preference corresponds to this field.

Value String True  

Label Value corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

UserProfile

This is a table representing the UserProfile entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the UserProfile.

LastName String True  

Label Last Name corresponds to this field.

FirstName String True  

Label First Name corresponds to this field.

Name String True  

Label Name corresponds to this field.

Title String True  

Label Title corresponds to this field.

ManagerId String True

UserProfile.Id

Label Manager ID corresponds to this field.

CompanyName String True  

Label Company Name corresponds to this field.

AboutMe String True  

Label About Me corresponds to this field.

Email String True  

Label E-mail corresponds to this field.

Phone String True  

Label Phone corresponds to this field.

MobilePhone String True  

Label Cell corresponds to this field.

Fax String True  

Label Fax corresponds to this field.

Street String True  

Label Street corresponds to this field.

City String True  

Label City corresponds to this field.

State String True  

Label State/Province corresponds to this field.

PostalCode String True  

Label Zip/Postal Code corresponds to this field.

Country String True  

Label Country corresponds to this field.

Latitude Double True  

Label Latitude corresponds to this field.

Longitude Double True  

Label Longitude corresponds to this field.

IsBadged Boolean True  

Label User Photo has a badge overlay corresponds to this field.

IsActive Boolean True  

Label Active corresponds to this field.

UserPreferencesActivityRemindersPopup Boolean True  

Label ActivityRemindersPopup corresponds to this field.

UserPreferencesEventRemindersCheckboxDefault Boolean True  

Label EventRemindersCheckboxDefault corresponds to this field.

UserPreferencesTaskRemindersCheckboxDefault Boolean True  

Label TaskRemindersCheckboxDefault corresponds to this field.

UserPreferencesReminderSoundOff Boolean True  

Label ReminderSoundOff corresponds to this field.

UserPreferencesDisableAllFeedsEmail Boolean True  

Label DisableAllFeedsEmail corresponds to this field.

UserPreferencesDisableFollowersEmail Boolean True  

Label DisableFollowersEmail corresponds to this field.

UserPreferencesDisableProfilePostEmail Boolean True  

Label DisableProfilePostEmail corresponds to this field.

UserPreferencesDisableChangeCommentEmail Boolean True  

Label DisableChangeCommentEmail corresponds to this field.

UserPreferencesDisableLaterCommentEmail Boolean True  

Label DisableLaterCommentEmail corresponds to this field.

UserPreferencesDisProfPostCommentEmail Boolean True  

Label DisProfPostCommentEmail corresponds to this field.

UserPreferencesApexPagesDeveloperMode Boolean True  

Label ApexPagesDeveloperMode corresponds to this field.

UserPreferencesHideCSNGetChatterMobileTask Boolean True  

Label HideCSNGetChatterMobileTask corresponds to this field.

UserPreferencesDisableMentionsPostEmail Boolean True  

Label DisableMentionsPostEmail corresponds to this field.

UserPreferencesDisMentionsCommentEmail Boolean True  

Label DisMentionsCommentEmail corresponds to this field.

UserPreferencesHideCSNDesktopTask Boolean True  

Label HideCSNDesktopTask corresponds to this field.

UserPreferencesHideChatterOnboardingSplash Boolean True  

Label HideChatterOnboardingSplash corresponds to this field.

UserPreferencesHideSecondChatterOnboardingSplash Boolean True  

Label HideSecondChatterOnboardingSplash corresponds to this field.

UserPreferencesDisCommentAfterLikeEmail Boolean True  

Label DisCommentAfterLikeEmail corresponds to this field.

UserPreferencesDisableLikeEmail Boolean True  

Label DisableLikeEmail corresponds to this field.

UserPreferencesDisableMessageEmail Boolean True  

Label DisableMessageEmail corresponds to this field.

UserPreferencesOptOutOfTouch Boolean True  

Label OptOutOfTouch corresponds to this field.

UserPreferencesDisableBookmarkEmail Boolean True  

Label DisableBookmarkEmail corresponds to this field.

UserPreferencesDisableSharePostEmail Boolean True  

Label DisableSharePostEmail corresponds to this field.

UserPreferencesEnableAutoSubForFeeds Boolean True  

Label EnableAutoSubForFeeds corresponds to this field.

UserPreferencesDisableFileShareNotificationsForApi Boolean True  

Label DisableFileShareNotificationsForApi corresponds to this field.

UserPreferencesShowTitleToExternalUsers Boolean True  

Label ShowTitleToExternalUsers corresponds to this field.

UserPreferencesShowManagerToExternalUsers Boolean True  

Label ShowManagerToExternalUsers corresponds to this field.

UserPreferencesShowEmailToExternalUsers Boolean True  

Label ShowEmailToExternalUsers corresponds to this field.

UserPreferencesShowWorkPhoneToExternalUsers Boolean True  

Label ShowWorkPhoneToExternalUsers corresponds to this field.

UserPreferencesShowMobilePhoneToExternalUsers Boolean True  

Label ShowMobilePhoneToExternalUsers corresponds to this field.

UserPreferencesShowFaxToExternalUsers Boolean True  

Label ShowFaxToExternalUsers corresponds to this field.

UserPreferencesShowStreetAddressToExternalUsers Boolean True  

Label ShowStreetAddressToExternalUsers corresponds to this field.

UserPreferencesShowCityToExternalUsers Boolean True  

Label ShowCityToExternalUsers corresponds to this field.

UserPreferencesShowStateToExternalUsers Boolean True  

Label ShowStateToExternalUsers corresponds to this field.

UserPreferencesShowPostalCodeToExternalUsers Boolean True  

Label ShowPostalCodeToExternalUsers corresponds to this field.

UserPreferencesShowCountryToExternalUsers Boolean True  

Label ShowCountryToExternalUsers corresponds to this field.

UserPreferencesShowProfilePicToGuestUsers Boolean True  

Label ShowProfilePicToGuestUsers corresponds to this field.

UserPreferencesShowTitleToGuestUsers Boolean True  

Label ShowTitleToGuestUsers corresponds to this field.

UserPreferencesShowCityToGuestUsers Boolean True  

Label ShowCityToGuestUsers corresponds to this field.

UserPreferencesShowStateToGuestUsers Boolean True  

Label ShowStateToGuestUsers corresponds to this field.

UserPreferencesShowPostalCodeToGuestUsers Boolean True  

Label ShowPostalCodeToGuestUsers corresponds to this field.

UserPreferencesShowCountryToGuestUsers Boolean True  

Label ShowCountryToGuestUsers corresponds to this field.

UserPreferencesHideS1BrowserUI Boolean True  

Label HideS1BrowserUI corresponds to this field.

FullPhotoUrl String True  

Label Url for full-sized Photo corresponds to this field.

SmallPhotoUrl String True  

Label Url for Thumbnail sized Photo corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

UserRecordAccess

This is a table representing the UserRecordAccess entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the UserRecordAccess.

UserId String True

User.Id

Label User ID corresponds to this field.

RecordId String True  

Label Record ID corresponds to this field.

HasReadAccess Boolean True  

Label Has Read Access corresponds to this field.

HasEditAccess Boolean True  

Label Has Edit Access corresponds to this field.

HasDeleteAccess Boolean True  

Label Has Delete Access corresponds to this field.

HasTransferAccess Boolean True  

Label Has Transfer Access corresponds to this field.

HasAllAccess Boolean True  

Label Has All Access corresponds to this field.

MaxAccessLevel String True  

Label Maximum Access Level corresponds to this field.

 

 

 

UserRole

This is a table representing the UserRole entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the UserRole.

Name String False  

Label Name corresponds to this field.

ParentRoleId String False

UserRole.Id

Label Parent Role ID corresponds to this field.

RollupDescription String False  

Label Description corresponds to this field.

OpportunityAccessForAccountOwner String False  

Label Opportunity Access Level for Account Owner corresponds to this field.

CaseAccessForAccountOwner String False  

Label Case Access Level for Account Owner corresponds to this field.

ContactAccessForAccountOwner String True  

Label Contact Access Level for Account Owner corresponds to this field.

ForecastUserId String False

User.Id

Label User ID corresponds to this field.

MayForecastManagerShare Boolean True  

Label May Forecast Manager Share corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

DeveloperName String False  

Label Developer Name corresponds to this field.

PortalAccountId String False

Account.Id

Label Account ID corresponds to this field.

PortalType String False  

Label Portal Type corresponds to this field.

PortalAccountOwnerId String True

User.Id

Label User ID corresponds to this field.

 

 

 

Vote

This is a table representing the Vote entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the Vote.

IsDeleted Boolean True  

Label Deleted corresponds to this field.

ParentId String False

Solution.Id

Label Parent ID corresponds to this field.

Type String False  

Label Vote Type corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.

 

 

 

WebLink

This is a table representing the WebLink entities in Salesforce.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
Id [KEY] String True  

Unique identifier of the WebLink.

PageOrSobjectType String False  

Label Page Or sObject Type Name corresponds to this field.

Name String False  

Label Name corresponds to this field.

IsProtected Boolean False  

Label Protected Component corresponds to this field.

Url String False  

Label URL corresponds to this field.

EncodingKey String False  

Label Link Encoding corresponds to this field.

LinkType String False  

Label Content Source corresponds to this field.

OpenType String False  

Label Behavior corresponds to this field.

Height Int False  

Label Height (in pixels) corresponds to this field.

Width Int False  

Label Width (in pixels) corresponds to this field.

ShowsLocation Boolean False  

Label Show Address Bar corresponds to this field.

HasScrollbars Boolean False  

Label Show Scrollbars corresponds to this field.

HasToolbar Boolean False  

Label Show Toolbars corresponds to this field.

HasMenubar Boolean False  

Label Show Menu Bar corresponds to this field.

ShowsStatus Boolean False  

Label Show Status Bar corresponds to this field.

IsResizable Boolean False  

Label Resizeable corresponds to this field.

Position String False  

Label Window Position corresponds to this field.

ScontrolId String False  

Label Custom S-Control ID corresponds to this field.

MasterLabel String False  

Label Label corresponds to this field.

Description String False  

Label Description corresponds to this field.

DisplayType String False  

Label Display Type corresponds to this field.

RequireRowSelection Boolean False  

Label Require Row Selection corresponds to this field.

NamespacePrefix String True  

Label Namespace Prefix corresponds to this field.

CreatedDate Datetime True  

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True  

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True  

Label System Modstamp corresponds to this field.