Prospect

Internal ID: prospect

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
accessrole	select	false	Role	false
accountnumber	text	true	Account	false
altemail	email	true	Alt. E-mail	false
altphone	phone	true	Alt. Phone	false
autoname	checkbox	false	Auto	false
balance	currency	false	Balance	false
billaddr1	text	false		false
billaddr2	text	false		false
billaddr3	text	false		false
billcity	text	false		false
billcountry	text	false		false
billpay	checkbox	false	Enable Online Bill Pay	false
billstate	text	false		false
billzip	text	false		false
buyingreason	select	true	Buying Reason	false
buyingtimeframe	select	true	Buying Time Frame	false
campaigncategory	select	false	Campaign Category	false
category	select	true	Category	false
clickstream	text	false	Clickstream (1st Visit)	false
comments	textarea	true	Comments	false
companyname	text	true	Company Name	false
consolbalance	currency	false	Consolidated	false
consoldaysoverdue	integer	false	Consolidated	false
consoldepositbalance	currency	false	Consolidated	false
consoloverduebalance	currency	false	Consolidated	false
consolunbilledorders	currency	false	Consolidated	false
contact	select	false	Primary Contact	false
creditholdoverride	select	false	Hold	false
creditlimit	poscurrency	false	Credit Limit	false
currency	select	true	Currency	true
currencyprecision	text	false	Currency Precision	false
customform	select	false	Custom Form	true
datecreated	datetime	false	Date Created	false
daysoverdue	integer	false	Days Overdue	false
defaultaddress	address	false	Address	false
defaultbankaccount	select	false	Bank Account	false
depositbalance	currency	false	Deposit Balance	false
draccount	select	false	Deferred Revenue Reclassification Account	false
email	email	false	E-Mail	false
emailpreference	select	true	E-Mail Preference	false
emailtransactions	checkbox	true	Email	false
entityid	text	true	Customer ID	true
entitystatus	select	true	Status	true
estimatedbudget	currency	true	Estimated Budget	false
externalid	text	false	ExternalId	false
fax	phone	true	Fax	false
faxtransactions	checkbox	true	Fax	false
firstname	text	false	Name	false
firstvisit	datetime	false	Date of First Visit	false
fxaccount	select	false	Foreign Currency Adjustment Revenue Account	false
giveaccess	checkbox	false	Give Access	false
globalsubscriptionstatus	select	false	Global Subscription Status	false
homephone	phone	true	Home Phone	false
image	select	false	Image	false
isbudgetapproved	checkbox	true	Budget Approved	false
isinactive	checkbox	true	Inactive	false
isjob	text	false		false
isperson	radio	true	Company	false
keywords	text	false	Search Engine Keywords (1st Visit)	false
language	select	false	Language	false
lastmodifieddate	datetime	false	Last Modified Date	false
lastname	text	false		false
lastpagevisited	text	false	Last Page Visited	false
lastvisit	datetime	false	Date of Last Visit	false
leadsource	select	false	Lead Source	false
middlename	text	false		false
mobilephone	phone	false	Mobile Phone	false
monthlyclosing	select	true	Monthly Closing Date	true
negativenumberformat	select	false	Negative Number Format	false
numberformat	select	false	Number Format	false
openingbalance	currency	false	Opening Balance	false
openingbalanceaccount	select	false	Opening Balance Account	false
openingbalancedate	date	false	Opening Balance Date	false
otherrelationships	select	false	Other Relationships	false
overduebalance	currency	false	Overdue Balance	false
parent	select	false	Child Of	false
partner	select	false	Partner	false
phone	phone	true	Phone	false
phoneticname	text	false	Furigana	false
prefccprocessor	select	false	Pref. CC Processor	false
pricelevel	select	false	Price Level	false
printoncheckas	text	false	Print on Check As	false
printtransactions	checkbox	true	Print	false
probability	percent	false	Probability	false
receivablesaccount	select	false	Default Receivables Account	false
referrer	text	false	Referrer (1st Visit)	false
resalenumber	text	false	Resale Number	false
salesreadiness	select	true	Sales Readiness	false
salesrep	integer	false	Sales Rep	false
salutation	text	true	Mr./Ms...	false
sendemail	checkbox	false	Send Notification E-mail	false
stage	text	false		false
startdate	date	true	Start Date	false
strength	text	false	Password Strength	false
subsidiary	select	false	Subsidiary	true
syncpartnerteams	checkbox	false	Update Transactions	false
syncsalesteams	checkbox	false	Update Transactions	false
taxable	checkbox	false	Taxable	false
taxfractionunit	select	false	Tax Rounding Precision	false
taxitem	select	false	Tax Item	false
taxrounding	select	false	Tax Rounding Method	false
terms	select	false	Terms	false
territory	select	false	Territory	false
title	text	false	Job Title	false
unbilledorders	currency	false	Unbilled Orders	false
unsubscribe	select	false	Unsubscribe from Campaigns	false
url	url	true	Web Address	false
vatregnumber	text	false	Tax Reg. Number	false
visits	integer	false	Number of Visits	false
weblead	text	false	Web Lead	false

Sublists

addressbook - Address

Internal ID	Type	Label	Required
addr1	text	Address 1	false
addr2	text	Address 2	false
addr3	text		false
addressee	text	Addressee	false
addressid	text		false
addrtext	address	Address	false
attention	text	Attention	false
city	text	City	false
country	select	Country	false
defaultbilling	checkbox	Default Billing	false
defaultshipping	checkbox	Default Shipping	false
displaystate	text	State/Province	false
id	integer	ID	false
internalid	integer		false
isresidential	checkbox	Residential Address	false
label	text	Label	false
override	checkbox	Override	false
phone	phone	Phone	false
state	text	State/Province	false
zip	text	Zip	false

