Originating Lead

Internal ID: originatinglead

Search Join only

Supports Custom Fields

Search Joins

Join ID Join Description Actual Join Name
msesubsidiary Subsidiary Subsidiary
originatinglead Originating Lead Lead
pricing Pricing Pricing

Search Filters

Internal ID Type Label
accountnumber text Account
address textarea Address
addressee text Addressee
addresslabel text Address Label
addressphone phone Address Phone
attention text Attention
availableoffline checkbox Always Available Offline
balance currency Balance
billaddress textarea Billing Address
billingratecard select Billing Rate Card
billingschedule select Billing Schedule
billingtransactionform select Billing Transaction Form
billingtransactiontype select Billing Transaction Type
boughtamount currency Total Amount Purchased
boughtdate date Purchase Dates
bounced checkbox Hard Bounced
buyingreason select Buying Reason
buyingtimeframe select Buying Time Frame
campaignevent select Campaign Event
category select Category
cccustomercode text CC Customer Code
ccdefault checkbox Default Credit Card
ccexpdate date CC Expire Date
ccholdername text Credit Cardholder Name
ccnumber checkbox Credit Card Number
ccstate select Credit Card State
ccstatefrom date Credit Card State From
cctype select Credit Card Type
city text City
comments textarea Comments
companyname text Company Name
consolbalance currency Consolidated Balance
consoldaysoverdue integer Consolidated Days Overdue
consoldepositbalance currency Consolidated Deposit Balance
consoloverduebalance currency Consolidated Overdue Balance
consolunbilledorders currency Consolidated Unbilled Orders
contact text Contact
contribution integer Contribution %
conversiondate date Conversion Date
country select Country
county text County/State
credithold select Credit Hold
creditholdoverride checkbox Override Credit Hold Off
creditlimit currency Credit Limit
currency select Primary Currency
custstage select Parent Stage
custstatus select Parent Status
dateclosed datetime Date Closed
datecreated datetime Date Created
daysoverdue integer Days Overdue
defaultorderpriority float Default Order Priority
depositbalance currency Deposit Balance
draccount select Deferred Revenue Reclassification Account
email text Email
emailpreference select Email Preference
emailtransactions checkbox Email Transactions
enddate date End Date
entityid text Name/ID
entitystatus select Status
estimatedbudget currency Estimated Budget
explicitconversion checkbox Explicit Conversion
externalid select External ID
externalidstring text External ID (Text)
fax phone Fax
faxtransactions checkbox Fax Transactions
firstname text First Name
firstorderdate date Date of First Order
firstsaledate date Date of First Sale
fxaccount select Foreign Currency Adjustment Revenue Account
fxbalance currency Balance (Foreign Currency)
fxconsolbalance currency Consolidated Balance (Foreign Currency)
fxconsolunbilledorders currency Consolidated Unbilled Orders (Foreign Currency)
fxunbilledorders currency Unbilled Orders (Foreign Currency)
giveaccess checkbox Login Access
globalsubscriptionstatus select Global Subscription Status
group multiselect Group
grouppricinglevel select Group Pricing Level
hasduplicates checkbox Duplicate
image image Image
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isbudgetapproved checkbox Budget Approved
isdefaultbilling checkbox Default Billing Address
isdefaultshipping checkbox Default Shipping Address
isinactive checkbox Inactive
isitemcorrelated checkbox Is Upsell Item Correlated
isjob checkbox Is Job
isperson checkbox Is Individual
isreportedlead checkbox Included in Lead Reports
isshipaddress checkbox Residential Address
itemcorrelation percent Upsell Item Correlation
itempricinglevel select Item Pricing Level
itempricingunitprice currency Item Pricing Unit Price
itemsbought multiselect Items Purchased
itemsordered multiselect Items Ordered
jobenddate date Actual End Date
jobestcost currency Estimated Cost
jobestenddate date Projected End Date
jobestrevenue currency Estimated Revenue
jobpctcomplete integer Percent Complete
jobstartdate date Start Date
jobstatus select Job Status
jobtype select Job Type
language select Language
lastmodifieddate datetime Last Modified
lastname text Last Name
lastorderdate date Date of Last Order
lastsaledate date Date of Last Sale
leaddate datetime Lead Date
leadsource select Lead Source
level select Level
manualcredithold checkbox Override Credit Hold On
merchantaccount select Credit Card Processor
middlename text Middle Name
monthlyclosing select Monthly Closing Date
negativenumberformat select Negative Number Format
numberformat select Number Format
oncredithold checkbox On Credit Hold
onlineformcampaignevent select Online Form History - Campaign Event
onlineformdate date Online Form History - Form Date
onlineformleadsource select Online Form History - Lead Source
onlineformname select Online Form History - Form Name
orderedamount currency Total Amount Ordered
ordereddate date Order Dates
otherrelationships multiselect Other Relationships
overduebalance currency Overdue Balance
parent select Sub of
parentitemsbought multiselect Items or Sub-Items Purchased
parentitemsordered multiselect Items or Sub-Items Ordered
partner select Partner
partnercontribution integer Partner Contribution %
partnerrole select Partner Role
partnerteammember select Partner Team Member
pec text PEC
permission select Permission
phone phone Phone
phoneticname text Phonetic Name
pricelevel select Price Level
pricinggroup select Pricing Group
pricingitem select Pricing Item
printtransactions checkbox Print Transactions
prospectdate datetime Prospect Date
pstexempt checkbox PST Exempt
receivablesaccount select Default Receivables Account
reminderdate date Renewal Reminder Date
representingsubsidiary select Represents Subsidiary
resalenumber text Resale Number
role select Role
salesreadiness select Sales Readiness
salesrep select Sales Rep
salesteammember select Sales Team Member
salesteamrole select Sales Team Role
salutation text Mr./Mrs...
shipaddress textarea Shipping Address
shipcomplete checkbox Ship Complete
shippingcarrier select Shipping Carrier
shippingitem select Shipping Item
stage select Stage
startdate date Start Date
state select State/Province (Deprecated)
subscription select Subscription
subscriptiondate date Subscription Date
subscriptionstatus checkbox Subscription Status
subsidiary select Subsidiary
taxable checkbox Taxable
terms select Terms
territory select Territory
title text Job Title
type select Primary Type (Deprecated)
unbilledorders currency Unbilled Orders
url url Web Address
vatregnumber text Tax Number
weblead checkbox Web Lead
zipcode text Zip

