Offerings and Functional Areas

This table shows the offerings in NetSuite Analytics Warehouse and their source.

To learn more about subject areas, see Overview.

Name Code Activation Dependency Description
Bank NS_BANK NA The Banking functional area provides information on banking-related transactions, including Checks, Deposits, Transfers, Credit Card Charges and Refunds, Tax Liability Checks, and Tax Payments.
Employee Expenses NS_EMP_EXPENSES NA The Employee Expenses functional area provides detailed information from Employee Expense Reports along with its snapshot.
Financials NS_FINANCIALS NA This functional area provides information on financial and revenue-related transactions and records, including Journals, System Journals, Cross Charge Journals, Statistical Journals, GL Impact Adjustments, Currency Revaluations, Netting Settlements, Budgets, Revenue Arrangements, Revenue Elements, Revenue Plans, Revenue Commitments, and Commitment Reversals. It also includes the Revenue Arrangement Snapshot fact.
Inventory NS_INVENTORY NA The Inventory functional area provides information on inventory-related transactions, including Inventory Counts, Adjustments, Transfers, Worksheets, Cost Revaluations, Status Changes, Transfer Orders, Bin Transfers, Bin Putaway Worksheets, Inventory Item Prices, and Inventory Assignments. It also includes point-in-time inventory facts, such as Inventory Item Locations, and even facts supporting Lot/Serialized Inventory such as Inventory Number Locations and Inventory Balances.
Inventory Aging NS_INVENTORY_AGING Inventory Snapshot This functional area offers the Inventory Aging Analysis, which helps you track how long items have been in stock by organizing inventory into specific time periods.
Inventory FSN Analysis NS_INVENTORY_FSN Inventory Snapshot This functional area provides the Inventory FSN (Fast, Slow, or Non-Moving) Analysis, which offers key attributes and measures to help you analyze inventory movement at the location and subsidiary levels across accounting periods, including base periods, quarters, and fiscal years in the default fiscal calendar.
Inventory Snapshot NS_INVENTORY_SNAPSHOT NA This functional area provides the Inventory Snapshot, which captures the on-hand quantity and value of items at each location on a daily basis, helping you track inventory levels and valuation over time.
Inventory Turnover NS_INVENTORY_TURNOVER Inventory Snapshot This functional area includes the Inventory Turnover Analysis fact, which measures item efficiency by analyzing how quickly items are sold at each location.
Manufacturing NS_MFG NA The Manufacturing functional area provides information on Assembly Build and Unbuild, Work Order, Work Order Issue, Work Order Close, Work Order Completion and Manufacturing Operation Task. It also contains Work Order Snapshot Fact.
Manufacturing Insights NS_MFG_INSIGHTS Manufacturing The Manufacturing Insightsfunctional area provides key performance indicators (KPIs) such as Perfect Work Orders, Behind Plan Ratio, Defect (Scrap) Density, and Yield at the work order level. This dataset helps you monitor and evaluate the quality, efficiency, and accuracy of manufacturing process execution.
Order to Cash NS_ORDER_TO_CASH Sales The Order to Cash functional area offers multiple purpose-driven enhanced facts, providing a complete view of the sales cycle from order placement to payment receipt. It includes detailed facts for Order Fulfillment, Customer Invoices, Payment Activity, Return Authorizations, Refunds and Revenue Recognition, which help in cross-transactional analysis and support informed decision-making.
Payroll NS_PAYROLL NA The Payroll functional area provides information on payroll-related transactions, including Paychecks and Paycheck Journals.
Procurement Spend Analysis NS_PROCUREMENT_SPEND Purchases and Payables The Procurement Spend Analysis functional area provides detailed insights into procurement spending along with derived indicators to make spend analysis easier, more efficient, and more effective.
Procure to Pay NS_PROCURE_TO_PAY Purchases and Payables The Procure to Pay functional area offers multiple purpose-driven enhanced facts, providing a complete view of the purchasing cycle from purchase requisition to vendor payment. It includes detailed facts for Item Receipt, Vendor Bill, Vendor Payment Activity, and Vendor Authorizations, enabling cross-transactional analysis and supporting informed decision-making.
Projects and Support Management NS_PROJ_SUPPORT_MGMT NA The Projects and Support Management functional area provides facts that capture detailed information on Timesheets, Time Tracking, Work Breakdown Structures (WBS), Support Cases, and Issues.
Purchases and Payables NS_PURCHASES NA The Purchases and Payables functional area provides information on Purchase Requisitions, Purchase Contracts, Purchase Orders, Item Receipts, Vendor Bills, Bill Credits, Vendor Payments, Vendor Authorizations, Vendor Prepayments, Prepayment Applications, Inbound Shipments, and Ownership Transfers. It also includes snapshot facts such as Purchase Order Snapshot, Vendor Bill Snapshot, Vendor Authorization Snapshot, and Inbound Shipment Snapshot.
Sales NS_SALES NA The Sales functional area provides information on a comprehensive range of sales-related transactions and records, including Sales Orders, Item Shipments, Customer Invoices, Customer Payments, Return Authorizations, Credit Memos, Cash Sales, Cash Refunds, Estimates, Opportunities, Commissions, Customer Deposits, Deposit Applications, Statement Charges, Store Pickups, Fulfillment Requests, Waves, Charges, and Subscriptions. It also includes enriched facts such as Net Sales Items which consists of data on item sales from various transactions minus the returns.
Sales Insights NS_SALES_INSIGHTS Sales The Sales Insights functional area includes detailed information on sales orders and related metrics derived from item fulfillments, store pickups, customer invoices, cash sales, and returns. These insights enable you to track and analyze key performance indicators (KPIs) such as order fulfillment rate, cash sale conversion rate, and return rate.
Sales Snapshots NS_SALES_SNAPSHOTS Sales The Sales Snapshots functional area provides snapshot facts of sales-related transactions, including Sales Orders, Item Shipments, Customer Invoices, Payments, Return Authorizations, Commissions, and Opportunities.