Salesforce Field Reference

Guide
Salesforce, Winter ’16

@salesforcedocs
Last updated: December 8, 2015
© Copyright 2000–2015 salesforce.com, inc. All rights reserved. Salesforce is a registered trademark of salesforce.com, inc.,

as are other names and marks. Other marks appearing herein may be trademarks of their respective owners.
CONTENTS

Salesforce Fields Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

Account . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
AccountContactRole . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
AccountPartner . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
AccountTeamMember . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
AccountTerritoryAssignmentRule . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
AccountTerritoryAssignmentRuleItem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
AccountTerritorySharingRule . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
ActivityHistory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Announcement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
ApexLog . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
ApexTestQueueItem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
ApexTestResult . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
AppMenuItem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Asset . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
AttachedContentDocument . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Attachment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
AuthConfig . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
AuthConfigProviders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
AuthProvider . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
AuthSession . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Bookmark . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
BrandTemplate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Campaign . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
CampaignMember . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
CampaignMemberStatus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
CaseContactRole . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
CaseMilestone . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
ChatterActivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
ChatterConversation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
ChatterConversationMember . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
ChatterMessage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
ClientBrowser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
CollaborationGroup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
CollaborationGroupMember . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
CollaborationGroupMemberRequest . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
CollaborationGroupRecord . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
CollaborationInvitation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Contents

CombinedAttachment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Contact . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
ContentDistribution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
ContentDistributionView . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
ContentDocument . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
ContentDocumentLink . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
ContentWorkspace . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
ContentWorkspaceDoc . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
ContentVersion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Contract . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
ContractContactRole . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
ContractLineItem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
CronJobDetail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
CurrencyType . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
CustomPermission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
CustomPermissionDependency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
Dashboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
DashboardComponent . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43
DatedConversionRate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
Division . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
Document . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45
Domain . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
DomainSite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
EmailMessage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47
EmailTemplate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
Entitlement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49
EntitlementContact . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50
EntitlementTemplate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50
EntitySubscription . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51
Event . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51
EventLogFile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53
ExternalDataSource . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
ExternalDataUserAuth . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
FeedComment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
FeedItem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
FeedTrackedChange . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57
FieldPermissions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57
Folder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
GoogleDoc . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
Group . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
Idea . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
Lead . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
ListView . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
ListViewChart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Contents

LoginHistory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64
LoginIp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64
LookedUpFromActivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
MailmergeTemplate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66
MilestoneType . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
NamedCredential . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Note . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68
NoteAndAttachment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69
OauthToken . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69
ObjectPermissions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70
OpenActivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71
Opportunity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72
OpportunityCompetitor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
OpportunityContactRole . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74
OpportunityHistory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74
OpportunityLineItem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75
OpportunityLineItemSchedule . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
OpportunityPartner . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77
OpportunitySplit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77
OpportunitySplitType . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
OpportunityStage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79
OpportunityTeamMember . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79
OwnedContentDocument . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80
Partner . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
PartnerNetworkConnection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
PartnerNetworkRecordConnection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
PartnerRole . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83
Period . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83
PermissionSet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84
PermissionSetAssignment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85
PermissionSetLicense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85
PermissionSetLicenseAssign . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
PlatformAction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
Pricebook2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87
PricebookEntry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88
Product2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89
ProductEntitlementTemplate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89
Question . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90
Quote . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91
RecentlyViewed . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93
Reply . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93
Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94
SelfServiceUser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95
ServiceContract . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
Contents

SetupEntityAccess . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97
Site . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97
SlaProcess . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98
Solution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
TagDefinition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100
Task . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100
Territory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102
Topic . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103
TopicAssignment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103
TwoFactorInfo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104
User . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104
UserAccountTeamMember . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106
UserLogin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107
UserRecordAccess . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108
UserRole . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108
UserProfile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109
UserTeamMember . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110
UserTerritory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110
Vote . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111
WebLink . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111
SALESFORCE FIELDS REFERENCE

This is a list of the standard fields for the major objects in Salesforce. For details about using each object, see the Salesforce online help.
For more technical details, see the SOAP API Developer's Guide.
Fields display in a variety of places in the Salesforce user interface, including page layouts, related lists, search layouts, list views, and
reports. For the majority of the fields, you can also use them as merge fields within custom formula fields, Visualforce pages, custom links,
and custom buttons. Merge fields serve as placeholders for data that will be replaced with information from your records, user information,
or company information. For more information about using merge fields, see “Merge Fields Overview” in the Salesforce online help.
Depending on your organization settings and Salesforce Edition, some of these fields may not be available. Not all fields have information
in every column. For example, a picklist field does not have a length or precision. The columns in the following tables include:

Field Label How the field is displayed in the user interface in areas such as
record detail pages, search results, and list views.

API Field Name The name of the field, as represented in the SOAP API.

Type Indicates the data type of a field. With the exception of boolean
and division, the types refer to standard Salesforce data types, such
as number or picklist.
A boolean data type is represented within Salesforce as a checkbox.
A division data type is used for the Division picklist available to
organizations that have enabled divisions.
Note that Lookup fields are both manually assigned and
system-generated references to other records. Not all of the Picklist
fields listed below have values that can be modified.
For more information on data types, see Primitive Data Types in
the SOAP API Developer's Guide.

Length The maximum number of characters in the field. For example, the
Shipping Zip/Postal Code has a length of 20. You cannot set it to
a value longer than 20 characters.

Precision The precision describes the order of magnitude for the field, in
other words, the complete length of the number, including digits
both to the left and right of the decimal point.
For example, 10234.56 has a precision of seven, five for the numbers
to the left of the decimal place and two for the numbers to the
right.
Note that this is different from the Length value in number fields
in Salesforce. The Length is the number of digits to the left of
the decimal place.

Scale The scale is the number of digits used to describe the fractional
value of the field, in other words, the number of digits to the right

1
Salesforce Fields Reference Account

of the decimal place. A scale of two means that two digits to the
right of the decimal place will be displayed.

Account
Represents an individual account, which is an organization or person involved with your business (such as customers, competitors, and
partners).

Fields
Field Label API Field Name Type Length Precision Scale
Account MasterRecordId reference 15

Account ID Id id 15

Account Number AccountNumber string 40

Account Owner OwnerId reference 15

Account Site Site string 80

Account Source AccountSource picklist 40

Annual Revenue AnnualRevenue currency 18 0

Billing Address BillingStreet textarea 255

Billing Address BillingCity string 40

Billing Address BillingState string 80

Billing Address BillingPostalCode string 20

Billing Address BillingCountry string 80

Created By CreatedById reference 15

Created Date CreatedDate datetime

Data.com Key Jigsaw string 20

Deleted IsDeleted boolean

Description Description textarea 32000

Employees NumberOfEmployees int 8 0

Fax Fax phone 40

Industry Industry picklist 40

Jigsaw Company Id JigsawCompanyId string 20

Last Activity LastActivityDate date

2
Salesforce Fields Reference AccountContactRole

Field Label API Field Name Type Length Precision Scale

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Ownership Ownership picklist 40

Parent Account ParentId reference 15

Phone Phone phone 40

Photo URL PhotoUrl url 255

Rating Rating picklist 40

SIC Code Sic string 20

SIC Description SicDesc string 80

Shipping Address ShippingStreet textarea 255

Shipping Address ShippingCity string 40

Shipping Address ShippingState string 80

Shipping Address ShippingPostalCode string 20

Shipping Address ShippingCountry string 80

System Modstamp SystemModstamp datetime

Ticker Symbol TickerSymbol string 20

Type Type picklist 40

Website Website url 255

AccountContactRole
Represents the role that a Contact plays on an Account.

Fields
Field Label API Field Name Type Length Precision Scale
Account AccountId reference 15

Contact ContactId reference 15

Contact Role ID Id id 15

Created By CreatedById reference 15

3
Salesforce Fields Reference AccountPartner

Field Label API Field Name Type Length Precision Scale

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Primary IsPrimary boolean

Role Role picklist 40

System Modstamp SystemModstamp datetime

AccountPartner
This read-only object represents a partner relationship between two Account objects. It is automatically created when a Partner object
is created for a partner relationship between two accounts.

Fields
Field Label API Field Name Type Length Precision Scale
Account From AccountFromId reference 15

Account Partner ID Id id 15

Account To AccountToId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Opportunity OpportunityId reference 15

Primary IsPrimary boolean

Reverse Partner ReversePartnerId reference 15

Role Role picklist 40

System Modstamp SystemModstamp datetime

4
Salesforce Fields Reference AccountTeamMember

AccountTeamMember
Represents a User who is a member of an Account team.

Fields
Field Label API Field Name Type Length Precision Scale
Account AccountId reference 15

Account Access AccountAccessLevel picklist 40

Account Team Member ID Id id 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Division Division picklist 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

System Modstamp SystemModstamp datetime

Team Role TeamMemberRole picklist 40

User UserId reference 15

AccountTerritoryAssignmentRule
An account assignment rule that assigns accounts to territories based on account fields. Only available if territory management has been
enabled for your organization.

Fields
Field Label API Field Name Type Length Precision Scale
Account Territory Assignment Rule Id id 15
ID

Active IsActive boolean

Apply to child territories IsInherited boolean

Boolean Filter BooleanFilter string 120

Created By CreatedById reference 15

Created Date CreatedDate datetime

5
Salesforce Fields Reference AccountTerritoryAssignmentRuleItem

Field Label API Field Name Type Length Precision Scale

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Rule Name Name string 80

System Modstamp SystemModstamp datetime

Territory TerritoryId reference 15

AccountTerritoryAssignmentRuleItem
A row of selection criteria for an AccountTerritoryAssignmentRule object. Only available if territory management has been enabled for
your organization.

Fields
Field Label API Field Name Type Length Precision Scale
Account Territory Assignment Rule RuleId reference 15

Account Territory Assignment Rule Id id 15

Item ID

Custom Field Definition Field picklist 40

Operation Operation picklist 40

Sort Order SortOrder int 9 0

System Modstamp SystemModstamp datetime

Value Value string 1000

AccountTerritorySharingRule
Represents the rules for sharing an Account within a Territory.

Fields
Field Label API Field Name Type Length Precision Scale
Account Access AccountAccessLevel picklist 40

Account Territory Rule ID Id id 15

Case Access CaseAccessLevel picklist 40

6
Salesforce Fields Reference ActivityHistory

Field Label API Field Name Type Length Precision Scale

Contact Access ContactAccessLevel picklist 40

Created By CreatedById reference 15

Created Date CreatedDate datetime

Description Description textarea 1000

Developer Name DeveloperName string 80

Group GroupId reference 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Name Name string 80

Opportunity Access OpportunityAccessLevel picklist 40

System Modstamp SystemModstamp datetime

User/Group UserOrGroupId reference 15

ActivityHistory
This read-only object is displayed in a related list of closed activities—past events and closed tasks—related to an object. It includes
activities for all contacts related to the object. ActivityHistory fields for phone calls are only available if your organization uses Salesforce
CRM Call Center.

Fields
Field Label API Field Name Type Length Precision Scale
Account AccountId reference 15

Activity ID Id id 15

All-Day Event IsAllDayEvent boolean

Assigned To OwnerId reference 15

Call Duration CallDurationInSeconds int 8 0

Call Object Identifier CallObject string 255

Call Result CallDisposition string 255

Call Type CallType picklist 40

Closed IsClosed boolean

Comments Description textarea 32000

7
Salesforce Fields Reference Announcement

Field Label API Field Name Type Length Precision Scale

Created By CreatedById reference 15

Created Date CreatedDate datetime

Date ActivityDate date

Deleted IsDeleted boolean

Duration DurationInMinutes int 9 0

End EndDateTime datetime

High Priority IsHighPriority boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Location Location string 80

Name WhoId reference 15

Priority Priority picklist 40

Public IsVisibleInSelfService boolean

Related To WhatId reference 15

Reminder Date/Time ReminderDateTime datetime

Reminder Set IsReminderSet boolean

Start StartDateTime datetime

Status Status picklist 40

Subject Subject combobox 80

System Modstamp SystemModstamp datetime

Task IsTask boolean

Type ActivityType picklist 40

Announcement
Represents a Chatter group announcement.

Fields
Field Label API Field Name Type Length Precision Scale
Announcement ID Id id 15

Created By CreatedById reference 15

8
Salesforce Fields Reference ApexLog

Field Label API Field Name Type Length Precision Scale

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Expiration Date ExpirationDate datetime

Feed Item FeedItemId reference 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Parent ParentId reference 15

System Modstamp SystemModstamp datetime

ApexLog
Represents an Apex debug log.

Fields
Field Label API Field Name Type Length Precision Scale
Application Application string 64

Date LastModifiedDate datetime

Duration (ms) DurationMilliseconds int 9 0

Location Location picklist 40

Log ID Id id 15

Log Size (bytes) LogLength int 9 0

Log User LogUserId reference 15

Operation Operation string 128

Request Type Request string 16

Start Time StartTime datetime

Status Status string 255

System Modstamp SystemModstamp datetime

ApexTestQueueItem
Represents a single Apex class in the Apex job queue.

9
Salesforce Fields Reference ApexTestResult

