paymentmethod

-- ============================================================
-- Table  : paymentmethod — The payment-method list: one row per method a document can carry, with its type and the GL account payments land in.
-- Purpose: Column-selected read of paymentmethod — 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 "Payment method name",
  t.methodtype AS "Method type (internal id)",
  t.account AS "GL account payments on this method land in (internal id)",
  t.merchantaccounts AS "Payment-processing profiles — MULTISELECT, not a scalar foreign key",
  t.isinactive AS "Inactive",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.externalid AS "External ID"
FROM <catalog>.<schema>.paymentmethod 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;