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	Description	Use in Adverity
account	account	A financial account used in the transaction, typically from the chart of accounts.	metric
actualshipdate	actualshipdate	The actual date when an order or items were shipped.	dimension
advertiser_name	advertiser_name	The full name of the advertiser associated with a marketing campaign or sales opportunity.	dimension
amount	amount	A monetary amount associated with a transaction or line item.	metric
amountpaid	amountpaid	The total amount that has been paid on a transaction, such as an invoice.	metric
amountremaining	amountremaining	The remaining balance or outstanding amount on a transaction.	metric
authcode	authcode	The authorization code for a credit card transaction, typically provided by the payment gateway.	dimension
billingaddress	billingaddress	The billing address associated with a transaction or entity.	metric
ccapproved	ccapproved	Indicates whether the credit card transaction has been approved.	dimension
ccavsstreetmatch	ccavsstreetmatch	The Address Verification Services (AVS) result code indicating if the provided street address matches the credit card’s billing address.	dimension
ccavszipmatch	ccavszipmatch	The Address Verification Services (AVS) result code indicating if the provided zip code matches the credit card’s billing address.	dimension
ccexpiredate	ccexpiredate	The expiration date of the credit card, typically in MM/YYYY format.	dimension
ccname	ccname	The name of the cardholder as it appears on the credit card.	dimension
ccstreet	ccstreet	The street address used for the credit card transaction, usually the billing street address.	dimension
cczipcode	cczipcode	The zip code used for the credit card transaction, usually the billing zip code.	dimension
checknumber	checknumber	The check number associated with a payment or transaction.	dimension
client_line_of_business	client_line_of_business	The primary industry or business segment of the client.	dimension
client_line_of_business_id	client_line_of_business_id	The internal identifier for the line of business associated with a client.	metric
companyid	companyid	The unique identifier for a company or entity within NetSuite.	metric
count	count		metric
createdby	createdby		dimension
createddate	createddate		dimension
createdfrom	createdfrom		metric
currency	currency		dimension
customer_name	customer_name		dimension
department	department	A reference to the department record associated with a transaction or employee.	dimension
discountamount	discountamount	The monetary amount of discount applied to a transaction.	metric
discountdate	discountdate		dimension
duedate	duedate		dimension
email	email	The email address associated with a contact, customer, or employee.	dimension
emailaddr	emailaddr	The email address associated with a customer, contact, or transaction.	dimension
entity	entity		metric
estgrossprofit	estgrossprofit	The estimated gross profit for a transaction, calculated as revenue minus estimated cost.	metric
estgrossprofitpercent	estgrossprofitpercent	The estimated gross profit expressed as a percentage of revenue.	metric
exchangerate	exchangerate		metric
externalid	externalid		dimension
fax	fax	The fax number associated with a contact or company.	dimension
handlingcost	handlingcost	The cost incurred for handling items or a transaction.	metric
handlingtaxcode	handlingtaxcode	The tax code applied to handling costs for a transaction.	metric
hours	hours	The number of hours recorded for a time entry or task.	metric
id	id	The internal ID of the record, a unique identifier generated by NetSuite.	dimension
integrationid	integrationid	An identifier used for linking records across different integrated systems or for internal integration purposes.	metric
isrecurringpayment	isrecurringpayment	A boolean indicator specifying whether a payment is part of a recurring payment schedule.	dimension
istaxable	istaxable	A boolean indicator specifying whether an item or transaction is subject to tax.	dimension
lastmodifiedby	lastmodifiedby		metric
lastmodifieddate	lastmodifieddate		dimension
leadsource	leadsource		metric
linkedtrackingnumberlist	linkedtrackingnumberlist		dimension
links	links	An array of links to related resources for the current record, providing navigation to further details or actions.	dimension
location	location		dimension
memo	memo	A short note or description for a transaction or record.	dimension
nextbill	nextbill	The date when the next billing cycle or payment is due for a recurring transaction or subscription.	dimension
number	number		dimension
opportunity_id	opportunity_id	The internal identifier of the associated opportunity record.	dimension
opportunity_name	opportunity_name	The name or title of the opportunity.	dimension
ordpicked	ordpicked		dimension
otherrefnum	otherrefnum		dimension
partner	partner	A reference to the partner record associated with a transaction or customer.	metric
paymenteventdate	paymenteventdate	The date and time when a payment processing event occurred.	dimension
paymenteventholdreason	paymenteventholdreason	The reason why a payment event is currently on hold.	dimension
paymenteventpurchasedatasent	paymenteventpurchasedatasent	Indicates whether purchase data was sent to the payment gateway for a payment event.	dimension
paymenteventresult	paymenteventresult	The outcome or status of a payment processing event (e.g., approved, declined).	dimension
paymenteventtype	paymenteventtype	The type or category of the payment processing event (e.g., authorization, capture).	dimension
paymentmethod	paymentmethod		metric
paymentoption	paymentoption		metric
paymentprocessingprofile	paymentprocessingprofile	The profile used to define payment processing parameters, such as the associated payment gateway.	metric
postingperiod	postingperiod		metric
prevdate	prevdate		dimension
quantity	quantity		metric
rate	rate		metric
saleseffectivedate	saleseffectivedate	The date that determines which commission plan and historical sales team a transaction applies to.	dimension
salesperson	salesperson	The sales representative associated with a transaction or customer.	dimension
salesrep	salesrep	The sales representative responsible for the transaction or customer.	dimension
shipaddress	shipaddress	The shipping address for a transaction.	dimension
shipcomplete	shipcomplete		dimension
shipdate	shipdate		dimension
shipmethod	shipmethod		dimension
shippingaddress	shippingaddress		metric
shippingcost	shippingcost	The cost associated with shipping items for a transaction.	metric
shippingtaxcode	shippingtaxcode	The tax code applied to shipping costs for a transaction.	metric
source	source	A reference to the source record, indicating the origin of data or a transaction.	dimension
status	status		dimension
subsidiary	subsidiary		metric
tax2total	tax2total	The total amount for a secondary tax component on a transaction.	metric
taxitem	taxitem	The specific tax item or component applied to a transaction.	metric
taxrate	taxrate	The percentage rate of tax applied to taxable items or services.	metric
taxtotal	taxtotal	The total amount of tax applied to a transaction.	metric
terms	terms	A reference to the payment terms record (e.g., Net 30, Due on Receipt).	metric
tobeemailed	tobeemailed	A boolean indicator specifying whether the transaction document should be emailed.	dimension
tobefaxed	tobefaxed	A boolean indicator specifying whether the transaction document should be faxed.	dimension
tobeprinted	tobeprinted		dimension
total	total	The total amount of a transaction, including taxes, shipping, and handling.	metric
totalcostestimate	totalcostestimate	The estimated total cost of a transaction, including all line items.	metric
trackingnumberlist	trackingnumberlist	A list of tracking numbers associated with the shipment of items.	metric
trandate	trandate		dimension
tranid	tranid		dimension
transactionnumber	transactionnumber		dimension
type	type		dimension
voided	voided		dimension