Fields
Field Label API Field Name Type Length Precision Scale
Apex Class ApexClassId reference 15

Apex Test Queue Item ID Id id 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Parent Job ParentJobId reference 15

Status Status picklist 40

Status Detail ExtendedStatus string 1000

System Modstamp SystemModstamp datetime

ApexTestResult
Represents the result of an Apex test method execution.

Fields
Field Label API Field Name Type Length Precision Scale
Apex Class ApexClassId reference 15

Apex Debug Log ApexLogId reference 15

Apex Job AsyncApexJobId reference 15

Apex Test Result ID Id id 15

Error Message Message string 4000

Method Name MethodName string 255

Pass/Fail Outcome picklist 40

Queue Item QueueItemId reference 15

Stack Trace StackTrace string 4000

System Modstamp SystemModstamp datetime

Time Started TestTimestamp datetime

AppMenuItem
Represents the organization’s default settings for items in the Force.com app menu or App Launcher.

10
Salesforce Fields Reference AppMenuItem

Fields
Field Label API Field Name Type Length Precision Scale
App Type Type picklist 255

App requires a registered mobile IsRegisteredDeviceOnly boolean

device

AppMenuItem ID Id id 15

Application ID ApplicationId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Date the mobile app was most MobileAppInstalledDate datetime

recently installed

Deleted IsDeleted boolean

Description Description string 250

Developer Name Name string 80

ID for the related mobile app binary MobileAppBinaryId string 255

Icon Url IconUrl url 255

Info URL InfoUrl url 255

Is this a canvas-enabled application CanvasEnabled boolean

IsUsingAdminAuthorization IsUsingAdminAuthorization boolean

Label Label string 250

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Logo Image URL LogoUrl url 255

Minimum required mobile device MobileMinOsVer string 255

OS version

Mobile Start Url MobileStartUrl url 255

Mobile device OS platform MobilePlatform picklist 255

Most recently installed version of MobileAppInstalledVersion string 255

the mobile app

Namespace Prefix NamespacePrefix string 80

Sort Order SortOrder int 9 0

Start Url StartUrl url 255

11
Salesforce Fields Reference Asset

Field Label API Field Name Type Length Precision Scale

System Modstamp SystemModstamp datetime

The canvas url for the canvas CanvasUrl url 255

application

The configured access method for CanvasAccessMethod picklist 255

the canvas application

The identifier used to render the CanvasReferenceId string 18

canvas application.

The selected/supported locations CanvasSelectedLocations string 255

of the canvas application

Type of mobile device MobileDeviceType string 255

URL to install the mobile app MobileAppInstallUrl url 255

Version of the mobile app MobileAppVer string 255

Asset
Represents an item of commercial value (such as a product sold by your company or by a competitor) that a customer has purchased
and installed.

Fields
Field Label API Field Name Type Length Precision Scale
Account AccountId reference 15

Asset ID Id id 15

Asset Name Name string 255

Competitor Asset IsCompetitorProduct boolean

Contact ContactId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description textarea 32000

Install Date InstallDate date

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

12
Salesforce Fields Reference AttachedContentDocument

Field Label API Field Name Type Length Precision Scale

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Price Price currency 18 0

Product Product2Id reference 15

Purchase Date PurchaseDate date

Quantity Quantity double 12 2

Serial Number SerialNumber string 80

Status Status picklist 40

System Modstamp SystemModstamp datetime

AttachedContentDocument
This read-only object contains all ContentDocument objects associated with an object.

Fields
Field Label API Field Name Type Length Precision Scale
Content Document Link Id Id id 15

Content Modified By LastModifiedById reference 15

Content Modified Date LastModifiedDate datetime

Content Size ContentSize int 9 0

Content URL ContentUrl url 255

Created CreatedDate datetime

Created by CreatedById reference 15

Deleted IsDeleted boolean

Document ContentDocumentId reference 15

External Data Source ExternalDataSourceName string 80

File Extension FileExtension string 40

File Type FileType string 20

Parent LinkedEntityId reference 15

Title Title string 255

13
Salesforce Fields Reference Attachment

Attachment
Represents a file that a User has uploaded and attached to a parent object.

Fields
Field Label API Field Name Type Length Precision Scale
Attachment ID Id id 15

Body Body base64

Body Length BodyLength int 8 0

Content Type ContentType string 120

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description textarea 500

File Name Name string 255

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Owner Name OwnerId reference 15

Parent ParentId reference 15

Private IsPrivate boolean

System Modstamp SystemModstamp datetime

AuthConfig
Represents authentication options for a communityor custom domain that was created by using My Domain.

Fields
Field Label API Field Name Type Length Precision Scale
Authentication Configuration ID Id id 15

Authentication Configuration Type Type picklist 255

Created By CreatedById reference 15

Created Date CreatedDate datetime

14
Salesforce Fields Reference AuthConfigProviders

Field Label API Field Name Type Length Precision Scale

Deleted IsDeleted boolean

Is Active IsActive boolean

Label MasterLabel string 80

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Master Language Language picklist 40

Name DeveloperName string 80

Namespace Prefix NamespacePrefix string 15

System Modstamp SystemModstamp datetime

URL Url string 240

AuthConfigProviders
This object links the authentication configuration for an organization to the Auth. Provider through the AuthOptionsAuthProvider
field of the AuthConfig object. The login page of a Community or custom domain that was created by using My Domain can allow
multiple SAML configurations and multiple authentication providers. These configurations can be set to show up as buttons on the login
page. Each configuration has an AuthConfigProvider object.

Fields
Field Label API Field Name Type Length Precision Scale
Auth Config AuthConfigId reference 15

Auth Config Provider ID Id id 15

Authentication Provider AuthProviderId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

System Modstamp SystemModstamp datetime

15
Salesforce Fields Reference AuthProvider

AuthProvider
An Auth Provider enables users to log into your Salesforce organization using their login credentials from an external service provider
such as Facebook© or Janrain©.

Fields
Field Label API Field Name Type Length Precision Scale
Auth. Provider ID Id id 15

Authorize Endpoint URL AuthorizeUrl url 1024

Consumer Key ConsumerKey string 256

Consumer Secret ConsumerSecret string 100

Created Date CreatedDate datetime

Custom Error URL ErrorUrl string 500

Custom Logout URL LogoutUrl url 1500

Default Scopes DefaultScopes string 256

Execute Registration As ExecutionUserId reference 15

Icon URL IconUrl url 1024

Name FriendlyName string 32

Options Options int 9 0

Provider Type ProviderType picklist 40

Registration Handler RegistrationHandlerId reference 15

Token Endpoint URL TokenUrl url 1024

Token Issuer IdTokenIssuer string 1024

URL Suffix DeveloperName string 32

User Info Endpoint URL UserInfoUrl url 1024

AuthSession
The AuthSession object represents an individual user session in your organization.

16
Salesforce Fields Reference Bookmark

Fields
Field Label API Field Name Type Length Precision Scale
Auth Session ParentId reference 15

Auth Session ID Id id 15

Created CreatedDate datetime

Login LoginType picklist 1

Login History LoginHistoryId reference 15

Logout URL LogoutUrl string 1500

Session Security Level SessionSecurityLevel picklist 40

Session Type SessionType picklist 40

Source IP SourceIp string

Updated LastModifiedDate datetime

User UsersId reference 15

User Type UserType picklist 40

Valid For NumSecondsValid int 9 0

Bookmark
Represents a link between opportunities that share common information.

Fields
Field Label API Field Name Type Length Precision Scale
Bookmark ID Id id 15

Bookmarked From FromId reference 15

Bookmarked To ToId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

System Modstamp SystemModstamp datetime

17
Salesforce Fields Reference BrandTemplate

BrandTemplate
Letterhead for HTML EmailTemplate.

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

Brand Template Name Name string 255

Created By CreatedById reference 15

Created Date CreatedDate datetime

Description Description string 1000

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Letterhead ID Id id 15

Letterhead Unique Name DeveloperName string 80

Namespace Prefix NamespacePrefix string 15

System Modstamp SystemModstamp datetime

Value Value textarea 32000

Campaign
Represents and tracks a marketing campaign, such as a direct mail promotion, webinar, or trade show.

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

Actual Cost ActualCost currency 18 0

Budgeted Cost BudgetedCost currency 18 0

Campaign ID Id id 15

Campaign Member Type CampaignMemberRecordTypeId reference 15

Campaign Name Name string 80

Campaign Owner OwnerId reference 15

18
Salesforce Fields Reference Campaign

Field Label API Field Name Type Length Precision Scale

Converted Leads NumberOfConvertedLeads int 9 0

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description textarea 32000

End Date EndDate date

Expected Response (%) ExpectedResponse percent 10 2

Expected Revenue ExpectedRevenue currency 18 0

Last Activity LastActivityDate date

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Num Sent NumberSent double 18 0

Num Total Opportunities NumberOfOpportunities int 9 0

Num Won Opportunities NumberOfWonOpportunities int 9 0

Parent Campaign ParentId reference 15

Start Date StartDate date

Status Status picklist 40

System Modstamp SystemModstamp datetime

Total Actual Cost in Hierarchy HierarchyActualCost currency 18 0

Total Budgeted Cost in Hierarchy HierarchyBudgetedCost currency 18 0

Total Contacts NumberOfContacts int 9 0

Total Contacts in Hierarchy HierarchyNumberOfContacts int 9 0

Total Converted Leads in Hierarchy HierarchyNumberOfConvertedLeads int 9 0

Total Expected Revenue in HierarchyExpectedRevenue currency 18 0

Hierarchy

Total Leads NumberOfLeads int 9 0

Total Leads in Hierarchy HierarchyNumberOfLeads int 9 0

Total Num Sent in Hierarchy HierarchyNumberSent double 18 0

Total Opportunities in Hierarchy HierarchyNumberOfOpportunities int 9 0

19
Salesforce Fields Reference CampaignMember

Field Label API Field Name Type Length Precision Scale

Total Responses NumberOfResponses int 9 0

Total Responses in Hierarchy HierarchyNumberOfResponses int 9 0

Total Value Opportunities AmountAllOpportunities currency 18 0

Total Value Opportunities in HierarchyAmountAllOpportunities currency 18 0

Hierarchy

Total Value Won Opportunities AmountWonOpportunities currency 18 0

Total Value Won Opportunities in HierarchyAmountWonOpportunities currency 18 0

Hierarchy

Total Won Opportunities in HierarchyNumberOfWonOpportunities int 9 0

Hierarchy

Type Type picklist 40

CampaignMember
Represents the association between a campaign and either a lead or a contact.

Fields
Field Label API Field Name Type Length Precision Scale
Campaign CampaignId reference 15

Campaign Member ID Id id 15

Contact ContactId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

First Responded Date FirstRespondedDate date

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Lead LeadId reference 15

Responded HasResponded boolean

Status Status picklist 40

System Modstamp SystemModstamp datetime

20
Salesforce Fields Reference CampaignMemberStatus

CampaignMemberStatus
One or more member status values defined for a campaign.

Fields
Field Label API Field Name Type Length Precision Scale
Campaign CampaignId reference 15

Campaign Member Status ID Id id 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Is Default IsDefault boolean

Label Label string 765

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Responded HasResponded boolean

Sort Order SortOrder int 9 0

System Modstamp SystemModstamp datetime

Case
Represents a case, which is a customer issue or problem.

Fields
Field Label API Field Name Type Length Precision Scale
Account Name AccountId reference 15

Asset AssetId reference 15

Business Hours BusinessHoursId reference 15

Case ID Id id 15

Case Number CaseNumber string 30

Case Origin Origin picklist 40

Case Owner OwnerId reference 15

21
Salesforce Fields Reference CaseContactRole

Field Label API Field Name Type Length Precision Scale

Case Reason Reason picklist 40

Closed IsClosed boolean

Closed When Created IsClosedOnCreate boolean

Contact Name ContactId reference 15

Created By CreatedById reference 15

Date/Time Closed ClosedDate datetime

Date/Time Opened CreatedDate datetime

Deleted IsDeleted boolean

Description Description textarea 32000

Escalated IsEscalated boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Parent Case ParentId reference 15

Priority Priority picklist 40

Status Status picklist 40

Subject Subject string 255

System Modstamp SystemModstamp datetime

Type Type picklist 40

Web Company SuppliedCompany string 80

Web Email SuppliedEmail email 80

Web Name SuppliedName string 80

Web Phone SuppliedPhone string 40

CaseContactRole
Represents the role that a given Contact plays on a Case.

22
Salesforce Fields Reference CaseMilestone

Fields
Field Label API Field Name Type Length Precision Scale
Case CasesId reference 15

Contact ContactId reference 15

Contact Role ID Id id 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Role Role picklist 40

System Modstamp SystemModstamp datetime

CaseMilestone
Represents a milestone (required step in a customer support process) on a Case.

Fields
Field Label API Field Name Type Length Precision Scale
Business Hours BusinessHoursId reference 15

Case CaseId reference 15

Case Milestone ID Id id 15

Completed IsCompleted boolean

Completion Date CompletionDate datetime

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Elapsed Time (Days) ElapsedTimeInDays double 6 2

Elapsed Time (Hours) ElapsedTimeInHrs double 6 2

Elapsed Time (Mins) ElapsedTimeInMins int 9 0

