accounttype
masterThe 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.
no lastmodifieddate on this record — full-refresh the type list. Its key is a TEXT mnemonic, not a number, so account.accttype joins here as a string comparison; casting either side to a number is how that join quietly returns nothing.
Browser page name is accountType. This record carries TWO ids: `id` is a text mnemonic and internalid is an integer twin, and the catalog keys on the text one. That choice is an INFERENCE, not a page-attested fact: the account page labels its join "Account to Account Type (accountType.id)", which names the text column, and no public source states outright which of the two the account.accttype select stores. The edge is drawn to the text key and typed varchar on both ends accordingly — if your own account shows otherwise, join on internalid instead and cast nothing. balancesheet and `left` are what make the record analytically useful rather than cosmetic: they say whether a type belongs on the balance sheet or the income statement, and which side of the ledger it naturally sits on — the two facts a P&L or balance-sheet rollup needs before it can group accounts at all. Both of the page's joins target the consolidated-rate-type key record, which this catalog does not carry, so it ships with no edges of its own; the edge that matters runs into it, from account.
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
'T'/'F' string.Fields
11 fields · 1 key
11 fields.
| # | Field | Description | Type | Flags |
|---|---|---|---|---|
| 1 | id | Type mnemonic — the TEXT id the account page's join label names | VARCHAR | Primary-key field |
| 2 | internalid | Integer twin of the text key | NUMBER | |
| 3 | longname | Type name as the UI shows it | VARCHAR | |
| 4 | balancesheet | Type belongs on the balance sheet rather than the income statement | VARCHAR | |
| 5 | left | Type sits on the debit side of the ledger | VARCHAR | |
| 6 | seqnum | Presentation order of the type | NUMBER | |
| 7 | eliminationalgo | Elimination algorithm applied to intercompany balances of this type | VARCHAR | |
| 8 | includeinrevaldefault | Accounts of this type are revalued by default | VARCHAR | |
| 9 | usercanchangerevaloption | The revaluation setting can be changed per account | VARCHAR | |
| 10 | defaultcashflowratetype | Default cash-flow rate type (internal id) — points at a key record this catalog does not carry | NUMBER | |
| 11 | defaultgeneralratetype | Default general rate type (internal id) — same uncataloged target | NUMBER |
Field provenance: hand-curated. 1 key field.
Boilerplate SQL
Starting point for reading the Connect-landed copy of accounttype on Databricks — dates are real DATE/TIMESTAMP columns and need no conversion, and the partition anchors are already in place. This record carries no modification stamp, and the snippet says so where the watermark would otherwise go. Set your Unity Catalog location, schema, and filter values below; they’re substituted into the SQL and the copy button.
3 parameters not filled: <catalog>, <schema>, <id>
-- ============================================================
-- Table : accounttype — The 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.
-- Purpose: Column-selected read of accounttype — auto-generated from field metadata
-- Grain : One row per id
-- Caution: no lastmodifieddate on this record — full-refresh the type list. Its key is a TEXT mnemonic, not a number, so account.accttype joins here as a string comparison; casting either side to a number is how that join quietly returns nothing.
-- Notes : Auto-generated skeleton for NetSuite data landed in your lakehouse from a SuiteAnalytics Connect (or SuiteQL) extract — it never addresses live NetSuite. Identifiers are lowercase as NetSuite2.com renders them. Select-type columns hold numeric internal ids: BUILTIN.DF() display resolution exists only at extraction time, so decode ids by joining the landed list records; see quirks #display-values. Check-box columns arrive as 'T'/'F' strings; see quirks #tf-booleans.
-- ============================================================
SELECT
t.id AS "Type mnemonic — the TEXT id the account page's join label names",
t.internalid AS "Integer twin of the text key",
t.longname AS "Type name as the UI shows it",
t.balancesheet AS "Type belongs on the balance sheet rather than the income statement", -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
t.`left` AS "Type sits on the debit side of the ledger", -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
t.seqnum AS "Presentation order of the type",
t.eliminationalgo AS "Elimination algorithm applied to intercompany balances of this type",
t.includeinrevaldefault AS "Accounts of this type are revalued by default", -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
t.usercanchangerevaloption AS "The revaluation setting can be changed per account", -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
t.defaultcashflowratetype AS "Default cash-flow rate type (internal id) — points at a key record this catalog does not carry",
t.defaultgeneralratetype AS "Default general rate type (internal id) — same uncataloged target"
FROM <catalog>.<schema>.accounttype t
WHERE
1 = 1 -- no partition column on this record; the filters below are optional
-- AND t.id = '<id>'
-- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.id;Verified August 2026 · Analytics Browser 2021.1 · corroborated 2025.2
Select columns hold internal ids, not display text — see decoding display values.
Relationships
Diagram of 1-hop neighbors — join details below. Document-link edges are highlighted; they chain one document to the next and are the joins newcomers most often get wrong.
Join details
ON account.accttype = accounttype.id
More Financials tables
- 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.
- 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.
- budgetsmachineThe budget's per-period rows: one row per budget and accounting period, with the amount budgeted for that period.
- 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.
- 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.
- 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.