Salesforce Fields and Entities Available for Synchronization

    This page describes the reference of the entities and fields supported for synchronization from the Salesforce instance.

    Note: Exalate for Salesforce allows syncing all the available objects and their fields within the Script connection. This page shows the most popular and widely used objects and their fields.

    Fields Supported in Case Entity


    field labelvariabletype
    1Account NameAccountIdLookup(Account)
    2AssetAssetIdLookup(Asset)
    3Business HoursBusinessHoursIdLookup(Business Hours)
    4Case NumberCaseNumberAuto Number
    5Case OriginOriginPicklist
    6Case OwnerOwnerIdLookup(User,Group)
    7Case ReasonReasonPicklist
    8Case SourceSourceIdLookup(Email Message, Messaging Session)
    9Closed When CreatedIsClosedOnCreateCheckbox
    10Contact EmailContactEmailEmail
    11Contact FaxContactFaxPhone
    12Contact MobileContactMobilePhone
    13Contact NameContactIdLookup(Contact)
    14Contact PhoneContactPhonePhone
    15Created ByCreatedByIdLookup(User)
    16Date/Time ClosedClosedDateDate/Time
    17Date/Time OpenedCreatedDateDate/Time
    18DescriptionDescriptionLong Text Area(32000)
    19Engineering Req NumberEngineeringReqNumber__cText(12)
    20Entitlement NameEntitlementIdLookup(Entitlement)
    21Entitlement Process End TimeSlaExitDateDate/Time
    22Entitlement Process Start TimeSlaStartDateDate/Time
    23EscalatedIsEscalatedCheckbox
    24Internal CommentsCommentsText Area(4000)
    25Last Modified ByLastModifiedByIdLookup(User)
    26Milestone StatusMilestoneStatusText(30)
    27Parent CaseParentIdLookup(Case)
    28Potential LiabilityPotentialLiability__cPicklist
    29PriorityPriorityPicklist
    30ProductProduct__cPicklist
    31ProductProductIdLookup(Product)
    32Service ContractServiceContractIdLookup(Service Contract)
    33SLA ViolationSLAViolation__cPicklist
    34StatusStatusPicklist
    35StoppedIsStoppedCheckbox
    36Stopped SinceStopStartDateDate/Time
    37SubjectSubjectText(255)
    38TypeTypePicklist
    39Web CompanySuppliedCompanyText(80)
    40Web EmailSuppliedEmailEmail
    41Web NameSuppliedNameText(80)
    42Web PhoneSuppliedPhoneText(40)

    Fields Supported in the Task Entity 


    field namevariabletype
    1Assigned ToOwnerIdLookup(User, Calendar, Group)
    2Call DurationCallDurationInSecondsNumber(8, 0)
    3Call Object IdentifierCallObjectText(255)
    4Call ResultCallDispositionText(255)
    5Call TypeCallTypePicklist
    6CommentsDescriptionLong Text Area(32000)
    7Create Recurring Series of TasksIsRecurrenceCheckbox
    8Created ByCreatedByIdLookup(User)
    9Due DateActivityDateDate
    10EmailEmailEmail
    11Last Modified ByLastModifiedByIdLookup(User)
    12NameWhoIdLookup(Contact,Lead)
    13PhonePhonePhone
    14PriorityPriorityPicklist
    15Recurrence IntervalRecurrenceIntervalNumber(9, 0)
    16Related ToWhatId

    Lookup (Contract,Order,Campaign,Account,Opportunity,Product,

    Asset,Case,Solution,Invoice,Work Order,Work Order Line Item,

    Service Appointment,Service Resource,Assigned Resource,

    Resource Absence,Entitlement,Service Contract,

    Contract Line Item,Location,Coaching,Goal,Metric,

    Asset Relationship,List Email, Return Order,Return Order Line Item,

    Contact Request,Image,Credit Memo, Communication Subscription Consent,

    Legal Entity,Party Consent,Queued Party,Process Exception)

    17Reminder SetIsReminderSetCheckbox
    18Repeat This TaskRecurrenceRegeneratedTypePicklist
    19StatusStatusPicklist
    20SubjectSubjectPicklist
    21Task SubtypeTaskSubtypePicklist
    22TypeTypePicklist

    Fields Supported in the Account Entity 


    field namevariabletype
    1Account NameNameName
    2Account NumberAccountNumberText(40)
    3Account OwnerOwnerIdLookup(User)
    4Account SiteSiteText(80)
    5Account SourceAccountSourcePicklist
    6ActiveActive__cPicklist
    7Annual RevenueAnnualRevenueCurrency(18, 0)
    8Billing AddressBillingAddressAddress
    9Clean StatusCleanStatusPicklist
    10Created ByCreatedByIdLookup(User)
    11Customer PriorityCustomerPriority__cPicklist
    12D&B CompanyDandbCompanyIdLookup(D&B Company)
    13D-U-N-S NumberDunsNumberText(9)
    14Data.com KeyJigsawText(20)
    15DescriptionDescriptionLong Text Area(32000)
    16EmployeesNumberOfEmployeesNumber(8, 0)
    17FaxFaxFax
    18IndustryIndustryPicklist
    19Last Modified ByLastModifiedByIdLookup(User)
    20NAICS CodeNaicsCodeText(8)
    21NAICS DescriptionNaicsDescText(120)
    22Number of LocationsNumberofLocations__cNumber(3, 0)
    23Operating HoursOperatingHoursIdLookup(Operating Hours)
    24OwnershipOwnershipPicklist
    25Parent AccountParentIdHierarchy
    26PhonePhonePhone
    27RatingRatingPicklist
    28Shipping AddressShippingAddressAddress
    29SIC CodeSicText(20)
    30SIC DescriptionSicDescText(80)
    31SLASLA__cPicklist
    32SLA Expiration DateSLAExpirationDate__cDate
    33SLA Serial NumberSLASerialNumber__cText(10)
    34Ticker SymbolTickerSymbolContent(20)
    35TradestyleTradestyleText(255)
    36TypeTypePicklist
    37Upsell OpportunityUpsellOpportunity__cPicklist
    38WebsiteWebsiteURL(255)
    39Year StartedYearStartedText(4)


    Fields Supported in the Product Entity 


    field namevariabletype
    1ActiveIsActiveCheckbox
    2Created ByCreatedByIdLookup(User)
    3Display URLDisplayUrlURL(1000)
    4External Data SourceExternalDataSourceIdLookup(External Data Source)
    5External IDExternalIdText(255)
    6Last Modified ByLastModifiedByIdLookup(User)
    7Product CodeProductCodeText(255)
    8Product DescriptionDescriptionText Area(4000)
    9Product FamilyFamilyPicklist
    10Product NameNameText(255)
    11Product SKUStockKeepingUnitText(180)
    12Quantity Unit Of MeasureQuantityUnitOfMeasurePicklist


    Fields Supported in the Opportunity Entity 


    field namevariabletype
    1Account NameAccountIdLookup(Account)
    2AmountAmountCurrency(16, 2)
    3Close DateCloseDateDate
    4ContractContractIdLookup(Contract)
    5Created ByCreatedByIdLookup(User)
    6Current Generator(s)CurrentGenerators__cText(100)
    7Delivery/Installation StatusDeliveryInstallationStatus__cPicklist
    8DescriptionDescriptionLong Text Area(32000)
    9Expected RevenueExpectedRevenueCurrency(16, 2)
    10Forecast CategoryForecastCategoryNamePicklist
    11Last Modified ByLastModifiedByIdLookup(User)
    12Lead SourceLeadSourcePicklist
    13Main Competitor(s)MainCompetitors__cText(100)
    14Next StepNextStepText(255)
    15Opportunity NameNameText(120)
    16Opportunity OwnerOwnerIdLookup(User)
    17Opportunity ScoreIqScoreNumber(9, 0)
    18Order NumberOrderNumber__cText(8)
    19Price BookPricebook2IdLookup(Price Book)
    20Primary Campaign SourceCampaignIdLookup(Campaign)
    21PrivateIsPrivateCheckbox
    22Probability (%)ProbabilityPercent(3, 0)
    23QuantityTotalOpportunityQuantityNumber(16, 2)
    24StageStageNamePicklist
    25Tracking NumberTrackingNumber__cText(12)
    26TypeTypePicklist