Last Modified By LastModifiedById reference 15

23
Salesforce Fields Reference ChatterActivity

Field Label API Field Name Type Length Precision Scale

Last Modified Date LastModifiedDate datetime

Milestone MilestoneTypeId reference 15

Start Date StartDate datetime

System Modstamp SystemModstamp datetime

Target Date TargetDate datetime

Target Response (Days) TargetResponseInDays double 6 2

Target Response (Hours) TargetResponseInHrs double 6 2

Target Response (Mins) TargetResponseInMins int 9 0

Time Remaining (Min:Sec) TimeRemainingInMins string 10

Time Since Target (Min:Sec) TimeSinceTargetInMins string 10

Violation IsViolated boolean

ChatterActivity
ChatterActivity represents the number of posts and comments made by a user and the number of comments and likes on posts and
comments received by the same user.

Fields
Field Label API Field Name Type Length Precision Scale
Chatter Activity ID Id id 15

Comment Count CommentCount int 9 0

Comment Received Count CommentReceivedCount int 9 0

Influence Raw Rank InfluenceRawRank int 9 0

Like Received Count LikeReceivedCount int 9 0

Parent ParentId reference 15

Post Count PostCount int 9 0

System Modstamp SystemModstamp datetime

ChatterConversation
Represents a private conversation in Chatter, consisting of messages that conversation members have sent or received.

24
Salesforce Fields Reference ChatterConversationMember

Fields
Field Label API Field Name Type Length Precision Scale
Conversation ID Id id 15

ChatterConversationMember
Represents a member of a private conversation in Chatter. A member has either sent messages to or received messages from other
conversation participants.

Fields
Field Label API Field Name Type Length Precision Scale
Chatter Conversation ConversationId reference 15

Conversation Member ID Id id 15

Member MemberId reference 15

ChatterMessage
Represents a message sent as part of a private conversation in Chatter.

Fields
Field Label API Field Name Type Length Precision Scale
Body Body textarea 10000

Chatter Conversation ConversationId reference 15

Chatter Message ID Id id 15

Created By CreatedById reference 15

Date Message Was Sent SentDate datetime

Sender SenderId reference 15

ClientBrowser
Represents a cookie added to the browser upon login, and also includes information about the browser application where the cookie
was inserted.

25
Salesforce Fields Reference CollaborationGroup

Fields
Field Label API Field Name Type Length Precision Scale
Client Browser ID Id id 15

Created Date CreatedDate datetime

Full User Agent FullUserAgent string 1024

Last Update LastUpdate datetime

Proxy Info ProxyInfo string 1024

User UsersId reference 15

CollaborationGroup
Represents a Chatter group.

Fields
Field Label API Field Name Type Length Precision Scale
Access Type CollaborationType picklist 40

Allow Customers CanHaveGuests boolean

Announcement AnnouncementId reference 15

Archive IsArchived boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Description Description textarea 1000

Disable Automatic Archiving IsAutoArchiveDisabled boolean

Group Id Id id 15

Has Private Fields Access HasPrivateFieldsAccess boolean

Information InformationBody textarea 1000

Information Title InformationTitle string 30

Last Feed Modified Date LastFeedModifiedDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

26
Salesforce Fields Reference CollaborationGroupMember

Field Label API Field Name Type Length Precision Scale

Last Viewed Date LastViewedDate datetime

Member Count MemberCount int 9 0

Name Name string 40

Owner OwnerId reference 15

System Modstamp SystemModstamp datetime

Url for Thumbnail sized Photo SmallPhotoUrl url 1024

Url for full-sized Photo FullPhotoUrl url 1024

CollaborationGroupMember
Represents a member of a Chatter group.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Group CollaborationGroupId reference 15

Group Member Id Id id 15

Group Member Role CollaborationRole picklist 40

Last Feed Access Date LastFeedAccessDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Member MemberId reference 15

Notification Frequency NotificationFrequency picklist 40

System Modstamp SystemModstamp datetime

CollaborationGroupMemberRequest
Represents a request to join a private Chatter group.

27
Salesforce Fields Reference CollaborationGroupRecord

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Group CollaborationGroupId reference 15

Group Member Request Id Id id 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Requester RequesterId reference 15

Response Message ResponseMessage string 255

Status Status picklist 40

System Modstamp SystemModstamp datetime

CollaborationGroupRecord
Represents the records associated with Chatter groups.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Group CollaborationGroupId reference 15

Group Record ID Id id 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Record RecordId reference 15

System Modstamp SystemModstamp datetime

CollaborationInvitation
Represents an invitation to join Chatter, either directly or through a group.

28
Salesforce Fields Reference CombinedAttachment

Fields
Field Label API Field Name Type Length Precision Scale
Chatter Invitation Id Id id 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Invitation Status Status picklist 40

Invited Email InvitedUserEmail string 240

Invited Email (Normalized) InvitedUserEmailNormalized email 80

Inviter InviterId reference 15

Modified By LastModifiedById reference 15

Modified Date LastModifiedDate datetime

Optional Message OptionalMessage string 255

Parent ParentId reference 15

Shared Entity SharedEntityId reference 15

System Modstamp SystemModstamp datetime

CombinedAttachment
This read-only object contains all notes, attachments, Google Docs, documents uploaded to libraries in Salesforce CRM Content, and
files added to Chatter that are associated with a record.

Fields
Field Label API Field Name Type Length Precision Scale
Combined Attachment Id Id id 15

Content Modified By LastModifiedById reference 15

Content Modified Date LastModifiedDate datetime

Content Size ContentSize int 9 0

Content URL ContentUrl url 255

Created CreatedDate datetime

Created by CreatedById reference 15

Deleted IsDeleted boolean

29
Salesforce Fields Reference Contact

Field Label API Field Name Type Length Precision Scale

External Data Source ExternalDataSourceName string 80

File Extension FileExtension string 40

File Type FileType string 30

Parent ParentId reference 15

Title Title string 255

Type RecordType string 30

Contact
Represents a contact, which is an individual associated with an account.

Fields
Field Label API Field Name Type Length Precision Scale
Account Name AccountId reference 15

Assistant AssistantName string 40

Asst. Phone AssistantPhone phone 40

Birthdate Birthdate date

Contact MasterRecordId reference 15

Contact ID Id id 15

Contact Owner OwnerId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Data.com Key Jigsaw string 20

Deleted IsDeleted boolean

Department Department string 80

Description Description textarea 32000

Do Not Call DoNotCall boolean

Email Email email 80

Email Bounced Date EmailBouncedDate datetime

Email Bounced Reason EmailBouncedReason string 255

Email Opt Out HasOptedOutOfEmail boolean

30
Salesforce Fields Reference Contact

Field Label API Field Name Type Length Precision Scale

Fax Fax phone 40

Fax Opt Out HasOptedOutOfFax boolean

Home Phone HomePhone phone 40

Is Email Bounced IsEmailBounced boolean

Jigsaw Contact Id JigsawContactId string 20

Last Activity LastActivityDate date

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Stay-in-Touch Request Date LastCURequestDate datetime

Last Stay-in-Touch Save Date LastCUUpdateDate datetime

Last Viewed Date LastViewedDate datetime

Lead Source LeadSource picklist 40

Mailing Address MailingStreet textarea 255

Mailing Address MailingCity string 40

Mailing Address MailingState string 80

Mailing Address MailingPostalCode string 20

Mailing Address MailingCountry string 80

Mobile MobilePhone phone 40

Name Salutation picklist 40

Name FirstName string 40

Name LastName string 80

Other Address OtherStreet textarea 255

Other Address OtherCity string 40

Other Address OtherState string 80

Other Address OtherPostalCode string 20

Other Address OtherCountry string 80

Other Phone OtherPhone phone 40

Phone Phone phone 40

Photo URL PhotoUrl url 255

31
Salesforce Fields Reference ContentDistribution

Field Label API Field Name Type Length Precision Scale

Reports To ReportsToId reference 15

System Modstamp SystemModstamp datetime

Title Title string 128

ContentDistribution
Represents information about sharing a document externally. This object is available in API version 32.0 and later.

Fields
Field Label API Field Name Type Length Precision Scale
Content Delivery ID Id id 15

Content Delivery Name Name string 100

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Document ContentDocumentId reference 15

Expiration Date ExpiryDate datetime

External Link DistributionPublicUrl string 256

First Viewed FirstViewDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Viewed LastViewDate datetime

Owner Name OwnerId reference 15

Password Password string 36

Preferences Preferences int 9 0

Related To RelatedRecordId reference 15

System Modstamp SystemModstamp datetime

Version ContentVersionId reference 15

View Count ViewCount int 9 0

32
Salesforce Fields Reference ContentDistributionView

ContentDistributionView
Represents information about views of a shared document. This read-only object is available in API version 32.0 and later.

Fields
Field Label API Field Name Type Length Precision Scale
Content Delivery DistributionId reference 15

Content Delivery View ParentViewId reference 15

Content Delivery View ID Id id 15

Created By CreatedById reference 15

Deleted IsDeleted boolean

File Downloaded IsDownload boolean

Internal View IsInternal boolean

System Modstamp SystemModstamp datetime

View Date CreatedDate datetime

ContentDocument
Represents a document that has been uploaded to a library in Salesforce CRM Content or a file in Chatter.

Fields
Field Label API Field Name Type Length Precision Scale
Archived By ArchivedById reference 15

Archived Date ArchivedDate date

Content Modified Date ContentModifiedDate datetime

ContentDocument ID Id id 15

Created CreatedDate datetime

Created By CreatedById reference 15

Description Description textarea 1000

File Extension FileExtension string 40

File Type FileType string 20

Is Archived IsArchived boolean

33
Salesforce Fields Reference ContentDocumentLink

Field Label API Field Name Type Length Precision Scale

Is Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Latest Published Version LatestPublishedVersionId reference 15

Owner OwnerId reference 15

Publish Status PublishStatus picklist 40

Size ContentSize int 9 0

System Modstamp SystemModstamp datetime

Title Title string 255

ContentDocumentLink
Represents the link between a Salesforce CRM Content document or Chatter file and where it's shared. A file can be shared with other
users, Chatter groups, records, and Salesforce CRM Content libraries.

Fields
Field Label API Field Name Type Length Precision Scale
ContentDocumentLink ID Id id 15

Document ContentDocumentId reference 15

Is Deleted IsDeleted boolean

Linked Entity LinkedEntityId reference 15

Share Type ShareType picklist 40

System Modstamp SystemModstamp datetime

Visibility Visibility picklist 40

ContentWorkspace
Represents a public library in Salesforce CRM Content.

34
Salesforce Fields Reference ContentWorkspaceDoc

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Default Content Type DefaultRecordTypeId reference 15

Description Description textarea 500

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Library ID Id id 15

Name Name string 255

Restrict Content Types IsRestrictContentTypes boolean

Restrict Linked Content Types IsRestrictLinkedContentTypes boolean

System Modstamp SystemModstamp datetime

Tag Model TagModel picklist 40

ContentWorkspaceDoc
Represents a link between a document and a public library in Salesforce CRM Content.

Fields
Field Label API Field Name Type Length Precision Scale
Created Date CreatedDate datetime

Document ContentDocumentId reference 15

Is Deleted IsDeleted boolean

Is Owning Library IsOwner boolean

Library ContentWorkspaceId reference 15

Library Document ID Id id 15

System Modstamp SystemModstamp datetime

ContentVersion
Represents a specific version of a document in Salesforce CRM Content or file in Chatter.

35
Salesforce Fields Reference ContentVersion

Fields
Field Label API Field Name Type Length Precision Scale
Checksum Checksum string 50

Content Location ContentLocation picklist 40

Content Modified By ContentModifiedById reference 15

Content Modified Date ContentModifiedDate datetime

Content Origin Origin picklist 40

Content URL ContentUrl url 1333

ContentVersion ID Id id 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Description Description textarea 1000

Document ContentDocumentId reference 15

External Data Source ExternalDataSourceId reference 15

External Document Info1 ExternalDocumentInfo1 string 1000

External Document Info2 ExternalDocumentInfo2 string 1000

Featured Content Boost FeaturedContentBoost int 9 0

Featured Content Date FeaturedContentDate date

File Extension FileExtension string 40

File Type FileType string 20

First Publish Location FirstPublishLocationId reference 15

Is Deleted IsDeleted boolean

Is Latest IsLatest boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Major Version IsMajorVersion boolean

Negative Rating Count NegativeRatingCount int 9 0

Owner OwnerId reference 15

Path On Client PathOnClient string 500

Positive Rating Count PositiveRatingCount int 9 0

Publish Status PublishStatus picklist 40

36
Salesforce Fields Reference Contract

Field Label API Field Name Type Length Precision Scale

Rating Count RatingCount int 9 0

Reason For Change ReasonForChange string 1000

Size ContentSize int 9 0

System Modstamp SystemModstamp datetime

Tags TagCsv textarea 2000

Title Title string 255

Version Data VersionData base64

Version Number VersionNumber string 20

Contract
Represents a contract (a business agreement) associated with an Account.

Fields
Field Label API Field Name Type Length Precision Scale
Account Name AccountId reference 15

Activated By ActivatedById reference 15

Activated Date ActivatedDate datetime

