systemnote

-- ============================================================
-- Table  : systemnote — The field-level change log: one row per record, field and change, with who changed it, in what context, and the old and new values as text.
-- Purpose: Column-selected read of systemnote — auto-generated from field metadata
-- Grain  : One row per record — see the Fields section for the full key
-- 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.recordid AS "Internal id of the record that changed — repeats once per logged change",
  t.recordtypeid AS "Record type that changed (internal id)",
  t.record AS "Record as displayed",
  t.field AS "Field that changed (internal id)",
  t.oldvalue AS "Old value, as display text",
  t.newvalue AS "New value, as display text",
  t.date AS "When the change was made",
  t.name AS "Entity who made the change (internal id)",
  t.role AS "Role used (internal id)",
  t.context AS "Context the change came from (internal id) — UI, CSV, script",
  t.type AS "Note type (internal id)"
FROM <catalog>.<schema>.systemnote t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
;