subsidiary

-- ============================================================
-- Table  : subsidiary — The OneWorld legal-entity master: one row per subsidiary, hierarchical through parent, each carrying its own base currency, country and fiscal calendar.
-- Purpose: Column-selected read of subsidiary — auto-generated from field metadata
-- Grain  : One row per id
-- 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 "Subsidiary name",
  t.fullname AS "Full hierarchical name",
  t.legalname AS "Legal name",
  t.parent AS "Parent subsidiary (internal id)",
  t.currency AS "Base currency (internal id)",
  t.country AS "Country (internal id)",
  t.state AS "State or province text",
  t.dropdownstate AS "State or province (internal id)",
  t.edition AS "NetSuite edition (internal id)",
  t.fiscalcalendar AS "Fiscal calendar (internal id)",
  t.languagelocale AS "Language locale (internal id)",
  t.iselimination AS "Elimination subsidiary",  -- '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.tranprefix AS "Document number prefix",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.subsidiary 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;