Billing Address BillingStreet textarea 255

Billing Address BillingCity string 40

Billing Address BillingState string 80

Billing Address BillingPostalCode string 20

Billing Address BillingCountry string 80

Company Signed By CompanySignedId reference 15

Company Signed Date CompanySignedDate date

Contract End Date EndDate date

Contract ID Id id 15

Contract Name Name string 80

Contract Number ContractNumber string 30

Contract Owner OwnerId reference 15

Contract Start Date StartDate date

37
Salesforce Fields Reference ContractContactRole

Field Label API Field Name Type Length Precision Scale

Contract Term (months) ContractTerm int 4 0

Created By CreatedById reference 15

Created Date CreatedDate datetime

Customer Signed By CustomerSignedId reference 15

Customer Signed Date CustomerSignedDate date

Customer Signed Title CustomerSignedTitle string 40

Deleted IsDeleted boolean

Description Description textarea 32000

Last Activity LastActivityDate date

Last Approved Date LastApprovedDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Owner Expiration Notice OwnerExpirationNotice picklist 40

Shipping Address ShippingStreet textarea 255

Shipping Address ShippingCity string 40

Shipping Address ShippingState string 80

Shipping Address ShippingPostalCode string 20

Shipping Address ShippingCountry string 80

Special Terms SpecialTerms textarea 4000

Status Status picklist 40

Status Category StatusCode picklist 40

System Modstamp SystemModstamp datetime

ContractContactRole
Represents the role that a given Contact plays on a Contract.

38
Salesforce Fields Reference ContractLineItem

Fields
Field Label API Field Name Type Length Precision Scale
Contact ContactId reference 15

Contact Role ID Id id 15

Contract ContractId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Primary IsPrimary boolean

Role Role picklist 40

System Modstamp SystemModstamp datetime

ContractLineItem
Represents a Product2 in a ServiceContract (customer support agreement).

Fields
Field Label API Field Name Type Length Precision Scale
Asset Name AssetId reference 15

Contract Line Item ID Id id 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Currency CurrencyIsoCode picklist 3

Deleted IsDeleted boolean

Description Description textarea 32000

Discount Discount percent 5 2

End Date EndDate date

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

39
Salesforce Fields Reference CronJobDetail

Field Label API Field Name Type Length Precision Scale

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Line Item Number LineItemNumber string 255

List Price ListPrice currency 18 2

Price Book Entry PricebookEntryId reference 15

Quantity Quantity double 12 2

Sales Price UnitPrice currency 18 2

Service Contract ServiceContractId reference 15

Start Date StartDate date

Status Status picklist 255

Subtotal Subtotal currency 18 2

System Modstamp SystemModstamp datetime

Total Price TotalPrice currency 18 2

CronJobDetail
Contains details about the associated scheduled job, such as the job’s name and type.

Fields
Field Label API Field Name Type Length Precision Scale
Job ID Id id 15

Job Name Name string 255

Type JobType picklist 40

CurrencyType
Represents the currencies used by an organization for which the multicurrency feature is enabled.

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

40
Salesforce Fields Reference CustomPermission

Field Label API Field Name Type Length Precision Scale

Conversion Rate ConversionRate double 18 6

Corporate Currency IsCorporate boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Currency ISO Code IsoCode picklist 40

Currency Type ID Id id 15

Decimal Places DecimalPlaces int 9 0

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

System Modstamp SystemModstamp datetime

CustomPermission
Represents a permission created to control access to a custom process or app, such as sending email.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Custom Permission ID Id id 15

Deleted IsDeleted boolean

Description Description textarea 255

Label MasterLabel string 80

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Master Language Language picklist 40

Name DeveloperName string 80

Namespace Prefix NamespacePrefix string 15

System Modstamp SystemModstamp datetime

41
Salesforce Fields Reference CustomPermissionDependency

CustomPermissionDependency
Represents the dependency between two custom permissions when one custom permission requires that you enable another custom
permission.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Custom Permission CustomPermissionId reference 15

Custom Permission Dependency ID Id id 15

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Required Custom Permission RequiredCustomPermissionId reference 15

System Modstamp SystemModstamp datetime

Dashboard
Represents a dashboard, which shows data from custom reports as visual components. Access is read-only.

Fields
Field Label API Field Name Type Length Precision Scale
Background Fade Direction BackgroundDirection picklist 40

Created By CreatedById reference 15

Created Date CreatedDate datetime

Dashboard ID Id id 15

Dashboard Running User Type picklist 40

Dashboard Unique Name DeveloperName string 80

Deleted IsDeleted boolean

Description Description string 255

Ending Color BackgroundEnd int 9 0

42
Salesforce Fields Reference DashboardComponent

Field Label API Field Name Type Length Precision Scale

Folder FolderId reference 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Last refreshed for this user DashboardResultRefreshedDate string 256

Left Size LeftSize picklist 40

Middle Size MiddleSize picklist 40

Namespace Prefix NamespacePrefix string 15

Right Size RightSize picklist 40

Running User RunningUserId reference 15

Running as DashboardResultRunningUser string 256

Starting Color BackgroundStart int 9 0

System Modstamp SystemModstamp datetime

Text Color TextColor int 9 0

Title Title string 80

Title Color TitleColor int 9 0

Title Size TitleSize int 9 0

DashboardComponent
Represents a dashboard component, which can be a chart, metric, table, or gauge on a dashboard. Access is read-only.

Fields
Field Label API Field Name Type Length Precision Scale
Dashboard DashboardId reference 15

Dashboard Component ID Id id 15

Dashboard Component Name Name string 80

43
Salesforce Fields Reference DatedConversionRate

DatedConversionRate
Represents the dated exchange rates used by an organization for which the multicurrency and the effective dated currency features are
enabled.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Currency Code IsoCode picklist 40

Date StartDate date

DatedConversion Rate ID Id id 15

Exchange Rate ConversionRate double 18 6

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Next Start Date NextStartDate date

System Modstamp SystemModstamp datetime

Division
A logical segment of your organization's data. For example, if your company is organized into different business units, you could create
a division for each business unit, such as “North America,” “Healthcare,” or “Consulting.”

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Division ID Id id 15

Global Division IsGlobalDivision boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Name Name string 80

44
Salesforce Fields Reference Document

Field Label API Field Name Type Length Precision Scale

Sort Order SortOrder int 8 0

System Modstamp SystemModstamp datetime

Document
Represents a file that a user has uploaded. Unlike Attachment records, documents are not attached to a parent object.

Fields
Field Label API Field Name Type Length Precision Scale
Author AuthorId reference 15

Body Body base64

Body Length BodyLength int 8 0

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description textarea 255

Document Content Searchable IsBodySearchable boolean

Document ID Id id 15

Document Name Name string 255

Document Unique Name DeveloperName string 80

Externally Available IsPublic boolean

File Extension Type string 40

Folder FolderId reference 15

Internal Use Only IsInternalUseOnly boolean

Keywords Keywords string 255

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

MIME Type ContentType string 120

Namespace Prefix NamespacePrefix string 15

45
Salesforce Fields Reference Domain

Field Label API Field Name Type Length Precision Scale

System Modstamp SystemModstamp datetime

Url Url string 255

Domain
Read-only object that represents a custom Web address assigned to a site in your organization. This object is available in API version
26.0 and later.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Domain ID Id id 15

Domain Name Domain string 765

Domain Type DomainType picklist 40

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Options Options int 9 0

System Modstamp SystemModstamp datetime

DomainSite
Read-only junction object that joins together the Site and Domain objects.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Custom URL ID Id id 15

Domain DomainId reference 15

Last Modified By LastModifiedById reference 15

46
Salesforce Fields Reference EmailMessage

Field Label API Field Name Type Length Precision Scale

Last Modified Date LastModifiedDate datetime

Path PathPrefix string 255

Site SiteId reference 15

System Modstamp SystemModstamp datetime

EmailMessage
An email message.

Fields
Field Label API Field Name Type Length Precision Scale
Activity ActivityId reference 15

BCC Address BccAddress string 4000

CC Address CcAddress string 4000

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Division Division picklist 15

EmailMessage ID Id id 15

From Address FromAddress email 1000

From Name FromName string 1000

HTML Body HtmlBody textarea 32000

Has Attachment HasAttachment boolean

Headers Headers textarea 32000

Is Incoming Incoming boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Message Date MessageDate datetime

Parent Case ParentId reference 15

Reply-to Email Message ReplyToEmailMessageId reference 15

Status Status picklist 40

47
Salesforce Fields Reference EmailTemplate

Field Label API Field Name Type Length Precision Scale

Subject Subject string 3000

System Modstamp SystemModstamp datetime

Text Body TextBody textarea 32000

To Address ToAddress string 4000

EmailTemplate
Represents a template for mass email, or email sent when the activity history related list of a record is modified.

Fields
Field Label API Field Name Type Length Precision Scale
API Version ApiVersion double 18 1

Author OwnerId reference 15

Available For Use IsActive boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Description Description string 4000

Email Body Body textarea 384000

Email Template ID Id id 15

Email Template Name Name string 80

Encoding Encoding picklist 40

Folder FolderId reference 15

HTML Value HtmlValue textarea 384000

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Used Date LastUsedDate datetime

Letterhead BrandTemplateId reference 15

Markup Markup textarea 1048576

Namespace Prefix NamespacePrefix string 15

Style TemplateStyle picklist 40

Subject Subject string 255

48
Salesforce Fields Reference Entitlement

Field Label API Field Name Type Length Precision Scale

System Modstamp SystemModstamp datetime

Template Type TemplateType picklist 40

Template Unique Name DeveloperName string 80

Times Used TimesUsed int 9 0

Entitlement
Represents the customer support an Account or Contact is eligible to receive.

Fields
Field Label API Field Name Type Length Precision Scale
Account Name AccountId reference 15

Asset Name AssetId reference 15

Business Hours BusinessHoursId reference 15

Cases Per Entitlement CasesPerEntitlement int 9 0

Contract Line Item ContractLineItemId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Currency CurrencyIsoCode picklist 3

Deleted IsDeleted boolean

Division Division picklist 15

End Date EndDate date

Entitlement ID Id id 15

Entitlement Name Name string 255

Entitlement Process SlaProcessId reference 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Per Incident IsPerIncident boolean

Remaining Cases RemainingCases int 9 0

49
Salesforce Fields Reference EntitlementContact

Field Label API Field Name Type Length Precision Scale

Service Contract ServiceContractId reference 15

Start Date StartDate date

Status Status picklist 255

System Modstamp SystemModstamp datetime

Type Type picklist 40

EntitlementContact
Represents a Contact eligible to receive customer support via an Entitlement.

Fields
Field Label API Field Name Type Length Precision Scale
Contact Name ContactId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Currency CurrencyIsoCode picklist 3

Deleted IsDeleted boolean

Division Division picklist 15

Entitlement Contact Name string 255

Entitlement Contact ID Id id 15

Entitlement Name EntitlementId reference 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

System Modstamp SystemModstamp datetime

EntitlementTemplate
Represents predefined terms of customer support for a product (Product2).

50
Salesforce Fields Reference EntitySubscription

Fields
Field Label API Field Name Type Length Precision Scale
Business Hours BusinessHoursId reference 15

Cases Per Entitlement CasesPerEntitlement int 9 0

Created By CreatedById reference 15

Created Date CreatedDate datetime

Entitlement Process SlaProcessId reference 15

Entitlement Template ID Id id 15

Entitlement Template Name Name string 120

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Per Incident IsPerIncident boolean

System Modstamp SystemModstamp datetime

Term (Days) Term int 9 0

Type Type picklist 40

EntitySubscription
Represents a subscription for a user following a record or another user.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Entity Subscription ID Id id 15

Parent ParentId reference 15

Subscriber SubscriberId reference 15

Event
Represents an event in the calendar. In the user interface, event and task records are collectively referred to as activities.

51
Salesforce Fields Reference Event

Fields
Field Label API Field Name Type Length Precision Scale
Account AccountId reference 15

Activity ID Id id 15

All-Day Event IsAllDayEvent boolean

Archived IsArchived boolean

Assigned To OwnerId reference 15

Create Recurring Series of Events IsRecurrence boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Date ActivityDate date

Deleted IsDeleted boolean

Description Description textarea 32000

Duration DurationInMinutes int 8 0

End EndDateTime datetime

End Date RecurrenceEndDateOnly date

Group Event Type GroupEventType picklist 40

Is Child IsChild boolean

Is Group Event IsGroupEvent boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Location Location string 255

Name WhoId reference 15

Private IsPrivate boolean

Recurrence Activity RecurrenceActivityId reference 15

Recurrence Day of Month RecurrenceDayOfMonth int 9 0

Recurrence Day of Week Mask RecurrenceDayOfWeekMask int 9 0

Recurrence Instance RecurrenceInstance picklist 40

Recurrence Interval RecurrenceInterval int 9 0

Recurrence Month of Year RecurrenceMonthOfYear picklist 40

Recurrence Time Zone RecurrenceTimeZoneSidKey picklist 40

52
Salesforce Fields Reference EventLogFile

Field Label API Field Name Type Length Precision Scale

Recurrence Type RecurrenceType picklist 40

Related To WhatId reference 15