contactroles - Contacts

Internal ID	Type	Label	Required
contact	select	Contact	false
email	email	Email	false
giveaccess	checkbox	Access	false
password	password	Password	false
passwordconfirm	password	Confirm Password	false
role	select	Role	false
sendemail	checkbox	Notify	false
strength	text	Password Strength	false

currency - Currencies

Internal ID	Type	Label	Required
balance	currency	Balance	false
consolbalance	currency	Consolidated	false
consoldepositbalance	currency	Consolidated	false
consoloverduebalance	currency	Consolidated	false
consolunbilledorders	currency	Consolidated	false
currency	select	Currency	true
currencyformatsample	text	Format Sample	false
depositbalance	currency	Deposit Balance	false
displaysymbol	text	Symbol	false
overduebalance	currency	Overdue Balance	false
overridecurrencyformat	checkbox	Override Currency Format	false
symbolplacement	select	Symbol Placement	false
unbilledorders	currency	Unbilled Orders	false

download - Downloads

Internal ID	Type	Label	Required
expiration	date	Expiration Date	false
file	select	Attach File	false
licensecode	textarea	License Code	false
remainingdownloads	integer	Remaining Downloads	false

grouppricing - Group Pricing

Internal ID	Type	Label	Required
group	select	Pricing Group	true
level	select	Price Level	true

itempricing - Item Pricing

Internal ID	Type	Label	Required
currency	select	Currency	false
item	select	Item	true
level	select	Price Level	true
price	currency2	Unit Price	false

partners - Partners

Internal ID	Type	Label	Required
contribution	percent	Contribution %	true
customer	text		false
id	text		false
isprimary	checkbox	Primary	false
partner	select	Partner	true
partnerrole	select	Partner Role	false

salesteam - Sales Team

Internal ID	Type	Label	Required
contribution	percent	Contribution %	true
customer	text		false
employee	select	Employee	true
id	text		false
isprimary	checkbox	Primary	false
issalesrep	text		false
salesrole	select	Sales Role	true

Tabs

Name	Label
access	Access
address	Address
custom	Custom
financial	Financial
general	General
info	Info
marketing	Marketing
qualification	Qualification
sales	Sales
support	Support
workflow	Workflow

Search Joins

Join ID	Join Description	Actual Join Name
campaignresponse	Campaign Response	Campaign
contact	Contact	Contact
contactprimary	Contact (Primary)	Contact
job	Job	Job
leadsource	Lead Source	Campaign
messages	Messages	Message
messagesfrom	Messages From	Message
messagesto	Messages To	Message
parentcustomer	Parent Customer	Customer
partner	Partner	Partner
salesrep	Sales Rep	Employee
subcustomer	Sub Customer	Customer
task	Task	Task
toplevelparent	Top Level Parent	Customer
websitecategory	Web Site Category	Presentation Category

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
boughtamount	currency	Total Amount Purchased
boughtdate	date	Purchase Dates
buyingreason	select	Buying Reason
buyingtimeframe	select	Buying Time Frame
category	select	Category
cccustomercode	text	CC Customer Code
ccdefault	checkbox	Default Credit Card
ccexpdate	date	CC Expire Date
ccholdername	text	Credit Cardholder Name
ccnumber	ccnumber	Credit Card Number
cctype	select	Credit Card Type
city	text	City
classbought	multiselect	Class
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	Currency
custstage	select	Parent Stage
custstatus	select	Parent Status
dateclosed	datetime	Date Closed
datecreated	datetime	Date Created
daysoverdue	integer	Days Overdue
depositbalance	currency	Deposit Balance
deptbought	multiselect	Department
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
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
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
isjob	checkbox	Is Job
isperson	checkbox	Is Individual
isreportedlead	checkbox	Included in Lead Reports
isshipaddress	checkbox	Residential Address
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
locationbought	multiselect	Location
manualcredithold	checkbox	Override Credit Hold On
merchantaccount	select	Credit Card Processor
middlename	text	Middle Name
monthlyclosing	select	Monthly Closing Date
oncredithold	checkbox	On Credit Hold
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
subsidbought	multiselect	Subsidiaries Bought
subsidiary	select	Subsidiary
taxable	checkbox	Taxable
terms	select	Terms
territory	select	Territory
title	text	Job Title
type	select	Entity Type
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	text	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
billphone	text	Billing Phone
billstate	select	Billing State/Province
billzipcode	text	Billing Zip
buyingreason	text	Buying Reason
buyingtimeframe	text	Buying Time Frame
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
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	Currency
dateclosed	datetime	Date Closed
datecreated	datetime	Date Created
daysoverdue	integer	Days Overdue
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
formulacurrency	currency	Formula (Currency)
formuladate	date	Formula (Date)
formuladatetime	datetime	Formula (Date/Time)
formulanumeric	float	Formula (Numeric)
formulapercent	percent	Formula (Percent)
formulatext	text	Formula (Text)
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
isperson	checkbox	Is Individual
isshipaddress	checkbox	Residential Address
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
oncredithold	checkbox	On Credit Hold
onlineformdate	text	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	Type
unbilledorders	currency	Unbilled Orders
url	text	Web Address
vatregnumber	text	Tax Number
weblead	checkbox	Web Lead
zipcode	text	Zip Code

Transform Types

Target Record Type	Field Defaults
estimate	customform
opportunity	customform
salesorder	customform