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	The advertiser associated with a marketing campaign or related record.	dimension
advertiser_name	advertiser_name	The name of the advertiser associated with a marketing campaign or related record.	dimension
agency	agency	The agency associated with a marketing campaign or related record.	dimension
allocatedhours	allocatedhours	The number of hours allocated to an employee for a specific task or project within a timesheet. This field is typically read-only.	dimension
altname	altname	An alternative name for an employee or other entity, often used for display or search purposes.	dimension
amount_credit	amount_credit	The credit amount for a transaction line. This field is typically queried from the Transaction Lines table.	metric
amount_debit	amount_debit	The debit amount for a transaction line. This field is typically queried from the Transaction Lines table.	metric
approvalStatus	approvalStatus	The current status of a timesheet or time entry approval process, such as pending, approved, or rejected. This field is read-only for Timesheets.	dimension
approvalStatus.id	approvalStatus.id	The internal ID of the approval status for a timesheet or time entry.	metric
approvalStatus.refName	approvalStatus.refName	The reference name or display value of the approval status for a timesheet or time entry.	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	The internal ID of the client (customer) associated with a project or transaction.	dimension
client_line_of_business	client_line_of_business	The line of business for a client (customer).	dimension
client_line_of_business_id	client_line_of_business_id	The internal ID of the line of business for a client (customer).	metric
client_name	client_name	The name of the client (customer) associated with a project or transaction.	dimension
client_vendor	client_vendor		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, often referring to the transaction date or record creation date.	dimension
delivered_units	delivered_units		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
endDate	endDate	The end date of a period, such as the end date of a timesheet or a project task.	dimension
firstname	firstname	The first name of a person, such as an employee or contact.	dimension
foreigntotal	foreigntotal	The total amount of a transaction in a foreign currency.	metric
formula	formula		metric
fullname	fullname	The full name of a person, such as an employee or contact.	dimension
function	function	The function or role associated with a project task or resource.	dimension
function_id	function_id	The internal ID of the function or role associated with a project task or resource.	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	Indicates whether an employee or transaction is exempt from certain taxes or requirements.	dimension
isProductive	isProductive	Indicates whether an employee’s time is considered productive.	dimension
isUtilized	isUtilized		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 line of business associated with a record 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
lockstatus.id	lockstatus.id	The internal ID of the lock status for a timesheet, indicating if it’s locked for further modifications. This field is typically read-only.	dimension
lockstatus.refName	lockstatus.refName	The reference name or display value of the lock status for a timesheet.	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 an employee or record.	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	A custom rate that overrides the standard rate for a specific item or service.	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
periodname	periodname	The name of the accounting period to which a transaction or time entry belongs.	dimension
plannedhours	plannedhours	The number of hours planned for a specific task or project within a timesheet.	dimension
price.id	price.id	The internal ID of the price level or pricing item.	metric
price.links	price.links		dimension
price.refName	price.refName	The reference name or display name of the price level or pricing item.	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
rejectedhours	rejectedhours	The total number of hours rejected in a timesheet or time entry. This field is read-only for Timesheets.	dimension
sales_rep	sales_rep	The sales representative associated with a customer or transaction.	dimension
startDate	startDate	The start date of a period, such as the start date of a timesheet or a project task.	dimension
submittedhours	submittedhours	The total number of hours submitted in a timesheet or time entry. This field is read-only for Timesheets.	dimension
subsidiary	subsidiary	The subsidiary associated with the record, such as an employee, timesheet, or transaction.	metric
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	The unique identifier for a team in NetSuite, such as a sales team, marketing team, or project team, particularly relevant when ‘Team Selling’ or similar features are enabled.	dimension
team_name	team_name	The descriptive name of a team within NetSuite, corresponding to the ‘team_id’. This field provides the human-readable name for a specific 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	The ID of the individual time record entry.	dimension
time_record_id	time_record_id	The internal ID of the individual time record entry.	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
totalHours	totalHours	The total number of hours entered on a timesheet. This field is updated in real time and is read-only for Timesheets.	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
tranid	tranid	The unique identifying number of a transaction.	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
workcalendarhours	workcalendarhours	The number of hours from the employee’s work calendar. This field is typically read-only for Timesheets.	dimension