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 or contraction of a name or term associated with a record, such as a company, department, or project. |
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. |
dimension |
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 |
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 classification of the recipient for alcohol sales, relevant for regulatory compliance in specific industries. |
dimension |
allowattachments |
allowattachments |
Indicates whether attachments can be added to the record. |
dimension |
allowinlinedeleting |
allowinlinedeleting |
Indicates whether users can delete items directly within a list or sublist. |
dimension |
allowinlineediting |
allowinlineediting |
Indicates whether users can edit fields directly within a list or sublist without opening the full record. |
dimension |
allowquicksearch |
allowquicksearch |
Indicates whether quick search functionality is enabled for this record or field. |
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 |
The Available-to-Promise (ATP) calculation method used for inventory planning. |
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, specifically in a Multi-Location Inventory (MLI) environment. |
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 |
Indicates whether a financial transaction has been cleared, typically in bank reconciliation. |
dimension |
cleareddate |
cleareddate |
The date when a financial transaction was cleared, typically in bank reconciliation. |
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 |
Indicates if the client also functions as a vendor, potentially relevant for dual-role entities. |
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 an inventory commitment is firm and cannot be easily changed. |
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 to orders, tracked by individual serial or lot numbers. |
metric |
committedqtyperseriallotnumberlocation |
committedqtyperseriallotnumberlocation |
The quantity of an item committed to orders, tracked by 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 |
Indicates whether the description should be copied from a source record. |
dimension |
cost |
cost |
The monetary cost associated with an item or transaction. |
metric |
costaccountingstatus |
costaccountingstatus |
The current status of an item or transaction within the cost accounting process. |
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 |
Indicates whether a job or project should be created from the current record or transaction. |
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. |
dimension |
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 |
A custom classification or type for a record. |
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 |
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 primarily used for displaying information, often a concatenation or formatted version of other fields. |
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 |
Indicates whether a specific line item on a transaction should be hidden from display. |
dimension |
donotprintline |
donotprintline |
Indicates whether a specific line item on a transaction should be excluded from printed documents. |
dimension |
dontshowprice |
dontshowprice |
Indicates whether the price for an item should be hidden from view. |
dimension |
duedate |
duedate |
The date by which a payment or task is due. |
dimension |
duplicate |
duplicate |
Indicates if the record is identified as a duplicate of an existing record. |
dimension |
eliminate |
eliminate |
Indicates if a transaction or account should be eliminated in consolidated financial reporting. |
dimension |
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 |
Specifies whether the minimum quantity requirement for an item should be enforced for internal orders. |
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 formal title or designation of an entity. |
dimension |
exchangerate |
exchangerate |
The currency exchange rate used for a transaction or financial record. |
metric |
excludefromraterequest |
excludefromraterequest |
Indicates whether an item or service should be excluded from rate requests or pricing calculations. |
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 |
The permission level assigned to external roles for accessing specific functionalities or data. |
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 foreign currency that has not yet been posted to the general ledger. |
metric |
foreignamountunpaid |
foreignamountunpaid |
The unpaid amount of a transaction in its foreign currency. |
metric |
foreignpaymentamountunused |
foreignpaymentamountunused |
The unused portion of a foreign currency payment. |
metric |
foreignpaymentamountused |
foreignpaymentamountused |
The portion of a foreign currency payment that has been applied. |
metric |
foreigntotal |
foreigntotal |
The total amount of a transaction in a foreign currency. |
metric |
forinvoicegrouping |
forinvoicegrouping |
Indicates if a transaction or item is intended for invoice grouping. |
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 |
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 |
Indicates whether a transaction has an associated cost line item. |
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 |
Indicates whether the name of the 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 |
Indicates whether an employee or resource is classified as productive. |
dimension |
isUtilized |
isUtilized |
Indicates whether a resource or asset is currently being utilized. |
dimension |
isautogeneratedrepresentingentity |
isautogeneratedrepresentingentity |
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 |
Indicates whether the general ledger line item is a custom entry. |
dimension |
isdonationitem |
isdonationitem |
Indicates whether an item is classified as a donation, often for non-profit organizations. |
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 |
Indicates whether a line item represents a finance charge. |
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 |
Indicates whether a line item represents a foreign exchange variance. |
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 |
Indicates whether an item or entity is available or visible online, typically in an e-commerce context. |
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 |
Indicates if an employee or resource is currently considered productive. |
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 |
Indicates if the record represents a summary rather than detailed information. |
dimension |
isunavailable |
isunavailable |
Indicates whether an item or resource is currently unavailable. |
dimension |
isutilized |
isutilized |
Indicates if a resource or asset is actively being utilized. |
dimension |
item |
item |
The item associated with a transaction line. |
dimension |
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 |
Indicates if an item is a component of a kit item. |
dimension |
kpi |
kpi |
Refers to a Key Performance Indicator associated with a record or report. |
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 |
The classification assigned to a specific line item in a transaction. |
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 shipments. |
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. |
dimension |
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 |
Indicates if a transaction line is the main line of the transaction, typically containing 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 |
Indicates whether a transaction is set up to recur automatically as a memorized transaction. |
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 |
Indicates that no specific permissions are required to access this resource. |
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 |
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 |
Indicates whether an order has been picked from inventory. |
dimension |
othername |
othername |
An alternative or secondary name for an entity. |
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 associated with a recurring transaction or event. |
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 |
Indicates whether a picking ticket for an order has been printed. |
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 |
Indicates whether the revenue commitment process has handled the transaction. |
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 |
The level of access granted to public users for a resource. |
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 an item that has been shipped from an external location but has not yet been received, typically tracked through open transfer orders. |
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 receiving or inspection 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 |
Indicates whether this account requires reconciliation using a matching process, common for bank or credit card accounts. |
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 number indicating eligibility for tax-exempt resale. |
dimension |
revalue |
revalue |
Indicates whether an asset or inventory should be revalued. |
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 final amount agreed upon for settlement of an invoice or claim. |
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 |
Indicates whether a default donation amount should be displayed, relevant for non-profit entities. |
dimension |
shownotes |
shownotes |
Indicates whether notes associated with a record should be displayed. |
dimension |
skey |
skey |
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. |
dimension |
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 reorder point or time-phased. |
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 |
Indicates if an event has a specific scheduled time or duration. |
dimension |
timemodified |
timemodified |
The time when the record was last modified. |
dimension |
timeofftype |
timeofftype |
The category or type of time off taken by an employee, such as vacation or sick leave. |
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 that is generated based on the transaction type. |
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 of a URL used for constructing links to a record or page. |
dimension |
usebins |
usebins |
A flag indicating whether bin management is enabled for an item or location. |
dimension |
usemarginalrates |
usemarginalrates |
dimension |
|
usepermissions |
usepermissions |
Indicates whether access to the record is controlled by permissions. |
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 |
Indicates the amount of revenue recognized under Vendor Specific Objective Evidence (VSOE) that has been delivered. |
dimension |
vsoesopgroup |
vsoesopgroup |
The VSOE (Vendor Specific Objective Evidence) Standalone Selling Price (SSP) group to which an item belongs. |
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 |