JDBC Driver for NetSuite

Build 23.0.8839

opportunity

The opportunity table.

Columns

Name Type References Description
actionitem String Actionitem
altsalesrangehigh Decimal Altsalesrangehigh
altsalesrangelow Decimal Altsalesrangelow
altsalestotal String Altsalestotal
balance Decimal Balance
billaddress String Billaddress
billaddresslist String Billaddresslist
billingaddress String Billingaddress
billisresidential String Billisresidential
buyingreason String Buyingreason
buyingtimeframe String Buyingtimeframe
class String Class
consolidatebalance Decimal Consolidatebalance
createddate Datetime Createddate
currency String Currency
currencyname String Currencyname
currencysymbol String Currencysymbol
customform String Customform
department String Department
documentstatus String Documentstatus
entity String Entity
entitynexus String Entitynexus
entitystatus String Entitystatus
entitytaxregnum String Entitytaxregnum
estgrossprofit Decimal Estgrossprofit
estgrossprofitpercent String Estgrossprofitpercent
estimatedbudget Decimal Estimatedbudget
exchangerate Decimal Exchangerate
expectedclosedate Date Expectedclosedate
externalid String Externalid
forecasttype String Forecasttype
isbasecurrency Boolean Isbasecurrency
isbudgetapproved Boolean Isbudgetapproved
job String Job
lastmodifieddate Datetime Lastmodifieddate
leadsource String Leadsource
location String Location
memo String Memo
nexus String Nexus
onetime Decimal Onetime
partner String Partner
probability String Probability
projaltsalesamt Decimal Projaltsalesamt
projectedtotal Decimal Projectedtotal
rangehigh Decimal Rangehigh
rangelow Decimal Rangelow
recurannually Decimal Recurannually
recurmonthly Decimal Recurmonthly
recurquarterly Decimal Recurquarterly
recurweekly Decimal Recurweekly
salesgroup String Salesgroup
salesreadiness String Salesreadiness
salesrep String Salesrep
shipaddress String Shipaddress
shipaddresslist String Shipaddresslist
shipisresidential String Shipisresidential
shipoverride String Shipoverride
shippingaddress String Shippingaddress
source String Source
status String Status
statusref String Statusref
subsidiary String Subsidiary
subsidiarytaxregnum String Subsidiarytaxregnum
syncpartnerteams Boolean Syncpartnerteams
syncsalesteams Boolean Syncsalesteams
taxdetailsoverride Boolean Taxdetailsoverride
taxpointdate Date Taxpointdate
taxpointdateoverride Boolean Taxpointdateoverride
taxregoverride Boolean Taxregoverride
title String Title
total String Total
totalcostestimate Decimal Totalcostestimate
trandate Date Trandate
tranid String Tranid
unbilledorders Decimal Unbilledorders
weightedtotal Decimal Weightedtotal
winlossreason String Winlossreason

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839