NetSuite: Most-used fields

The general ledger account associated with a transaction line.

The internal ID of the general ledger account associated with a transaction line.

The name of the general ledger account associated with a transaction line.

The unique identifier for an account, often required when the 'Use Account Numbers' preference is enabled in NetSuite.

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.

Reference to the advertiser entity for marketing or campaign records.

The name of the advertiser.

Reference to the advertising or marketing agency.

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.

The monetary value of a transaction line item or a total, represented as a decimal number.

The monetary amount of a credit applied.

The monetary amount of a debit applied.

The remaining balance on a transaction that has not yet been paid.

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.

An organizational segment or division within the company, used for departmental tracking and reporting.

The classification of a transaction or record, used for reporting and categorization.

The internal ID of the classification associated with a transaction or record.

A collection of links related to the associated classification record.

The reference name or display name of the classification associated with a transaction or record.

Internal identifier for the client associated with a record.

The line of business associated with the client.

Internal identifier for the client's line of business.

The name of the client.

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.

The name of the company for a customer or other entity record.

The internal ID of the record from which the current record was created (e.g., an invoice created from a sales order).

The currency used for the transaction or record, such as USD, EUR, or CAD. Requires the Multiple Currencies feature to be enabled.

The internal ID of the custom form used for the record.

The reference name or display name of the custom form used for the record.

The customer associated with a transaction or other record.

The internal ID of the customer associated with a transaction or other record.

A collection of links related to the associated customer record.

The reference name or display name of the customer associated with a transaction or other record.

A generic date field for a record or event.

The number of days a transaction or payment is past its due date.

The quantity of units delivered for an order or campaign.

The department associated with a transaction or record, used for reporting and categorization.

The internal ID of the department associated with a transaction or record.

A collection of links related to the associated department record.

The reference name or display name of the department associated with a transaction or record.

The internal ID of the department.

The unique identifying number of a transaction document.

The date by which a payment or task is expected to be completed. For transactions, it is the date when payment is due.

The email address for an entity such as a customer or employee.

The internal ID of the employee associated with a record, such as a timesheet or transaction.

A collection of links related to the associated employee record, providing navigation to related resources.

The reference name or display name of the employee associated with a record.

The specific business unit to which an employee is assigned.

The email address of the employee.

The first name of the employee.

The functional role or department of an employee within the organization (e.g., Sales, Marketing, Finance).

The internal ID of the employee.

The official job title held by an employee.

The last name of the employee.

The full name of the employee. In NetSuite, employee records contain a 'name' field.

The internal NetSuite ID for the employee record, used as a unique identifier for API calls.

The subsidiary with which the employee is associated. This is often used for multi-company or global NetSuite instances.

The job title of the employee.

The name of the entity associated with a transaction or record, such as a customer, vendor, or employee.

The exchange rate applied for transactions involving foreign currencies.

A general ledger account used to record income generated from sales or services.

The first name of a person, such as an employee or contact.

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.

The full name of a person, such as an employee or contact.

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.

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.

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.

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.

The unique internal identifier for the record.

Indicates whether time or expenses are billable to a customer or project.

Boolean flag indicating if a transaction or item is exempt from certain taxes or regulations.

Boolean flag indicating if a resource's time is considered productive.

Boolean flag indicating if a resource has been utilized.

The item associated with a transaction line.

The internal ID of the item associated with a transaction line.

A collection of links related to the associated item record.

The reference name or display name of the item associated with a transaction line.

The internal ID of the item.

The date and time when the record was last modified or updated.

The last name of a person, such as an employee or contact.

The specific line of business associated with a transaction or entity.

A collection of links related to the record, providing navigation to related resources.

The physical location associated with a transaction or record.

The internal ID of the location associated with a transaction or record.

A collection of links related to the associated location record.

The reference name or display name of the location associated with a transaction or record.

A general text field used for notes, comments, or a brief description related to a record or transaction in NetSuite.

A generic field for the name of a record or entity.

The internal ID of the NetSuite transaction.

The unique internal identifier for a specific line item within a transaction.

The office location associated with a record, such as an employee or transaction.

The client associated with a sales opportunity.

The unique internal identifier for an opportunity record, representing a sales or business opportunity.

The name or title of the opportunity record, providing a descriptive label for the sales or business opportunity.

The unique internal identifier for an Opportunity record in NetSuite, used to track potential sales deals.

The descriptive name or title of a sales opportunity in NetSuite.

Boolean flag indicating if a custom or manual rate overrides the default rate.

A unique identifier for the parent company or top-level client in a hierarchical client structure.

The name of the parent company or top-level client in a hierarchical client structure.

The accounting period to which a transaction or time entry belongs.

The internal ID of the accounting period to which a transaction or time entry belongs.

Internal identifier for the price level or specific price of an item.

Collection of links to the price record.

Display name or reference name of the price level or specific price.

The name of the project associated with a task or record.

A specific activity or milestone within a project that needs to be tracked and completed.

The internal ID of the project task.

The sales representative associated with a customer or transaction.

The subsidiary associated with the record, such as an employee, timesheet, or transaction.

The internal ID of the subsidiary associated with the record.

A collection of links related to the associated subsidiary record.

The reference name or display name of the subsidiary associated with the record.

The internal ID of the subsidiary.

The first name of the employee's supervisor.

The internal ID of the employee's supervisor.

The last name of the employee's supervisor.

The full name of the employee's direct supervisor.

Internal identifier for a team.

The name of the team.

The date and time when the record was last modified. For Timesheets, this is a read-only field.

The internal ID of the time type associated with a time entry or timesheet.

The reference name or display name of the time type associated with a time entry or timesheet.

The specific date on which the time entry was recorded or the activity occurred. This can correspond to 'tranDate' in time records.

The calendar month component of a date, used for time-based reporting and analysis.

The category or reason for an employee's absence from work (e.g., vacation, sick leave, public holiday).

Reference to a time tracking record.

Internal identifier for a time tracking record.

The calendar year component of a date, used for time-based reporting and analysis.

The unique internal ID for a Time Bill record, which tracks hours worked by an employee, often for billing purposes.

The internal ID of the timesheet record.

A collection of links related to the associated timesheet record.

The reference name or display name of the timesheet record.

The grand total amount of a transaction in the transaction's currency.

The transaction date of a record, often used for filtering.

The date on which a transaction was recorded.

The transaction date of a record, often used for filtering.

The currency used for the specific transaction.

The classification of a transaction, indicating its nature (e.g., Sales Order, Purchase Order, Invoice, Cash Sale, Journal Entry).

The type of a record or transaction (e.g., Sales Order, Invoice, Employee).

The name of the vendor associated with a transaction or record.

Indicates whether a transaction has been voided.