Fields
Find the unique API accessible name of a field
Fields that can be used with pack formulas from your Salesforce instance
Fields
Object
Label
Name
Data Type
Type
Coda Formula
Search
Object
Details
Field
Name
Data Type
Type
Account
38
Billing Street
BillingStreet
textarea
Standard
Billing City
BillingCity
string
Standard
Billing State/Province
BillingState
string
Standard
Billing Zip/Postal Code
BillingPostalCode
string
Standard
Billing Country
BillingCountry
string
Standard
Billing Latitude
BillingLatitude
double
Standard
Billing Longitude
BillingLongitude
double
Standard
Billing Geocode Accuracy
BillingGeocodeAccuracy
picklist
Standard
Billing Address
BillingAddress
address
Standard
Shipping Street
ShippingStreet
textarea
Standard
Shipping City
ShippingCity
string
Standard
Shipping State/Province
ShippingState
string
Standard
Shipping Zip/Postal Code
ShippingPostalCode
string
Standard
Shipping Country
ShippingCountry
string
Standard
Shipping Latitude
ShippingLatitude
double
Standard
Shipping Longitude
ShippingLongitude
double
Standard
Shipping Geocode Accuracy
ShippingGeocodeAccuracy
picklist
Standard
Shipping Address
ShippingAddress
address
Standard
SIC Code
Sic
string
Standard
Ticker Symbol
TickerSymbol
string
Standard
Jigsaw Company ID
JigsawCompanyId
string
Standard
Account Source
AccountSource
picklist
Standard
SIC Description
SicDesc
string
Standard
Account Number
AccountNumber
string
Standard
Ownership
Ownership
picklist
Standard
Account Site
Site
string
Standard
D-U-N-S Number
DunsNumber
string
Standard
Tradestyle
Tradestyle
string
Standard
NAICS Code
NaicsCode
string
Standard
NAICS Description
NaicsDesc
string
Standard
Year Started
YearStarted
string
Standard
Operating Hour ID
OperatingHoursId
reference
Standard
Customer Priority
CustomerPriority__c
picklist
Custom
SLA
SLA__c
picklist
Custom
Active
Active__c
picklist
Custom
Upsell Opportunity
UpsellOpportunity__c
picklist
Custom
SLA Serial Number
SLASerialNumber__c
string
Custom
SLA Expiration Date
SLAExpirationDate__c
date
Custom
Campaign
17
Start Date
StartDate
date
Standard
End Date
EndDate
date
Standard
Expected Revenue in Campaign
ExpectedRevenue
currency
Standard
Budgeted Cost in Campaign
BudgetedCost
currency
Standard
Actual Cost in Campaign
ActualCost
currency
Standard
Expected Response (%)
ExpectedResponse
percent
Standard
Num Sent in Campaign
NumberSent
double
Standard
Active
IsActive
boolean
Standard
Leads in Campaign
NumberOfLeads
int
Standard
Converted Leads in Campaign
NumberOfConvertedLeads
int
Standard
Contacts in Campaign
NumberOfContacts
int
Standard
Responses in Campaign
NumberOfResponses
int
Standard
Opportunities in Campaign
NumberOfOpportunities
int
Standard
Won Opportunities in Campaign
NumberOfWonOpportunities
int
Standard
Value Opportunities in Campaign
AmountAllOpportunities
currency
Standard
Value Won Opportunities in Campaign
AmountWonOpportunities
currency
Standard
Record Type ID
CampaignMemberRecordTypeId
reference
Standard
Case
26
Case Type
Type
picklist
Standard
Contact ID
ContactId
reference
Standard
Last Viewed Date
LastViewedDate
datetime
Standard
Last Referenced Date
LastReferencedDate
datetime
Standard
Master Record ID
MasterRecordId
reference
Standard
Parent Case ID
ParentId
reference
Standard
Case Number
CaseNumber
string
Standard
Name
SuppliedName
string
Standard
Email Address
SuppliedEmail
email
Standard
Phone
SuppliedPhone
string
Standard
Company
SuppliedCompany
string
Standard
Case Reason
Reason
picklist
Standard
Case Origin
Origin
picklist
Standard
Closed Date
ClosedDate
datetime
Standard
Escalated
IsEscalated
boolean
Standard
Contact Phone
ContactPhone
phone
Standard
Contact Mobile
ContactMobile
phone
Standard
Contact Email
ContactEmail
email
Standard
Contact Fax
ContactFax
phone
Standard
Internal Comments
Comments
textarea
Standard
Asset ID
AssetId
reference
Standard
Source ID
SourceId
reference
Standard
Engineering Req Number
EngineeringReqNumber__c
string
Custom
SLA Violation
SLAViolation__c
picklist
Custom
Product
Product__c
picklist
Custom
Potential Liability
PotentialLiability__c
picklist
Custom
Contact
30
Other Street
OtherStreet
textarea
Standard
Other City
OtherCity
string
Standard
Other State/Province
OtherState
string
Standard
Other Zip/Postal Code
OtherPostalCode
string
Standard
Other Country
OtherCountry
string
Standard
Other Latitude
OtherLatitude
double
Standard
Other Longitude
OtherLongitude
double
Standard
Other Geocode Accuracy
OtherGeocodeAccuracy
picklist
Standard
Other Address
OtherAddress
address
Standard
Mailing Street
MailingStreet
textarea
Standard
Mailing City
MailingCity
string
Standard
Mailing State/Province
MailingState
string
Standard
Mailing Zip/Postal Code
MailingPostalCode
string
Standard
Mailing Country
MailingCountry
string
Standard
Mailing Latitude
MailingLatitude
double
Standard
Mailing Longitude
MailingLongitude
double
Standard
Mailing Geocode Accuracy
MailingGeocodeAccuracy
picklist
Standard
Mailing Address
MailingAddress
address
Standard
Home Phone
HomePhone
phone
Standard
Other Phone
OtherPhone
phone
Standard
Asst. Phone
AssistantPhone
phone
Standard
Reports To ID
ReportsToId
reference
Standard
Department
Department
string
Standard
Birthdate
Birthdate
date
Standard
Last Stay-in-Touch Request Date
LastCURequestDate
datetime
Standard
Last Stay-in-Touch Save Date
LastCUUpdateDate
datetime
Standard
Is Email Bounced
IsEmailBounced
boolean
Standard
Assistant's Name
AssistantName
string
Standard
Level
Level__c
picklist
Custom
Languages
Languages__c
string
Custom
Lead
46
Full Name
Name
string
Standard
Lead Source
LeadSource
picklist
Standard
Last Activity
LastActivityDate
date
Standard
Phone
Phone
phone
Standard
Website
Website
url
Standard
Photo URL
PhotoUrl
url
Standard
Industry
Industry
picklist
Standard
Annual Revenue
AnnualRevenue
currency
Standard
Employees
NumberOfEmployees
int
Standard
Data.com Key
Jigsaw
string
Standard
Last Name
LastName
string
Standard
First Name
FirstName
string
Standard
Salutation
Salutation
picklist
Standard
Fax
Fax
phone
Standard
Email
Email
email
Standard
Title
Title
string
Standard
Email Bounced Reason
EmailBouncedReason
string
Standard
Email Bounced Date
EmailBouncedDate
datetime
Standard
Jigsaw Contact ID
JigsawContactId
string
Standard
Individual ID
IndividualId
reference
Standard
Company
Company
string
Standard
Street
Street
textarea
Standard
City
City
string
Standard
State/Province
State
string
Standard
Zip/Postal Code
PostalCode
string
Standard
Country
Country
string
Standard
Latitude
Latitude
double
Standard
Longitude
Longitude
double
Standard
Geocode Accuracy
GeocodeAccuracy
picklist
Standard
Address
Address
address
Standard
Mobile Phone
MobilePhone
phone
Standard
Rating
Rating
picklist
Standard
Converted
IsConverted
boolean
Standard
Converted Date
ConvertedDate
date
Standard
Converted Account ID
ConvertedAccountId
reference
Standard
Converted Contact ID
ConvertedContactId
reference
Standard
Converted Opportunity ID
ConvertedOpportunityId
reference
Standard
Unread By Owner
IsUnreadByOwner
boolean
Standard
Current Generator(s)
CurrentGenerators__c
string
Custom
Clean Status
CleanStatus
picklist
Standard
D&B Company ID
DandbCompanyId
reference
Standard
Number of Locations
NumberofLocations__c
double
Custom
Company D-U-N-S Number
CompanyDunsNumber
string
Standard
SIC Code
SICCode__c
string
Custom
Product Interest
ProductInterest__c
picklist
Custom
Primary
Primary__c
picklist
Custom
Opportunity
24
Stage
StageName
picklist
Standard
Amount
Amount
currency
Standard
Probability (%)
Probability
percent
Standard
Close Date
CloseDate
date
Standard
Next Step
NextStep
string
Standard
Won
IsWon
boolean
Standard
Forecast Category
ForecastCategory
picklist
Standard
Forecast Category
ForecastCategoryName
picklist
Standard
Campaign ID
CampaignId
reference
Standard
Has Line Item
HasOpportunityLineItem
boolean
Standard
Price Book ID
Pricebook2Id
reference
Standard
Fiscal Quarter
FiscalQuarter
int
Standard
Fiscal Year
FiscalYear
int
Standard
Fiscal Period
Fiscal
string
Standard
Has Open Activity
HasOpenActivity
boolean
Standard
Has Overdue Task
HasOverdueTask
boolean
Standard
Opportunity History ID
LastAmountChangedHistoryId
reference
Standard
Opportunity History ID
LastCloseDateChangedHistoryId
reference
Standard
Private
IsPrivate
boolean
Standard
Quantity
TotalOpportunityQuantity
double
Standard
Delivery/Installation Status
DeliveryInstallationStatus__c
picklist
Custom
Tracking Number
TrackingNumber__c
string
Custom
Order Number
OrderNumber__c
string
Custom
Main Competitor(s)
MainCompetitors__c
string
Custom
Task
39
Activity ID
Id
id
Standard
Deleted
IsDeleted
boolean
Standard
Account ID
AccountId
reference
Standard
Description
Description
textarea
Standard
Closed
IsClosed
boolean
Standard
Assigned To ID
OwnerId
reference
Standard
Created Date
CreatedDate
datetime
Standard
Created By ID
CreatedById
reference
Standard
Last Modified Date
LastModifiedDate
datetime
Standard
Last Modified By ID
LastModifiedById
reference
Standard
System Modstamp
SystemModstamp
datetime
Standard
Status
Status
picklist
Standard
Subject
Subject
combobox
Standard
Priority
Priority
picklist
Standard
Name ID
WhoId
reference
Standard
Related To ID
WhatId
reference
Standard
Due Date Only
ActivityDate
date
Standard
High Priority
IsHighPriority
boolean
Standard
Archived
IsArchived
boolean
Standard
Call Duration
CallDurationInSeconds
int
Standard
Call Type
CallType
picklist
Standard
Call Result
CallDisposition
string
Standard
Call Object Identifier
CallObject
string
Standard
Reminder Date/Time
ReminderDateTime
datetime
Standard
Reminder Set
IsReminderSet
boolean
Standard
Recurrence Activity ID
RecurrenceActivityId
reference
Standard
Create Recurring Series of Tasks
IsRecurrence
boolean
Standard
Recurrence Start
RecurrenceStartDateOnly
date
Standard
Recurrence End
RecurrenceEndDateOnly
date
Standard
Recurrence Time Zone
RecurrenceTimeZoneSidKey
picklist
Standard
Recurrence Type
RecurrenceType
picklist
Standard
Recurrence Interval
RecurrenceInterval
int
Standard
Recurrence Day of Week Mask
RecurrenceDayOfWeekMask
int
Standard
Recurrence Day of Month
RecurrenceDayOfMonth
int
Standard
Recurrence Instance
RecurrenceInstance
picklist
Standard
Recurrence Month of Year
RecurrenceMonthOfYear
picklist
Standard
Repeat This Task
RecurrenceRegeneratedType
picklist
Standard
Task Subtype
TaskSubtype
picklist
Standard
Completed Date/Time
CompletedDateTime
datetime
Standard
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.