NetSuite: Most-used fields

The table below gives information about most-used fields that you can import from NetSuite. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Use in Adverity
accesslevel	accesslevel	dimension
account	account	metric
account_id	account_id	dimension
account_name	account_name	dimension
accountinglinetype	accountinglinetype	dimension
accountnumber	accountnumber	metric
accountsearchdisplayname	accountsearchdisplayname	dimension
accountsearchdisplaynamecopy	accountsearchdisplaynamecopy	dimension
acctnumber	acctnumber	dimension
accttype	accttype	dimension
actualshipdate	actualshipdate	dimension
advertiser	advertiser	dimension
advertiser_name	advertiser_name	dimension
agency	agency	dimension
alcoholrecipienttype	alcoholrecipienttype	dimension
allowattachments	allowattachments	dimension
allowinlinedeleting	allowinlinedeleting	dimension
allowinlineediting	allowinlineediting	dimension
allowquicksearch	allowquicksearch	dimension
altname	altname	dimension
altphone	altphone	dimension
amount	amount	metric
amount_credit	amount_credit	metric
amount_debit	amount_debit	metric
amountnet	amountnet	metric
amountunbilled	amountunbilled	metric
approvalstatus	approvalstatus	metric
assetaccount	assetaccount	metric
assigned	assigned	metric
atpmethod	atpmethod	dimension
availabletopartners	availabletopartners	dimension
averagecost	averagecost	metric
averagecostmli	averagecostmli	metric
balancesearch	balancesearch	metric
billexchratevarianceacct	billexchratevarianceacct	metric
billingaddress	billingaddress	metric
billingschedule	billingschedule	metric
billingstatus	billingstatus	dimension
billpricevarianceacct	billpricevarianceacct	metric
billqtyvarianceacct	billqtyvarianceacct	metric
binnumber	binnumber	metric
casetaskevent	casetaskevent	metric
cashflowrate	cashflowrate	dimension
category	category	metric
category1099misc	category1099misc	metric
class	class	metric
class.id	class.id	metric
class.links	class.links	dimension
class.refName	class.refName	dimension
classTranslation.links	classTranslation.links	dimension
cleared	cleared	dimension
cleareddate	cleareddate	dimension
client_id	client_id	dimension
client_line_of_business	client_line_of_business	dimension
client_line_of_business_id	client_line_of_business_id	dimension
client_name	client_name	dimension
client_vendor	client_vendor	dimension
closedate	closedate	dimension
comments	comments	dimension
commitinventory	commitinventory	metric
commitmentfirm	commitmentfirm	dimension
committedqtyperlocation	committedqtyperlocation	metric
committedqtyperseriallotnumber	committedqtyperseriallotnumber	metric
committedqtyperseriallotnumberlocation	committedqtyperseriallotnumberlocation	metric
company	company	metric
companyname	companyname	dimension
completeddate	completeddate	dimension
consolbalancesearch	consolbalancesearch	metric
consoldaysoverduesearch	consoldaysoverduesearch	metric
consoloverduebalancesearch	consoloverduebalancesearch	metric
consolunbilledorderssearch	consolunbilledorderssearch	metric
contact	contact	metric
copydescription	copydescription	dimension
cost	cost	metric
costaccountingstatus	costaccountingstatus	dimension
costestimatetype	costestimatetype	dimension
costingmethod	costingmethod	dimension
costingmethoddisplay	costingmethoddisplay	dimension
countinterval	countinterval	metric
couponcode	couponcode	metric
created	created	dimension
createdby	createdby	metric
createddate	createddate	dimension
createdfrom	createdfrom	metric
createjob	createjob	dimension
creditforeignamount	creditforeignamount	metric
creditholdoverride	creditholdoverride	dimension
creditlimit	creditlimit	metric
currency	currency	metric
customForm.id	customForm.id	metric
customForm.refName	customForm.refName	dimension
customer	customer	metric
customer.id	customer.id	metric
customer.links	customer.links	dimension
customer.refName	customer.refName	dimension
customer_id	customer_id	dimension
customer_name	customer_name	dimension
customform	customform	metric
customtype	customtype	metric
date	date	dimension
dateclosed	dateclosed	dimension
datecreated	datecreated	dimension
daysopen	daysopen	metric
daysoverduesearch	daysoverduesearch	metric
debitforeignamount	debitforeignamount	metric
defaultbillingaddress	defaultbillingaddress	metric
defaultshippingaddress	defaultshippingaddress	metric
deferredrevenueaccount	deferredrevenueaccount	metric
deferrevrec	deferrevrec	dimension
delivered_units	delivered_units	metric
department	department	metric
department.id	department.id	metric
department.links	department.links	dimension
department.refName	department.refName	dimension
department_id	department_id	dimension
deploymentname	deploymentname	dimension
description	description	dimension
directrevenueposting	directrevenueposting	dimension
discountdate	discountdate	dimension
displayfield	displayfield	dimension
displayname	displayname	dimension
displaynamewithhierarchy	displaynamewithhierarchy	dimension
division_id	division_id	dimension
document_number	document_number	dimension
documentnumber	documentnumber	metric
donotdisplayline	donotdisplayline	dimension
donotprintline	donotprintline	dimension
dontshowprice	dontshowprice	dimension
duedate	duedate	dimension
duplicate	duplicate	dimension
eliminate	eliminate	dimension
email	email	dimension
emailpreference	emailpreference	dimension
emailtransactions	emailtransactions	dimension
employee	employee	metric
employee.id	employee.id	metric
employee.links	employee.links	dimension
employee.refName	employee.refName	dimension
employee_email	employee_email	dimension
employee_first_name	employee_first_name	dimension
employee_id	employee_id	dimension
employee_last_name	employee_last_name	dimension
employee_title	employee_title	dimension
enablemailmerge	enablemailmerge	dimension
enddate	enddate	dimension
enforceminqtyinternally	enforceminqtyinternally	dimension
entity	entity	metric
entityid	entityid	dimension
entitynumber	entitynumber	metric
entitystatus	entitystatus	metric
entitytitle	entitytitle	dimension
exchangerate	exchangerate	metric
excludefromraterequest	excludefromraterequest	dimension
excludefromsitemap	excludefromsitemap	dimension
expenseaccount	expenseaccount	metric
externalid	externalid	dimension
externalrolepermissionlevel	externalrolepermissionlevel	metric
fax	fax	dimension
faxtransactions	faxtransactions	dimension
featureddescription	featureddescription	dimension
firstname	firstname	dimension
firstsaledate	firstsaledate	dimension
foreignamount	foreignamount	metric
foreignamountpaid	foreignamountpaid	metric
foreignamountpaidnopost	foreignamountpaidnopost	metric
foreignamountunpaid	foreignamountunpaid	metric
foreignpaymentamountunused	foreignpaymentamountunused	metric
foreignpaymentamountused	foreignpaymentamountused	metric
foreigntotal	foreigntotal	metric
forinvoicegrouping	forinvoicegrouping	dimension
formula	formula	metric
froogleproductfeed	froogleproductfeed	dimension
fulfillable	fulfillable	dimension
fullname	fullname	dimension
function	function	dimension
function_id	function_id	dimension
fxcost	fxcost	metric
gainlossaccount	gainlossaccount	metric
generalrate	generalrate	dimension
generateaccruals	generateaccruals	dimension
giveaccess	giveaccess	dimension
globalsubscriptionstatus	globalsubscriptionstatus	metric
group	group	metric
groupinvoices	groupinvoices	dimension
hascostline	hascostline	dimension
hasfulfillableitems	hasfulfillableitems	dimension
hours	hours	metric
id	id	dimension
impressions	impressions	metric
includeChildren	includeChildren	dimension
includechildren	includechildren	dimension
includeinforecast	includeinforecast	dimension
includename	includename	dimension
incomeaccount	incomeaccount	metric
intercoexpenseaccount	intercoexpenseaccount	metric
intercoincomeaccount	intercoincomeaccount	metric
internalId	internalId	metric
internalid	internalid	metric
inventory	inventory	dimension
invtcountinterval	invtcountinterval	metric
isBillable	isBillable	dimension
isExempt	isExempt	dimension
isInactive	isInactive	dimension
isProductive	isProductive	dimension
isUtilized	isUtilized	dimension
isautogeneratedrepresentingentity	isautogeneratedrepresentingentity	dimension
isbillable	isbillable	dimension
isclosed	isclosed	dimension
iscogs	iscogs	dimension
iscustomglline	iscustomglline	dimension
isdonationitem	isdonationitem	dimension
isdropshipitem	isdropshipitem	dimension
isexempt	isexempt	dimension
isfinchrg	isfinchrg	dimension
isfulfillable	isfulfillable	dimension
isfullyshipped	isfullyshipped	dimension
isfxvariance	isfxvariance	dimension
isinactive	isinactive	dimension
isinventoryaffecting	isinventoryaffecting	dimension
isonline	isonline	dimension
isordered	isordered	dimension
isperson	isperson	dimension
isproductive	isproductive	dimension
isreversal	isreversal	dimension
isspecialorderitem	isspecialorderitem	dimension
issummary	issummary	dimension
isunavailable	isunavailable	dimension
isutilized	isutilized	dimension
item	item	dimension
item.id	item.id	metric
item.links	item.links	dimension
item.refName	item.refName	dimension
item_id	item_id	dimension
item_name	item_name	dimension
itemclass	itemclass	metric
itemcount	itemcount	metric
itemid	itemid	dimension
itemname	itemname	dimension
itemtype	itemtype	dimension
kitcomponent	kitcomponent	dimension
kpi	kpi	dimension
language	language	dimension
lastModifiedDate	lastModifiedDate	dimension
lastmodified	lastmodified	dimension
lastmodifiedby	lastmodifiedby	metric
lastmodifieddate	lastmodifieddate	dimension
lastname	lastname	dimension
lastpurchaseprice	lastpurchaseprice	metric
lastpurchasepricemli	lastpurchasepricemli	metric
lastquantityavailablechange	lastquantityavailablechange	dimension
lastsaledate	lastsaledate	dimension
leadsource	leadsource	metric
line_of_business	line_of_business	dimension
lineclass	lineclass	metric
linecreateddate	linecreateddate	dimension
linelastmodifieddate	linelastmodifieddate	dimension
linesequencenumber	linesequencenumber	metric
linkedtrackingnumberlist	linkedtrackingnumberlist	metric
links	links	dimension
location	location	dimension
location.id	location.id	metric
location.links	location.links	dimension
location.refName	location.refName	dimension
mainline	mainline	dimension
manufacturer	manufacturer	dimension
master_parent_id	master_parent_id	dimension
matchbilltoreceipt	matchbilltoreceipt	dimension
matrixitemnametemplate	matrixitemnametemplate	dimension
matrixtype	matrixtype	dimension
memo	memo	dimension
memorized	memorized	dimension
message	message	dimension
name	name	dimension
needsbill	needsbill	dimension
netamount	netamount	metric
nextagproductfeed	nextagproductfeed	dimension
nextbilldate	nextbilldate	dimension
nextcountdate	nextcountdate	dimension
nextinvtcountdate	nextinvtcountdate	dimension
nexus	nexus	metric
nopermissionrequired	nopermissionrequired	dimension
ns_transaction_id	ns_transaction_id	dimension
number	number	metric
office	office	dimension
oldcommitmentfirm	oldcommitmentfirm	dimension
oncredithold	oncredithold	dimension
onhandvaluemli	onhandvaluemli	metric
opportunity	opportunity	metric
opportunity_id	opportunity_id	dimension
opportunity_name	opportunity_name	dimension
ordpicked	ordpicked	dimension
othername	othername	metric
otherrefnum	otherrefnum	dimension
overduebalancesearch	overduebalancesearch	metric
overrideRate	overrideRate	dimension
overriderate	overriderate	dimension
owner	owner	metric
owner.id	owner.id	metric
owner.links	owner.links	dimension
owner.refName	owner.refName	dimension
parent	parent	metric
parent.id	parent.id	metric
parent.links	parent.links	dimension
parent.refName	parent.refName	dimension
partner	partner	metric
paymenthold	paymenthold	dimension
paymentmethod	paymentmethod	metric
paymentoption	paymentoption	metric
percentcomplete	percentcomplete	metric
percenttimecomplete	percenttimecomplete	metric
period	period	dimension
period_id	period_id	dimension
periodclosed	periodclosed	dimension
phone	phone	dimension
ponumber	ponumber	dimension
posting	posting	dimension
postingperiod	postingperiod	metric
preferredlocation	preferredlocation	metric
prevdate	prevdate	dimension
price	price	metric
price.id	price.id	metric
price.links	price.links	dimension
price.refName	price.refName	dimension
pricinggroup	pricinggroup	metric
printedpickingticket	printedpickingticket	dimension
printitems	printitems	dimension
printtransactions	printtransactions	dimension
priority	priority	dimension
probability	probability	metric
processedbyrevcommit	processedbyrevcommit	dimension
project_name	project_name	dimension
project_task_id	project_task_id	dimension
publicpermissionlevel	publicpermissionlevel	metric
purchasedescription	purchasedescription	dimension
quantity	quantity	metric
quantityavailable	quantityavailable	metric
quantitybackordered	quantitybackordered	metric
quantitybilled	quantitybilled	metric
quantitycommitted	quantitycommitted	metric
quantityintransitexternal	quantityintransitexternal	metric
quantityonhand	quantityonhand	metric
quantityonorder	quantityonorder	metric
quantitypicked	quantitypicked	metric
quantityrejected	quantityrejected	metric
quantityshiprecv	quantityshiprecv	metric
rate	rate	metric
rateamount	rateamount	metric
ratepercent	ratepercent	metric
receivablesaccount	receivablesaccount	metric
reconcilewithmatching	reconcilewithmatching	dimension
recordid	recordid	metric
recordtype	recordtype	dimension
reminderminutes	reminderminutes	metric
remindertype	remindertype	dimension
representingsubsidiary	representingsubsidiary	metric
resalenumber	resalenumber	dimension
revalue	revalue	dimension
revenuerecognitionrule	revenuerecognitionrule	metric
revrecforecastrule	revrecforecastrule	metric
sales_order_id	sales_order_id	dimension
sales_rep	sales_rep	dimension
saleunit	saleunit	metric
scriptId	scriptId	dimension
scriptid	scriptid	dimension
searchstage	searchstage	dimension
seasonaldemand	seasonaldemand	dimension
settlementamount	settlementamount	metric
shipcarrier	shipcarrier	dimension
shipcomplete	shipcomplete	dimension
shipdate	shipdate	dimension
shipindividually	shipindividually	dimension
shipmethod	shipmethod	metric
shippingaddress	shippingaddress	metric
shippingcarrier	shippingcarrier	dimension
shoppingproductfeed	shoppingproductfeed	dimension
shopzillaproductfeed	shopzillaproductfeed	dimension
showdefaultdonationamount	showdefaultdonationamount	dimension
shownotes	shownotes	dimension
skey	skey	dimension
source	source	dimension
startdate	startdate	dimension
status	status	dimension
stockdescription	stockdescription	dimension
storedescription	storedescription	dimension
storedetaileddescription	storedetaileddescription	dimension
storedisplayimage	storedisplayimage	metric
storedisplayname	storedisplayname	dimension
storedisplaythumbnail	storedisplaythumbnail	metric
subsidiary	subsidiary	metric
subsidiary.id	subsidiary.id	metric
subsidiary.links	subsidiary.links	dimension
subsidiary.refName	subsidiary.refName	dimension
subsidiary_id	subsidiary_id	dimension
subtype	subtype	dimension
supervisor	supervisor	dimension
supervisor_first_name	supervisor_first_name	dimension
supervisor_id	supervisor_id	dimension
supervisor_last_name	supervisor_last_name	dimension
supplyreplenishmentmethod	supplyreplenishmentmethod	dimension
targeting	targeting	dimension
taxline	taxline	dimension
team_id	team_id	dimension
team_name	team_name	dimension
terms	terms	metric
timeModified	timeModified	dimension
timeType.id	timeType.id	dimension
timeType.refName	timeType.refName	dimension
time_record	time_record	dimension
time_record_id	time_record_id	dimension
timedevent	timedevent	dimension
timemodified	timemodified	dimension
timeofftype	timeofftype	metric
timesheet	timesheet	metric
timesheet.id	timesheet.id	metric
timesheet.links	timesheet.links	dimension
timesheet.refName	timesheet.refName	dimension
timetype	timetype	dimension
title	title	dimension
tobeprinted	tobeprinted	dimension
toplevelparent	toplevelparent	metric
totalquantityonhand	totalquantityonhand	metric
totalvalue	totalvalue	metric
tracklandedcost	tracklandedcost	dimension
tranDate	tranDate	dimension
trandate	trandate	dimension
trandisplayname	trandisplayname	dimension
tranid	tranid	dimension
tranline	tranline	metric
transaction	transaction	metric
transaction_date	transaction_date	dimension
transactiondiscount	transactiondiscount	dimension
transactionnumber	transactionnumber	dimension
type	type	dimension
typebaseddocumentnumber	typebaseddocumentnumber	dimension
unbilledorderssearch	unbilledorderssearch	metric
uniquekey	uniquekey	metric
units	units	dimension
unitstype	unitstype	metric
unsubscribe	unsubscribe	dimension
upccode	upccode	metric
urlcomponent	urlcomponent	dimension
usebins	usebins	dimension
usemarginalrates	usemarginalrates	dimension
usepermissions	usepermissions	dimension
userevenuearrangement	userevenuearrangement	dimension
value	value	metric
vendor	vendor	metric
vendor_name	vendor_name	dimension
vendorname	vendorname	dimension
visibletocustomer	visibletocustomer	dimension
void	void	dimension
voided	voided	dimension
vsoedelivered	vsoedelivered	dimension
vsoesopgroup	vsoesopgroup	dimension
website	website	metric
weight	weight	metric
weightunit	weightunit	metric
weightunits	weightunits	dimension
yahooproductfeed	yahooproductfeed	dimension