Opportunity

Internal ID: opportunity

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
actionitem	text	true	Action Item	false
altsalesrangehigh	currency	false	To	false
altsalesrangelow	currency	false	Range	false
altsalestotal	text	false	Total (Alt. Sales Amount)	false
balance	currency	false	Balance	false
billaddr1	text	false	Billing Address Line 1	false
billaddr2	text	false	Billing Address Line 2	false
billaddr3	text	false	Billing Address Line 3	false
billaddress	address	false	Bill To	false
billaddressee	text	false	Billing Addressee	false
billaddresslist	select	false	Bill To Select	false
billattention	text	false	Billing Attention	false
billcity	text	false	Billing Address City	false
billcountry	text	false	Billing Address Country	false
billisresidential	text	false	Shipping address is residential	false
billphone	text	false	Billing Phone	false
billstate	text	false	Billing Address State	false
billzip	text	false	Billing Address Zip Code	false
buyingreason	select	true	Buying Reason	false
buyingtimeframe	select	true	Buying Time Frame	false
class	select	false	Class	false	References a value from a user defined list at Setup > Company > Classifications > Classes. This field is required when the Make Classes Mandatory preference is enabled at Setup > Accounting > Accounting Preferences. If you are using a customForm that has class customized at the item level, you can NOT set this field at the body level. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
consolidatebalance	currency	false	Consolidated Balance	false
createddate	datetime	false		false
currency	select	false	Currency	true	If you do not use the Multi-Currency Customers feature, the currency of the customer you are creating this transaction for is shown here. If you use the Multi-Currency Customers feature, select the transaction currency you want to create this transaction in. This customer's primary currency is selected by default. If you have already selected items on this transaction, selecting a new currency refreshes them to show the price in the new currency (except for items you entered custom prices for) and recalculates tax and gross profit.
currencyname	text	false	Currency	false
currencysymbol	text	false	Currency Symbol	false
customform	select	false	Custom Form	true
department	select	false	Department	false	References a value from a user defined list at Setup > Company > Departments. If you are using a customForm that has department customized at the item level, you can NOT set this field at the body level. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
documentstatus	text	false		false
entity	select	false	Company	true	References a company record that already exists in your account. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
entitynexus	select	false	Nexus	false
entitystatus	select	true	Status	true
estgrossprofit	currency	false	Est. Gross Profit	false
estgrossprofitpercent	percent	false	Est. Gross Profit Percent	false
estimatedbudget	currency	true	Estimated Budget	false
exchangerate	currency2	false	Exchange Rate	true
expectedclosedate	date	true	Expected Close	true
externalid	text	false	ExternalId	false
forecasttype	select	true	Forecast Type	false
isbasecurrency	checkbox	false	Base Currency	false
isbudgetapproved	checkbox	true	Budget Approved	false
job	select	false	Project	false
lastmodifieddate	datetime	false		false
leadsource	select	false	Lead Source	false
location	select	false	Location	false	This is a reference to a user defined location at Setup > Company > Locations. If you are using a customForm that has location customized at the item level, you can NOT set this field at the body level. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
memo	textarea	false	Details	false	Enter additional information about the opportunity.
nexus	select	false	Nexus	false
partner	select	true	Partner	false	References a partner record that already exists in your account. If a value is not provided, the field is populated with the partner associated with the company referenced in the entity field (if a partner exists for that company). In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
probability	percent	true	Probability	true	If the value for probability is not provided, a calculated value based on the Status populates the field. If the value for probability is set, it overrides the slaved value depending on the default settings. For example: � If conditional defaults are ON, on update the probability changes if the status changes and the probability is NOT specified in the request. � If conditional defaults are OFF, on update the probability does NOT change if status changes. � If conditional defaults are ON, and a value for both status and probability are submitted, then the submitted values are set.
projaltsalesamt	currency	true	Alt. Sales Total	false
projectedtotal	currency	true	Projected Total	true
rangehigh	currency	true	To	false
rangelow	currency	true	Range	false
salesgroup	select	false	Choose Team	false
salesreadiness	select	true	Sales Readiness	false
salesrep	select	true	Sales Rep	false
shipaddr1	text	false	Shipping Address Line 1	false
shipaddr2	text	false	Shipping Address Line 2	false
shipaddr3	text	false	Shipping Address Line 3	false
shipaddress	address	false	Ship To	false
shipaddressee	text	false	Shipping Addressee	false
shipaddresslist	select	false	Ship To Select	false
shipattention	text	false	Shipping Attention	false
shipcity	text	false	Shipping Address City	false
shipcountry	text	false	Shipping Address Country	false
shipisresidential	text	false	Shipping address is residential	false
shipoverride	text	false		false
shipphone	text	false	Shipping Phone	false
shipstate	text	false	Shipping Address State	false
shipzip	text	false	Shipping Address Zip Code	false
source	text	false	Source	false
status	text	false		false
statusRef	text	false		false
subsidiary	select	false	Subsidiary	false	This field displays the subsidiary associated with this transaction.
syncpartnerteams	checkbox	false	Update Customer	false
syncsalesteams	checkbox	false	Update Customer	false
title	text	true	Title	false	Sets the value of the title displayed on lists, reports and on the Opportunities subtab of the record the opportunity is associated with.
total	text	false		false
totalcostestimate	currency	false	Est. Extended Cost	false
trandate	date	false	Date Created	true
tranid	text	false	Opportunity #	false
unbilledorders	currency	false	Unbilled Orders	false
weightedtotal	currency	false	Weighted Total	false
winlossreason	select	true	Win/Loss Reason	false

