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.
account Dimension
The general ledger account associated with a transaction line.
account_id Metric
The internal ID of the general ledger account associated with a transaction line.
account_name Dimension
The name of the general ledger account associated with a transaction line.
account_number Dimension
The unique identifier for an account, often required when the 'Use Account Numbers' preference is enabled in NetSuite.
account_type Dimension
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.
advertiser Dimension
Reference to the advertiser entity for marketing or campaign records.
advertiser_name Dimension
The name of the advertiser.
agency Dimension
Reference to the advertising or marketing agency.
aging_bucket Dimension
Categorizes outstanding financial balances (e.g., invoices, bills) based on how long they have been past their due date. Common categories include 'Current', '1-30 Days Past Due', '31-60 Days Past Due', and '90+ Days Past Due', used for accounts receivable and accounts payable aging reports.
amount Metric
The monetary value of a transaction line item or a total, represented as a decimal number.
amount_credit Metric
The monetary amount of a credit applied.
amount_debit Metric
The monetary amount of a debit applied.
amount_unpaid Metric
The remaining balance on a transaction that has not yet been paid.
approval_status Dimension
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.
business_unit Dimension
An organizational segment or division within the company, used for departmental tracking and reporting.
class Metric
The classification of a transaction or record, used for reporting and categorization.
class.id Metric
The internal ID of the classification associated with a transaction or record.
class.links Dimension
A collection of links related to the associated classification record.
class.refName Dimension
The reference name or display name of the classification associated with a transaction or record.
client_id Dimension
Internal identifier for the client associated with a record.
client_line_of_business Dimension
The line of business associated with the client.
client_line_of_business_id Metric
Internal identifier for the client's line of business.
client_name Dimension
The name of the client.
client_vendor Dimension
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.
companyname Dimension
The name of the company for a customer or other entity record.
created_from_id Metric
The internal ID of the record from which the current record was created (e.g., an invoice created from a sales order).
currency Dimension
The currency used for the transaction or record, such as USD, EUR, or CAD. Requires the Multiple Currencies feature to be enabled.
customForm.id Metric
The internal ID of the custom form used for the record.
customForm.refName Dimension
The reference name or display name of the custom form used for the record.
customer Dimension
The customer associated with a transaction or other record.
customer.id Metric
The internal ID of the customer associated with a transaction or other record.
customer.links Dimension
A collection of links related to the associated customer record.
customer.refName Dimension
The reference name or display name of the customer associated with a transaction or other record.
date Dimension
A generic date field for a record or event.
days_overdue Metric
The number of days a transaction or payment is past its due date.
delivered_units Metric
The quantity of units delivered for an order or campaign.
department Metric
The department associated with a transaction or record, used for reporting and categorization.
department.id Metric
The internal ID of the department associated with a transaction or record.
department.links Dimension
A collection of links related to the associated department record.
department.refName Dimension
The reference name or display name of the department associated with a transaction or record.
department_id Dimension
The internal ID of the department.
document_number Dimension
The unique identifying number of a transaction document.
due_date Dimension
The date by which a payment or task is expected to be completed. For transactions, it is the date when payment is due.
email Dimension
The email address for an entity such as a customer or employee.
employee.id Metric
The internal ID of the employee associated with a record, such as a timesheet or transaction.
employee.links Dimension
A collection of links related to the associated employee record, providing navigation to related resources.
employee.refName Dimension
The reference name or display name of the employee associated with a record.
employee_business_unit Dimension
The specific business unit to which an employee is assigned.
employee_email Dimension
The email address of the employee.
employee_first_name Dimension
The first name of the employee.
employee_function Dimension
The functional role or department of an employee within the organization (e.g., Sales, Marketing, Finance).
employee_id Metric
The internal ID of the employee.
employee_job_title Dimension
The official job title held by an employee.
employee_last_name Dimension
The last name of the employee.
employee_name Dimension
The full name of the employee. In NetSuite, employee records contain a 'name' field.
employee_ns_id Dimension
The internal NetSuite ID for the employee record, used as a unique identifier for API calls.
employee_subsidiary Dimension
The subsidiary with which the employee is associated. This is often used for multi-company or global NetSuite instances.
employee_title Dimension
The job title of the employee.
entity_name Dimension
The name of the entity associated with a transaction or record, such as a customer, vendor, or employee.
exchangerate Metric
The exchange rate applied for transactions involving foreign currencies.
finance_revenue_account Dimension
A general ledger account used to record income generated from sales or services.
firstname Dimension
The first name of a person, such as an employee or contact.
formula Metric
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.
fullname Dimension
The full name of a person, such as an employee or contact.
function Dimension
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.
function_id Metric
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.
hours Metric
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.
hours_decimal Metric
The duration of a time entry recorded in decimal hours. This field is used to log time spent on a work package by an employee, with support for decimal values if the 'Use Days Instead of Hours for All Time Entries' feature is disabled in NetSuite.
id Metric
The unique internal identifier for the record.
isBillable Dimension
Indicates whether time or expenses are billable to a customer or project.
isExempt Dimension
Boolean flag indicating if a transaction or item is exempt from certain taxes or regulations.
isProductive Dimension
Boolean flag indicating if a resource's time is considered productive.
isUtilized Dimension
Boolean flag indicating if a resource has been utilized.
item Dimension
The item associated with a transaction line.
item.id Metric
The internal ID of the item associated with a transaction line.
item.links Dimension
A collection of links related to the associated item record.
item.refName Dimension
The reference name or display name of the item associated with a transaction line.
item_id Dimension
The internal ID of the item.
lastModifiedDate Dimension
The date and time when the record was last modified or updated.
lastname Dimension
The last name of a person, such as an employee or contact.
line_of_business Dimension
The specific line of business associated with a transaction or entity.
links Dimension
A collection of links related to the record, providing navigation to related resources.
location Dimension
The physical location associated with a transaction or record.
location.id Metric
The internal ID of the location associated with a transaction or record.
location.links Dimension
A collection of links related to the associated location record.
location.refName Dimension
The reference name or display name of the location associated with a transaction or record.
memo Dimension
A general text field used for notes, comments, or a brief description related to a record or transaction in NetSuite.
name Dimension
A generic field for the name of a record or entity.
ns_transaction_id Metric
The internal ID of the NetSuite transaction.
ns_transaction_line_id Dimension
The unique internal identifier for a specific line item within a transaction.
office Dimension
The office location associated with a record, such as an employee or transaction.
opp_client Dimension
The client associated with a sales opportunity.
opp_id Dimension
The unique internal identifier for an opportunity record, representing a sales or business opportunity.
opp_name Dimension
The name or title of the opportunity record, providing a descriptive label for the sales or business opportunity.
opportunity_id Dimension
The unique internal identifier for an Opportunity record in NetSuite, used to track potential sales deals.
opportunity_name Dimension
The descriptive name or title of a sales opportunity in NetSuite.
overrideRate Dimension
Boolean flag indicating if a custom or manual rate overrides the default rate.
parent_client_id Dimension
A unique identifier for the parent company or top-level client in a hierarchical client structure.
parent_client_name Dimension
The name of the parent company or top-level client in a hierarchical client structure.
period Dimension
The accounting period to which a transaction or time entry belongs.
period_id Dimension
The internal ID of the accounting period to which a transaction or time entry belongs.
price.id Metric
Internal identifier for the price level or specific price of an item.
price.links Dimension
Collection of links to the price record.
price.refName Dimension
Display name or reference name of the price level or specific price.
project_name Dimension
The name of the project associated with a task or record.
project_task Dimension
A specific activity or milestone within a project that needs to be tracked and completed.
project_task_id Metric
The internal ID of the project task.
sales_rep Dimension
The sales representative associated with a customer or transaction.
subsidiary Dimension
The subsidiary associated with the record, such as an employee, timesheet, or transaction.
subsidiary.id Metric
The internal ID of the subsidiary associated with the record.
subsidiary.links Dimension
A collection of links related to the associated subsidiary record.
subsidiary.refName Dimension
The reference name or display name of the subsidiary associated with the record.
subsidiary_id Dimension
The internal ID of the subsidiary.
supervisor_first_name Dimension
The first name of the employee's supervisor.
supervisor_id Metric
The internal ID of the employee's supervisor.
supervisor_last_name Dimension
The last name of the employee's supervisor.
supervisor_name Dimension
The full name of the employee's direct supervisor.
team_id Dimension
Internal identifier for a team.
team_name Dimension
The name of the team.
timeModified Dimension
The date and time when the record was last modified. For Timesheets, this is a read-only field.
timeType.id Dimension
The internal ID of the time type associated with a time entry or timesheet.
timeType.refName Dimension
The reference name or display name of the time type associated with a time entry or timesheet.
time_date Dimension
The specific date on which the time entry was recorded or the activity occurred. This can correspond to 'tranDate' in time records.
time_month Dimension
The calendar month component of a date, used for time-based reporting and analysis.
time_off_type Dimension
The category or reason for an employee's absence from work (e.g., vacation, sick leave, public holiday).
time_record Dimension
Reference to a time tracking record.
time_record_id Metric
Internal identifier for a time tracking record.
time_year Dimension
The calendar year component of a date, used for time-based reporting and analysis.
timebill_id Dimension
The unique internal ID for a Time Bill record, which tracks hours worked by an employee, often for billing purposes.
timesheet.id Metric
The internal ID of the timesheet record.
timesheet.links Dimension
A collection of links related to the associated timesheet record.
timesheet.refName Dimension
The reference name or display name of the timesheet record.
total_amount Metric
The grand total amount of a transaction in the transaction's currency.
tranDate Dimension
The transaction date of a record, often used for filtering.
tran_date Dimension
The date on which a transaction was recorded.
trandate Dimension
The transaction date of a record, often used for filtering.
transaction_currency Dimension
The currency used for the specific transaction.
transaction_type Dimension
The classification of a transaction, indicating its nature (e.g., Sales Order, Purchase Order, Invoice, Cash Sale, Journal Entry).
type Dimension
The type of a record or transaction (e.g., Sales Order, Invoice, Employee).
vendor_name Dimension
The name of the vendor associated with a transaction or record.
voided Dimension
Indicates whether a transaction has been voided.