NetSuite: Use SuiteQL to Get Features That are Available / Enabled

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.

nameidisavailableisactive
Box Document ManagementBOXNETTF
A/PPAYABLESTT
A/RRECEIVABLESTT
ACH Vendor PaymentsACHVENDTF
AccountingACCOUNTINGTT
Accounting PeriodsACCOUNTINGPERIODSTT
Activity CodesACTIVITYCODESFF
Add-On ItemsADDONSTF
Adjustment Only BooksMULTIBOOKTF
Advanced Bill of MaterialsADVANCEDBILLOFMATERIALSFF
Advanced BillingADVBILLINGTT
Advanced Bin/Numbered Inventory ManagementADVBINSERIALLOTMGMTTT
Advanced Employee PermissionsADVANCEDEMPLOYEEPERMISSIONSFF
Advanced ForecastingADVFORECASTINGTT
Advanced Government-Issued ID TrackingADVANCEDGVMNTISSUEDIDTRACKINGFF
Advanced Inventory ManagementADVINVENTORYMGMTTT
Advanced Item Location ConfigurationENHANCEDINVENTORYLOCATIONTF
Advanced NumberingADVANCEDNUMBERINGSEQUENCESTF
Advanced PDF/HTML TemplatesADVANCEDPRINTINGTT
Advanced Partner AccessADVPARTNERACCESSTF
Advanced Procurement ApprovalsADVANCEDPROCUREMENTAPPROVALSTF
Advanced Project BudgetsWBSFF
Advanced Project ProfitabilityADVANCEDPROJECTACCOUNTINGTF
Advanced PromotionsADVANCEDPROMOTIONSTF
Advanced ReceivingADVRECEIVINGTT
Advanced Revenue ManagementADVANCEDREVENUERECOGNITIONTF
Advanced Revenue Recognition SuiteAppADVANCEDREVENUERECOGNITIONAPPTF
Advanced ShippingADVSHIPPINGTT
Advanced Site CustomizationADVANCEDSITECUSTTT
Advanced Subscription BillingADVSUBSCRIPTIONBILLINGTT
Advanced TaxesADVTAXENGINETT
Advanced Web ReportsADVWEBREPORTSTT
Advanced Web SearchADVWEBSEARCHTT
Alternate Sales AmountALTSALESAMOUNTFF
AmortizationAMORTIZATIONTF
Approval RoutingAPPROVALROUTINGTT
Assembly ItemsASSEMBLIESFF
Asynchronous AfterSubmit Customer ProcessingASYNCCUSTOMERTT
Asynchronous AfterSubmit Sales Order ProcessingASYNCSALESORDERTT
Auto-Apply PromotionsAUTOAPPLYPROMOTIONSTT
Automated Case EscalationESCALATIONRULESTF
Automated Intercompany Drop ShipINTERCOMPANYAUTODROPSHIPTF
Automated Intercompany ManagementINTERCOMPANYAUTOELIMINATIONTF
Automatic Location AssignmentAUTOLOCATIONASSIGNMENTTT
Available To PromiseAVAILABLETOPROMISETF
Balancing SegmentsBALANCING_SEGMENTSTF
Bar Coding and Item LabelsBARCODESTT
Basic Government-Issued ID TrackingBASICGVMNTISSUEDIDTRACKINGFF
Bill Costs To CustomersBILLSCOSTSTT
Billing AccountsBILLINGACCOUNTSTT
Billing OperationsBILLINGWORKCENTERTT
Billing Rate CardsBILLINGRATECARDSTF
Bin ManagementBINMANAGEMENTTT
Blanket Purchase OrdersBLANKETPURCHASEORDERSTF
CRM Template CategoriesCRM_TEMPLATE_CATEGORIESTT
Cached Data in DatasetsSUITECUBE_ENTERPRISETF
Campaign AssistantCAMPAIGNASSISTANTTF
Capture Email RepliesEMAILINTEGRATIONTT
Centralized Purchasing and BillingCENTRALIZEDPURCHASINGBILLINGTF
Charge-Based BillingCHARGEBASEDBILLINGTT
ClassesCLASSESTT
Client SuiteScriptCUSTOMCODETT
Commerce CategoriesCOMMERCECATEGORIESTT
Commerce Search AnalyticsCOMMERCESEARCHANALYTICSTT
Commission on Custom FieldsCOMMISSIONONCUSTOMFIELDSFF
Compensation TrackingCOMPENSATIONTRACKINGFF
Consolidated PaymentsCONSOLPAYMENTSTF
Copy To AccountSDFCOPYTOACCOUNTTF
Create bundles with SuiteBundlerCREATESUITEBUNDLESTT
Credit Card PaymentsCCTRACKINGTT
Credit Card Soft DescriptorsSOFTDESCRIPTORSTF
Currency Exchange Rate IntegrationFXRATEUPDATESTF
Currency Exchange Rate TypesFXRATETYPETF
Custom GL LinesCUSTOMGLLINESTT
Custom RecordsCUSTOMRECORDSTT
Custom SegmentsCUSTOMSEGMENTSTF
Custom TransactionsCUSTOMTRANSACTIONSTT
Customer AccessCUSTOMERACCESSTT
Customer Relationship ManagementCRMTT
Customer Support and ServiceSUPPORTTT
Customizable Checkout SubdomainsCHECKOUTSUBDOMAINTF
Demand PlanningITEMDEMANDPLANNINGTT
DepartmentsDEPARTMENTSTT
Descriptive URLsSITELOCATIONALIASESTT
Disable HMAC-SHA1 for Token-based AuthenticationKILLSHA1FORTBATF
Disable Inbound Single Sign-onKILLINBOUNDSSOTF
Distribution Resource PlanningDISTRIBUTIONRESOURCEPLANNINGTF
Document PublishingDOCUMENTPUBLISHINGTF
Drop Shipments & Special OrdersDROPSHIPMENTSTT
Duplicate Detection & MergeDUPLICATESTT
Dynamic AllocationDYNALLOCATIONTT
EU One Stop ShopMOSSTF
Effective DatingEFFECTIVEDATINGFF
Electronic Funds TransferEFTTF
Email Case CaptureINBOUNDCASEEMAILTF
Employee Center Dashboard PublishingEMPLOYEECENTERPUBLISHINGFF
Employee Change RequestsEMPLOYEECHANGEREQUESTSFF
Employee CommissionsCOMMISSIONSFF
Enhanced File SecurityFCEXPENSETF
Enhanced Premier PayrollENHANCEDPREMIERPAYROLLFF
EstimatesESTIMATESTT
Expense AllocationEXPENSEALLOCATIONTT
Expense ReportsEXPREPORTSTT
Expense migration scheduled from startFCEXPENSEMIGRATECONTROLLERTF
Extended Accounting Period Close ProcessPERBOOKCLOSINGTF
External Catalog Site (WSDK)EXTSTORETF
File CabinetDOCUMENTSTT
File Cabinet Advanced SecurityFCADVANCEDSECURITYTF
Foreign currency variance mappingGAINLOSSACCTMAPPINGTF
Fulfillment RequestFULFILLMENTREQUESTTT
GL Audit NumberingGLAUDITNUMBERINGTF
Gift CertificatesGIFTCERTIFICATESTT
Global PermissionsEMPPERMSTT
Grid Order ManagementGRIDORDERMANAGEMENTTF
Gross ProfitGROSSPROFITTT
Group Average CostingGROUPAVERAGECOSTINGTT
Help DeskHELPDESKTF
Historical MetricsHISTORICALMETRICSTF
Host HTML FilesWEBHOSTINGTT
IP Address RulesIPADDRESSRULESTF
In-Transit PaymentsINTRANSITPAYMENTSTF
Inbound Shipment ManagementINBOUNDSHIPMENTTF
India Localization SuiteTax EngineSUITETAXENGINEINDIATF
India Localization SuiteTax ReportsSUITETAXREPORTSINDIATF
Inline EditingEXTREMELISTTT
InstallmentsINSTALLMENTSTT
Intelligent RecommendationsINTELLIGENTRECOMMENDATIONSTF
Intercompany Cross-Subsidiary FulfillmentCROSSSUBSIDIARYFULFILLMENTTF
Intercompany FrameworkINTERCOMPANYFRAMEWORKTF
Intercompany Time and ExpenseINTERCOMPANYTIMEEXPENSETF
International Tax ReportsI18NTAXREPORTSTT
IntranetINTRANETTT
InventoryINVENTORYTT
Inventory CountINVENTORYCOUNTTT
Inventory StatusINVENTORYSTATUSTF
Invoice GroupsINVOICEGROUPTF
Item OptionsITEMOPTIONSTT
Job Costing and Project BudgetingJOBCOSTINGFF
Job ManagementJOBMANAGEMENTFF
Job RequisitionsJOBREQUISITIONFF
KPI ScorecardsKPIREPORTSTT
Knowledge BaseKNOWLEDGEBASETF
KudosKUDOSFF
Landed CostLANDEDCOSTTT
Lead ConversionLEADMANAGEMENTTF
LocationsLOCATIONSTT
Lot TrackingLOTNUMBEREDINVENTORYTT
Mail MergeMAILMERGETT
Manufacturing Routing and Work CenterMFGROUTINGFF
Manufacturing Work In ProcessMFGWORKINPROCESSFF
Marketing AutomationMARKETINGTT
Material Requirements PlanningMATERIALREQUIREMENTSPLANNINGTF
Matrix ItemsMATRIXITEMSTT
Merchandise HierarchyMERCHANDISEHIERARCHYTF
Mobile Push NotificationMOBILEPUSHNTFTT
Multi Currency MergeMULTICURRENCYMERGETT
Multi Subsidiary CustomerMULTISUBSIDIARYCUSTOMERTF
Multi-Currency CustomersMULTICURRENCYCUSTOMERTT
Multi-Currency VendorsMULTICURRENCYVENDORTT
Multi-LanguageMULTILANGUAGETF
Multi-Location InventoryMULTILOCINVTTT
Multi-Partner ManagementMULTIPARTNERTF
Multiple BudgetsMULTIPLEBUDGETSTT
Multiple CalendarsMULTIPLECALENDARSTT
Multiple CurrenciesMULTICURRENCYTT
Multiple PricesMULTPRICETT
Multiple Shipping RoutesMULTISHIPTOTT
Multiple Units of MeasureUNITSOFMEASURETT
Multiple VendorsMULTIVENDORTT
NetSuite Analytics WarehouseSUITE_OAX_CONNECTORFF
NetSuite Approvals WorkflowNETSUITEAPPROVALSWORKFLOWTF
NetSuite as OIDC ProviderNSASOIDCPROVIDERTF
New Weekly Timesheets InterfaceWEEKLYTIMESHEETSNEWUITF
OAuth 2.0OAUTH2TF
Online FormsEXTCRMTT
Online OrderingONLINEORDERINGTT
OpenID Connect (OIDC) Single Sign-onOIDCTF
OpenID Single Sign-onOPENIDSSOTF
OpportunitiesOPPORTUNITIESTT
Other Sublist FieldsOTHERSUBLISTFIELDSFT
Outsourced ManufacturingOUTSOURCEDMFGFF
Partner AccessPARTNERACCESSTF
Partner Commissions/RoyaltiesPARTNERCOMMISSIONSFF
Partner Relationship ManagementPRMTF
PayPal IntegrationPAYPALINTEGRATIONTF
Paycheck JournalPAYCHECKJOURNALTF
Payment InstrumentsPAYMENTINSTRUMENTSTT
Payment LinkPAYMENTLINKTT
PayrollPAYROLLFF
Payroll ServicePAYROLLSERVICEFF
Per-Employee Billing RatesBILLINGCLASSESTT
Performance ManagementPERFORMANCEMANAGEMENTFF
Period End Journal EntriesPERIODENDJOURNALENTRIESTF
Personalized Catalog ViewsPERSONALIZED_CATALOG_VIEWSTT
Pick, Pack and ShipPICKPACKSHIPTT
Planned WorkPLANNEDWORKFF
Project ManagementADVANCEDJOBSFF
Project Task ManagerPROJECTTASKMANAGERFF
ProjectsJOBSTT
Promotion CodesPROMOCODESTT
Purchase ContractsPURCHASECONTRACTSTT
Purchase OrdersPURCHASEORDERSTT
Purchase RequestsPURCHASEREQSTT
Quantity PricingQUANTITYPRICINGTT
REST Web ServicesRESTWEBSERVICESTT
Remove Personal InformationPI_REMOVALTF
Request For QuoteRFQTT
Required Deposit WorkflowREQUIREDDEPOSITWORKFLOWTF
RequisitionsREQUISITIONSTF
Resource Allocation Approval WorkflowRESOURCEALLOCATIONAPPROVALFF
Resource Allocation ChartRESOURCEALLOCATIONCHARTFF
Resource AllocationsRESOURCEALLOCATIONSFF
Resource Skill SetsRESOURCESKILLSETSFF
Return AuthorizationsRETURNAUTHSTT
Revenue CommitmentsREVENUECOMMITMENTSFF
Revenue RecognitionREVENUERECOGNITIONFF
Rule-Based Recognition TreatmentRULEBASEDRECOGNITIONTREATMENTTF
SAML Single Sign-onSAMLSSOTF
SOAP Web ServicesWEBSERVICESEXTERNALTT
Sales CampaignsSALESCAMPAIGNSTT
Sales Channel AllocationSALESCHANNELALLOCATIONTF
Sales Force AutomationSFATT
Sales Order Revenue ForecastingREVRECSALESORDERFORECASTINGFF
Sales OrdersSALESORDERSTT
Sell Downloadable FilesDOWNLOADITEMSFF
Send Purchase Card DataPURCHASECARDDATAFF
Serialized InventorySERIALIZEDINVENTORYTT
Server SuiteScriptSERVERSIDESCRIPTINGTT
Service Printed Checks and StubsSERVICEPRINTEDCHECKSFF
Service Printed W-2s and 1099sSERVICEPRINTEDW2SFF
Shipping Label IntegrationSHIPPINGLABELSTT
Site Builder (Web Store)SITEBUILDER_STORETT
Site Builder (Website)SITEBUILDERTT
Site Management ToolsADVANCEDSITEMANAGEMENTTT
Standard CostingSTANDARDCOSTINGTF
Statistical AccountsSTATACCOUNTINGTT
Store PickupSTOREPICKUPTT
Subscription BillingSUBSCRIPTIONBILLINGTT
Subscription Billing Enhanced UI SuiteAppTIMEBASEDPRICINGSUITEAPPTF
Subscription CategoriesCAMPAIGNSUBSCRIPTIONSTT
SuiteAnalytics ConnectSUITEANALYTICSCONNECTFF
SuiteAnalytics WorkbookUSRTT
SuiteApp Control CenterSUITEAPPCONTROLCENTERTF
SuiteCloud Development FrameworkSUITEAPPDEVELOPMENTFRAMEWORKTT
SuiteCommerceSUITECOMMERCETT
SuiteCommerce AdvancedSUITECOMMERCE_ADVANCEDTT
SuiteCommerce In-StoreSUITECOMMERCE_IN_STORETT
SuiteCommerce My AccountSUITECOMMERCE_MY_ACCOUNTTT
SuiteFlowWORKFLOWTT
SuitePromotionsSTACKABLEPROMOTIONSTT
SuiteScript Server PagesWEBAPPLICATIONSTT
SuiteSignOnSUITESIGNONTT
SuiteSocialSUITESOCIALTF
SuiteTax Data RecordsSUITETAXDATARECORDSTF
SuiteTax EngineSUITETAXENGINETF
SuiteTax ReportsSUITETAXREPORTSTF
Supplementary Tax CalculationSUPPLTAXCALCTT
Supply AllocationSUPPLYALLOCATIONTF
Supply Chain Control TowerSUPPLYCHAINCONTROLTOWERTF
Supply Chain ManagementSUPPLYCHAINMANAGEMENTTF
Supply Chain Predicted RisksSUPPLYCHAINPREDICTEDRISKSTF
Tableau® Workbook ExportTABLEAUTF
Tax Audit FilesTAXAUDITFILESTT
Team SellingTEAMSELLINGTF
Telephony IntegrationTELEPHONYTF
Termination Reason TrackingTERMINATIONREASONTRACKINGFF
Time TrackingTIMETRACKINGTT
Time Tracking for CRMCRMTIMETF
Time-Based PricingTIMEBASEDPRICINGTF
Time-Off ManagementTIMEOFFMANAGEMENTFF
Token-based AuthenticationTBATT
URL Component AliasesURLCOMPONENTALIASESTT
Upsell ManagerUPSELLTT
Use Deletion ReasonTRANDELETIONREASONCODETF
VSOEREVRECVSOEFF
Vendor AccessVENDORACCESSTF
Vendor PrepaymentsVENDORPREPAYMENTSTF
Warehouse ManagementWMSSYSTEMFF
Warranty and Repairs ManagementWARRANTYANDREPAIRSMANAGEMENTTF
Web Site Duplicate Email ManagementWEBDUPLICATEEMAILMANAGEMENTTT
WebsiteWEBSITETT
Weekly TimesheetsWEEKLYTIMESHEETSTF
Withholding TaxWITHHOLDINGTAXTF
Work OrdersWORKORDERSFF
Workforce AnalyticsHRANALYSISFF
Worldwide Support for Phone Number FormattingINTERNATIONALPHONENUMBERSTF
{#Issue#} ManagementISSUEDBFF
{#Vendor Return Authorizations#}VENDORRETURNAUTHSTT

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.

About Me

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.