currency

-- ============================================================
-- Table  : currency — The currency list: one row per currency the account transacts in, with precision, base/anchor flags and a default rate.
-- Purpose: Column-selected read of currency — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: the ISO code (USD, EUR) is the `symbol` column; `displaysymbol` holds the glyph ($, €). Joining on the wrong one is the classic first-day mistake.
-- 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 "Currency name",
  t.symbol AS "ISO code (USD, EUR) — despite the column name",
  t.displaysymbol AS "Display glyph ($, €)",
  t.symbolplacement AS "Symbol placement (internal id)",
  t.exchangerate AS "Default exchange rate on the currency record",
  t.currencyprecision AS "Decimal precision",
  t.isbasecurrency AS "Is a base currency",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.isanchorcurrency AS "Is the anchor currency",  -- '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.includeinfxrateupdates AS "Included in automatic rate updates",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.fxrateupdatetimezone AS "Rate-update time zone (internal id)",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.currency 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;