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. |