Reminder Date/Time ReminderDateTime datetime

Reminder Set IsReminderSet boolean

Show Time As ShowAs picklist 40

Start StartDateTime datetime

Start Date RecurrenceStartDateTime datetime

Subject Subject combobox 255

System Modstamp SystemModstamp datetime

Time ActivityDateTime datetime

Type Type picklist 40

EventLogFile
This object is available in API versions 29.0 and later.

Fields
Field Label API Field Name Type Length Precision Scale
API Version ApiVersion double 18 1

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Event Log File ID Id id 15

Event Type EventType picklist 255

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Log Date LogDate datetime

Log File LogFile base64

Log File Content Type LogFileContentType string 255

Log File Field Names LogFileFieldNames string 1333

Log File Field Types LogFileFieldTypes string 1333

53
Salesforce Fields Reference ExternalDataSource

Field Label API Field Name Type Length Precision Scale

Log File Length LogFileLength double 18 0

System Modstamp SystemModstamp datetime

ExternalDataSource
Represents an external data source, such as SharePoint®.

Fields
Field Label API Field Name Type Length Precision Scale
API Key ApiKey string 128

Created By CreatedById reference 15

Created Date CreatedDate datetime

Custom Configuration CustomConfiguration textarea 4000

Default External Repository Repository string 255

Deleted IsDeleted boolean

External Data Source MasterLabel string 80

External Data Source ID Id id 15

Identity Type PrincipalType picklist 255

Large Icon LargeIconId reference 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Master Language Language picklist 40

Name DeveloperName string 80

Namespace Prefix NamespacePrefix string 15

Small Icon SmallIconId reference 15

System Modstamp SystemModstamp datetime

Type Type picklist 255

URL Endpoint textarea 1000

54
Salesforce Fields Reference ExternalDataUserAuth

ExternalDataUserAuth
Stores authentication settings for a specific user to access an external system. The external system must be defined in an external data
source or a named credential that’s configured to use per-user authentication.

Fields
Field Label API Field Name Type Length Precision Scale
Authentication Protocol Protocol picklist 255

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

External Data Source ExternalDataSourceId reference 15

External Data User Authentication Id id 15

ID

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Password Password encryptedstring 175

System Modstamp SystemModstamp datetime

User UserId reference 15

Username Username string 255

FeedComment
Represents a comment added to a feed by a user. Represents a comment added to a feed by a user.

Fields
Field Label API Field Name Type Length Precision Scale
Comment Body CommentBody textarea 5000

Comment Type CommentType picklist 40

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Feed Comment ID Id id 15

55
Salesforce Fields Reference FeedItem

Field Label API Field Name Type Length Precision Scale

Feed Item FeedItemId reference 15

Inserted By InsertedById reference 15

Parent ParentId reference 15

Related Record RelatedRecordId reference 15

FeedItem
FeedItem represents an entry in the feed, such as changes in a record feed, including text posts, link posts, and content posts.

Fields
Field Label API Field Name Type Length Precision Scale
Best Comment BestCommentId reference 15

Body Body textarea 5000

Comment Count CommentCount int 9 0

Content Data ContentData base64

Content Description ContentDescription textarea 1000

Content File Name ContentFileName string 255

Content File Type ContentType string 120

Content Size ContentSize int 9 0

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Feed Item ID Id id 15

Feed Item Type Type picklist 40

Has Content HasContent boolean

Has Link HasLink boolean

Inserted By InsertedById reference 15

Last Modified Date LastModifiedDate datetime

Like Count LikeCount int 9 0

Link Url LinkUrl url 1000

Parent ParentId reference 15

56
Salesforce Fields Reference FeedTrackedChange

Field Label API Field Name Type Length Precision Scale

Related Record RelatedRecordId reference 15

System Modstamp SystemModstamp datetime

Title Title string 255

FeedTrackedChange
Represents an individual field change or set of field changes. A FeedTrackedChange is a child object of a record feed, such as AccountFeed

Fields
Field Label API Field Name Type Length Precision Scale
Feed Item FeedItemId reference 15

Feed Tracked Change ID Id id 15

Field FieldName string 120

New Value NewValue anyType 255 18 0

Old Value OldValue anyType 255 18 0

FieldPermissions
Represents the enabled field permissions for the parent PermissionSet.

Fields
Field Label API Field Name Type Length Precision Scale
PermissionsRead boolean

Editable PermissionsEdit boolean

Entity SobjectType picklist 40

Field Permissions ID Id id 15

Parent Entity ParentId reference 15

Standard Field Name or Custom Field picklist 40

Field

System Modstamp SystemModstamp datetime

57
Salesforce Fields Reference Folder

Folder
Represents a repository for a Document, EmailTemplate, Report, or Dashboard. Only one type of item can be contained in a folder.

Fields
Field Label API Field Name Type Length Precision Scale
Access Type AccessType picklist 40

Created By CreatedById reference 15

Created Date CreatedDate datetime

Folder ID Id id 15

Folder Unique Name DeveloperName string 80

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Name Name string 40

Namespace Prefix NamespacePrefix string 15

Read Only IsReadonly boolean

System Modstamp SystemModstamp datetime

Type Type picklist 40

GoogleDoc
Represents a link to a Google Document.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Division Division picklist 15

Google Doc Id Id id 15

Google Doc Name Name string 80

Google Doc Owner OwnerId reference 15

58
Salesforce Fields Reference Group

Field Label API Field Name Type Length Precision Scale

Google Doc URL Url string 255

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Parent ParentId reference 15

System Modstamp SystemModstamp datetime

Group
Groups are sets of users. They can contain individual users, other groups, the users in a particular role or territory, or the users in a particular
role or territory plus all of the users below that role or territory in the hierarchy.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Developer Name DeveloperName string 80

Email Email email 255

Group ID Id id 15

Include Bosses DoesIncludeBosses boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Name Name string 40

Owner Name OwnerId reference 15

Related RelatedId reference 15

Send Email to Members DoesSendEmailToMembers boolean

System Modstamp SystemModstamp datetime

Type Type picklist 40

Idea
Represents an idea on which users are allowed to comment and vote, for example, a suggestion for an enhancement to an existing
product or process.

59
Salesforce Fields Reference Idea

Fields
Field Label API Field Name Type Length Precision Scale
Categories Categories multipicklist 765 7

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Idea Body Body textarea 32000

Idea ID Id id 15

Is Merged IsMerged boolean

IsHtml IsHtml boolean

Last Idea Comment LastCommentId reference 15

Last Idea Comment Date LastCommentDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Name of Creator CreatorName string 121

Number of Comments NumComments int 9 0

Parent Idea ParentIdeaId reference 15

Record Type RecordTypeId reference

Status Status picklist 40

System Modstamp SystemModstamp datetime

Title Title string 255

Url of Creator's Profile Photo CreatorFullPhotoUrl string 255

Url of Creator's Thumbnail Photo CreatorSmallPhotoUrl string 255

Vote Score VoteScore double 18 4

Vote Total VoteTotal double 18 0

Zone CommunityId reference 15

60
Salesforce Fields Reference Lead

Lead
Represents a prospect or potential Opportunity.

Fields
Field Label API Field Name Type Length Precision Scale
Address Street textarea 255

Address City string 40

Address State string 80

Address PostalCode string 20

Address Country string 80

Annual Revenue AnnualRevenue currency 18 0

Company Company string 255

Converted IsConverted boolean

Converted Account ConvertedAccountId reference 15

Converted Contact ConvertedContactId reference 15

Converted Date ConvertedDate date

Converted Opportunity ConvertedOpportunityId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Data.com Key Jigsaw string 20

Deleted IsDeleted boolean

Description Description textarea 32000

Do Not Call DoNotCall boolean

Email Email email 80

Email Bounced Date EmailBouncedDate datetime

Email Bounced Reason EmailBouncedReason string 255

Email Opt Out HasOptedOutOfEmail boolean

Fax Fax phone 40

Fax Opt Out HasOptedOutOfFax boolean

Industry Industry picklist 40

Jigsaw Contact Id JigsawContactId string 20

61
Salesforce Fields Reference ListView

Field Label API Field Name Type Length Precision Scale

Last Activity LastActivityDate date

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Transfer Date LastTransferDate date

Last Viewed Date LastViewedDate datetime

Lead MasterRecordId reference 15

Lead ID Id id 15

Lead Owner OwnerId reference 15

Lead Source LeadSource picklist 40

Lead Status Status picklist 40

Mobile MobilePhone phone 40

Name Salutation picklist 40

Name FirstName string 40

Name LastName string 80

No. of Employees NumberOfEmployees int 8 0

Phone Phone phone 40

Photo URL PhotoUrl url 255

Rating Rating picklist 40

System Modstamp SystemModstamp datetime

Title Title string 128

Unread By Owner IsUnreadByOwner boolean

Website Website url 255

ListView
This object is available in API version 32.0 and later.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

62
Salesforce Fields Reference ListViewChart

Field Label API Field Name Type Length Precision Scale

Created Date CreatedDate datetime

Custom Object Definition SobjectType picklist 40

Is SOQL Compatible IsSoqlCompatible boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

List View ID Id id 15

Namespace Prefix NamespacePrefix string 15

System Modstamp SystemModstamp datetime

View Name Name string 40

View Unique Name DeveloperName string 80

ListViewChart
This object is available in API version 33.0 and later.

Fields
Field Label API Field Name Type Length Precision Scale
API Name DeveloperName string 80

Aggregate Field AggregateField picklist 255

Aggregate Type AggregateType picklist 255

Chart Type ChartType picklist 255

Created By CreatedById reference 15

Created Date CreatedDate datetime

Custom Object Definition SobjectType picklist 40

Deleted IsDeleted boolean

Grouping Field GroupingField picklist 255

Label MasterLabel string 80

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

63
Salesforce Fields Reference LoginHistory

Field Label API Field Name Type Length Precision Scale

List View Chart ID Id id 15

Master Language Language picklist 40

Owner OwnerId reference 15

System Modstamp SystemModstamp datetime

LoginHistory
Represents the login history for all successful and failed login attempts for organizations and enabled portals.

Fields
Field Label API Field Name Type Length Precision Scale
API Type ApiType string 64

API Version ApiVersion string 32

Application Application string 64

Browser Browser string 64

Client Version ClientVersion string 64

Login History Id Id id 15

Login Time LoginTime datetime

Login Type LoginType picklist 1

Login URL LoginUrl string 255

Platform Platform string 64

Source IP SourceIp string

Status Status string 128

UserId UserId reference 15

LoginIp
Represents a validated IP address.

64
Salesforce Fields Reference LookedUpFromActivity

Fields
Field Label API Field Name Type Length Precision Scale
Challenge Method ChallengeMethod picklist 40

Challenge SentDate ChallengeSentDate datetime

Created Date CreatedDate datetime

IsAuthenticated IsAuthenticated boolean

Login IP ID Id id 15

Source IP SourceIp string

User UsersId reference 15

LookedUpFromActivity
This read-only object is displayed as a related list on an activity record (an event or a task); the list contains records that have custom
lookup relationships from the activity to another object. This object is not queryable.

Fields
Field Label API Field Name Type Length Precision Scale
Account AccountId reference 15

Activity ID Id id 15

All-Day Event IsAllDayEvent boolean

Assigned To OwnerId reference 15

Call Duration CallDurationInSeconds int 8 0

Call Object Identifier CallObject string 255

Call Result CallDisposition string 255

Call Type CallType picklist 40

Closed IsClosed boolean

Comments Description textarea 32000

Created By CreatedById reference 15

Created Date CreatedDate datetime

Date ActivityDate date

Deleted IsDeleted boolean

65
Salesforce Fields Reference MailmergeTemplate

Field Label API Field Name Type Length Precision Scale

Duration DurationInMinutes int 9 0

End EndDateTime datetime

High Priority IsHighPriority boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Location Location string 80

Name WhoId reference 15

Priority Priority picklist 40

Public IsVisibleInSelfService boolean

Related To WhatId reference 15

Reminder Date/Time ReminderDateTime datetime

Reminder Set IsReminderSet boolean

Start StartDateTime datetime

Status Status picklist 40

Subject Subject combobox 80

System Modstamp SystemModstamp datetime

Task IsTask boolean

Type ActivityType picklist 40

MailmergeTemplate
Represents a mail merge template (a Microsoft Word document) used for performing mail merges for your organization.

Fields
Field Label API Field Name Type Length Precision Scale
Body Body base64

Body Length BodyLength int 8 0

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description string 255

66
Salesforce Fields Reference MilestoneType

Field Label API Field Name Type Length Precision Scale

Document Type Category picklist 40

File Filename string 255

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Used Date LastUsedDate datetime

Mail Merge Template ID Id id 15

Name Name string 80

System Modstamp SystemModstamp datetime

MilestoneType
Represents a milestone (required step in a customer support process).

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Description Description textarea 255

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Milestone Type ID Id id 15

Name Name string 80

Recurrence Type RecurrenceType picklist 40

System Modstamp SystemModstamp datetime

NamedCredential
Represents a named credential, which specifies the URL of a callout endpoint and its required authentication parameters in one definition.
A named credential can be specified as an endpoint to simplify the setup of authenticated callouts.