Sublists

accountingbookdetail - Accounting Books

Internal ID	Type	Label	Required
exchangerate	currency2	Exchange Rate	true

competitors - Competitors

Internal ID	Type	Label	Required
competitor	select	Name	true
id	text		false
notes	textarea	Notes	false
url	url	URL	false
winner	checkbox	Winner	false

item - Items

Internal ID	Type	Label	Required
altsalesamt	currency	Alt. Sales Amount	false
amount	currency	Amount	false
billingschedule	text		false
billvariancestatus	text		false
costestimate	currency	Est. Extended Cost	false
costestimaterate	rate		false
costestimatetype	select	Cost Estimate Type	false
daysbeforeexpiration	text		false
deferrevrec	checkbox		false
description	textarea	Description	false
expectedshipdate	date	Expected Ship Date	false
fromjob	checkbox	Project Item	false
id	text		false
isestimate	checkbox	Billable Estimate	false
istaxable	text		false
isvsoebundle	text		false
item	select	Item	true
itemsubtype	text		false
itemtype	text		false
job	select	Job	false
line	text		false
linenumber	integer		false
matrixtype	text		false
options	namevaluelist	Options	false
price	select	Price Level	false
printitems	text		false
quantity	float	Quantity	false
rate	rate	Rate	false
rateschedule	text		false
units	select	Units	false

partners - Partners

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

salesteam - Sales Team

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

Tabs

Name	Label
address	Address
custom	Custom
general	General
items	Items
multipartner	Partners
qualification	Qualification
teamselling	Sales Team
workflow	Workflow

Search Joins

Join ID	Join Description	Actual Join Name
competitor	Competitor	Competitor
competitorwinner	Competitor (Winner)	Competitor
contact	Contact	Contact
contactprimary	Contact (Primary)	Contact
customer	Customer	Customer
decisionmaker	Decision Maker	Contact
leadsource	Lead Source	Campaign
messages	Messages	Message
partner	Partner	Partner
salesrep	Sales Rep	Employee
task	Task	Task

Search Filters

