NetSuite Reference
Foundation
Subsidiaries, currencies and both exchange-rate tables, accounting periods and books, locations, departments and classes — the dimension layer every OneWorld filter resolves against. Location sits here rather than in inventory: in NetSuite it is an org segment first and a stocking site second.
9 tables
Analytics Browser 2021.1 · corroborated 2025.2 · Verified August 2026
Record map
The business records that resolve into this module’s tables. Document records all land on the transaction spine — one table family, separated by a type value — so this is the map from the record you know to the table you query.
| Record | Table | Oracle reference |
|---|---|---|
| Locationlocation | location | Record page (opens in new tab) |
| Subsidiarysubsidiary | subsidiary | Record page (opens in new tab) |
Tables
Master · 5
- classificationThe class segment: one row per class, hierarchical through parent. The analytics id is classification; the NetSuite UI calls it "Class".master
- currencyThe currency list: one row per currency the account transacts in, with precision, base/anchor flags and a default rate.master
- departmentThe department segment: one row per department, hierarchical through parent, used to stripe transaction lines for reporting.master
- locationThe location master: stocking sites, stores and virtual locations, hierarchical through parent, carrying the inventory-availability, bin and warehouse-management switches that decide how stock behaves at a site.master
- subsidiaryThe OneWorld legal-entity master: one row per subsidiary, hierarchical through parent, each carrying its own base currency, country and fiscal calendar.master
Control · 4
- accountingbookThe multi-book accounting register: one row per book, with isprimary marking the book most analytics should anchor on.control
- 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.control
- 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.control
- currencyrateDated transaction exchange rates: one row per base-currency / transaction-currency pair per effective date, with a rate type.control