67
Salesforce Fields Reference Note

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Identity Type PrincipalType picklist 255

Label MasterLabel string 80

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Master Language Language picklist 40

Name DeveloperName string 80

Named Credential ID Id id 15

Namespace Prefix NamespacePrefix string 15

System Modstamp SystemModstamp datetime

URL Endpoint textarea 1000

Note
Represents a note, which is text associated with a custom object or a standard object, such as a Contact, Contract, or Opportunity.

Fields
Field Label API Field Name Type Length Precision Scale
Body Body textarea 32000

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Note Id Id id 15

Note Owner OwnerId reference 15

Parent ParentId reference 15

68
Salesforce Fields Reference NoteAndAttachment

Field Label API Field Name Type Length Precision Scale

Private IsPrivate boolean

System Modstamp SystemModstamp datetime

Title Title string 80

NoteAndAttachment
This read-only object contains all notes and attachments associated with an object.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Is Note IsNote boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Note or Attachment Id Id id 15

Owner Name OwnerId reference 15

Parent ParentId reference 15

Private IsPrivate boolean

System Modstamp SystemModstamp datetime

Title Title string 80

OauthToken
A connected app integrates an application with Salesforce using APIs. Connected apps use standard SAML and OAuth protocols to
authenticate, provide Single Sign-On, and provide tokens for use with Salesforce APIs. In addition to standard OAuth capabilities,
connected apps allow administrators to set various security policies and have explicit control over who may use the corresponding
applications.

69
Salesforce Fields Reference ObjectPermissions

Fields
Field Label API Field Name Type Length Precision Scale
Access Token AccessToken string 255

AppMenuItem AppMenuItemId reference 15

Application Name AppName string 255

Created Date CreatedDate datetime

Delete Token DeleteToken string 255

Last Used Date LastUsedDate datetime

Oauth Token ID Id id 15

Request Token RequestToken string 255

Use Count UseCount int 9 0

User UserId reference 15

ObjectPermissions
Represents the enabled object permissions for the parent PermissionSet.

Fields
Field Label API Field Name Type Length Precision Scale
Permissions int 9 0

Created By CreatedById reference 15

Created Date CreatedDate datetime

Entity Name SobjectType picklist 40

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

ObjectPermissions ID Id id 15

Parent Entity ParentId reference 15

System Modstamp SystemModstamp datetime

70
Salesforce Fields Reference OpenActivity

OpenActivity
This read-only object is displayed in a related list of open activities—future events and open tasks—related to an object. It includes
activities for all contacts related to the object. OpenActivity fields for phone calls are only available if your organization uses Salesforce
CRM Call Center.

Fields
Field Label API Field Name Type Length Precision Scale
Account AccountId reference 15

Activity ID Id id 15

All-Day Event IsAllDayEvent boolean

Assigned To OwnerId reference 15

Call Duration CallDurationInSeconds int 8 0

Call Object Identifier CallObject string 255

Call Result CallDisposition string 255

Call Type CallType picklist 40

Closed IsClosed boolean

Comments Description textarea 32000

Created By CreatedById reference 15

Created Date CreatedDate datetime

Date ActivityDate date

Deleted IsDeleted boolean

Duration DurationInMinutes int 9 0

End EndDateTime datetime

High Priority IsHighPriority boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Location Location string 80

Name WhoId reference 15

Priority Priority picklist 40

Public IsVisibleInSelfService boolean

Related To WhatId reference 15

71
Salesforce Fields Reference Opportunity

Field Label API Field Name Type Length Precision Scale

Reminder Date/Time ReminderDateTime datetime

Reminder Set IsReminderSet boolean

Start StartDateTime datetime

Status Status picklist 40

Subject Subject combobox 80

System Modstamp SystemModstamp datetime

Task IsTask boolean

Type ActivityType picklist 40

Opportunity
Represents an opportunity, which is a sale or pending deal.

Fields
Field Label API Field Name Type Length Precision Scale
Account Name AccountId reference 15

Amount Amount currency 18 2

Close Date CloseDate date

Closed IsClosed boolean

Contract ContractId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description textarea 32000

Expected Revenue ExpectedRevenue currency 18 2

Fiscal Period FiscalYear int 8 0

Fiscal Period FiscalQuarter int 8 0

Forecast Category ForecastCategory picklist 40

Forecast Category ForecastCategoryName picklist 40

Has Line Item HasOpportunityLineItem boolean

Last Activity LastActivityDate date

72
Salesforce Fields Reference OpportunityCompetitor

Field Label API Field Name Type Length Precision Scale

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Lead Source LeadSource picklist 40

Next Step NextStep string 255

Opportunity ID Id id 15

Opportunity Name Name string 120

Opportunity Owner OwnerId reference 15

Price Book Pricebook2Id reference 15

Primary Campaign Source CampaignId reference 15

Private IsPrivate boolean

Probability (%) Probability percent 3 0

Quantity TotalOpportunityQuantity double 18 2

Stage StageName picklist 40

System Modstamp SystemModstamp datetime

Type Type picklist 40

Won IsWon boolean

OpportunityCompetitor
Represents a competitor on an Opportunity.

Fields
Field Label API Field Name Type Length Precision Scale
Competitor Name CompetitorName combobox 40

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

73
Salesforce Fields Reference OpportunityContactRole

Field Label API Field Name Type Length Precision Scale

Opportunity OpportunityId reference 15

Opportunity: Competitor ID Id id 15

Strengths Strengths string 1000

System Modstamp SystemModstamp datetime

Weaknesses Weaknesses string 1000

OpportunityContactRole
Represents the role that a Contact plays on an Opportunity.

Fields
Field Label API Field Name Type Length Precision Scale
Contact ContactId reference 15

Contact Role ID Id id 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Opportunity OpportunityId reference 15

Primary IsPrimary boolean

Role Role picklist 40

System Modstamp SystemModstamp datetime

OpportunityHistory
Represents the stage history of an Opportunity.

Fields
Field Label API Field Name Type Length Precision Scale
Amount Amount currency 18 2

74
Salesforce Fields Reference OpportunityLineItem

Field Label API Field Name Type Length Precision Scale

Close Date CloseDate date

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Expected Revenue ExpectedRevenue currency 18 2

Opportunity OpportunityId reference 15

Opportunity History ID Id id 15

Probability Probability percent 3 0

Stage Name StageName picklist 40

System Modstamp SystemModstamp datetime

To ForecastCategory ForecastCategory picklist 40

OpportunityLineItem
Represents an opportunity line item, which is a member of the list of Product2 products associated with an Opportunity.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Date ServiceDate date

Deleted IsDeleted boolean

Discount Discount percent 5 2

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Line Description Description string 255

Line Item ID Id id 15

List Price ListPrice currency 18 2

Opportunity OpportunityId reference 15

Opportunity Product Name Name string 376

Price Book Entry PricebookEntryId reference 15

75
Salesforce Fields Reference OpportunityLineItemSchedule

Field Label API Field Name Type Length Precision Scale

Product Product2Id reference 15

Product Code ProductCode string 255

Quantity Quantity double 12 2

Sales Price UnitPrice currency 18 2

Sort Order SortOrder int 9 0

Subtotal Subtotal currency 18 2

System Modstamp SystemModstamp datetime

Total Price TotalPrice currency 18 2

OpportunityLineItemSchedule
Represents information about the quantity, revenue distribution, and delivery dates for a particular OpportunityLineItem.

Fields
Field Label API Field Name Type Length Precision Scale
Comments Description string 80

Created By CreatedById reference 15

Created Date CreatedDate datetime

Currency ISO Code CurrencyIsoCode picklist 3

Deleted IsDeleted boolean

Division Division picklist 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Line Item OpportunityLineItemId reference 15

Quantity Quantity double 18 2

Revenue Revenue currency 18 2

Schedule Date ScheduleDate date

Schedule ID Id id 15

System Modstamp SystemModstamp datetime

Type Type picklist 40

76
Salesforce Fields Reference OpportunityPartner

OpportunityPartner
This read-only object represents a partner relationship between an Account and an Opportunity. This object is automatically created
when a Partner object is created for a partner relationship between an account and an opportunity.

Fields
Field Label API Field Name Type Length Precision Scale
Account To AccountToId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Opportunity OpportunityId reference 15

Opportunity Partner ID Id id 15

Primary IsPrimary boolean

Reverse Partner ReversePartnerId reference 15

Role Role picklist 40

System Modstamp SystemModstamp datetime

OpportunitySplit
OpportunitySplit credits one or more opportunity team members with a portion of the opportunity amount.

Fields
Field Label API Field Name Type Length Precision Scale
Amount SplitAmount currency 18 2

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

77
Salesforce Fields Reference OpportunitySplitType

Field Label API Field Name Type Length Precision Scale

Name Split string 255

Note SplitNote string 255

Opportunity Name OpportunityId reference 15

Opportunity Split ID Id id 15

Opportunity Split Type SplitTypeId reference 15

Percent (%) SplitPercentage percent 5 2

System Modstamp SystemModstamp datetime

Team Member SplitOwnerId reference 15

OpportunitySplitType
OpportunitySplitType provides unique labels and behavior for each split type.

Fields
Field Label API Field Name Type Length Precision Scale
100% Validated IsTotalValidated boolean

Active IsActive boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Data Status SplitDataStatus picklist 255

Deleted IsDeleted boolean

Description Description textarea 255

Developer Name DeveloperName string 80

Entity SplitEntity picklist 255

Field SplitField picklist 255

Label MasterLabel string 80

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Master Language Language picklist 40

Namespace Prefix NamespacePrefix string 15

Opportunity Split Type ID Id id 15

78
Salesforce Fields Reference OpportunityStage

Field Label API Field Name Type Length Precision Scale

System Modstamp SystemModstamp datetime

OpportunityStage
Represents the stage of an Opportunity in the sales pipeline, such as New Lead, Negotiating, Pending, Closed, and so on.

Fields
Field Label API Field Name Type Length Precision Scale
Closed IsClosed boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Description Description string 255

Forecast Category ForecastCategory picklist 40

Forecast Category Name ForecastCategoryName picklist 40

Is Active IsActive boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Master Label MasterLabel string 255

Opportunity Stage ID Id id 15

Probability (%) DefaultProbability percent 3 0

Sort Order SortOrder int 9 0

System Modstamp SystemModstamp datetime

Won IsWon boolean

OpportunityTeamMember
Represents a User on the opportunity team of an Opportunity.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

79
Salesforce Fields Reference OwnedContentDocument

Field Label API Field Name Type Length Precision Scale

Created Date CreatedDate datetime

Currency ISO Code CurrencyIsoCode picklist 3

Deleted IsDeleted boolean

Division Division picklist 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Opportunity OpportunityId reference 15

Opportunity Access OpportunityAccessLevel picklist 40

Opportunity Team Member ID Id id 15

Opportunity Team Member Name Name string 361

System Modstamp SystemModstamp datetime

Team Role TeamMemberRole picklist 40

User UserId reference 15

OwnedContentDocument
Represents a file owned by a user.

Fields
Field Label API Field Name Type Length Precision Scale
Content Modified By LastModifiedById reference 15

Content Modified Date LastModifiedDate datetime

Content Size ContentSize int 9 0

Content URL ContentUrl url 255

Created CreatedDate datetime

Created By OwnerId reference 15

Created by CreatedById reference 15

Deleted IsDeleted boolean

Document ContentDocumentId reference 15

External Data Source ExternalDataSourceName string 80

File Extension FileExtension string 40

80
Salesforce Fields Reference Partner

Field Label API Field Name Type Length Precision Scale

File Type FileType string 20

Title Title string 255

User Owned Content Document Id Id id 15

Partner
Represents a partner relationship between two Account records or between an Opportunity and an Account.

Fields
Field Label API Field Name Type Length Precision Scale
Account From AccountFromId reference 15

Account To AccountToId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Opportunity OpportunityId reference 15

Partner ID Id id 15

Primary IsPrimary boolean

Reverse Partner ReversePartnerId reference 15

Role Role picklist 40

System Modstamp SystemModstamp datetime

PartnerNetworkConnection
Represents a Salesforce to Salesforce connection between Salesforce organizations.

Fields
Field Label API Field Name Type Length Precision Scale
Account AccountId reference 15

81
Salesforce Fields Reference PartnerNetworkRecordConnection

Field Label API Field Name Type Length Precision Scale

Connection Name ConnectionName string 295

Connection Owner PrimaryContactId reference 15

Connection Status ConnectionStatus picklist 40

Contact ContactId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Decision Date ResponseDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Partner Network Connection ID Id id 15

PartnerNetworkRecordConnection
Represents a record shared between Salesforce organizations using Salesforce to Salesforce.

Fields
Field Label API Field Name Type Length Precision Scale
Connection ConnectionId reference 15

Local Record LocalRecordId reference 15

Parent Record ParentRecordId reference 15

Partner Network Record Connection Id id 15

ID

Partner Record PartnerRecordId reference 15

Related Records RelatedRecords string 1000

Send Closed Tasks SendClosedTasks boolean

Send Emails SendEmails boolean

Send Open Tasks SendOpenTasks boolean

Start Date StartDate datetime

Status Status picklist 40

Stop Date EndDate datetime

82
Salesforce Fields Reference PartnerRole

