customer

-- ============================================================
-- Table  : customer — The customer master: identity, status, terms, credit control and the entity-level balance rollups, plus the sales-history date stamps.
-- Purpose: Column-selected read of customer — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: the balance columns here are entity-level rollups — PER-SUBSIDIARY receivables live on customersubsidiaryrelationship, and in a OneWorld account that is the number finance means.
-- 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.entityid AS "Entity ID",
  t.entitytitle AS "Customer ID as displayed",
  t.altname AS "Customer name",
  t.companyname AS "Company name",
  t.isperson AS "Individual rather than a company",  -- '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.datecreated AS "Date created",
  t.lastmodifieddate AS "Last modified — the incremental watermark",
  t.parent AS "Parent customer (internal id)",
  t.currency AS "Customer currency (internal id)",
  t.terms AS "Payment terms (internal id)",
  t.category AS "Customer category (internal id)",
  t.pricelevel AS "Default price level (internal id)",
  t.entitystatus AS "Customer status (internal id)",
  t.creditlimit AS "Credit limit",
  t.oncredithold AS "On credit hold",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.balancesearch AS "Entity-level balance — per-subsidiary balances live on customersubsidiaryrelationship",
  t.representingsubsidiary AS "Subsidiary this customer represents for intercompany (internal id)"
FROM <catalog>.<schema>.customer t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.id = <id>
  -- AND t.lastmodifieddate >= TIMESTAMP '<watermark>'  -- inserts and updates only — deletes never appear here; diff deletedrecord, which is itself blind to line-level deletes (see quirks #deletes)
ORDER BY t.id;