vendor

-- ============================================================
-- Table  : vendor — The vendor master: identity, terms, incoterm, credit limit and payables balances in both the vendor's primary currency and the base currency.
-- Purpose: Column-selected read of vendor — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: balance twins: `balanceprimary` is stated in the vendor's currency, `balance` in the base currency — the same trap applies to unbilledordersprimary / unbilledorders. Mixing them silently mixes currencies.
-- 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 "Vendor ID as displayed",
  t.altname AS "Vendor name",
  t.companyname AS "Company name",
  t.legalname AS "Legal name",
  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.category AS "Vendor category (internal id)",
  t.currency AS "Vendor primary currency (internal id)",
  t.terms AS "Payment terms (internal id)",
  t.incoterm AS "Incoterm (internal id)",
  t.creditlimit AS "Credit limit",
  t.balanceprimary AS "Balance in the vendor's own currency",
  t.balance AS "Balance in the base currency — the twin of balanceprimary",
  t.unbilledordersprimary AS "Unbilled orders in the vendor's own currency",
  t.representingsubsidiary AS "Subsidiary this vendor represents for intercompany (internal id)"
FROM <catalog>.<schema>.vendor 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;