TIBCO Data Virtualization® Adapter Online Help > TDV Salesforce with SSO Adapter > Data Model > Tables
 
Tables
The adapter exposes tables for data sources that support both retrieving and updating data.
Generally, querying Salesforce with SSO tables is the same as querying a table in a relational database. The following sections provide Salesforce with SSO-specific information on querying the tables. For example, any columns required in the WHERE clause and fields required to insert.
Salesforce with SSO Adapter Tables
Name
Description
This is a table representing the AcceptedEventRelation entities in Salesforce.
This is a table representing the Account entities in Salesforce.
This is a table representing the AccountContactRole entities in Salesforce.
This is a table representing the AccountFeed entities in Salesforce.
This is a table representing the AccountHistory entities in Salesforce.
This is a table representing the AccountPartner entities in Salesforce.
This is a table representing the AccountShare entities in Salesforce.
This is a table representing the ActivityHistory entities in Salesforce.
This is a table representing the AdditionalNumber entities in Salesforce.
This is a table representing the ApexClass entities in Salesforce.
This is a table representing the ApexComponent entities in Salesforce.
This is a table representing the ApexLog entities in Salesforce.
This is a table representing the ApexPage entities in Salesforce.
This is a table representing the ApexTestQueueItem entities in Salesforce.
This is a table representing the ApexTestResult entities in Salesforce.
This is a table representing the ApexTrigger entities in Salesforce.
This is a table representing the AppMenuItem entities in Salesforce.
This is a table representing the Approval entities in Salesforce.
This is a table representing the Asset entities in Salesforce.
This is a table representing the AssetFeed entities in Salesforce.
This is a table representing the AssignmentRule entities in Salesforce.
This is a table representing the AsyncApexJob entities in Salesforce.
This is a table representing the Attachment entities in Salesforce.
This is a table representing the AuthProvider entities in Salesforce.
This is a table representing the AuthSession entities in Salesforce.
This is a table representing the BrandTemplate entities in Salesforce.
This is a table representing the BusinessHours entities in Salesforce.
This is a table representing the BusinessProcess entities in Salesforce.
This is a table representing the CallCenter entities in Salesforce.
This is a table representing the Campaign entities in Salesforce.
This is a table representing the CampaignFeed entities in Salesforce.
This is a table representing the CampaignMember entities in Salesforce.
This is a table representing the CampaignMemberStatus entities in Salesforce.
This is a table representing the CampaignShare entities in Salesforce.
This is a table representing the Case entities in Salesforce.
This is a table representing the CaseComment entities in Salesforce.
This is a table representing the CaseContactRole entities in Salesforce.
This is a table representing the CaseFeed entities in Salesforce.
This is a table representing the CaseHistory entities in Salesforce.
This is a table representing the CaseShare entities in Salesforce.
This is a table representing the CaseSolution entities in Salesforce.
This is a table representing the CaseStatus entities in Salesforce.
This is a table representing the CaseTeamMember entities in Salesforce.
This is a table representing the CaseTeamRole entities in Salesforce.
This is a table representing the CaseTeamTemplate entities in Salesforce.
This is a table representing the CaseTeamTemplateMember entities in Salesforce.
This is a table representing the CaseTeamTemplateRecord entities in Salesforce.
This is a table representing the CategoryData entities in Salesforce.
This is a table representing the CategoryNode entities in Salesforce.
This is a table representing the ChatterActivity entities in Salesforce.
This is a table representing the ClientBrowser entities in Salesforce.
This is a table representing the CollaborationGroup entities in Salesforce.
This is a table representing the CollaborationGroupFeed entities in Salesforce.
This is a table representing the CollaborationGroupMember entities in Salesforce.
This is a table representing the CollaborationGroupMemberRequest entities in Salesforce.
This is a table representing the CollaborationInvitation entities in Salesforce.
This is a table representing the Community entities in Salesforce.
This is a table representing the Contact entities in Salesforce.
This is a table representing the ContactFeed entities in Salesforce.
This is a table representing the ContactHistory entities in Salesforce.
This is a table representing the ContactShare entities in Salesforce.
This is a table representing the ContentDocument entities in Salesforce.
This is a table representing the ContentDocumentFeed entities in Salesforce.
This is a table representing the ContentDocumentHistory entities in Salesforce.
This is a table representing the ContentDocumentLink entities in Salesforce.
This is a table representing the ContentVersion entities in Salesforce.
This is a table representing the ContentVersionHistory entities in Salesforce.
This is a table representing the Contract entities in Salesforce.
This is a table representing the ContractContactRole entities in Salesforce.
This is a table representing the ContractFeed entities in Salesforce.
This is a table representing the ContractHistory entities in Salesforce.
This is a table representing the ContractStatus entities in Salesforce.
This is a table representing the CronJobDetail entities in Salesforce.
This is a table representing the CronTrigger entities in Salesforce.
This is a table representing the Dashboard entities in Salesforce.
This is a table representing the DashboardComponent entities in Salesforce.
This is a table representing the DashboardComponentFeed entities in Salesforce.
This is a table representing the DashboardFeed entities in Salesforce.
This is a table representing the DeclinedEventRelation entities in Salesforce.
This is a table representing the Document entities in Salesforce.
This is a table representing the DocumentAttachmentMap entities in Salesforce.
This is a table representing the Domain entities in Salesforce.
This is a table representing the DomainSite entities in Salesforce.
This is a table representing the EmailServicesAddress entities in Salesforce.
This is a table representing the EmailServicesFunction entities in Salesforce.
This is a table representing the EmailStatus entities in Salesforce.
This is a table representing the EmailTemplate entities in Salesforce.
This is a table representing the EntitySubscription entities in Salesforce.
This is a table representing the Event entities in Salesforce.
This is a table representing the EventFeed entities in Salesforce.
This is a table representing the EventRelation entities in Salesforce.
This is a table representing the FeedComment entities in Salesforce.
This is a table representing the FeedItem entities in Salesforce.
This is a table representing the FeedPollChoice entities in Salesforce.
This is a table representing the FeedPollVote entities in Salesforce.
This is a table representing the FieldPermissions entities in Salesforce.
This is a table representing the FiscalYearSettings entities in Salesforce.
This is a table representing the Folder entities in Salesforce.
This is a table representing the ForecastShare entities in Salesforce.
This is a table representing the Group entities in Salesforce.
This is a table representing the GroupMember entities in Salesforce.
This is a table representing the HashtagDefinition entities in Salesforce.
This is a table representing the Holiday entities in Salesforce.
This is a table representing the Lead entities in Salesforce.
This is a table representing the LeadFeed entities in Salesforce.
This is a table representing the LeadHistory entities in Salesforce.
This is a table representing the LeadShare entities in Salesforce.
This is a table representing the LeadStatus entities in Salesforce.
This is a table representing the LoginHistory entities in Salesforce.
This is a table representing the LoginIp entities in Salesforce.
This is a table representing the MailmergeTemplate entities in Salesforce.
This is a table representing the MobileDeviceRegistrar entities in Salesforce.
This is a table representing the Name entities in Salesforce.
This is a table representing the Note entities in Salesforce.
This is a table representing the NoteAndAttachment entities in Salesforce.
This is a table representing the ObjectPermissions entities in Salesforce.
This is a table representing the OpenActivity entities in Salesforce.
This is a table representing the Opportunity entities in Salesforce.
This is a table representing the OpportunityCompetitor entities in Salesforce.
This is a table representing the OpportunityContactRole entities in Salesforce.
This is a table representing the OpportunityFeed entities in Salesforce.
This is a table representing the OpportunityFieldHistory entities in Salesforce.
This is a table representing the OpportunityHistory entities in Salesforce.
This is a table representing the OpportunityLineItem entities in Salesforce.
This is a table representing the OpportunityPartner entities in Salesforce.
This is a table representing the OpportunityShare entities in Salesforce.
This is a table representing the OpportunityStage entities in Salesforce.
This is a table representing the Organization entities in Salesforce.
This is a table representing the OrgWideEmailAddress entities in Salesforce.
This is a table representing the Partner entities in Salesforce.
This is a table representing the PartnerRole entities in Salesforce.
This is a table representing the Period entities in Salesforce.
This is a table representing the PermissionSet entities in Salesforce.
This is a table representing the PermissionSetAssignment entities in Salesforce.
This is a table representing the PermissionSetLicense entities in Salesforce.
This is a table representing the PermissionSetLicenseAssign entities in Salesforce.
This is a table representing the Pricebook2 entities in Salesforce.
This is a table representing the Pricebook2History entities in Salesforce.
This is a table representing the PricebookEntry entities in Salesforce.
This is a table representing the ProcessDefinition entities in Salesforce.
This is a table representing the ProcessInstance entities in Salesforce.
This is a table representing the ProcessInstanceHistory entities in Salesforce.
This is a table representing the ProcessInstanceStep entities in Salesforce.
This is a table representing the ProcessInstanceWorkitem entities in Salesforce.
This is a table representing the ProcessNode entities in Salesforce.
This is a table representing the Product2 entities in Salesforce.
This is a table representing the Product2Feed entities in Salesforce.
This is a table representing the Profile entities in Salesforce.
This is a table representing the PushTopic entities in Salesforce.
This is a table representing the QueueSobject entities in Salesforce.
This is a table representing the Quote entities in Salesforce.
This is a table representing the QuoteDocument entities in Salesforce.
This is a table representing the QuoteFeed entities in Salesforce.
This is a table representing the QuoteLineItem entities in Salesforce.
This is a table representing the RecentlyViewed entities in Salesforce.
This is a table representing the RecordType entities in Salesforce.
This is a table representing the Report entities in Salesforce.
This is a table representing the ReportFeed entities in Salesforce.
This is a table representing the Scontrol entities in Salesforce.
This is a table representing the SelfServiceUser entities in Salesforce.
This is a table representing the SetupEntityAccess entities in Salesforce.
This is a table representing the Site entities in Salesforce.
This is a table representing the SiteFeed entities in Salesforce.
This is a table representing the SiteHistory entities in Salesforce.
This is a table representing the Solution entities in Salesforce.
This is a table representing the SolutionFeed entities in Salesforce.
This is a table representing the SolutionHistory entities in Salesforce.
This is a table representing the SolutionStatus entities in Salesforce.
This is a table representing the StaticResource entities in Salesforce.
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.
This is a table representing the TaskFeed entities in Salesforce.
This is a table representing the TaskPriority entities in Salesforce.
This is a table representing the TaskStatus entities in Salesforce.
This is a table representing the Topic entities in Salesforce.
This is a table representing the TopicAssignment entities in Salesforce.
This is a table representing the TopicFeed entities in Salesforce.
This is a table representing the UndecidedEventRelation entities in Salesforce.
This is a table representing the User entities in Salesforce.
This is a table representing the UserFeed entities in Salesforce.
This is a table representing the UserLicense entities in Salesforce.
This is a table representing the UserLogin entities in Salesforce.
This is a table representing the UserPreference entities in Salesforce.
This is a table representing the UserProfile entities in Salesforce.
This is a table representing the UserRecordAccess entities in Salesforce.
This is a table representing the UserRole entities in Salesforce.
This is a table representing the Vote entities in Salesforce.
This is a table representing the WebLink entities in Salesforce.
The adapter can also expose custom entities on your Salesforce with SSO account that are not mentioned in the Tables. You can query against these custom entities as with any other table. Additionally, you can query against custom fields of standard entities.
There is a naming limitation that applies to the lists and to the custom fields. Empty spaces in list names are converted to underscores for the table names. Also, all custom fields and custom entities are identified by Salesforce with SSO with a __c appended to the end of the name.
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
.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
.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 Dashboard ComponentFeed.
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
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.