taxtype
masterThe 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.
no lastmodifieddate — full refresh. The four behavior flags are 'T'/'F' strings, and they are the record's whole analytic content: two tax codes with the same rate and different flags produce different totals.
Browser page name is taxType. This is where tax BEHAVIOR lives, which is why a tax reconciliation that reads only rates goes wrong: taxinnetamount and doesnotaddtototal change what the transaction total means, and posttoitemcost decides whether tax becomes inventory value. Its one page-listed join targets the per-nexus tax-account satellite, which this catalog does not carry, so it ships with no edges.
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
9 fields · 1 key
9 fields.
| # | Field | Description | Type | Flags |
|---|---|---|---|---|
| 1 | id | Internal ID | NUMBER | Primary-key field |
| 2 | name | Tax type name | VARCHAR | |
| 3 | description | Description | VARCHAR | |
| 4 | country | Country the type applies in (internal id) | NUMBER | |
| 5 | doesnotaddtototal | Tax under this type does not add to the transaction total | VARCHAR | |
| 6 | posttoitemcost | Tax posts into item cost rather than to a tax account | VARCHAR | |
| 7 | reversecharge | Type is a reverse charge | VARCHAR | |
| 8 | taxinnetamount | Tax is included in the net amount | VARCHAR | |
| 9 | isinactive | Inactive | VARCHAR |
Field provenance: hand-curated. 1 key field.
Boilerplate SQL
Starting point for reading the Connect-landed copy of taxtype 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 : taxtype — The 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.
-- Purpose: Column-selected read of taxtype — auto-generated from field metadata
-- Grain : One row per id
-- Caution: no lastmodifieddate — full refresh. The four behavior flags are 'T'/'F' strings, and they are the record's whole analytic content: two tax codes with the same rate and different flags produce different totals.
-- 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 "Internal ID",
t.name AS "Tax type name",
t.description AS "Description",
t.country AS "Country the type applies in (internal id)",
t.doesnotaddtototal AS "Tax under this type does not add to the transaction total", -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
t.posttoitemcost AS "Tax posts into item cost rather than to a tax account", -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
t.reversecharge AS "Type is a reverse charge", -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
t.taxinnetamount AS "Tax is included in the net amount", -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
t.isinactive AS "Inactive" -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
FROM <catalog>.<schema>.taxtype 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.
More Financials tables
- 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.
- 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.
- 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.