PartnerRole
Represents a role for an account Partner, such as consultant, supplier, and so on.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Master Label MasterLabel string 255

Partner Role Value ID Id id 15

Reverse Role ReverseRole picklist 40

Sort Order SortOrder int 9 0

System Modstamp SystemModstamp datetime

Period
Represents a fiscal period defined in FiscalYearSettings.

Fields
Field Label API Field Name Type Length Precision Scale
End Date EndDate date

Fiscal Year Settings FiscalYearSettingsId reference 15

Is Forecast Period IsForecastPeriod boolean

Number Number int 9 0

Period ID Id id 15

Period Name PeriodLabel picklist 40

Quarter Name QuarterLabel picklist 40

Start Date StartDate date

System Modstamp SystemModstamp datetime

Type Type picklist 40

83
Salesforce Fields Reference PermissionSet

PermissionSet
Represents a set of permissions that’s used to grant additional access to one or more users without changing their profile or reassigning
profiles.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Description Description string 255

Is Owned By Profile IsOwnedByProfile boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Namespace Prefix NamespacePrefix string 15

Permission Set Label Label string 80

Permission Set Name Name string 80

PermissionSet ID Id id 15

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

Permissions Permissions int 9 0

84
Salesforce Fields Reference PermissionSetAssignment

Field Label API Field Name Type Length Precision Scale

Profile ProfileId reference 15

System Modstamp SystemModstamp datetime

User License UserLicenseId reference 15

PermissionSetAssignment
Represents the association between a User and a PermissionSet.

Fields
Field Label API Field Name Type Length Precision Scale
Date Assigned SystemModstamp datetime

Permission Set PermissionSetId reference 15

PermissionSetAssignment ID Id id 15

User AssigneeId reference 15

PermissionSetLicense
Represents a license that’s used to enable one or more users to receive a specified permission without changing their profile or reassigning
profiles. You can use permission set licenses to grant access, but not to deny access.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Developer Name DeveloperName string 80

Expiration Date ExpirationDate date

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Master Language Language picklist 40

Permission Set License ID Id id 15

85
Salesforce Fields Reference PermissionSetLicenseAssign

Field Label API Field Name Type Length Precision Scale

Permission Set License Key PermissionSetLicenseKey string 81

Permission Set License Label MasterLabel string 80

Status Status picklist 255

System Modstamp SystemModstamp datetime

Total Licenses TotalLicenses int 9 0

Used Licenses UsedLicenses int 9 0

PermissionSetLicenseAssign
Represents the association between a User and a PermissionSetLicense.

Fields
Field Label API Field Name Type Length Precision Scale
Assignee AssigneeId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Date Assigned SystemModstamp datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Permission Set License PermissionSetLicenseId reference 15

Permission Set License Assignment Id id 15

ID

PlatformAction
PlatformAction is a virtual read-only object. It enables you to query for actions displayed in the UI—such as standard and custom buttons,
quick actions, and productivity actions—given a user, a context, device format, and a record ID.

86
Salesforce Fields Reference Pricebook2

Fields
Field Label API Field Name Type Length Precision Scale
API Name ApiName string 255

Action List Context ActionListContext picklist 255

Action Target Type ActionTargetType picklist 255

Action Target URL ActionTargetUrl url 255

Category Category picklist 255

Confirmation Message ConfirmationMessage string 255

Device Format DeviceFormat picklist 255

Group ID GroupId reference 15

Icon Content Type IconContentType string 255

Icon Height IconHeight int 9 0

Icon URL IconUrl url 255

Icon Width IconWidth int 9 0

Invocation Status InvocationStatus picklist 255

Invoked By InvokedByUserId reference 15

Is Group Default IsGroupDefault boolean

Label Label string 255

Last Modified Date LastModifiedDate datetime

Not used ID Id id 15

Platform Action ID ExternalId string 255

Primary Color PrimaryColor string 255

Related Source Entity RelatedSourceEntity string 255

Source Entity SourceEntity string 255

Subtype Subtype string 255

Type Type picklist 255

Pricebook2
Represents a price book that contains the list of products that your organization sells.

87
Salesforce Fields Reference PricebookEntry

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description string 255

Is Standard Price Book IsStandard boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Price Book ID Id id 15

Price Book Name Name string 255

System Modstamp SystemModstamp datetime

PricebookEntry
Represents a product entry (an association between a Pricebook2 and Product2) in a price book.

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

List Price UnitPrice currency 18 2

Price Book Pricebook2Id reference 15

Price Book Entry ID Id id 15

88
Salesforce Fields Reference Product2

Field Label API Field Name Type Length Precision Scale

Product Product2Id reference 15

Product Code ProductCode string 255

Product Name Name string 255

System Modstamp SystemModstamp datetime

Use Standard Price UseStandardPrice boolean

Product2
Represents a product that your organization sells.

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Product Code ProductCode string 255

Product Description Description textarea 4000

Product Family Family picklist 40

Product ID Id id 15

Product Name Name string 255

System Modstamp SystemModstamp datetime

ProductEntitlementTemplate
Represents predefined terms of customer support (Entitlement) that users can add to products (Product2).

89
Salesforce Fields Reference Question

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Entitlement Template EntitlementTemplateId reference 15

Product Product2Id reference 15

Product Entitlement Template ID Id id 15

System Modstamp SystemModstamp datetime

Question
Represents a question in a community that users can view and reply to.

Fields
Field Label API Field Name Type Length Precision Scale
Best Reply BestReplyId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Currency ISO Code CurrencyIsoCode picklist 3

Deleted IsDeleted boolean

Has Single Field For Content HasSingleFieldForContent boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Reply LastReplyId reference 15

Last Reply Date LastReplyDate datetime

Last Viewed Date LastViewedDate datetime

Number of Replies NumReplies int 9 0

Question Body Body textarea 32000

Question ID Id id 15

Question Title Title string 255

90
Salesforce Fields Reference Quote

Field Label API Field Name Type Length Precision Scale

Record Type RecordTypeId reference

System Modstamp SystemModstamp datetime

Up Votes UpVotes int 9 0

Vote Score VoteScore double 18 4

Zone CommunityId reference 15

Quote
The Quote object represents a quote, which is a record showing proposed prices for products and services.

Fields
Field Label API Field Name Type Length Precision Scale
Account Name AccountId reference 15

Additional To AdditionalStreet textarea 255

Additional To AdditionalCity string 40

Additional To AdditionalState string 80

Additional To AdditionalPostalCode string 20

Additional To AdditionalCountry string 80

Additional To Name AdditionalName string 255

Bill To BillingStreet textarea 255

Bill To BillingCity string 40

Bill To BillingState string 80

Bill To BillingPostalCode string 20

Bill To BillingCountry string 80

Bill To Name BillingName string 255

Contact Name ContactId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description textarea 32000

Discount Discount percent 5 2

91
Salesforce Fields Reference Quote

Field Label API Field Name Type Length Precision Scale

Email Email email 80

Expiration Date ExpirationDate date

Fax Fax phone 40

Grand Total GrandTotal currency 18 2

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Line Items LineItemCount int 9 0

Opportunity Name OpportunityId reference 15

Phone Phone phone 40

Pricebook Pricebook2Id reference 15

Quote ID Id id 15

Quote Name Name string 255

Quote Number QuoteNumber string 30

Quote To QuoteToStreet textarea 255

Quote To QuoteToCity string 40

Quote To QuoteToState string 80

Quote To QuoteToPostalCode string 20

Quote To QuoteToCountry string 80

Quote To Name QuoteToName string 255

Ship To ShippingStreet textarea 255

Ship To ShippingCity string 40

Ship To ShippingState string 80

Ship To ShippingPostalCode string 20

Ship To ShippingCountry string 80

Ship To Name ShippingName string 255

Shipping and Handling ShippingHandling currency 18 2

Status Status picklist 40

Subtotal Subtotal currency 18 2

92
Salesforce Fields Reference RecentlyViewed

Field Label API Field Name Type Length Precision Scale

Syncing IsSyncing boolean

System Modstamp SystemModstamp datetime

Tax Tax currency 18 2

Total Price TotalPrice currency 18 2

RecentlyViewed
Represents records that the current user has recently viewed or referenced (by viewing a related record).

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

Alias Alias string 8

E-mail Email email 80

Language Language picklist 40

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Phone Phone phone 40

Profile ProfileId reference 15

Recently Viewed ID Id id 15

Record Type ID RecordTypeId reference 15

Role UserRoleId reference 15

Title Title string 80

Type Type picklist 40

Reply
Represents a reply that a user has submitted to a question in an answers community.

93
Salesforce Fields Reference Report

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Currency ISO Code CurrencyIsoCode picklist 3

Deleted IsDeleted boolean

Down Votes DownVotes int 9 0

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Name Name string 255

Question QuestionId reference 15

Reply Body Body textarea 32000

Reply ID Id id 15

System Modstamp SystemModstamp datetime

Up Votes UpVotes int 9 0

Vote Total VoteTotal double 18 0

Zone CommunityId reference 15

Report
Represents a report, a set of data that meets certain criteria, displayed in an organized way. Access is read-only.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description string 255

Folder OwnerId reference 15

Format Format picklist 40

Last Modified By LastModifiedById reference 15

94
Salesforce Fields Reference SelfServiceUser

Field Label API Field Name Type Length Precision Scale

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Run LastRunDate datetime

Last Viewed Date LastViewedDate datetime

Namespace Prefix NamespacePrefix string 15

Report ID Id id 15

Report Name Name string 40

Report Unique Name DeveloperName string 80

System Modstamp SystemModstamp datetime

SelfServiceUser
Represents a Self-Service user.

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

Contact ContactId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Email Email email 80

LanguageLocaleKey LanguageLocaleKey picklist 40

Last Login LastLoginDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

LocaleSidKey LocaleSidKey picklist 40

Super User SuperUser boolean

System Modstamp SystemModstamp datetime

TimeZoneSidKey TimeZoneSidKey picklist 40

User ID Id id 15

Username Username string 80

95
Salesforce Fields Reference ServiceContract

ServiceContract
Represents a customer support contract (business agreement).

Fields
Field Label API Field Name Type Length Precision Scale
Account Name AccountId reference 15

Activation Date ActivationDate datetime

Approval Status ApprovalStatus picklist 40

Billing Address BillingStreet textarea 255

Billing Address BillingCity string 40

Billing Address BillingState string 80

Billing Address BillingPostalCode string 20

Billing Address BillingCountry string 80

Contact Name ContactId reference 15

Contract Name Name string 255

Contract Number ContractNumber string 30

Created By CreatedById reference 15

Created Date CreatedDate datetime

Currency CurrencyIsoCode picklist 3

Deleted IsDeleted boolean

Description Description textarea 32000

Discount Discount percent 5 2

End Date EndDate date

Grand Total GrandTotal currency 18 2

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Line Items LineItemCount int 9 0

Price Book Pricebook2Id reference 15

Service Contract ID Id id 15

96
Salesforce Fields Reference SetupEntityAccess

Field Label API Field Name Type Length Precision Scale

Service Contract Owner OwnerId reference 15

Shipping Address ShippingStreet textarea 255

Shipping Address ShippingCity string 40

Shipping Address ShippingState string 80

Shipping Address ShippingPostalCode string 20

Shipping Address ShippingCountry string 80

Shipping and Handling ShippingHandling currency 18 2

Special Terms SpecialTerms textarea 32000

Start Date StartDate date

Status Status picklist 255

Subtotal Subtotal currency 18 2

System Modstamp SystemModstamp datetime

Tax Tax currency 18 2

Term (months) Term int 9 0

Total Price TotalPrice currency 18 2

SetupEntityAccess
Represents the enabled setup entity access settings (such as for Apex classes) for the parent PermissionSet.

Fields
Field Label API Field Name Type Length Precision Scale
Parent Entity ParentId reference 15

Setup Entity SetupEntityId reference 15

Setup Entity Type SetupEntityType picklist 40

SetupEntityAccess ID Id id 15

System Modstamp SystemModstamp datetime

Site
Represents a public website that is integrated with an Organization.

97
Salesforce Fields Reference SlaProcess

Fields
Field Label API Field Name Type Length Precision Scale
Analytics Tracking Code AnalyticsTrackingCode string 40

Clickjack Protection Level ClickjackProtectionLevel picklist 40

Created By CreatedById reference 15

Created Date CreatedDate datetime

Daily Bandwidth Limit (MB) DailyBandwidthLimit int 9 0

Daily Bandwidth Used DailyBandwidthUsed int 9 0

Daily Request Time Limit (min) DailyRequestTimeLimit int 9 0

Daily Request Time Used DailyRequestTimeUsed int 9 0

Default Web Address UrlPathPrefix string 40

Guest User GuestUserId reference 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Monthly Page Views Allowed MonthlyPageViewsEntitlement int 9 0

Options Options int 9 0

Site Contact AdminId reference 15

Site Description Description textarea 1000

Site ID Id id 15

Site Label MasterLabel string 255

Site Name Name string 80

Site Status Status picklist 40

Site Subdomain Prefix Subdomain string 80

Site Type SiteType picklist 40

System Modstamp SystemModstamp datetime

SlaProcess
Represents an entitlement process associated with an Entitlement.

