NetSuite Reference
All NetSuite Analytics Tables
Every record in the reference, sorted alphabetically. Use the jump-bar to skip to a letter, or filter by module, data class, and partition scope.
What the badges mean
- master
- Data class: what the record holds — master data, transaction documents, control/configuration, or a documented convenience record. NetSuite has no product-family or schema axis, so this is the whole classification.
- Subsidiary-scoped
- The record carries a
subsidiarycolumn that partitions its rows, so the generated SQL anchors it. On a few records the column is a multiselect rather than a scalar foreign key — the table notes say which (see the quirks guide). - Location-scoped
- The record carries a
locationcolumn — an org segment in NetSuite before it is a warehouse — and the generated SQL anchors it the same way. - View
- A documented convenience record rather than a stored one. Land the records it stands in for instead of assuming it extracts as-is — the table notes say where the rows actually live.
Structural facts — how the record is partitioned, not a trap by itself
Join & extract hazards — verify before you rely on this
In field listings, the Key chip marks a primary-key field, and the T/F chip marks a check-box column Connect returns as a
'T'/'F' string.FilterShowing 70 of 70 tables
Module
Tables starting with A
- accountThe chart of accounts: one row per account, hierarchical through parent, with its type, currency, special-account marker and the balance NetSuite maintains on it.masterfinancials
- accountingbookThe multi-book accounting register: one row per book, with isprimary marking the book most analytics should anchor on.controlfoundation
- accountingperiodThe period calendar: one row per period, hierarchical through parent, with year/quarter/adjustment flags and the close and lock state that governs what can still post.controlfoundation
- accounttypeThe account-type list: one row per type, carrying the side of the ledger it posts to, whether it belongs on the balance sheet, and the default revaluation and consolidation-rate behavior for accounts of that type.masterfinancials
Tables starting with B
- bomThe bill-of-materials header: one row per BOM, naming it and setting which assemblies, locations and subsidiaries it may be used on. The component lines live on the revision, not here.mastermanufacturing
- bomrevisionA dated version of a bill of materials: one row per revision, with the effective start and end dates that decide which component list is in force on a given day.mastermanufacturing
- bomrevisioncomponentThe BOM line: one row per component on a revision, with the quantity, the BOM quantity, the component yield, the unit and how the component is sourced.mastermanufacturing
- budgetcategoryThe budget-category list: four columns naming the categories a budget can be filed under — the original plan, a revision, a forecast — and whether a category is global.masterfinancials
- budgetsThe budget header: one row per budget — an account, a fiscal year and whatever combination of subsidiary, class, department, location, customer and item the budget is dimensioned by — with the total the per-period rows add up to.transactionfinancials
- budgetsmachineThe budget's per-period rows: one row per budget and accounting period, with the amount budgeted for that period.transactionfinancials
Tables starting with C
- classificationThe class segment: one row per class, hierarchical through parent. The analytics id is classification; the NetSuite UI calls it "Class".masterfoundation
- consolidatedexchangeratePeriod consolidation rates: one row per accounting book, posting period and from/to subsidiary pair, carrying the current, average and historical rate flavors side by side.controlfoundation
- currencyThe currency list: one row per currency the account transacts in, with precision, base/anchor flags and a default rate.masterfoundation
- currencyrateDated transaction exchange rates: one row per base-currency / transaction-currency pair per effective date, with a rate type.controlfoundation
- customerThe customer master: identity, status, terms, credit control and the entity-level balance rollups, plus the sales-history date stamps.masterentities
- customersubsidiaryrelationshipThe OneWorld customer bridge: one row per customer per subsidiary the customer is shared with, carrying that subsidiary's receivable, deposit and unbilled-order balances.controlentities
Tables starting with D
- deletedrecordThe deletion ledger: one row per deleted record with its type, name, script id, who deleted it and when. The only public evidence that something disappeared.transactionplatform
- departmentThe department segment: one row per department, hierarchical through parent, used to stripe transaction lines for reporting.masterfoundation
Tables starting with E
- entityThe entity supertype: one row for every customer, vendor, employee, partner, contact, project and group, with pointer columns to the concrete record and a type discriminator.masterentities
- expensecategoryThe expense-category list: one row per category an expense report line can be coded to, with its default rate, whether a rate must be entered, and the account the expense posts to.masterfinancials
Tables starting with F
Tables starting with I
- inventoryassignmentThe lot/serial detail line: one row per transaction line per inventory number, with the assigned quantity, bin and inventory status.transactioninventory
- inventoryitemlocationsThe per-item-per-location balance and policy record: on hand, available, committed, back-ordered and in-transit quantities alongside the reorder point, safety stock, lead times and the location's cost basis.masterinventory
- inventorynumberThe lot and serial master: one row per lot or serial number per item, with the expiration date and the quantity rollups for that number.masterinventory
- itemThe unified item master: one row for every item type — inventory, non-inventory, service, kit, assembly — discriminated by itemtype and subtype, carrying costing, pricing, planning parameters and global quantity rollups.masteritems
- itemdemandplanThe demand plan header: one row per item and location being planned, with the projection method, interval, duration and start date that define the plan's time buckets.transactionplanning
- itemdemandplandemandplandetailThe demand plan's time buckets: one row per bucket, with its row number, start and end dates and the planned quantity.transactionplanning
- itemlocationconfigurationThe per-item-per-location planning parameters: reorder point, safety stock, preferred stock level, lead times, demand and supply time fences, supply type and the lot-sizing rule that decides how much a planned order covers.masterplanning
- itemmemberThe generic component record — analytics label "Members": one row per member line of a parent item, carrying the component, its parent, the quantity, the component yield and the effective/obsolete revision window. It is the shape the kit, item-group and assembly member records all repeat.controlitems
- itemsubsidiarymapThe item-to-subsidiary bridge: two columns, one row per item per subsidiary the item is available in. This is the item side of OneWorld scoping.controlitems
- itemsupplyplanThe supply plan header: one row per item and location the planning engine produced supply for, with the unit of measure the plan is stated in.transactionplanning
- itemsupplyplanorderThe planned orders a supply plan generated: one row per proposed order, with its type, order and receipt dates, quantity, source location and whether it has been turned into a real document yet.transactionplanning
- itemsupplyplanplanningmessageThe planning engine's action messages: one row per recommendation — reschedule in, reschedule out, cancel — with the message text, the quantity, the dates involved and the order it refers to.transactionplanning
- itemvendorThe item sourcing sublist: one row per item, vendor and subsidiary, with the vendor's part code, preferred flag and purchase price.controlitems
Tables starting with L
Tables starting with M
- manufacturingcosttemplateThe manufacturing cost template: a named set of labor, machine and overhead rates a routing step is costed with, owned by a subsidiary.mastermanufacturing
- manufacturingcosttemplatecostdetailThe rate lines of a cost template: one row per cost category, with the charge item, the run rate and the fixed rate that category contributes.mastermanufacturing
- manufacturingoperationtaskThe operation task on a work order: one row per step being executed, with its work center, cost template, scheduled dates, input and completed quantities, and both the standard and the actual run and setup times.transactionmanufacturing
- manufacturingroutingThe routing header: one row per routing for an item, tied to the bill of materials it is run against, with a default marker and the subsidiary that owns it.mastermanufacturing
- manufacturingroutingroutingstepThe operation steps of a routing: one row per step, with its sequence, name, work center, cost template, run rate per unit and setup time.mastermanufacturing
Tables starting with N
- nexttransactionlinelinkThe forward line-link table: one row per line-to-line link travelling downstream — a sales-order line to its fulfillment line, a fulfillment line to its invoice line — with the link type and linked amount.transactiontransactions
- nexusThe nexus list: one row per tax jurisdiction the account is registered in, hierarchical through a parent nexus, with the country, state and the tax agency filings go to.masterfinancials
Tables starting with P
- paymentmethodThe payment-method list: one row per method a document can carry, with its type and the GL account payments land in.mastertransactions
- picktaskThe warehouse pick task: one row per item, lot/serial and recommended bin a picker is asked to pull, with the picked and remaining quantities and the wave it belongs to.transactionfulfillment-logistics
- previoustransactionlinelinkThe backward line-link table: the exact mirror of nexttransactionlinelink, travelling upstream from an invoice line to the sales-order line it originated on.transactiontransactions
- pricelevelThe price-level list: one row per level (base price, online price, a customer tier), each with the markup or discount percentage that defines it.masterpricing
- pricingThe item price matrix: one row per item, price level, currency, quantity break and sale unit, carrying the unit price. This is where a price actually lives.controlpricing
- pricinggroupThe pricing-group list: four columns naming the groups items are bucketed into for group-level price rules.masterpricing
Tables starting with Q
Tables starting with S
- salesinvoicedThe invoiced-sales analytics view: the ordered twin plus a posting period, one row per invoiced transaction line with amount, quantity and the estimated cost and gross-profit columns.viewtransactions
- salesorderedThe ordered-sales analytics view: one row per sales transaction line with the amount, quantity, estimated cost and estimated gross profit already computed, alongside the customer, item, and the class/department/location segments.viewtransactions
- salestaxitemThe tax-code list: one row per tax code a transaction line can be taxed under, pointing at the tax type that decides how the tax behaves.masterfinancials
- shipitemThe shipping-item record — which in NetSuite is also the shipping METHOD: one row per method a document can be shipped on, carrying its carrier service codes and the whole rate-and-handling rule set behind the quoted freight.masterfulfillment-logistics
- subsidiaryThe OneWorld legal-entity master: one row per subsidiary, hierarchical through parent, each carrying its own base currency, country and fiscal calendar.masterfoundation
- systemnoteThe field-level change log: one row per record, field and change, with who changed it, in what context, and the old and new values as text.transactionplatform
- systemnote2The second-generation change log: the same field-level history as systemnote, but with the old and new values split into typed columns — string, numeric, date, boolean and reference — beside a UTC change timestamp.transactionplatform
Tables starting with T
- taxitemtaxgroupThe tax-item supertype: one row per tax code and tax group together, which is the surface a transaction line's tax pointer actually resolves against.masterfinancials
- taxtypeThe tax-type list: one row per type, carrying the behavior flags that decide how tax under it posts — whether it adds to the transaction total, whether it lands in item cost, whether it is a reverse charge, and whether it is included in the net amount.masterfinancials
- termThe payment-terms master: one row per terms code with the whole date-driven rule set behind it — days till net due, discount percentage and expiry, day-of-month due, and the installment schedule columns.masterpricing
- transactionThe document header for every transaction type NetSuite records — sales orders, purchase orders, fulfillments, receipts, invoices, journals — separated by the type column rather than by table.transactiontransactions
- transactionaccountinglineThe accounting projection of a transaction line: base-currency amount, debit, credit and net, per accounting book, with the GL account and audit-number stamps.transactiontransactions
- transactionbillingaddressThe billing address stamped on a document: the same fourteen columns as the shipping twin, keyed by the address key the transaction header's billing pointer resolves to.transactiontransactions
- transactionlineThe line grain of the transaction spine: item, quantity, rate and transaction-currency amounts, plus the subsidiary, location, class and department that scope the line.transactiontransactions
- transactionshipmentThe shipment satellite of a transaction: ship-from and ship-to addresses, ship method, shipping and handling rates, weight, and whether the shipment has been fulfilled.transactiontransactions
- transactionshippingaddressThe shipping address as it was stamped on a document: the formatted block plus the parsed lines, city, state, zip, country and phone, keyed by the address key the transaction header points at.transactiontransactions
Tables starting with U
- unitstypeThe units-of-measure header: one row per UOM family (weight, each, volume). The individual units and their conversion rates hang off the joined unitstypeuom record.masteritems
- unitstypeuomThe individual units inside a units-of-measure family: name, abbreviation, the base-unit marker and the conversion rate that turns this unit into the family's base unit.masteritems
Tables starting with V
- vendorThe vendor master: identity, terms, incoterm, credit limit and payables balances in both the vendor's primary currency and the base currency.masterentities
- vendorsubsidiaryrelationshipThe OneWorld vendor bridge: one row per vendor per subsidiary, with payables, in-transit and unbilled balances in both the relationship currency and the base currency, plus the per-subsidiary credit limit.controlentities