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
abbreviation	abbreviation	A shortened form of a word or phrase, used as an identifier or display value.	dimension
accesslevel	accesslevel	The level of access permissions granted to a user or role.	dimension
account	account	A record in the general ledger used to store transactions, categorized by account types such as accounts payable, cash, or cost of goods sold.	metric
account_id	account_id	The internal ID of the General Ledger account.	dimension
account_name	account_name	The name of the General Ledger account.	dimension
accountinglinetype	accountinglinetype	The classification of an accounting line item, indicating its purpose within a transaction.	dimension
accountnumber	accountnumber	The unique number assigned to a General Ledger account.	metric
accountsearchdisplayname	accountsearchdisplayname	The name used for an account when it appears in search results or lists.	dimension
accountsearchdisplaynamecopy	accountsearchdisplaynamecopy	A copy of the display name for an account, used for search results or simplified display purposes.	dimension
acctnumber	acctnumber	The account number. This is an alternative name for ‘accountnumber’.	dimension
accttype	accttype	The type of account (e.g., Bank, Accounts Receivable, Expense, Income).	dimension
actualshipdate	actualshipdate	The actual date when an item or order was shipped.	dimension
advertiser	advertiser	The entity or customer that is advertising, often linked to marketing and sales records.	dimension
advertiser_name	advertiser_name	The full name of the advertiser associated with a marketing campaign or sales opportunity.	dimension
agency	agency	The external agency involved in sales, marketing, or other services for the account.	dimension
alcoholrecipienttype	alcoholrecipienttype	The type of recipient for alcohol-related sales or shipments, relevant for compliance and taxation.	dimension
allowattachments	allowattachments	Indicates whether attachments can be added to the record.	dimension
allowinlinedeleting	allowinlinedeleting	Indicates if in-line deleting is permitted for a record or line item within the NetSuite UI. This field reflects a configuration setting for user interface behavior.	dimension
allowinlineediting	allowinlineediting	Indicates if in-line editing is enabled for a record or specific fields within the NetSuite UI, allowing direct modification without opening a separate editing page. This field reflects a configuration setting for user interface behavior.	dimension
allowquicksearch	allowquicksearch	Indicates whether a record or field is available for use in quick search functionality within NetSuite, allowing users to rapidly find relevant data.	dimension
altname	altname	An alternative or secondary name for a record, often used for display or search purposes.	dimension
altphone	altphone	An alternative phone number for a contact or company.	dimension
amount	amount	The total monetary value associated with a transaction or line item.	metric
amount_credit	amount_credit	The credit amount of a transaction line.	metric
amount_debit	amount_debit	The debit amount of a transaction line.	metric
amountnet	amountnet	The net amount of a transaction line item, excluding taxes or discounts.	metric
amountunbilled	amountunbilled	The portion of the transaction amount that has not yet been billed.	metric
approvalstatus	approvalstatus	The current status of a record within an approval workflow (e.g., Pending Approval, Approved, Rejected).	metric
assetaccount	assetaccount	The General Ledger account used to track assets.	metric
assigned	assigned	Indicates if a record, such as a task or lead, has been assigned to a specific user or resource.	metric
atpmethod	atpmethod	Specifies the Available-to-Promise (ATP) calculation method used for inventory items, determining how future supply and demand are considered for order fulfillment.	dimension
availabletopartners	availabletopartners	Indicates whether the record or item is visible or accessible to partner entities.	dimension
averagecost	averagecost	The calculated average cost of an item.	metric
averagecostmli	averagecostmli	The average cost of an item calculated using the Moving Average (MLI) costing method, reflecting inventory valuation.	metric
balancesearch	balancesearch	Represents the current balance of an account as determined by a search query.	metric
billexchratevarianceacct	billexchratevarianceacct	The general ledger account used to record variances due to changes in exchange rates on vendor bills.	metric
billingaddress	billingaddress	The address used for billing purposes for a customer or transaction.	metric
billingschedule	billingschedule	The predefined schedule used to generate invoices for a subscription or project.	metric
billingstatus	billingstatus	The current status of the billing process for a transaction (e.g., Billed, Partially Billed, Not Billed).	dimension
billpricevarianceacct	billpricevarianceacct	The general ledger account used to record variances between the purchase order price and the vendor bill price.	metric
billqtyvarianceacct	billqtyvarianceacct	The general ledger account used to record variances between the quantity ordered and the quantity billed.	metric
binnumber	binnumber	The bin number where an item is stored in a warehouse.	metric
casetaskevent	casetaskevent	Relates to an interaction or activity, such as a customer support case, a task, or a scheduled event.	metric
cashflowrate	cashflowrate	Selects the type of exchange rate used to translate foreign currency amounts for an account in the cash flow statement.	dimension
category	category	A classification used to group or identify records, such as customer types or commerce categories.	metric
category1099misc	category1099misc	Defines the 1099-MISC category to which cash-basis transactions for a vendor are reported, corresponding to a specific box on the 1099 form.	metric
class	class	A classification or segment used for reporting and tracking purposes in accounting and financial management.	metric
class.id	class.id	The internal identifier of the associated class (classification) record.	metric
class.links	class.links	A collection of HATEOAS links providing references to the associated class record.	dimension
class.refName	class.refName	The reference name (display name) of the associated class (classification) record.	dimension
classTranslation.links	classTranslation.links	A collection of HATEOAS links providing references to the associated class translation subrecord.	dimension
cleared	cleared	A boolean flag indicating whether a financial transaction, such as a check or deposit, has been cleared by the bank.	dimension
cleareddate	cleareddate	The date on which a financial transaction, such as a check or deposit, was cleared by the bank.	dimension
client_id	client_id	The unique internal identifier for a client or customer record.	dimension
client_line_of_business	client_line_of_business	The primary industry or business segment of the client.	dimension
client_line_of_business_id	client_line_of_business_id	The internal identifier for the line of business associated with a client.	dimension
client_name	client_name	The full name of the client or customer.	dimension
client_vendor	client_vendor	Refers to an entity that can function as both a client (customer) and a vendor (supplier) within the system.	dimension
closedate	closedate	The date when a record, such as an opportunity or case, was closed.	dimension
comments	comments	Additional notes or comments associated with the record or transaction.	dimension
commitinventory	commitinventory	Controls whether inventory should be committed for an order, reserving stock.	metric
commitmentfirm	commitmentfirm	Indicates if a particular commitment, often related to inventory or orders, is considered firm and cannot be easily changed or cancelled.	dimension
committedqtyperlocation	committedqtyperlocation	The quantity of an item committed to orders, broken down by inventory location.	metric
committedqtyperseriallotnumber	committedqtyperseriallotnumber	The quantity of an item committed for sale or use, tracked by its unique serial or lot number.	metric
committedqtyperseriallotnumberlocation	committedqtyperseriallotnumberlocation	The quantity of an item committed for sale or use, tracked by its unique serial or lot number and specific inventory location.	metric
company	company	The name of the company associated with the record, such as a customer or vendor.	metric
companyname	companyname	The legal or display name of the company.	dimension
completeddate	completeddate	The date when a task, project phase, or other activity was marked as completed.	dimension
consolbalancesearch	consolbalancesearch	The consolidated balance for an account across multiple subsidiaries or entities, used in financial reporting.	metric
consoldaysoverduesearch	consoldaysoverduesearch	The number of days an invoice or payment is overdue, calculated on a consolidated basis for multiple entities.	metric
consoloverduebalancesearch	consoloverduebalancesearch	The total consolidated amount of overdue balances for an account across multiple subsidiaries.	metric
consolunbilledorderssearch	consolunbilledorderssearch	The total consolidated value of orders that have not yet been billed across multiple subsidiaries.	metric
contact	contact	The associated contact person for a customer, vendor, or other record.	metric
copydescription	copydescription	A flag indicating whether the description from a source record or item should be copied to a new record.	dimension
cost	cost	The monetary cost associated with an item or transaction.	metric
costaccountingstatus	costaccountingstatus	The current status of cost accounting for an item or transaction, indicating stages like ‘pending’, ‘processed’, or ‘error’.	dimension
costestimatetype	costestimatetype	Defines the method NetSuite uses to calculate the estimated gross profit for an item, such as Average Cost, Last Purchase Price, or Item Defined Cost.	dimension
costingmethod	costingmethod	The inventory costing method used for an item (e.g., Average Cost, LIFO, FIFO).	dimension
costingmethoddisplay	costingmethoddisplay	The display name of the costing method used for inventory valuation, such as FIFO or Average Cost.	dimension
countinterval	countinterval	Specifies the frequency or period for physically counting an inventory item, used in cycle counting to determine when an item is due for counting.	metric
couponcode	couponcode	A code used to apply a discount or promotion to a transaction.	metric
created	created	The date and time when the record was initially created in the system.	dimension
created_from_id	created_from_id	The internal identifier of the record from which the current record was generated or copied, indicating its origin in a workflow.	dimension
createdby	createdby	The employee or user who created the record.	metric
createddate	createddate	The date when the record was created in the system.	dimension
createdfrom	createdfrom	The record from which the current record was created (e.g., a sales order created from an estimate).	metric
createjob	createjob	A flag or action indicating whether a job record should be created, often associated with project management or service orders.	dimension
creditforeignamount	creditforeignamount	The credit amount of a transaction in the foreign currency.	metric
creditholdoverride	creditholdoverride	Indicates if a credit hold placed on a customer’s account has been manually overridden.	dimension
creditlimit	creditlimit	The maximum amount of credit extended to a customer.	metric
currency	currency	The currency used for the transaction or record.	metric
customForm.id	customForm.id	The internal identifier of the associated custom form.	metric
customForm.refName	customForm.refName	The reference name (display name) of the associated custom form.	dimension
customer	customer	The customer associated with the record or transaction.	metric
customer.id	customer.id	The internal identifier of the associated customer record.	metric
customer.links	customer.links	A collection of HATEOAS links providing references to the associated customer record.	dimension
customer.refName	customer.refName	The reference name (display name) of the associated customer record.	dimension
customer_id	customer_id	The internal ID of the customer associated with the record.	dimension
customer_name	customer_name	The name of the customer associated with the record.	dimension
customform	customform	The internal identifier of the custom form used for displaying and entering data for this record.	metric
customtype	customtype	Refers to a user-defined type, often used to categorize custom records or custom fields within NetSuite for specific business needs.	metric
date	date	The primary date associated with a transaction or record.	dimension
dateclosed	dateclosed	The date when a record, such as an opportunity or project, was closed.	dimension
datecreated	datecreated	The date when the record was created. Similar to ‘created’ and ‘createddate’.	dimension
daysopen	daysopen	The number of days a record, such as an opportunity or case, has been open.	metric
daysoverduesearch	daysoverduesearch	The number of days an invoice or payment is overdue, determined by a search query.	metric
debitforeignamount	debitforeignamount	The debit amount of a transaction in the foreign currency.	metric
defaultbillingaddress	defaultbillingaddress	The primary address designated for billing purposes for a customer or vendor.	metric
defaultshippingaddress	defaultshippingaddress	The primary address designated for shipping purposes for a customer.	metric
deferredrevenueaccount	deferredrevenueaccount	The general ledger account used to record revenue that has been received but not yet earned.	metric
deferrevrec	deferrevrec	Indicates whether revenue recognition for an item or transaction should be deferred.	dimension
delivered_units	delivered_units	The quantity of units that have been delivered for an order or item.	metric
department	department	The department associated with the record or transaction, used for segmentation and reporting.	metric
department.id	department.id	The internal identifier of the associated department record.	metric
department.links	department.links	A collection of HATEOAS links providing references to the associated department record.	dimension
department.refName	department.refName	The reference name (display name) of the associated department record.	dimension
department_id	department_id	The internal identifier of the department.	dimension
deploymentname	deploymentname	The name assigned to a specific deployment instance, possibly related to scripts, workflows, or integrations.	dimension
description	description	A detailed text description of the record or item.	dimension
directrevenueposting	directrevenueposting	Indicates if revenue should be posted directly without following a standard revenue recognition schedule.	dimension
discountdate	discountdate	The date by which payment must be made to receive an early payment discount.	dimension
displayfield	displayfield	A field that determines how data is presented or which specific data field should be displayed in a given context.	dimension
displayname	displayname	The name of the record as it is displayed in the user interface.	dimension
displaynamewithhierarchy	displaynamewithhierarchy	The name of a record shown with its hierarchical path, for example, for accounts or departments.	dimension
division_id	division_id	The internal identifier for the division to which an entity or record belongs.	dimension
document_number	document_number	The unique identification number assigned to a document or transaction.	dimension
documentnumber	documentnumber	The system-generated or user-defined document number for a transaction.	metric
donotdisplayline	donotdisplayline	A flag indicating that a specific line item, typically within a transaction or report, should not be displayed in the user interface.	dimension
donotprintline	donotprintline	A flag indicating that a specific line item, usually from a transaction or document, should be excluded when the document is printed.	dimension
dontshowprice	dontshowprice	A flag indicating that the price for an item or service should not be displayed, often used in quotes or proposals.	dimension
duedate	duedate	The date by which a payment or task is due.	dimension
duplicate	duplicate	A flag indicating if a record is a duplicate or if a duplicate record check should be performed.	dimension
eliminate	eliminate	Indicates if a transaction or account should be eliminated in consolidated financial reporting.	dimension
email	email	The email address associated with a contact or entity.	dimension
emailpreference	emailpreference	The email preference for sending documents or notifications, such as ‘PDF’ or ‘HTML’.	dimension
emailtransactions	emailtransactions	Indicates whether transactions associated with this record should be sent via email.	dimension
employee	employee	The employee associated with the record or transaction.	metric
employee.id	employee.id	The internal identifier of the associated employee record.	metric
employee.links	employee.links	A collection of HATEOAS links providing references to the associated employee record.	dimension
employee.refName	employee.refName	The reference name (display name) of the associated employee 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 identifier of the employee.	dimension
employee_last_name	employee_last_name	The last name of the employee.	dimension
employee_title	employee_title	The job title of the employee.	dimension
enablemailmerge	enablemailmerge	Indicates whether mail merge functionality is enabled for the record, often for customer communications.	dimension
enddate	enddate	The end date of a period, project, or subscription.	dimension
enforceminqtyinternally	enforceminqtyinternally	A flag indicating whether the minimum quantity requirement for an item is enforced by the system for internal processes, such as during order entry or manufacturing.	dimension
entity	entity	A general reference to a customer, vendor, partner, or employee record.	metric
entityid	entityid	The ID of the entity (customer, vendor, partner, or employee).	dimension
entitynumber	entitynumber	A unique identifier for an entity, such as a customer, vendor, or employee.	metric
entitystatus	entitystatus	The current status of an entity, such as a lead, prospect, or customer.	metric
entitytitle	entitytitle	The title or salutation used for an entity, such as ‘Mr.’, ‘Ms.’, ‘Dr.’, within a customer or contact record.	dimension
exchangerate	exchangerate	The currency exchange rate used for a transaction or financial record.	metric
excludefromraterequest	excludefromraterequest	A flag indicating if a particular item or service should be excluded when calculating shipping rates or other rate requests.	dimension
excludefromsitemap	excludefromsitemap	Indicates whether a page or item should be excluded from the website sitemap, relevant for e-commerce.	dimension
expenseaccount	expenseaccount	The General Ledger account used to record expenses.	metric
externalid	externalid	A unique identifier for a record from an external system, used for integration purposes.	dimension
externalrolepermissionlevel	externalrolepermissionlevel	Defines the permission level granted to an external role, controlling access to data and functionalities for external users or integrations.	metric
fax	fax	The fax number for a contact or company.	dimension
faxtransactions	faxtransactions	Indicates whether transactions associated with this record should be sent via fax.	dimension
featureddescription	featureddescription	A description used for featured products or promotions, often displayed prominently in e-commerce.	dimension
finance_revenue_account	finance_revenue_account	The general ledger account designated for recording revenue for this specific item or transaction, impacting financial reporting.	dimension
firstname	firstname	The first name of an individual.	dimension
firstsaledate	firstsaledate	The date of the first recorded sale to a customer or for a specific item.	dimension
foreignamount	foreignamount	The monetary amount of a transaction in a foreign currency.	metric
foreignamountpaid	foreignamountpaid	The amount paid on a transaction in its foreign currency.	metric
foreignamountpaidnopost	foreignamountpaidnopost	The amount paid in a foreign currency for a transaction, which is recorded but not yet posted to the general ledger.	metric
foreignamountunpaid	foreignamountunpaid	The unpaid amount of a transaction in its foreign currency.	metric
foreignpaymentamountunused	foreignpaymentamountunused	The portion of a foreign currency payment that has not yet been applied to an invoice or other transaction.	metric
foreignpaymentamountused	foreignpaymentamountused	The portion of a foreign currency payment that has already been applied to an invoice or other transaction.	metric
foreigntotal	foreigntotal	The total amount of a transaction in a foreign currency.	metric
forinvoicegrouping	forinvoicegrouping	A flag indicating if a transaction or line item is considered for grouping together on a single invoice.	dimension
formula	formula	A calculated field based on a defined formula.	metric
froogleproductfeed	froogleproductfeed	Indicates whether an item should be included in a product feed for Froogle (Google Shopping).	dimension
fulfillable	fulfillable	Indicates whether an item or order is ready for fulfillment.	dimension
fullname	fullname	The full name of a person or entity.	dimension
function	function	The role or purpose of an employee or resource within the organization.	dimension
function_id	function_id	The internal identifier for the function or role of an employee.	dimension
fxcost	fxcost	The cost of an item or transaction expressed in a foreign currency.	metric
gainlossaccount	gainlossaccount	The general ledger account used to record gains or losses, typically from foreign exchange differences or asset disposals.	metric
generalrate	generalrate	The general exchange rate type used for currency conversion in accounts.	dimension
generateaccruals	generateaccruals	Indicates whether accrual entries should be automatically generated for a transaction or item.	dimension
giveaccess	giveaccess	Controls whether a user or contact is granted access to the system or specific functionalities.	dimension
globalsubscriptionstatus	globalsubscriptionstatus	The overall subscription status for a customer, indicating their preference for communications.	metric
group	group	The group to which an entity or item belongs.	metric
groupinvoices	groupinvoices	Indicates whether multiple invoices for a customer should be grouped together for billing or display.	dimension
hascostline	hascostline	A boolean flag indicating if a transaction or item has associated cost lines, typically for tracking expenses or inventory costs.	dimension
hasfulfillableitems	hasfulfillableitems	Indicates whether an order contains items that are ready to be fulfilled.	dimension
hours	hours	The number of hours recorded or allocated for a task, project, or employee.	metric
id	id	The internal system identifier for a record.	dimension
impressions	impressions	The number of times an advertisement or content has been displayed, relevant for marketing analytics.	metric
includeChildren	includeChildren	A flag indicating whether to include child records or sub-subsidiaries in an operation or classification.	dimension
includechildren	includechildren	Indicates whether child records should be included when processing or displaying information for a parent record, often used in hierarchical structures.	dimension
includeinforecast	includeinforecast	Indicates whether an item or opportunity should be included in sales forecasts.	dimension
includename	includename	A flag that, when true, indicates that the name associated with an entity or record should be included in a display or report.	dimension
incomeaccount	incomeaccount	The General Ledger account used to record income.	metric
intercoexpenseaccount	intercoexpenseaccount	An accounting field representing the expense account used in transactions between different subsidiaries within a NetSuite OneWorld account.	metric
intercoincomeaccount	intercoincomeaccount	An accounting field representing the income account used in transactions between different subsidiaries within a NetSuite OneWorld account.	metric
internalId	internalId	The unique, system-generated internal identifier for a record within NetSuite.	metric
internalid	internalid	The internal system identifier for a record.	metric
inventory	inventory	Refers to the quantity or details of items held in stock.	dimension
invtcountinterval	invtcountinterval	Specifies the number of days between required inventory counts for an item, utilized in NetSuite’s calculated inventory count feature.	metric
isBillable	isBillable	A flag indicating whether an expense, time entry, or item is billable to a customer.	dimension
isExempt	isExempt	A flag indicating whether an item or transaction is exempt from certain taxes or regulations.	dimension
isInactive	isInactive	A boolean indicating whether the record is currently inactive and not in use.	dimension
isProductive	isProductive	A boolean flag indicating if a resource (e.g., employee, asset) is considered productive, often used in time tracking or resource management.	dimension
isUtilized	isUtilized	A boolean flag indicating if a resource or capacity has been utilized or consumed.	dimension
isautogeneratedrepresentingentity	isautogeneratedrepresentingentity	A boolean flag indicating if the representing entity (e.g., a contact for a company) was automatically generated by the system.	dimension
isbillable	isbillable	A boolean field indicating whether an item, activity, or expense is billable to a customer.	dimension
isclosed	isclosed	A boolean indicating whether the record or transaction is closed.	dimension
iscogs	iscogs	Indicates whether the line item relates to Cost of Goods Sold (COGS).	dimension
iscustomglline	iscustomglline	A boolean flag indicating if a general ledger (GL) line item is a custom entry, differentiating it from standard system-generated GL lines.	dimension
isdonationitem	isdonationitem	A boolean flag identifying an item as a donation, typically used in non-profit or fundraising contexts.	dimension
isdropshipitem	isdropshipitem	A flag indicating whether the item is a dropship item.	dimension
isexempt	isexempt	A flag indicating whether an item or transaction is exempt from certain taxes or regulations.	dimension
isfinchrg	isfinchrg	A boolean flag indicating if a transaction line represents a finance charge, such as interest on overdue payments.	dimension
isfulfillable	isfulfillable	Indicates whether an item or order can be fulfilled.	dimension
isfullyshipped	isfullyshipped	Indicates whether an order has been completely shipped.	dimension
isfxvariance	isfxvariance	A boolean flag indicating if a transaction or value represents a foreign exchange (FX) variance, which is a difference due to currency rate fluctuations.	dimension
isinactive	isinactive	A boolean field indicating whether a record is currently inactive.	dimension
isinventoryaffecting	isinventoryaffecting	Indicates whether a transaction line item affects inventory levels.	dimension
isonline	isonline	A boolean flag indicating if an item or service is available for online sale or display, relevant for e-commerce operations.	dimension
isordered	isordered	Indicates whether an item has been ordered.	dimension
isperson	isperson	Indicates if the entity is an individual (person) rather than a company.	dimension
isproductive	isproductive	A boolean flag indicating if a resource (e.g., employee, asset) is considered productive, often used in time tracking or resource management.	dimension
isreversal	isreversal	Indicates whether a transaction is a reversal of a previous entry.	dimension
isspecialorderitem	isspecialorderitem	A flag indicating whether the item is a special order item.	dimension
issummary	issummary	A boolean flag indicating if a record or report represents summarized data rather than detailed individual entries.	dimension
isunavailable	isunavailable	A boolean flag indicating that an item or resource is currently unavailable.	dimension
isutilized	isutilized	A boolean flag indicating if a resource or capacity has been utilized or consumed.	dimension
item	item	The item associated with a transaction line.	metric
item.id	item.id	The internal identifier of the associated item record.	metric
item.links	item.links	A collection of HATEOAS links providing references to the associated item record.	dimension
item.refName	item.refName	The reference name (display name) of the associated item record.	dimension
item_id	item_id	The internal identifier of the item.	dimension
item_name	item_name	The name of the item.	dimension
itemclass	itemclass	The classification or category of an inventory item.	metric
itemcount	itemcount	The total number of items in a specific group or transaction.	metric
itemid	itemid	The unique identifier for an item.	dimension
itemname	itemname	The name of the item.	dimension
itemtype	itemtype	The classification of an item (e.g., Inventory Item, Service, Non-Inventory Item).	dimension
kitcomponent	kitcomponent	Identifies an item as a component of a kit item, which is a bundle of items sold together.	dimension
kpi	kpi	A Key Performance Indicator (KPI) identifier, used to reference specific metrics for business performance analysis.	dimension
language	language	The language preference for an entity or user.	dimension
lastModifiedDate	lastModifiedDate	The date and time when the record was last modified.	dimension
lastmodified	lastmodified	The date and time when the record was last modified or updated in NetSuite.	dimension
lastmodifiedby	lastmodifiedby	The employee or user who last modified the record.	metric
lastmodifieddate	lastmodifieddate	The date and time when the record was last modified or updated in NetSuite.	dimension
lastname	lastname	The last name of an individual.	dimension
lastpurchaseprice	lastpurchaseprice	The most recent price at which an item was purchased.	metric
lastpurchasepricemli	lastpurchasepricemli	The most recent purchase price for an item, specifically tracked on a per-location basis when the Multi-Location Inventory feature is enabled.	metric
lastquantityavailablechange	lastquantityavailablechange	A timestamp indicating the last time the available quantity of an item changed for a specific location, useful for tracking inventory level fluctuations.	dimension
lastsaledate	lastsaledate	The date of the most recent sale to a customer or for a specific item.	dimension
leadsource	leadsource	The marketing source from which a lead originated.	metric
line_of_business	line_of_business	The primary industry or business segment to which an entity or item belongs.	dimension
lineclass	lineclass	A classification or category assigned to a transaction line item for reporting or accounting purposes.	metric
linecreateddate	linecreateddate	The date when a specific line item on a transaction was created.	dimension
linelastmodifieddate	linelastmodifieddate	The date when a specific line item on a transaction was last modified.	dimension
linesequencenumber	linesequencenumber	The sequential number of a line item within a transaction or list.	metric
linkedtrackingnumberlist	linkedtrackingnumberlist	A list of tracking numbers associated with linked records, often used for tracing shipments or related transactions.	metric
links	links	A collection of related URLs or references that provide navigation to associated records or external resources.	dimension
location	location	The physical or logical location associated with inventory, transactions, or employees.	metric
location.id	location.id	The internal identifier of the associated location record.	metric
location.links	location.links	A collection of HATEOAS links providing references to the associated location record.	dimension
location.refName	location.refName	The reference name (display name) of the associated location record.	dimension
mainline	mainline	A boolean flag indicating if a line item is the main line of a transaction, typically representing the header-level information.	dimension
manufacturer	manufacturer	The company that produced an item.	dimension
master_parent_id	master_parent_id	The internal identifier of the top-level parent record in a hierarchical structure, such as for projects, customers, or items.	dimension
matchbilltoreceipt	matchbilltoreceipt	Indicates whether a vendor bill should be matched against a corresponding receipt for reconciliation.	dimension
matrixitemnametemplate	matrixitemnametemplate	A template that defines the naming convention for matrix items, allowing for systematic generation of names based on item attributes and matrix options.	dimension
matrixtype	matrixtype	An enumeration field that indicates whether an item is a ‘parent’ or ‘child’ within a matrix item structure.	dimension
memo	memo	A short note or description for a transaction or record.	dimension
memorized	memorized	A flag indicating if a transaction or report setting is memorized for recurring use, enabling quick recreation of similar entries.	dimension
message	message	A text message or communication associated with a record.	dimension
name	name	The primary name of the record or entity.	dimension
needsbill	needsbill	Indicates whether a purchase order or receipt requires a vendor bill to be created.	dimension
netamount	netamount	The total amount of a transaction after applying discounts but before taxes.	metric
nextagproductfeed	nextagproductfeed	Indicates whether an item should be included in a product feed for Nextag.	dimension
nextbilldate	nextbilldate	The scheduled date for the next billing cycle.	dimension
nextcountdate	nextcountdate	The system-calculated date for the next scheduled inventory count for a specific item, based on its count interval.	dimension
nextinvtcountdate	nextinvtcountdate	The system-calculated date for the next scheduled inventory count for a specific inventory item.	dimension
nexus	nexus	The tax jurisdiction or location where a company has a significant presence, impacting tax calculations.	metric
nopermissionrequired	nopermissionrequired	A boolean flag indicating that no specific permissions are required to access or modify a particular field or record.	dimension
ns_transaction_id	ns_transaction_id	The unique internal identifier for a specific transaction within NetSuite.	dimension
number	number	A unique identifying number for a record or transaction.	metric
office	office	The office location associated with an employee or department.	dimension
oldcommitmentfirm	oldcommitmentfirm	The previous status of a commitment, indicating if it was formerly considered firm before a change was made.	dimension
oncredithold	oncredithold	Indicates whether a customer’s account is currently on credit hold, preventing further credit sales.	dimension
onhandvaluemli	onhandvaluemli	A read-only field representing the total value of an item’s on-hand quantity across all locations, calculated by multiplying the quantity on hand by the purchase price.	metric
opportunity	opportunity	The sales opportunity associated with a transaction or record.	metric
opportunity_id	opportunity_id	The internal identifier of the associated opportunity record.	dimension
opportunity_name	opportunity_name	The name or title of the opportunity.	dimension
ordpicked	ordpicked	A boolean flag indicating if an item from an order has been picked from inventory, typically as part of the fulfillment process.	dimension
othername	othername	An alternative or secondary name for an entity or record.	metric
otherrefnum	otherrefnum	An alternative reference number for a transaction, such as a customer’s purchase order number.	dimension
overduebalancesearch	overduebalancesearch	The total amount of overdue balances for a specific account, determined by a search query.	metric
overrideRate	overrideRate	Indicates if the standard rate for an item or service has been manually overridden.	dimension
overriderate	overriderate	Indicates if the standard rate for an item or service has been manually overridden.	dimension
owner	owner	The employee or user who owns or is responsible for the record.	metric
owner.id	owner.id	The internal identifier of the associated owner record (e.g., an employee).	metric
owner.links	owner.links	A collection of HATEOAS links providing references to the associated owner record.	dimension
owner.refName	owner.refName	The reference name (display name) of the associated owner record.	dimension
parent	parent	The parent record in a hierarchical relationship.	metric
partner	partner	The partner associated with the record or transaction.	metric
paymenthold	paymenthold	Indicates whether a payment is currently on hold, preventing its processing.	dimension
paymentmethod	paymentmethod	The method of payment used for a transaction (e.g., Credit Card, Check, ACH).	metric
paymentoption	paymentoption	The available payment methods or options for a transaction.	metric
percentcomplete	percentcomplete	The percentage of a project or task that has been completed.	metric
percenttimecomplete	percenttimecomplete	The percentage of time completed for a project task or activity.	metric
period	period	The accounting period associated with a financial transaction.	dimension
period_id	period_id	The internal identifier of the accounting or time-based period.	dimension
periodclosed	periodclosed	Indicates whether the accounting period associated with a transaction is closed.	dimension
phone	phone	The primary phone number associated with an entity or record.	dimension
ponumber	ponumber	The purchase order number.	dimension
posting	posting	Indicates whether a transaction has been posted to the general ledger.	dimension
postingperiod	postingperiod	The accounting period to which a transaction is posted.	metric
preferredlocation	preferredlocation	The preferred inventory location for an item or customer.	metric
prevdate	prevdate	The previous date recorded for a specific event or transaction.	dimension
price	price	The selling price of an item.	metric
price.id	price.id	The internal identifier of the associated price record or price level.	metric
price.links	price.links	A collection of HATEOAS links providing references to the associated price record or price level.	dimension
price.refName	price.refName	The reference name (display name) of the associated price record or price level.	dimension
pricinggroup	pricinggroup	The group used for applying specific pricing rules to items or customers.	metric
printedpickingticket	printedpickingticket	A boolean flag indicating if the picking ticket for an order has been printed, signaling that items are ready for warehouse picking.	dimension
printitems	printitems	Indicates whether items on a transaction should be printed on the generated document.	dimension
printtransactions	printtransactions	Indicates whether transactions associated with this record should be printed.	dimension
priority	priority	The priority level assigned to a record, such as a task or support case.	dimension
probability	probability	The probability of an opportunity closing successfully.	metric
processedbyrevcommit	processedbyrevcommit	A flag indicating if a transaction or item has been processed as part of a revenue commitment, impacting revenue recognition schedules.	dimension
project_name	project_name	The name of the project.	dimension
project_task_id	project_task_id	The internal identifier of the associated project task.	dimension
publicpermissionlevel	publicpermissionlevel	Defines the access level for public users or entities to a specific record or data point.	metric
purchasedescription	purchasedescription	A description of the item as it appears on purchase orders.	dimension
quantity	quantity	The quantity of an item in inventory or on a transaction line.	metric
quantityavailable	quantityavailable	The quantity of an item currently available in inventory.	metric
quantitybackordered	quantitybackordered	The quantity of an item that is currently backordered.	metric
quantitybilled	quantitybilled	The quantity of items that have been billed on an order.	metric
quantitycommitted	quantitycommitted	The quantity of an item that has been committed to orders but not yet fulfilled.	metric
quantityintransitexternal	quantityintransitexternal	The quantity of items that are currently in transit between locations, specifically referring to external transfers.	metric
quantityonhand	quantityonhand	The physical quantity of an item currently available in stock.	metric
quantityonorder	quantityonorder	The quantity of an item that has been ordered from a vendor but not yet received.	metric
quantitypicked	quantitypicked	The quantity of an item that has been picked from inventory for an order.	metric
quantityrejected	quantityrejected	The quantity of items that were rejected during a quality check, return, or receipt process.	metric
quantityshiprecv	quantityshiprecv	The quantity of items that have been shipped or received.	metric
rate	rate	The unit rate or price of an item on a transaction line.	metric
rateamount	rateamount	The monetary rate or price for an item or service.	metric
ratepercent	ratepercent	The rate expressed as a percentage, often for discounts or taxes.	metric
receivablesaccount	receivablesaccount	The general ledger account used to record money owed to the company by customers.	metric
reconcilewithmatching	reconcilewithmatching	A flag indicating if a transaction requires reconciliation by matching it against other records, such as bank statements or purchase orders.	dimension
recordid	recordid	The internal identifier of a record.	metric
recordtype	recordtype	The type of record in NetSuite (e.g., Customer, Invoice, Sales Order).	dimension
reminderminutes	reminderminutes	The number of minutes before an event or task that a reminder should be triggered.	metric
remindertype	remindertype	The type of reminder set for an event or task (e.g., email, pop-up).	dimension
representingsubsidiary	representingsubsidiary	The subsidiary that this entity represents, relevant in multi-subsidiary environments.	metric
resalenumber	resalenumber	A unique identification number for a resale certificate, typically used for tax exemption purposes on sales for resale.	dimension
revalue	revalue	A flag or action indicating that an asset or inventory item should be revalued, often due to changes in market price or currency exchange rates.	dimension
revenuerecognitionrule	revenuerecognitionrule	The rule governing how revenue is recognized for an item or transaction.	metric
revrecforecastrule	revrecforecastrule	The rule used to forecast revenue recognition for an item or service.	metric
sales_order_id	sales_order_id	The internal ID of the sales order associated with a transaction.	dimension
sales_rep	sales_rep	The sales representative associated with a customer or transaction.	dimension
saleunit	saleunit	The unit of measure used when selling an item, such as ‘each’, ‘box’, or ‘gallon’.	metric
scriptId	scriptId	The unique script identifier for custom records, custom fields, or SuiteScript components.	dimension
scriptid	scriptid	The programmatic identifier used to uniquely reference a custom script or object within NetSuite.	dimension
searchstage	searchstage	The current stage of a lead or opportunity within the sales pipeline, as determined by a search.	dimension
seasonaldemand	seasonaldemand	A factor used in demand planning to account for fluctuations in item demand based on seasonal trends, holidays, or specific periods of the year.	dimension
settlementamount	settlementamount	The monetary amount agreed upon for settlement of a payment, dispute, or financial obligation.	metric
shipcarrier	shipcarrier	The shipping carrier used for a shipment.	dimension
shipcomplete	shipcomplete	Indicates that all items on an order must be shipped together in a single shipment.	dimension
shipdate	shipdate	The date when an item is scheduled to be shipped.	dimension
shipindividually	shipindividually	Indicates that items on an order can be shipped separately rather than all at once.	dimension
shipmethod	shipmethod	The shipping method used for a shipment.	metric
shippingaddress	shippingaddress	The address used for shipping purposes for a customer or transaction.	metric
shippingcarrier	shippingcarrier	The shipping carrier used for a particular shipment or transaction.	dimension
shoppingproductfeed	shoppingproductfeed	Indicates whether an item should be included in a generic shopping product feed for e-commerce.	dimension
shopzillaproductfeed	shopzillaproductfeed	Indicates whether an item should be included in a product feed for Shopzilla.	dimension
showdefaultdonationamount	showdefaultdonationamount	A flag indicating whether a default donation amount should be displayed, typically in online forms or fundraising campaigns.	dimension
shownotes	shownotes	A boolean flag indicating if notes associated with a record or transaction should be displayed.	dimension
skey	skey	A short key or identifier, often used for quick reference or indexing purposes.	dimension
source	source	The source of a transaction or record (e.g., Web, Phone, POS).	dimension
startdate	startdate	The date on which a project, task, or period begins.	dimension
status	status	The current status of a record or transaction.	dimension
stockdescription	stockdescription	A description of the item used for inventory and stock management.	dimension
storedescription	storedescription	A description of the item displayed in an online store or e-commerce platform.	dimension
storedetaileddescription	storedetaileddescription	A comprehensive description of the item for display in an online store, providing more details than the standard store description.	dimension
storedisplayimage	storedisplayimage	The image file used to represent the item in an online store.	metric
storedisplayname	storedisplayname	The name of the item as it appears in an online store.	dimension
storedisplaythumbnail	storedisplaythumbnail	The thumbnail image file used to represent the item in an online store.	metric
subsidiary	subsidiary	The subsidiary associated with a record or transaction in a OneWorld account.	metric
subsidiary.id	subsidiary.id	The internal identifier of the associated subsidiary record.	metric
subsidiary.links	subsidiary.links	A collection of HATEOAS links providing references to the associated subsidiary record.	dimension
subsidiary.refName	subsidiary.refName	The reference name (display name) of the associated subsidiary record.	dimension
subsidiary_id	subsidiary_id	The internal identifier of the subsidiary.	dimension
subtype	subtype	A more specific classification or category for a record type.	dimension
supervisor	supervisor	A reference to the employee who is the supervisor.	dimension
supervisor_first_name	supervisor_first_name	The first name of the employee’s direct supervisor.	dimension
supervisor_id	supervisor_id	The internal identifier of the employee’s direct supervisor.	dimension
supervisor_last_name	supervisor_last_name	The last name of the employee’s direct supervisor.	dimension
supplyreplenishmentmethod	supplyreplenishmentmethod	The method used to replenish inventory supply, such as time-phased, reorder point, or master production schedule (MPS).	dimension
targeting	targeting	Describes the criteria used for targeting specific customers or markets in marketing campaigns.	dimension
taxline	taxline	Indicates whether a transaction line item represents a tax amount.	dimension
team_id	team_id	The internal identifier for the team associated with an employee or project.	dimension
team_name	team_name	The name of the team associated with an employee or project.	dimension
terms	terms	The payment terms associated with an invoice or bill.	metric
timeModified	timeModified	The time when the record was last modified.	dimension
timeType.id	timeType.id	The internal identifier of the associated time type record.	dimension
timeType.refName	timeType.refName	The reference name (display name) of the associated time type record.	dimension
time_record	time_record	A reference to a time entry record.	dimension
time_record_id	time_record_id	The internal identifier of the time entry record.	dimension
timedevent	timedevent	A flag indicating if an activity or task is a scheduled event with a specific time duration.	dimension
timemodified	timemodified	The time when the record was last modified.	dimension
timeofftype	timeofftype	The category or type of time off, such as ‘vacation’, ‘sick leave’, or ‘personal leave’, used in employee management.	metric
timesheet	timesheet	A reference to a timesheet record.	metric
timesheet.id	timesheet.id	The internal identifier of the associated timesheet record.	metric
timesheet.links	timesheet.links	A collection of HATEOAS links providing references to the associated timesheet record.	dimension
timesheet.refName	timesheet.refName	The reference name (display name) of the associated timesheet record.	dimension
timetype	timetype	The type of time entry or period.	dimension
title	title	The job title of an employee or the title of a record.	dimension
tobeprinted	tobeprinted	Indicates whether a document or transaction is pending to be printed.	dimension
toplevelparent	toplevelparent	The ultimate parent record in a hierarchical structure.	metric
totalquantityonhand	totalquantityonhand	The total quantity of an item currently available in inventory.	metric
totalvalue	totalvalue	The total monetary value of a transaction or inventory.	metric
tracklandedcost	tracklandedcost	A flag indicating whether landed costs should be tracked for an item.	dimension
tranDate	tranDate	The date of the transaction.	dimension
trandate	trandate	The date of the transaction.	dimension
trandisplayname	trandisplayname	The display name of a transaction, often including its type and number.	dimension
tranid	tranid	The transaction ID or number.	dimension
tranline	tranline	Refers to a specific line item within a transaction.	metric
transaction	transaction	A financial or operational event recorded in NetSuite, such as a sales order, invoice, or payment.	metric
transaction_date	transaction_date	The date when the transaction occurred.	dimension
transactiondiscount	transactiondiscount	The total discount applied to a transaction.	dimension
transactionnumber	transactionnumber	The system-generated or user-defined number for a transaction.	dimension
type	type	The general classification or type of a record (e.g., Customer, Vendor, Invoice).	dimension
typebaseddocumentnumber	typebaseddocumentnumber	A document number generated or assigned based on the specific type of transaction or record.	dimension
unbilledorderssearch	unbilledorderssearch	The total value of orders that have been placed but not yet billed, determined by a search query.	metric
uniquekey	uniquekey	A system-generated unique identifier for a record.	metric
units	units	The unit of measure for an item or quantity.	dimension
unitstype	unitstype	A record that defines a group of related units of measure (e.g., ‘Weight’ for pounds and kilograms), used when the Multiple Units of Measure feature is enabled.	metric
unsubscribe	unsubscribe	Indicates whether a contact has unsubscribed from marketing communications.	dimension
upccode	upccode	The Universal Product Code (UPC) for an item.	metric
urlcomponent	urlcomponent	A segment or part of a URL, often used to construct dynamic URLs for web pages or API endpoints.	dimension
usebins	usebins	A flag indicating whether bin management is enabled for an item or location.	dimension
usemarginalrates	usemarginalrates	A flag indicating whether marginal tax rates or pricing rates should be applied for calculations.	dimension
usepermissions	usepermissions	A boolean flag indicating whether specific user permissions are applied or enforced for accessing a record or feature.	dimension
userevenuearrangement	userevenuearrangement	Indicates whether a revenue arrangement should be used for revenue recognition for an item or transaction.	dimension
value	value		metric
vendor	vendor	The vendor associated with a record or transaction.	metric
vendor_name	vendor_name	The name of the vendor.	dimension
vendorname	vendorname	The name of the vendor.	dimension
visibletocustomer	visibletocustomer	Indicates whether the record or information is visible to the customer.	dimension
void	void	Indicates whether a transaction should be voided or canceled.	dimension
voided	voided	Indicates whether a transaction or record has been cancelled or invalidated.	dimension
vsoedelivered	vsoedelivered	A flag indicating whether services or items under a VSOE (Vendor Specific Objective Evidence) arrangement have been delivered, impacting revenue recognition.	dimension
vsoesopgroup	vsoesopgroup	The VSOE (Vendor Specific Objective Evidence) Standalone Selling Price (SSP) Group to which an item belongs, used for revenue recognition compliance.	dimension
website	website	The website address associated with a company or contact.	metric
weight	weight	The weight of an item.	metric
weightunit	weightunit	The unit of measurement used for the weight of an item, such as pounds or kilograms.	metric
weightunits	weightunits	The unit of measure used for an item’s weight (e.g., lbs, kgs).	dimension
yahooproductfeed	yahooproductfeed	Indicates whether an item should be included in a product feed for Yahoo Shopping.	dimension