98
Salesforce Fields Reference Solution

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

Business Hours BusinessHoursId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Description Description textarea 255

Entitlement Process ID Id id 15

Entitlement Process Name Name string 120

Entry Date Field StartDateField picklist 40

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Name NameNorm string 240

System Modstamp SystemModstamp datetime

Solution
Represents a detailed description of a customer issue and the resolution of that issue.

Fields
Field Label API Field Name Type Length Precision Scale
Author OwnerId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Is Html IsHtml boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

99
Salesforce Fields Reference TagDefinition

Field Label API Field Name Type Length Precision Scale

Num Related Cases TimesUsed int 9 0

Public IsPublished boolean

Reviewed IsReviewed boolean

Solution Details SolutionNote textarea 32000

Solution ID Id id 15

Solution Number SolutionNumber string 30

Solution Title SolutionName string 255

Status Status picklist 40

System Modstamp SystemModstamp datetime

Visible in Public Knowledge Base IsPublishedInPublicKb boolean

TagDefinition
Defines the attributes of child Tag objects.

Fields
Field Label API Field Name Type Length Precision Scale
Deleted IsDeleted boolean

Display Tag Text Name string 765

Last Modified By LastModifiedById reference 15

System Modstamp SystemModstamp datetime

Tag Definition ID Id id 15

Tag Type Type picklist 40

Task
Represents a business activity such as making a phone call or other to-do items. In the user interface, Task and Event records are collectively
referred to as activities.

100
Salesforce Fields Reference Task

Fields
Field Label API Field Name Type Length Precision Scale
Account AccountId reference 15

Activity ID Id id 15

Archived IsArchived boolean

Assigned To OwnerId reference 15

Call Duration CallDurationInSeconds int 8 0

Call Object Identifier CallObject string 255

Call Result CallDisposition string 255

Call Type CallType picklist 40

Closed IsClosed boolean

Comments Description textarea 32000

Create Recurring Series of Tasks IsRecurrence boolean

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Due Date ActivityDate date

End Date RecurrenceEndDateOnly date

High Priority IsHighPriority boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Name WhoId reference 15

Priority Priority picklist 40

Recurrence Activity RecurrenceActivityId reference 15

Recurrence Day of Month RecurrenceDayOfMonth int 9 0

Recurrence Day of Week Mask RecurrenceDayOfWeekMask int 9 0

Recurrence Instance RecurrenceInstance picklist 40

Recurrence Interval RecurrenceInterval int 9 0

Recurrence Month of Year RecurrenceMonthOfYear picklist 40

Recurrence Time Zone RecurrenceTimeZoneSidKey picklist 40

Recurrence Type RecurrenceType picklist 40

101
Salesforce Fields Reference Territory

Field Label API Field Name Type Length Precision Scale

Related To WhatId reference 15

Reminder Date/Time ReminderDateTime datetime

Reminder Set IsReminderSet boolean

Repeat This Task RecurrenceRegeneratedType picklist 40

Start Date RecurrenceStartDateOnly date

Status Status picklist 40

Subject Subject combobox 255

System Modstamp SystemModstamp datetime

Type Type picklist 40

Territory
Represents a flexible collection of accounts and users where the users have at least read access to the accounts, regardless of who owns
the accounts. Only available if territory management has been enabled for your organization.

Fields
Field Label API Field Name Type Length Precision Scale
Account Access Level AccountAccessLevel picklist 40

Case Access Level CaseAccessLevel picklist 40

Confine Opportunity Assignment RestrictOpportunityTransfer boolean

Contact Access Level ContactAccessLevel picklist 40

Currency CurrencyIsoCode picklist 3

Description Description string 1000

Developer Name DeveloperName string 80

Forecast Manager ForecastUserId reference 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

May Forecast Manager Share MayForecastManagerShare boolean

Opportunity Access Level OpportunityAccessLevel picklist 40

Parent Territory ParentTerritoryId reference 15

System Modstamp SystemModstamp datetime

102
Salesforce Fields Reference Topic

Field Label API Field Name Type Length Precision Scale

Territory ID Id id 15

Territory Name Name string 80

Topic
Represents a topic on a Chatter post or record.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Description Description string 1000

Name Name string 99

System Modstamp SystemModstamp datetime

Talking About TalkingAbout int 9 0

Topic ID Id id 15

TopicAssignment
Represents the assignment of a topic to a specific feed item or record.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Object Type EntityType string 80

Record EntityId reference 15

Record Key Prefix EntityKeyPrefix string 3

System Modstamp SystemModstamp datetime

Topic TopicId reference 15

103
Salesforce Fields Reference TwoFactorInfo

Field Label API Field Name Type Length Precision Scale

Topic Assignment Id Id id 15

TwoFactorInfo
Use this object when customizing two-factor authentication in your organization.

Fields
Field Label API Field Name Type Length Precision Scale
Algorithm Type Type picklist 255

Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Shared key between User and SharedKey string 255

authentication service

System Modstamp SystemModstamp datetime

Two Factor ID Id id 15

User UserId reference 15

User
Represents a user in your organization.

Fields
Field Label API Field Name Type Length Precision Scale
EmailPreferences int 9 0

About Me AboutMe textarea 1000

Account AccountId reference 15

Active IsActive boolean

Address Street textarea 255

104
Salesforce Fields Reference User

Field Label API Field Name Type Length Precision Scale

Address City string 40

Address State string 80

Address PostalCode string 20

Address Country string 80

Admin Info Emails ReceivesAdminInfoEmails boolean

Alias Alias string 8

Allow Forecasting ForecastEnabled boolean

Call Center CallCenterId reference 15

Cell MobilePhone phone 40

Chatter Email Highlights Frequency DigestFrequency picklist 40

Company Name CompanyName string 80

Contact ContactId reference 15

Created By CreatedById reference 15

Created Date CreatedDate datetime

Default Notification Frequency DefaultGroupNotificationFrequency picklist 40

when Joining Groups

Delegated Approver DelegatedApproverId reference 15

Department Department string 80

Division Division string 80

E-mail Email email 128

Email Encoding EmailEncodingKey picklist 40

Email Sender Address SenderEmail email 80

Email Sender Name SenderName string 80

Email Signature Signature string 1333

Employee Number EmployeeNumber string 20

Extension Extension phone 40

Fax Fax phone 40

Info Emails ReceivesInfoEmails boolean

Language LanguageLocaleKey picklist 40

Last Login LastLoginDate datetime

Last Modified By LastModifiedById reference 15

105
Salesforce Fields Reference UserAccountTeamMember

Field Label API Field Name Type Length Precision Scale

Last Modified Date LastModifiedDate datetime

Last Password Change or Reset LastPasswordChangeDate datetime

Last Referenced Date LastReferencedDate datetime

Last Viewed Date LastViewedDate datetime

Locale LocaleSidKey picklist 40

Manager ManagerId reference 15

Nickname CommunityNickname string 40

Offline Edition Trial Expiration Date OfflineTrialExpirationDate datetime

Phone Phone phone 40

Profile ProfileId reference 15

Role UserRoleId reference 15

Sales Anywhere Trial Expiration Date OfflinePdaTrialExpirationDate datetime

Stay-in-Touch Email Note StayInTouchNote string 512

Stay-in-Touch Email Signature StayInTouchSignature string 512

Stay-in-Touch Email Subject StayInTouchSubject string 80

System Modstamp SystemModstamp datetime

Time Zone TimeZoneSidKey picklist 40

Title Title string 80

Url for Thumbnail sized Photo SmallPhotoUrl url 1024

Url for full-sized Photo FullPhotoUrl url 1024

User ID Id id 15

User Photo badge text overlay BadgeText string 80

User Type UserType picklist 40

Username Username string 80

UserAccountTeamMember
Represents a User on the default account team of another User.

106
Salesforce Fields Reference UserLogin

Fields
Field Label API Field Name Type Length Precision Scale
Account Access AccountAccessLevel picklist 40

Case Access CaseAccessLevel picklist 40

Contact Access ContactAccessLevel picklist 40

Created By CreatedById reference 15

Created Date CreatedDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Opportunity Access OpportunityAccessLevel picklist 40

System Modstamp SystemModstamp datetime

Team Role TeamMemberRole picklist 40

User OwnerId reference 15

User UserId reference 15

User Account Team Member ID Id id 15

UserLogin
Represents the settings that affect a user’s ability to log into an organization. To access this object, you need the
UserPermissions.ManageUsers permission. This object is available in API version 29.0 and later.

Fields
Field Label API Field Name Type Length Precision Scale
Is Frozen IsFrozen boolean

Is Password Locked IsPasswordLocked boolean

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

User UserId reference 15

User Login ID Id id 15

107
Salesforce Fields Reference UserRecordAccess

UserRecordAccess
Represents a user’s access to a set of records.

Fields
Field Label API Field Name Type Length Precision Scale
Has All Access HasAllAccess boolean

Has Delete Access HasDeleteAccess boolean

Has Edit Access HasEditAccess boolean

Has Read Access HasReadAccess boolean

Has Transfer Access HasTransferAccess boolean

Maximum Access Level MaxAccessLevel picklist 40

Record RecordId picklist 40

User UserId reference 15

User Record Access ID Id id 15

UserRole
Represents a user role in your organization.

Fields
Field Label API Field Name Type Length Precision Scale
Case Access Level for Account CaseAccessForAccountOwner picklist 40
Owner

Contact Access Level for Account ContactAccessForAccountOwner picklist 40

Owner

Description RollupDescription string 80

Developer Name DeveloperName string 80

Forecast Manager ForecastUserId reference 15

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

May Forecast Manager Share MayForecastManagerShare boolean

Name Name string 80

108
Salesforce Fields Reference UserProfile

Field Label API Field Name Type Length Precision Scale

Opportunity Access Level for OpportunityAccessForAccountOwner picklist 40
Account Owner

Parent Role ParentRoleId reference 15

Partner Account PortalAccountId reference 15

Portal Type PortalType picklist 40

Role ID Id id 15

System Modstamp SystemModstamp datetime

User PortalAccountOwnerId reference 15

UserProfile
Represents a Chatter user profile.

Fields
Field Label API Field Name Type Length Precision Scale
About Me AboutMe textarea 1000

Active IsActive boolean

Address Street textarea 255

Address City string 40

Address State string 80

Address PostalCode string 20

Address Country string 80

Cell MobilePhone phone 40

Company Name CompanyName string 80

E-mail Email email 128

Fax Fax phone 40

Information Currency CurrencyIsoCode picklist 3

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Manager ManagerId reference 15

Phone Phone phone 40

109
Salesforce Fields Reference UserTeamMember

Field Label API Field Name Type Length Precision Scale

System Modstamp SystemModstamp datetime

Title Title string 80

Url for Thumbnail sized Photo SmallPhotoUrl url 1024

Url for full-sized Photo FullPhotoUrl url 1024

User ID Id id 15

User Photo has a badge overlay IsBadged boolean

UserTeamMember
Represents a single User on the default opportunity team of another User.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Opportunity Access OpportunityAccessLevel picklist 40

System Modstamp SystemModstamp datetime

Team Role TeamMemberRole picklist 40

User OwnerId reference 15

User UserId reference 15

User Team Member ID Id id 15

UserTerritory
Represents a User who has been assigned to a Territory.

Fields
Field Label API Field Name Type Length Precision Scale
Active IsActive boolean

110
Salesforce Fields Reference Vote

Field Label API Field Name Type Length Precision Scale

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

System Modstamp SystemModstamp datetime

Territory TerritoryId reference 15

User UserId reference 15

UserTerritory ID Id id 15

Vote
Represents a vote that a user has made on an Idea or a Reply.

Fields
Field Label API Field Name Type Length Precision Scale
Created By CreatedById reference 15

Created Date CreatedDate datetime

Deleted IsDeleted boolean

Parent ParentId reference 15

System Modstamp SystemModstamp datetime

Vote ID Id id 15

Vote Type Type picklist 40

WebLink
Represents a custom link to a URL or Scontrol.

Fields
Field Label API Field Name Type Length Precision Scale
Behavior OpenType picklist 40

Content Source LinkType picklist 40

Created By CreatedById reference 15

Created Date CreatedDate datetime

111
Salesforce Fields Reference WebLink

Field Label API Field Name Type Length Precision Scale

Custom Link ID Id id 15

Custom Object Definition PageOrSobjectType picklist 40

Description Description textarea 1000

Display Type DisplayType picklist 40

Height (in pixels) Height int 9 0

Label MasterLabel string 240

Last Modified By LastModifiedById reference 15

Last Modified Date LastModifiedDate datetime

Link Encoding EncodingKey picklist 40

Name Name string 240

Namespace Prefix NamespacePrefix string 15

Protected Component IsProtected boolean

Require Row Selection RequireRowSelection boolean

Resizeable IsResizable boolean

Scontrol ScontrolId reference 15

Show Address Bar ShowsLocation boolean

Show Menu Bar HasMenubar boolean

Show Scrollbars HasScrollbars boolean

Show Status Bar ShowsStatus boolean

Show Toolbars HasToolbar boolean

System Modstamp SystemModstamp datetime

URL Url textarea 1048576

Width (in pixels) Width int 9 0

Window Position Position picklist 40

112