Internal ID	Type	Label
amount	currency	Item Amount
availableoffline	checkbox	Always Available Offline
buyingreason	select	Buying Reason
buyingtimeframe	select	Buying Time Frame
class	select	Class
closedate	date	Actual Close
competitor	select	Competitor
contribution	integer	Contribution %
currency	select	Currency
custtype	select	Customer Category
datecreated	datetime	Date Created
daysopen	integer	Days Open
daystoclose	integer	Days To Close
department	select	Department
entity	select	Prospect/Customer
entitystatus	select	Opportunity Status
estimatedbudget	currency	Estimated Budget
expectedclosedate	date	Expected Close Date
externalid	select	External ID
externalidstring	text	External ID (Text)
forecasttype	select	Forecast Type
foreignprojectedamount	currency	Projected Total (Foreign Currency)
foreignrangehigh	currency	Range - High (Foreign Currency)
foreignrangelow	currency	Range - Low (Foreign Currency)
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
fxtrancostestimate	currency	Est. Extended Cost (Transaction) (Foreign Currency)
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
isbudgetapproved	checkbox	Budget Approved
item	multiselect	Item
lastmodifieddate	datetime	Date Last Modified
leadsource	select	Lead Source
location	select	Location
memo	text	Memo
number	integer	Number
partner	select	Partner
partnercontribution	integer	Partner Contribution %
partnerrole	select	Partner Role
partnerteammember	select	Partner Team Member
postingperiod	period	Period
probability	integer	Probability
projaltsalesamt	currency	Projected Alt.Sales Amount
projectedtotal	currency	Projected Amount
rangehigh	currency	Range - High
rangehighalt	currency	Alt.Sales Range - High
rangelow	currency	Range - Low
rangelowalt	currency	Alt.Sales Range - Low
salesreadiness	select	Sales Readiness
salesrep	select	Sales Rep
salesteammember	select	Sales Team Member
salesteamrole	select	Sales Team Role
status	select	Document Status
subsidiary	select	Subsidiary
taxperiod	period	Tax Period
title	text	Title
trancostestimate	currency	Est. Extended Cost (Transaction)
trandate	date	Date
tranestgrossprofit	currency	Est. Gross Profit (Transaction)
tranestgrossprofitpct	percent	Est. Gross Profit Percent (Transaction)
tranfxestgrossprofit	currency	Est. Gross Profit (Transaction) (Foreign Currency)
tranid	text	Number/ID
winlossreason	select	Win/Loss Reason
wonby	select	Won By

Search Columns

Internal ID	Type	Label
actionitem	text	Action Item
availableoffline	checkbox	Always Available Offline
buyingreason	text	Buying Reason
buyingtimeframe	text	Buying Time Frame
class	select	Class
classnohierarchy	select	Class (no hierarchy)
closedate	date	Actual Close
competitor	select	Competitor
contribution	percent	Contribution %
contributionprimary	percent	Primary Sales Rep Contribution %
currency	select	Currency
custtype	text	Customer Category
datecreated	datetime	Date Created
daysopen	integer	Days Open
daystoclose	integer	Days To Close
decisionmaker	select	Decision Maker
department	select	Department
departmentnohierarchy	select	Department (no hierarchy)
documentstatus	select	Document Status
entity	select	Customer
entitystatus	select	Opportunity Status
estimatedbudget	currency	Estimated Budget
expectedclosedate	date	Expected Close
externalid	select	External ID
forecasttype	select	Forecast Type
foreignprojectedamount	currency	Projected Total (Foreign Currency)
foreignrangehigh	currency	Range - High (Foreign Currency)
foreignrangelow	currency	Range - Low (Foreign Currency)
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)
fxtrancostestimate	currency	Est. Extended Cost (Transaction) (Foreign Currency)
internalid	select	Internal ID
isbudgetapproved	checkbox	Budget Approved
lastmodifieddate	datetime	Last Modified
lastviewed	datetime	Last Viewed
leadsource	select	Lead Source
location	select	Location
locationnohierarchy	select	Location (no hierarchy)
memo	text	Memo
partner	select	Partner
partnercontribution	percent	Partner Contribution %
partnerrole	select	Partner Role
partnerteammember	select	Partner Team Member
period	text	Period
probability	percent	Probability
projaltsalesamt	currency	Projected Alt.Sales Total
projectedtotal	currency	Projected Total
rangehigh	currency	Range - High
rangehighalt	currency	Alt.Sales Range - High
rangelow	currency	Range - Low
rangelowalt	currency	Alt.Sales Range - Low
salesreadiness	text	Sales Readiness
salesrep	select	Sales Rep
salesteammember	select	Sales Team Member
salesteamrole	select	Sales Team Role
subsidiary	select	Subsidiary
subsidiarynohierarchy	select	Subsidiary (no hierarchy)
taxperiod	select	Tax Period
title	text	Title
total	currency	Item Amount
trancostestimate	currency	Est. Extended Cost (Transaction)
trandate	date	Date
tranestgrossprofit	currency	Est. Gross Profit (Transaction)
tranestgrossprofitpct	percent	Est. Gross Profit Percent (Transaction)
tranfxestgrossprofit	currency	Est. Gross Profit (Transaction) (Foreign Currency)
tranid	text	Number
weightedtotal	currency	Weighted Total
winlossreason	select	Win/Loss Reason
wonby	select	Won By

Transform Types

Target Record Type	Field Defaults
cashsale	customform,billdate
estimate	customform
invoice	customform,billdate
salesorder	customform