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 identifier of the associated general ledger account. |
metric |
account.links |
account.links |
A collection of HATEOAS links related to the associated general ledger account resource. |
dimension |
account.refName |
account.refName |
The human-readable reference name or display name of the associated general ledger account. |
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 |
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 |
amountPaid |
amountPaid |
The total amount that has been paid on a transaction. |
metric |
amountRemaining |
amountRemaining |
The remaining amount due on a transaction after any payments or credits have been applied. |
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 |
applied |
applied |
The portion of a payment or credit that has been formally applied to one or more open transactions. |
metric |
apply.links |
apply.links |
A collection of HATEOAS links related to the application of payments or credits. |
dimension |
approvalstatus |
approvalstatus |
The current status of a record within an approval workflow (e.g., Pending Approval, Approved, Rejected). |
metric |
arAcct.id |
arAcct.id |
The internal identifier of the Accounts Receivable (AR) account. |
metric |
arAcct.links |
arAcct.links |
A collection of HATEOAS links related to the Accounts Receivable (AR) account resource. |
dimension |
arAcct.refName |
arAcct.refName |
The human-readable reference name or display name of the Accounts Receivable (AR) account. |
dimension |
asOfDate |
asOfDate |
The specific date as of which a report or financial statement is generated. |
dimension |
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 |
balance |
balance |
The current outstanding monetary balance for an account or transaction. |
metric |
balancesearch |
balancesearch |
Represents the current balance of an account as determined by a search query. |
metric |
billAddress |
billAddress |
The billing address associated with a transaction or entity. |
dimension |
billAddressList |
billAddressList |
A list of available billing addresses for selection. |
dimension |
billAddressList.id |
billAddressList.id |
The internal identifier of the selected billing address from a predefined list. |
metric |
billAddressList.links |
billAddressList.links |
A collection of HATEOAS links related to the billing address list resource. |
dimension |
billAddressList.refName |
billAddressList.refName |
The human-readable reference name or display name of the selected billing address from a list. |
dimension |
billexchratevarianceacct |
billexchratevarianceacct |
The general ledger account used to record variances due to changes in exchange rates on vendor bills. |
metric |
billingAddress.links |
billingAddress.links |
A collection of HATEOAS links related to the billing address resource. |
dimension |
billingAddress_text |
billingAddress_text |
The complete billing address presented as a single formatted text string. |
dimension |
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 |
checkNumber |
checkNumber |
The unique number assigned to a physical check used for payment. |
dimension |
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 when a payment or transaction was officially cleared by the financial institution. |
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 |
createdDate |
createdDate |
The date and time when the record was initially created in the system. |
dimension |
createdFrom |
createdFrom |
Reference to the source record from which the current record was created (e.g., an invoice created from a sales order). |
dimension |
createdFrom.id |
createdFrom.id |
The internal identifier of the record from which the current record was created. |
metric |
createdFrom.links |
createdFrom.links |
A collection of HATEOAS links related to the source record from which the current record was created. |
dimension |
createdFrom.refName |
createdFrom.refName |
The human-readable reference name or display name of the source record from which the current record was created. |
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 |
credit.links |
credit.links |
A collection of HATEOAS links related to credit memos or credit applications. |
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 |
currency.id |
currency.id |
The internal identifier of the currency used for the transaction. |
metric |
currency.links |
currency.links |
A collection of HATEOAS links related to the currency resource. |
dimension |
currency.refName |
currency.refName |
The human-readable reference name or display name of the currency. |
dimension |
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 script deployment in NetSuite. Script deployments define how and when a SuiteScript runs. |
dimension |
deposit.links |
deposit.links |
A collection of HATEOAS links related to deposit records. |
dimension |
dept_name |
dept_name |
Identifies and categorizes records based on the department they belong to in the NetSuite account. |
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 |
discountItem |
discountItem |
Reference to the item record specifically configured to represent a discount. |
dimension |
discountItem.id |
discountItem.id |
The internal identifier of the item record used for a discount. |
metric |
discountItem.links |
discountItem.links |
A collection of HATEOAS links related to the discount item resource. |
dimension |
discountItem.refName |
discountItem.refName |
The human-readable reference name or display name of the discount item. |
dimension |
discountRate |
discountRate |
The percentage rate applied for a discount. |
metric |
discountTotal |
discountTotal |
The total monetary value of the discount applied to a transaction. |
metric |
discountdate |
discountdate |
The date by which payment must be made to receive an early payment discount. |
dimension |
displayfield |
displayfield |
Indicates whether a field is visible on a record form. This can also refer to the display type setting for custom 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 |
A boolean (checkbox) field on a transaction line that controls whether the line item is displayed. This is particularly relevant for components within a kit. |
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 action is required. |
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 |
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 concluding date of a defined period or term. |
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 |
entity.id |
entity.id |
The internal identifier of the associated entity (e.g., customer, vendor, employee). |
metric |
entity.links |
entity.links |
A collection of HATEOAS links related to the associated entity resource. |
dimension |
entity.refName |
entity.refName |
The human-readable reference name or display name of the associated entity. |
dimension |
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 |
estGrossProfit |
estGrossProfit |
The estimated gross profit amount for a transaction or item. |
metric |
estGrossProfitPercent |
estGrossProfitPercent |
The estimated gross profit expressed as a percentage. |
metric |
exchangeRate |
exchangeRate |
The currency exchange rate used when processing transactions in multiple currencies. |
metric |
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 |
expCost.links |
expCost.links |
A collection of HATEOAS links related to expense cost records. |
dimension |
expenseaccount |
expenseaccount |
The General Ledger account used to record expenses. |
metric |
externalId |
externalId |
A unique identifier assigned to the record by an external system, often used for integration purposes. |
dimension |
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 |
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 designated for recording financial gains or losses. |
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 |
handlingMode.id |
handlingMode.id |
The internal identifier of the specified handling mode (e.g., for shipping or delivery). |
dimension |
handlingMode.refName |
handlingMode.refName |
The human-readable reference name or display name of the handling mode. |
dimension |
hascostline |
hascostline |
A boolean field indicating whether a transaction line includes cost information. This field is available in the TRANSACTION_LINES table for SuiteQL queries. |
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 |
integrationId |
integrationId |
A unique identifier specifically used for tracking data through external integrations. |
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 flag indicating if an entity (customer or vendor) that acts as an agent for a subsidiary was automatically generated by NetSuite. |
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 flag indicating whether the item is designated as a donation item. |
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 |
itemCost.links |
itemCost.links |
A collection of HATEOAS links related to item cost records. |
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 |
job |
job |
Reference to an associated job or project. |
dimension |
job.id |
job.id |
The internal identifier of the associated job or project. |
metric |
job.links |
job.links |
A collection of HATEOAS links related to the job or project resource. |
dimension |
job.refName |
job.refName |
The human-readable reference name or display name of the associated job or project. |
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 flag used in NetSuite searches and reports to identify the main header line of a transaction. |
dimension |
manufacturer |
manufacturer |
The company that produced an item. |
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 |
Refers to an access setting for custom record types, indicating that no specific permissions are required for internal roles to access the 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 flag indicating whether the items for an order have been physically picked from inventory. |
dimension |
originator |
originator |
The individual or entity responsible for initiating the transaction or record. |
dimension |
otherRefNum |
otherRefNum |
Represents a reference number, such as a customer’s Purchase Order (PO) number, associated with a transaction in NetSuite. This field is commonly found on sales orders, invoices, and purchase orders. |
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 |
partners.links |
partners.links |
A collection of HATEOAS links related to associated partner records. |
dimension |
payment |
payment |
The monetary amount of a payment or a reference to a payment record. |
metric |
paymentOperation |
paymentOperation |
The specific type of payment operation performed (e.g., authorization, capture, refund). |
dimension |
paymentOperation.id |
paymentOperation.id |
The internal identifier of the payment operation. |
dimension |
paymentOperation.refName |
paymentOperation.refName |
The human-readable reference name or display name of the payment operation. |
dimension |
paymentOption |
paymentOption |
The chosen method for making a payment (e.g., credit card, bank transfer). |
dimension |
paymentOption.id |
paymentOption.id |
The internal identifier of the selected payment option. |
metric |
paymentOption.links |
paymentOption.links |
A collection of HATEOAS links related to the payment option resource. |
dimension |
paymentOption.refName |
paymentOption.refName |
The human-readable reference name or display name of the payment option. |
dimension |
paymentProcessingProfile |
paymentProcessingProfile |
The configuration profile used for processing payments, defining rules and gateways. |
dimension |
paymentProcessingProfile.id |
paymentProcessingProfile.id |
The internal identifier of the payment processing profile. |
metric |
paymentProcessingProfile.links |
paymentProcessingProfile.links |
A collection of HATEOAS links related to the payment processing profile resource. |
dimension |
paymentProcessingProfile.refName |
paymentProcessingProfile.refName |
The human-readable reference name or display name of the payment processing profile. |
dimension |
paymenthold |
paymenthold |
Indicates whether a payment is currently on hold, preventing its processing. |
dimension |
paymentlink |
paymentlink |
A URL or identifier for a payment link that allows customers to make payments. |
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 |
pending |
pending |
A flag indicating that a transaction, status, or action is awaiting completion or approval. |
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.id |
postingPeriod.id |
The internal identifier of the accounting posting period. |
metric |
postingPeriod.links |
postingPeriod.links |
A collection of HATEOAS links related to the posting period resource. |
dimension |
postingPeriod.refName |
postingPeriod.refName |
The human-readable reference name or display name of the accounting posting period. |
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 relevant in a sequence of dates or for a historical reference. |
dimension |
prevRep |
prevRep |
Reference to the sales representative who was previously assigned to an account or transaction. |
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 |
An identifier or reference number associated with service resale items, which are services bought and then billed to customers. |
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 |
salesEffectiveDate |
salesEffectiveDate |
The date when a sales transaction officially becomes effective or active. |
dimension |
salesRep |
salesRep |
Reference to the sales representative assigned to an account or transaction. |
dimension |
salesRep.id |
salesRep.id |
The internal identifier of the assigned sales representative. |
metric |
salesRep.links |
salesRep.links |
A collection of HATEOAS links related to the sales representative resource. |
dimension |
salesRep.refName |
salesRep.refName |
The human-readable reference name or display name of the sales representative. |
dimension |
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 |
shipAddress |
shipAddress |
The shipping address associated with a transaction or order. |
dimension |
shipAddressList |
shipAddressList |
A list of available shipping addresses for selection. |
dimension |
shipAddressList.id |
shipAddressList.id |
The internal identifier of the selected shipping address from a predefined list. |
metric |
shipAddressList.links |
shipAddressList.links |
A collection of HATEOAS links related to the shipping address list resource. |
dimension |
shipAddressList.refName |
shipAddressList.refName |
The human-readable reference name or display name of the selected shipping address from a list. |
dimension |
shipDate |
shipDate |
The date when items were shipped or are scheduled to be shipped. |
dimension |
shipIsResidential |
shipIsResidential |
A flag indicating whether the shipping address is classified as a residential address. |
dimension |
shipOverride |
shipOverride |
A boolean field used to indicate whether a custom shipping address is being applied to a transaction, overriding the default address linked to the customer. |
dimension |
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.links |
shippingAddress.links |
A collection of HATEOAS links related to the shipping address resource. |
dimension |
shippingAddress_text |
shippingAddress_text |
The complete shipping address presented as a single formatted text string. |
dimension |
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. |
dimension |
shownotes |
shownotes |
A boolean flag indicating if notes associated with a record or transaction should be displayed. |
dimension |
skey |
skey |
A system-generated key often used for internal sorting or indexing purposes. |
dimension |
source |
source |
The source of a transaction or record (e.g., Web, Phone, POS). |
dimension |
source.id |
source.id |
The internal identifier of the source system or record from which the data originates. |
dimension |
source.refName |
source.refName |
The human-readable reference name or display name of the source system or record. |
dimension |
startDate |
startDate |
The initial date of a defined period or term. |
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 |
status.id |
status.id |
The internal identifier of the current status of the record or transaction. |
dimension |
status.refName |
status.refName |
The human-readable reference name or display name of the current status. |
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 |
subtotal |
subtotal |
The sum of all line item amounts before any taxes, discounts, or shipping charges are applied. |
metric |
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 |
terms.id |
terms.id |
The internal identifier of the payment terms (e.g., ‘Net 30’). |
metric |
terms.links |
terms.links |
A collection of HATEOAS links related to the payment terms resource. |
dimension |
terms.refName |
terms.refName |
The human-readable reference name or display name of the payment terms. |
dimension |
time.links |
time.links |
A collection of HATEOAS links related to time tracking or time entries. |
dimension |
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 |
toBeEmailed |
toBeEmailed |
A flag indicating whether the document or record is marked for emailing. |
dimension |
toBeFaxed |
toBeFaxed |
A flag indicating whether the document or record is marked for faxing. |
dimension |
toBePrinted |
toBePrinted |
A flag indicating whether the document or record is marked for printing. |
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 |
total |
total |
The final grand total amount of the transaction, including all applicable charges, taxes, and discounts. |
metric |
totalCostEstimate |
totalCostEstimate |
The estimated total cost associated with the transaction, project, or item. |
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 |
tranId |
tranId |
The internal transaction identifier, often a system-generated unique ID. |
metric |
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 |
transactionNumber |
transactionNumber |
The human-readable sequential number assigned to a transaction. |
dimension |
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 |
unapplied |
unapplied |
The amount of a payment or credit that has not yet been applied to any open transaction. |
metric |
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 |
Represents a segment of a URL used for defining web addresses, particularly for facets or item records in web stores. |
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 |
Represents the actual data content or specific selected option held within a field or property. |
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 |