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	The general ledger account associated with a transaction line.	dimension
account_id	account_id	The internal ID of the general ledger account associated with a transaction line.	metric
account_name	account_name	The name of the general ledger account associated with a transaction line.	dimension
advertiser	advertiser	Reference to the advertiser entity for marketing or campaign records.	dimension
advertiser_name	advertiser_name	The name of the advertiser.	dimension
agency	agency	Reference to the advertising or marketing agency.	dimension
amount_credit	amount_credit	The monetary amount of a credit applied.	metric
amount_debit	amount_debit	The monetary amount of a debit applied.	metric
class	class	The classification of a transaction or record, used for reporting and categorization.	metric
class.id	class.id	The internal ID of the classification associated with a transaction or record.	metric
class.links	class.links	A collection of links related to the associated classification record.	dimension
class.refName	class.refName	The reference name or display name of the classification associated with a transaction or record.	dimension
client_id	client_id	Internal identifier for the client associated with a record.	dimension
client_line_of_business	client_line_of_business	The line of business associated with the client.	dimension
client_line_of_business_id	client_line_of_business_id	Internal identifier for the client’s line of business.	metric
client_name	client_name	The name of the client.	dimension
client_vendor	client_vendor	This field identifies a business entity in NetSuite, which can be either a customer (client) for sales and CRM purposes or a supplier (vendor) for procurement and financial transactions.	dimension
companyname	companyname	The name of the company for a customer or other entity record.	dimension
created_from_id	created_from_id	The internal ID of the record from which the current record was created (e.g., an invoice created from a sales order).	metric
customForm.id	customForm.id	The internal ID of the custom form used for the record.	metric
customForm.refName	customForm.refName	The reference name or display name of the custom form used for the record.	dimension
customer	customer	The customer associated with a transaction or other record.	dimension
customer.id	customer.id	The internal ID of the customer associated with a transaction or other record.	metric
customer.links	customer.links	A collection of links related to the associated customer record.	dimension
customer.refName	customer.refName	The reference name or display name of the customer associated with a transaction or other record.	dimension
date	date	A generic date field for a record or event.	dimension
delivered_units	delivered_units	The quantity of units delivered for an order or campaign.	metric
department	department	The department associated with a transaction or record, used for reporting and categorization.	metric
department.id	department.id	The internal ID of the department associated with a transaction or record.	metric
department.links	department.links	A collection of links related to the associated department record.	dimension
department.refName	department.refName	The reference name or display name of the department associated with a transaction or record.	dimension
department_id	department_id	The internal ID of the department.	dimension
document_number	document_number	The unique identifying number of a transaction document.	dimension
email	email	The email address for an entity such as a customer or employee.	dimension
employee.id	employee.id	The internal ID of the employee associated with a record, such as a timesheet or transaction.	metric
employee.links	employee.links	A collection of links related to the associated employee record, providing navigation to related resources.	dimension
employee.refName	employee.refName	The reference name or display name of the employee associated with a record.	dimension
employee_email	employee_email	The email address of the employee.	dimension
employee_first_name	employee_first_name	The first name of the employee.	dimension
employee_id	employee_id	The internal ID of the employee.	metric
employee_last_name	employee_last_name	The last name of the employee.	dimension
employee_title	employee_title	The job title of the employee.	dimension
firstname	firstname	The first name of a person, such as an employee or contact.	dimension
formula	formula	This field enables dynamic calculations and data manipulation using expressions, SQL functions, or SuiteScript functions. It can be used in saved searches for custom computed columns, in workflow conditions, or as custom record fields to derive values based on other fields, constants, or conditional logic.	metric
fullname	fullname	The full name of a person, such as an employee or contact.	dimension
function	function	This field represents a specific operation or command that can be executed to process data. In NetSuite, functions are commonly used within formulas or SuiteQL queries to perform calculations, data conversions, date arithmetic, or to retrieve display values for fields. Examples include SQL functions and NetSuite’s built-in SuiteQL functions.	dimension
function_id	function_id	Internal identifier for the business function or role.	metric
hours	hours	The actual time, in hours, recorded or spent on a specific task or project. This corresponds to fields like ‘actualWork’ or ‘actualTime’ found in NetSuite Project Task or Project records.	metric
id	id	The unique internal identifier for the record.	metric
isBillable	isBillable	Indicates whether time or expenses are billable to a customer or project.	dimension
isExempt	isExempt	Boolean flag indicating if a transaction or item is exempt from certain taxes or regulations.	dimension
isProductive	isProductive	Boolean flag indicating if a resource’s time is considered productive.	dimension
isUtilized	isUtilized	Boolean flag indicating if a resource has been utilized.	dimension
item	item	The item associated with a transaction line.	dimension
item.id	item.id	The internal ID of the item associated with a transaction line.	metric
item.links	item.links	A collection of links related to the associated item record.	dimension
item.refName	item.refName	The reference name or display name of the item associated with a transaction line.	dimension
item_id	item_id	The internal ID of the item.	dimension
lastModifiedDate	lastModifiedDate	The date and time when the record was last modified or updated.	dimension
lastname	lastname	The last name of a person, such as an employee or contact.	dimension
line_of_business	line_of_business	The specific line of business associated with a transaction or entity.	dimension
links	links	A collection of links related to the record, providing navigation to related resources.	dimension
location	location	The physical location associated with a transaction or record.	dimension
location.id	location.id	The internal ID of the location associated with a transaction or record.	metric
location.links	location.links	A collection of links related to the associated location record.	dimension
location.refName	location.refName	The reference name or display name of the location associated with a transaction or record.	dimension
memo	memo	A general text field used for notes, comments, or a brief description related to a record or transaction in NetSuite.	dimension
name	name	A generic field for the name of a record or entity.	dimension
ns_transaction_id	ns_transaction_id	The internal ID of the NetSuite transaction.	metric
office	office	The office location associated with a record, such as an employee or transaction.	dimension
opportunity_id	opportunity_id	The unique internal identifier for an Opportunity record in NetSuite, used to track potential sales deals.	dimension
opportunity_name	opportunity_name	The descriptive name or title of a sales opportunity in NetSuite.	dimension
overrideRate	overrideRate	Boolean flag indicating if a custom or manual rate overrides the default rate.	dimension
period	period	The accounting period to which a transaction or time entry belongs.	dimension
period_id	period_id	The internal ID of the accounting period to which a transaction or time entry belongs.	dimension
price.id	price.id	Internal identifier for the price level or specific price of an item.	metric
price.links	price.links	Collection of links to the price record.	dimension
price.refName	price.refName	Display name or reference name of the price level or specific price.	dimension
project_name	project_name	The name of the project associated with a task or record.	dimension
project_task_id	project_task_id	The internal ID of the project task.	metric
sales_rep	sales_rep	The sales representative associated with a customer or transaction.	dimension
subsidiary	subsidiary	The subsidiary associated with the record, such as an employee, timesheet, or transaction.	dimension
subsidiary.id	subsidiary.id	The internal ID of the subsidiary associated with the record.	metric
subsidiary.links	subsidiary.links	A collection of links related to the associated subsidiary record.	dimension
subsidiary.refName	subsidiary.refName	The reference name or display name of the subsidiary associated with the record.	dimension
subsidiary_id	subsidiary_id	The internal ID of the subsidiary.	dimension
supervisor_first_name	supervisor_first_name	The first name of the employee’s supervisor.	dimension
supervisor_id	supervisor_id	The internal ID of the employee’s supervisor.	metric
supervisor_last_name	supervisor_last_name	The last name of the employee’s supervisor.	dimension
team_id	team_id	Internal identifier for a team.	dimension
team_name	team_name	The name of the team.	dimension
timeModified	timeModified	The date and time when the record was last modified. For Timesheets, this is a read-only field.	dimension
timeType.id	timeType.id	The internal ID of the time type associated with a time entry or timesheet.	dimension
timeType.refName	timeType.refName	The reference name or display name of the time type associated with a time entry or timesheet.	dimension
time_record	time_record	Reference to a time tracking record.	dimension
time_record_id	time_record_id	Internal identifier for a time tracking record.	metric
timesheet.id	timesheet.id	The internal ID of the timesheet record.	metric
timesheet.links	timesheet.links	A collection of links related to the associated timesheet record.	dimension
timesheet.refName	timesheet.refName	The reference name or display name of the timesheet record.	dimension
tranDate	tranDate	The transaction date of a record, often used for filtering.	dimension
trandate	trandate	The transaction date of a record, often used for filtering.	dimension
type	type	The type of a record or transaction (e.g., Sales Order, Invoice, Employee).	dimension
vendor_name	vendor_name	The name of the vendor associated with a transaction or record.	dimension
voided	voided	Indicates whether a transaction has been voided.	dimension