Search Columns

Internal ID Type Label
accountnumber text Account
address text Address
address1 text Address 1
address2 text Address 2
address3 text Address 3
addressee text Addressee
addressinternalid integer Address Internal ID
addresslabel text Address Label
addressphone text Address Phone
altcontact text Alt. Contact
altemail email Alt. Email
altname text Name
altphone phone Office Phone
attention text Attention
availableoffline checkbox Always Available Offline
balance currency Balance
billaddress text Billing Address
billaddress1 text Billing Address 1
billaddress2 text Billing Address 2
billaddress3 text Billing Address 3
billaddressee text Billing Addressee
billattention text Billing Attention
billcity text Billing City
billcountry select Billing Country
billcountrycode text Billing Country Code
billingratecard text Billing Rate Card
billingschedule select Billing Schedule
billingtransactionform select Billing Transaction Form
billingtransactiontype select Billing Transaction Type
billphone text Billing Phone
billstate select Billing State/Province
billzipcode text Billing Zip
bounced checkbox Hard Bounced
buyingreason text Buying Reason
buyingtimeframe text Buying Time Frame
campaignevent select Campaign Event
category select Category
cccustomercode text CC Customer Code
ccdefault checkbox Default Credit Card
ccexpdate mmyydate CC Expire Date
ccholdername text Credit Cardholder Name
ccinternalid text Credit Card Internal ID
ccnumber ccnumber Credit Card Number
ccstate select Credit Card State
ccstatefrom date Credit Card State From
cctype select Credit Card Type
city text City
comments text Comments
companyname text Company Name
consolbalance currency Consolidated Balance
consoldaysoverdue integer Consolidated Days Overdue
consoldepositbalance currency Consolidated Deposit Balance
consoloverduebalance currency Consolidated Overdue Balance
consolunbilledorders currency Consolidated Unbilled Orders
contact select Primary Contact
contribution percent Contribution %
contributionprimary percent Primary Sales Rep Contribution %
conversiondate date Conversion Date
country select Country
countrycode text Country Code
credithold select Credit Hold
creditholdoverride checkbox Override Credit Hold Off
creditlimit currency Credit Limit
currency select Primary Currency
dateclosed datetime Date Closed
datecreated datetime Date Created
daysoverdue integer Days Overdue
defaultorderpriority float Default Order Priority
depositbalance currency Deposit Balance
draccount text Deferred Revenue Reclassification Account
email email Email
emailpreference select Email Preference
emailtransactions checkbox Email Transactions
enddate date End Date
entityid text Name
entitynumber integer Number
entitystatus select Status
estimatedbudget currency Estimated Budget
explicitconversion checkbox Explicit Conversion
externalid select External ID
fax text Fax
faxtransactions checkbox Fax Transactions
firstname text First Name
firstorderdate date Date of First Order
firstsaledate date Date of First Sale
fxaccount text Foreign Currency Adjustment Revenue Account
fxbalance currency Balance (Foreign Currency)
fxconsolbalance currency Consolidated Balance (Foreign Currency)
fxconsolunbilledorders currency Consolidated Unbilled Orders (Foreign Currency)
fxunbilledorders currency Unbilled Orders (Foreign Currency)
giveaccess checkbox Login Access
globalsubscriptionstatus select Global Subscription Status
grouppricinglevel text Group Pricing Level
hasduplicates checkbox Duplicate
homephone phone Home Phone
image select Image
internalid select Internal ID
isbudgetapproved checkbox Budget Approved
isdefaultbilling checkbox Default Billing Address
isdefaultshipping checkbox Default Shipping Address
isinactive checkbox Inactive
isitemcorrelated checkbox Is Upsell Item Correlated
isperson checkbox Is Individual
isshipaddress checkbox Residential Address
itemcorrelation percent Upsell Item Correlation
itempricinglevel text Item Pricing Level
itempricingunitprice currency Item Pricing Unit Price
jobenddate date Job Actual End
jobprojectedend date Job Projected End
jobstartdate date Job Start
jobtype select Job Type
language select Language
lastmodifieddate datetime Last Modified
lastname text Last Name
lastorderdate date Date of Last Order
lastsaledate date Date of Last Sale
lastviewed datetime Last Viewed
leaddate datetime Lead Date
leadsource select Lead Source
level select Level
manualcredithold checkbox Override Credit Hold On
middlename text Middle Name
mobilephone phone Mobile Phone
monthlyclosing select Monthly Closing Date
negativenumberformat select Negative Number Format
numberformat select Number Format
oncredithold checkbox On Credit Hold
onlineformcampaignevent text Online Form History - Campaign Event
onlineformdate date Online Form History - Date
onlineformleadsource text Online Form History - Lead Source
onlineformname text Online Form History - Form Name
overduebalance currency Overdue Balance
parent select Top Level Parent
partner select Partner
partnercontribution percent Partner Contribution %
partnerrole text Partner Role
partnerteammember select Partner Team Member
pec text PEC
permission select Permission
phone phone Phone
phoneticname text Phonetic Name
prefccprocessor select Credit Card Processor
pricelevel select Price Level
pricinggroup text Pricing Group
pricingitem text Pricing Item
printtransactions checkbox Print Transactions
prospectdate datetime Prospect Date
receivablesaccount text Default Receivables Account
reminderdays integer Reminder Days
representingsubsidiary select Represents Subsidiary
resalenumber text Resale Number
role text Role
salesreadiness text Sales Readiness
salesrep select Sales Rep
salesteammember select Sales Team Member
salesteamrole select Sales Team Role
salutation text Mr./Mrs...
shipaddress text Shipping Address
shipaddress1 text Shipping Address 1
shipaddress2 text Shipping Address 2
shipaddress3 text Shipping Address 3
shipaddressee text Shipping Addressee
shipattention text Shipping Attention
shipcity text Shipping City
shipcomplete checkbox Ship Complete
shipcountry select Shipping Country
shipcountrycode text Shipping Country Code
shipphone text Shipping Phone
shippingcarrier select Shipping Carrier
shippingitem select Shipping Item
shipstate text Shipping State/Province
shipzip text Shipping Zip
stage select Stage
startdate date Start Date
state select State/Province
statedisplayname select State/Province Display Name
subscription select Subscription
subscriptiondate datetime Subscription Date
subscriptionstatus checkbox Subscription Status
subsidiary select Subsidiary
subsidiarynohierarchy select Subsidiary (no hierarchy)
taxable checkbox Taxable
taxitem select Tax Item
terms select Terms
territory select Territory
title text Job Title
type select Primary Type (Deprecated)
unbilledorders currency Unbilled Orders
url text Web Address
vatregnumber text Tax Number
weblead checkbox Web Lead
zipcode text Zip Code