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
account_number	account_number	The unique identifier for an account, often required when the ‘Use Account Numbers’ preference is enabled in NetSuite.	dimension
account_type	account_type	The classification of a financial account, such as Bank, Accounts Receivable, Inventory, Income, or Expense. This field specifies how the account functions within the accounting system.	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
aging_bucket	aging_bucket		dimension
amount	amount	The monetary value of a transaction line item or a total, represented as a decimal number.	metric
amount_credit	amount_credit	The monetary amount of a credit applied.	metric
amount_debit	amount_debit	The monetary amount of a debit applied.	metric
amount_unpaid	amount_unpaid	The remaining balance on a transaction that has not yet been paid.	metric
approval_status	approval_status	The current approval status of a record or transaction, indicating if it has been approved, pending, or rejected. For time-related records, this can indicate whether hours are approved or rejected.	dimension
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
currency	currency	The currency used for the transaction or record, such as USD, EUR, or CAD. Requires the Multiple Currencies feature to be enabled.	dimension
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
days_overdue	days_overdue	The number of days a transaction or payment is past its due date.	metric
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
due_date	due_date	The date by which a payment or task is expected to be completed. For transactions, it is the date when payment is due.	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_business_unit	employee_business_unit	The business unit associated with the employee. NetSuite uses classifications like departments, classes, and locations for categorization, so ‘business_unit’ likely maps to one of these or a custom field.	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_function	employee_function		dimension
employee_id	employee_id	The internal ID of the employee.	metric
employee_job_title	employee_job_title		dimension
employee_last_name	employee_last_name	The last name of the employee.	dimension
employee_name	employee_name	The full name of the employee. In NetSuite, employee records contain a ‘name’ field.	dimension
employee_ns_id	employee_ns_id	The internal NetSuite ID for the employee record, used as a unique identifier for API calls.	dimension
employee_subsidiary	employee_subsidiary	The subsidiary with which the employee is associated. This is often used for multi-company or global NetSuite instances.	dimension
employee_title	employee_title	The job title of the employee.	dimension
entity_name	entity_name	The name of the entity associated with a transaction or record, such as a customer, vendor, or employee.	dimension
exchangerate	exchangerate	The exchange rate applied for transactions involving foreign currencies.	metric
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	The unique internal identifier for a specific NetSuite feature or functional area. This field helps categorize and manage data related to various business processes, such as marketing automation, project management, or other operational functions.	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
hours_decimal	hours_decimal	The total number of hours recorded in decimal format. For time tracking, NetSuite typically records ‘hours’ which can be represented as a duration or decimal.	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
ns_transaction_line_id	ns_transaction_line_id	The unique internal identifier for a specific line item within a transaction.	dimension
office	office	The office location associated with a record, such as an employee or transaction.	dimension
opp_id	opp_id	The unique internal identifier for an opportunity record, representing a sales or business opportunity.	dimension
opp_name	opp_name	The name or title of the opportunity record, providing a descriptive label for the sales or business opportunity.	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
parent_client_id	parent_client_id		dimension
parent_client_name	parent_client_name		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	project_task	A specific activity or milestone within a project that needs to be tracked and completed.	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
supervisor_name	supervisor_name	The name of the employee’s direct supervisor. NetSuite employee records can reference an ‘approver’ field which might correspond to a 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_date	time_date	The specific date on which the time entry was recorded or the activity occurred. This can correspond to ‘tranDate’ in time records.	dimension
time_month	time_month		dimension
time_off_type	time_off_type		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
time_year	time_year		dimension
timebill_id	timebill_id	The unique internal ID for a Time Bill record, which tracks hours worked by an employee, often for billing purposes.	dimension
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
total_amount	total_amount	The grand total amount of a transaction in the transaction’s currency.	metric
tranDate	tranDate	The transaction date of a record, often used for filtering.	dimension
tran_date	tran_date	The date on which a transaction was recorded.	dimension
trandate	trandate	The transaction date of a record, often used for filtering.	dimension
transaction_currency	transaction_currency	The currency used for the specific transaction.	dimension
transaction_type	transaction_type	The classification of a transaction, indicating its nature (e.g., Sales Order, Purchase Order, Invoice, Cash Sale, Journal Entry).	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