Published on June 21, 2022.
Many of the SuiteQL-related questions that I get asked the most often involve NetSuite account configuration. For example, developers ask if it's possible to use SuiteQL to determine the customizations have been made to a NetSuite account, or the features that have been enabled in it.
I've written in the past about queries that can be used to get information about the Custom Record Types and Custom Fields that have been setup in an account, and more recently about any Custom Lists that have been setup.
It is also possible to use SuiteQL to get information about the features that have been enabled in an account, as well as the features that are available - which is a slight, but important, difference. That information is available in a table named CompanyFeatureSetup, and you can query it like this:SELECT Name, ID, IsAvailable, IsActive FROM CompanyFeatureSetup ORDER BY Name
The results will look something like the table shown below, which lists 288 features, and indicates if they are available in the account, and if they are active.
name | id | isavailable | isactive |
---|---|---|---|
Box Document Management | BOXNET | T | F |
A/P | PAYABLES | T | T |
A/R | RECEIVABLES | T | T |
ACH Vendor Payments | ACHVEND | T | F |
Accounting | ACCOUNTING | T | T |
Accounting Periods | ACCOUNTINGPERIODS | T | T |
Activity Codes | ACTIVITYCODES | F | F |
Add-On Items | ADDONS | T | F |
Adjustment Only Books | MULTIBOOK | T | F |
Advanced Bill of Materials | ADVANCEDBILLOFMATERIALS | F | F |
Advanced Billing | ADVBILLING | T | T |
Advanced Bin/Numbered Inventory Management | ADVBINSERIALLOTMGMT | T | T |
Advanced Employee Permissions | ADVANCEDEMPLOYEEPERMISSIONS | F | F |
Advanced Forecasting | ADVFORECASTING | T | T |
Advanced Government-Issued ID Tracking | ADVANCEDGVMNTISSUEDIDTRACKING | F | F |
Advanced Inventory Management | ADVINVENTORYMGMT | T | T |
Advanced Item Location Configuration | ENHANCEDINVENTORYLOCATION | T | F |
Advanced Numbering | ADVANCEDNUMBERINGSEQUENCES | T | F |
Advanced PDF/HTML Templates | ADVANCEDPRINTING | T | T |
Advanced Partner Access | ADVPARTNERACCESS | T | F |
Advanced Procurement Approvals | ADVANCEDPROCUREMENTAPPROVALS | T | F |
Advanced Project Budgets | WBS | F | F |
Advanced Project Profitability | ADVANCEDPROJECTACCOUNTING | T | F |
Advanced Promotions | ADVANCEDPROMOTIONS | T | F |
Advanced Receiving | ADVRECEIVING | T | T |
Advanced Revenue Management | ADVANCEDREVENUERECOGNITION | T | F |
Advanced Revenue Recognition SuiteApp | ADVANCEDREVENUERECOGNITIONAPP | T | F |
Advanced Shipping | ADVSHIPPING | T | T |
Advanced Site Customization | ADVANCEDSITECUST | T | T |
Advanced Subscription Billing | ADVSUBSCRIPTIONBILLING | T | T |
Advanced Taxes | ADVTAXENGINE | T | T |
Advanced Web Reports | ADVWEBREPORTS | T | T |
Advanced Web Search | ADVWEBSEARCH | T | T |
Alternate Sales Amount | ALTSALESAMOUNT | F | F |
Amortization | AMORTIZATION | T | F |
Approval Routing | APPROVALROUTING | T | T |
Assembly Items | ASSEMBLIES | F | F |
Asynchronous AfterSubmit Customer Processing | ASYNCCUSTOMER | T | T |
Asynchronous AfterSubmit Sales Order Processing | ASYNCSALESORDER | T | T |
Auto-Apply Promotions | AUTOAPPLYPROMOTIONS | T | T |
Automated Case Escalation | ESCALATIONRULES | T | F |
Automated Intercompany Drop Ship | INTERCOMPANYAUTODROPSHIP | T | F |
Automated Intercompany Management | INTERCOMPANYAUTOELIMINATION | T | F |
Automatic Location Assignment | AUTOLOCATIONASSIGNMENT | T | T |
Available To Promise | AVAILABLETOPROMISE | T | F |
Balancing Segments | BALANCING_SEGMENTS | T | F |
Bar Coding and Item Labels | BARCODES | T | T |
Basic Government-Issued ID Tracking | BASICGVMNTISSUEDIDTRACKING | F | F |
Bill Costs To Customers | BILLSCOSTS | T | T |
Billing Accounts | BILLINGACCOUNTS | T | T |
Billing Operations | BILLINGWORKCENTER | T | T |
Billing Rate Cards | BILLINGRATECARDS | T | F |
Bin Management | BINMANAGEMENT | T | T |
Blanket Purchase Orders | BLANKETPURCHASEORDERS | T | F |
CRM Template Categories | CRM_TEMPLATE_CATEGORIES | T | T |
Cached Data in Datasets | SUITECUBE_ENTERPRISE | T | F |
Campaign Assistant | CAMPAIGNASSISTANT | T | F |
Capture Email Replies | EMAILINTEGRATION | T | T |
Centralized Purchasing and Billing | CENTRALIZEDPURCHASINGBILLING | T | F |
Charge-Based Billing | CHARGEBASEDBILLING | T | T |
Classes | CLASSES | T | T |
Client SuiteScript | CUSTOMCODE | T | T |
Commerce Categories | COMMERCECATEGORIES | T | T |
Commerce Search Analytics | COMMERCESEARCHANALYTICS | T | T |
Commission on Custom Fields | COMMISSIONONCUSTOMFIELDS | F | F |
Compensation Tracking | COMPENSATIONTRACKING | F | F |
Consolidated Payments | CONSOLPAYMENTS | T | F |
Copy To Account | SDFCOPYTOACCOUNT | T | F |
Create bundles with SuiteBundler | CREATESUITEBUNDLES | T | T |
Credit Card Payments | CCTRACKING | T | T |
Credit Card Soft Descriptors | SOFTDESCRIPTORS | T | F |
Currency Exchange Rate Integration | FXRATEUPDATES | T | F |
Currency Exchange Rate Types | FXRATETYPE | T | F |
Custom GL Lines | CUSTOMGLLINES | T | T |
Custom Records | CUSTOMRECORDS | T | T |
Custom Segments | CUSTOMSEGMENTS | T | F |
Custom Transactions | CUSTOMTRANSACTIONS | T | T |
Customer Access | CUSTOMERACCESS | T | T |
Customer Relationship Management | CRM | T | T |
Customer Support and Service | SUPPORT | T | T |
Customizable Checkout Subdomains | CHECKOUTSUBDOMAIN | T | F |
Demand Planning | ITEMDEMANDPLANNING | T | T |
Departments | DEPARTMENTS | T | T |
Descriptive URLs | SITELOCATIONALIASES | T | T |
Disable HMAC-SHA1 for Token-based Authentication | KILLSHA1FORTBA | T | F |
Disable Inbound Single Sign-on | KILLINBOUNDSSO | T | F |
Distribution Resource Planning | DISTRIBUTIONRESOURCEPLANNING | T | F |
Document Publishing | DOCUMENTPUBLISHING | T | F |
Drop Shipments & Special Orders | DROPSHIPMENTS | T | T |
Duplicate Detection & Merge | DUPLICATES | T | T |
Dynamic Allocation | DYNALLOCATION | T | T |
EU One Stop Shop | MOSS | T | F |
Effective Dating | EFFECTIVEDATING | F | F |
Electronic Funds Transfer | EFT | T | F |
Email Case Capture | INBOUNDCASEEMAIL | T | F |
Employee Center Dashboard Publishing | EMPLOYEECENTERPUBLISHING | F | F |
Employee Change Requests | EMPLOYEECHANGEREQUESTS | F | F |
Employee Commissions | COMMISSIONS | F | F |
Enhanced File Security | FCEXPENSE | T | F |
Enhanced Premier Payroll | ENHANCEDPREMIERPAYROLL | F | F |
Estimates | ESTIMATES | T | T |
Expense Allocation | EXPENSEALLOCATION | T | T |
Expense Reports | EXPREPORTS | T | T |
Expense migration scheduled from start | FCEXPENSEMIGRATECONTROLLER | T | F |
Extended Accounting Period Close Process | PERBOOKCLOSING | T | F |
External Catalog Site (WSDK) | EXTSTORE | T | F |
File Cabinet | DOCUMENTS | T | T |
File Cabinet Advanced Security | FCADVANCEDSECURITY | T | F |
Foreign currency variance mapping | GAINLOSSACCTMAPPING | T | F |
Fulfillment Request | FULFILLMENTREQUEST | T | T |
GL Audit Numbering | GLAUDITNUMBERING | T | F |
Gift Certificates | GIFTCERTIFICATES | T | T |
Global Permissions | EMPPERMS | T | T |
Grid Order Management | GRIDORDERMANAGEMENT | T | F |
Gross Profit | GROSSPROFIT | T | T |
Group Average Costing | GROUPAVERAGECOSTING | T | T |
Help Desk | HELPDESK | T | F |
Historical Metrics | HISTORICALMETRICS | T | F |
Host HTML Files | WEBHOSTING | T | T |
IP Address Rules | IPADDRESSRULES | T | F |
In-Transit Payments | INTRANSITPAYMENTS | T | F |
Inbound Shipment Management | INBOUNDSHIPMENT | T | F |
India Localization SuiteTax Engine | SUITETAXENGINEINDIA | T | F |
India Localization SuiteTax Reports | SUITETAXREPORTSINDIA | T | F |
Inline Editing | EXTREMELIST | T | T |
Installments | INSTALLMENTS | T | T |
Intelligent Recommendations | INTELLIGENTRECOMMENDATIONS | T | F |
Intercompany Cross-Subsidiary Fulfillment | CROSSSUBSIDIARYFULFILLMENT | T | F |
Intercompany Framework | INTERCOMPANYFRAMEWORK | T | F |
Intercompany Time and Expense | INTERCOMPANYTIMEEXPENSE | T | F |
International Tax Reports | I18NTAXREPORTS | T | T |
Intranet | INTRANET | T | T |
Inventory | INVENTORY | T | T |
Inventory Count | INVENTORYCOUNT | T | T |
Inventory Status | INVENTORYSTATUS | T | F |
Invoice Groups | INVOICEGROUP | T | F |
Item Options | ITEMOPTIONS | T | T |
Job Costing and Project Budgeting | JOBCOSTING | F | F |
Job Management | JOBMANAGEMENT | F | F |
Job Requisitions | JOBREQUISITION | F | F |
KPI Scorecards | KPIREPORTS | T | T |
Knowledge Base | KNOWLEDGEBASE | T | F |
Kudos | KUDOS | F | F |
Landed Cost | LANDEDCOST | T | T |
Lead Conversion | LEADMANAGEMENT | T | F |
Locations | LOCATIONS | T | T |
Lot Tracking | LOTNUMBEREDINVENTORY | T | T |
Mail Merge | MAILMERGE | T | T |
Manufacturing Routing and Work Center | MFGROUTING | F | F |
Manufacturing Work In Process | MFGWORKINPROCESS | F | F |
Marketing Automation | MARKETING | T | T |
Material Requirements Planning | MATERIALREQUIREMENTSPLANNING | T | F |
Matrix Items | MATRIXITEMS | T | T |
Merchandise Hierarchy | MERCHANDISEHIERARCHY | T | F |
Mobile Push Notification | MOBILEPUSHNTF | T | T |
Multi Currency Merge | MULTICURRENCYMERGE | T | T |
Multi Subsidiary Customer | MULTISUBSIDIARYCUSTOMER | T | F |
Multi-Currency Customers | MULTICURRENCYCUSTOMER | T | T |
Multi-Currency Vendors | MULTICURRENCYVENDOR | T | T |
Multi-Language | MULTILANGUAGE | T | F |
Multi-Location Inventory | MULTILOCINVT | T | T |
Multi-Partner Management | MULTIPARTNER | T | F |
Multiple Budgets | MULTIPLEBUDGETS | T | T |
Multiple Calendars | MULTIPLECALENDARS | T | T |
Multiple Currencies | MULTICURRENCY | T | T |
Multiple Prices | MULTPRICE | T | T |
Multiple Shipping Routes | MULTISHIPTO | T | T |
Multiple Units of Measure | UNITSOFMEASURE | T | T |
Multiple Vendors | MULTIVENDOR | T | T |
NetSuite Analytics Warehouse | SUITE_OAX_CONNECTOR | F | F |
NetSuite Approvals Workflow | NETSUITEAPPROVALSWORKFLOW | T | F |
NetSuite as OIDC Provider | NSASOIDCPROVIDER | T | F |
New Weekly Timesheets Interface | WEEKLYTIMESHEETSNEWUI | T | F |
OAuth 2.0 | OAUTH2 | T | F |
Online Forms | EXTCRM | T | T |
Online Ordering | ONLINEORDERING | T | T |
OpenID Connect (OIDC) Single Sign-on | OIDC | T | F |
OpenID Single Sign-on | OPENIDSSO | T | F |
Opportunities | OPPORTUNITIES | T | T |
Other Sublist Fields | OTHERSUBLISTFIELDS | F | T |
Outsourced Manufacturing | OUTSOURCEDMFG | F | F |
Partner Access | PARTNERACCESS | T | F |
Partner Commissions/Royalties | PARTNERCOMMISSIONS | F | F |
Partner Relationship Management | PRM | T | F |
PayPal Integration | PAYPALINTEGRATION | T | F |
Paycheck Journal | PAYCHECKJOURNAL | T | F |
Payment Instruments | PAYMENTINSTRUMENTS | T | T |
Payment Link | PAYMENTLINK | T | T |
Payroll | PAYROLL | F | F |
Payroll Service | PAYROLLSERVICE | F | F |
Per-Employee Billing Rates | BILLINGCLASSES | T | T |
Performance Management | PERFORMANCEMANAGEMENT | F | F |
Period End Journal Entries | PERIODENDJOURNALENTRIES | T | F |
Personalized Catalog Views | PERSONALIZED_CATALOG_VIEWS | T | T |
Pick, Pack and Ship | PICKPACKSHIP | T | T |
Planned Work | PLANNEDWORK | F | F |
Project Management | ADVANCEDJOBS | F | F |
Project Task Manager | PROJECTTASKMANAGER | F | F |
Projects | JOBS | T | T |
Promotion Codes | PROMOCODES | T | T |
Purchase Contracts | PURCHASECONTRACTS | T | T |
Purchase Orders | PURCHASEORDERS | T | T |
Purchase Requests | PURCHASEREQS | T | T |
Quantity Pricing | QUANTITYPRICING | T | T |
REST Web Services | RESTWEBSERVICES | T | T |
Remove Personal Information | PI_REMOVAL | T | F |
Request For Quote | RFQ | T | T |
Required Deposit Workflow | REQUIREDDEPOSITWORKFLOW | T | F |
Requisitions | REQUISITIONS | T | F |
Resource Allocation Approval Workflow | RESOURCEALLOCATIONAPPROVAL | F | F |
Resource Allocation Chart | RESOURCEALLOCATIONCHART | F | F |
Resource Allocations | RESOURCEALLOCATIONS | F | F |
Resource Skill Sets | RESOURCESKILLSETS | F | F |
Return Authorizations | RETURNAUTHS | T | T |
Revenue Commitments | REVENUECOMMITMENTS | F | F |
Revenue Recognition | REVENUERECOGNITION | F | F |
Rule-Based Recognition Treatment | RULEBASEDRECOGNITIONTREATMENT | T | F |
SAML Single Sign-on | SAMLSSO | T | F |
SOAP Web Services | WEBSERVICESEXTERNAL | T | T |
Sales Campaigns | SALESCAMPAIGNS | T | T |
Sales Channel Allocation | SALESCHANNELALLOCATION | T | F |
Sales Force Automation | SFA | T | T |
Sales Order Revenue Forecasting | REVRECSALESORDERFORECASTING | F | F |
Sales Orders | SALESORDERS | T | T |
Sell Downloadable Files | DOWNLOADITEMS | F | F |
Send Purchase Card Data | PURCHASECARDDATA | F | F |
Serialized Inventory | SERIALIZEDINVENTORY | T | T |
Server SuiteScript | SERVERSIDESCRIPTING | T | T |
Service Printed Checks and Stubs | SERVICEPRINTEDCHECKS | F | F |
Service Printed W-2s and 1099s | SERVICEPRINTEDW2S | F | F |
Shipping Label Integration | SHIPPINGLABELS | T | T |
Site Builder (Web Store) | SITEBUILDER_STORE | T | T |
Site Builder (Website) | SITEBUILDER | T | T |
Site Management Tools | ADVANCEDSITEMANAGEMENT | T | T |
Standard Costing | STANDARDCOSTING | T | F |
Statistical Accounts | STATACCOUNTING | T | T |
Store Pickup | STOREPICKUP | T | T |
Subscription Billing | SUBSCRIPTIONBILLING | T | T |
Subscription Billing Enhanced UI SuiteApp | TIMEBASEDPRICINGSUITEAPP | T | F |
Subscription Categories | CAMPAIGNSUBSCRIPTIONS | T | T |
SuiteAnalytics Connect | SUITEANALYTICSCONNECT | F | F |
SuiteAnalytics Workbook | USR | T | T |
SuiteApp Control Center | SUITEAPPCONTROLCENTER | T | F |
SuiteCloud Development Framework | SUITEAPPDEVELOPMENTFRAMEWORK | T | T |
SuiteCommerce | SUITECOMMERCE | T | T |
SuiteCommerce Advanced | SUITECOMMERCE_ADVANCED | T | T |
SuiteCommerce In-Store | SUITECOMMERCE_IN_STORE | T | T |
SuiteCommerce My Account | SUITECOMMERCE_MY_ACCOUNT | T | T |
SuiteFlow | WORKFLOW | T | T |
SuitePromotions | STACKABLEPROMOTIONS | T | T |
SuiteScript Server Pages | WEBAPPLICATIONS | T | T |
SuiteSignOn | SUITESIGNON | T | T |
SuiteSocial | SUITESOCIAL | T | F |
SuiteTax Data Records | SUITETAXDATARECORDS | T | F |
SuiteTax Engine | SUITETAXENGINE | T | F |
SuiteTax Reports | SUITETAXREPORTS | T | F |
Supplementary Tax Calculation | SUPPLTAXCALC | T | T |
Supply Allocation | SUPPLYALLOCATION | T | F |
Supply Chain Control Tower | SUPPLYCHAINCONTROLTOWER | T | F |
Supply Chain Management | SUPPLYCHAINMANAGEMENT | T | F |
Supply Chain Predicted Risks | SUPPLYCHAINPREDICTEDRISKS | T | F |
Tableau® Workbook Export | TABLEAU | T | F |
Tax Audit Files | TAXAUDITFILES | T | T |
Team Selling | TEAMSELLING | T | F |
Telephony Integration | TELEPHONY | T | F |
Termination Reason Tracking | TERMINATIONREASONTRACKING | F | F |
Time Tracking | TIMETRACKING | T | T |
Time Tracking for CRM | CRMTIME | T | F |
Time-Based Pricing | TIMEBASEDPRICING | T | F |
Time-Off Management | TIMEOFFMANAGEMENT | F | F |
Token-based Authentication | TBA | T | T |
URL Component Aliases | URLCOMPONENTALIASES | T | T |
Upsell Manager | UPSELL | T | T |
Use Deletion Reason | TRANDELETIONREASONCODE | T | F |
VSOE | REVRECVSOE | F | F |
Vendor Access | VENDORACCESS | T | F |
Vendor Prepayments | VENDORPREPAYMENTS | T | F |
Warehouse Management | WMSSYSTEM | F | F |
Warranty and Repairs Management | WARRANTYANDREPAIRSMANAGEMENT | T | F |
Web Site Duplicate Email Management | WEBDUPLICATEEMAILMANAGEMENT | T | T |
Website | WEBSITE | T | T |
Weekly Timesheets | WEEKLYTIMESHEETS | T | F |
Withholding Tax | WITHHOLDINGTAX | T | F |
Work Orders | WORKORDERS | F | F |
Workforce Analytics | HRANALYSIS | F | F |
Worldwide Support for Phone Number Formatting | INTERNATIONALPHONENUMBERS | T | F |
{#Issue#} Management | ISSUEDB | F | F |
{#Vendor Return Authorizations#} | VENDORRETURNAUTHS | T | T |
The CompanyFeatureSetup table can be very helpful if you're trying to determine differences between accounts, whether they're different customer accounts, or even differences between production, sandbox, or developer accounts.
Hello, I'm Tim Dietrich. I develop custom software for businesses that are running on NetSuite, including mobile apps, Web portals, Web APIs, and more.
I'm the developer of several popular NetSuite open source solutions, including the SuiteQL Query Tool, SuiteAPI, and more.
I founded SuiteStep, a NetSuite development studio, to provide custom software and AI solutions - and continue pushing the boundaries of what's possible on the NetSuite platform.
Copyright © 2025 Tim Dietrich.