expensecategory

-- ============================================================
-- Table  : expensecategory — The 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.
-- Purpose: Column-selected read of expensecategory — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: no lastmodifieddate on this record — full refresh. expenseacct and expenseitem are id pointers at the account and item records, but neither is attested as a join on this page, so no edge is drawn and both are read as ids.
-- 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 "Category name",
  t.description AS "Description",
  t.expenseacct AS "Account the expense posts to (internal id) — read as an id, no page-attested join",
  t.expenseitem AS "Item the expense is billed through (internal id) — read as an id, no page-attested join",
  t.defaultrate AS "Default rate applied to a line in this category",
  t.raterequired AS "A rate must be entered on the line",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.personalcorporatecardexpense AS "Category marks a personal expense on a corporate card",  -- '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
  t.subsidiary AS "Subsidiaries the category serves — a MULTISELECT, so no anchor is emitted",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.expensecategory 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;