term

-- ============================================================
-- Table  : term — The payment-terms master: one row per terms code with the whole date-driven rule set behind it — days till net due, discount percentage and expiry, day-of-month due, and the installment schedule columns.
-- Purpose: Column-selected read of term — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: terms are a RULE, not a date: nothing here tells you when a specific invoice is due. Read the document's own duedate and use these columns to explain it, not to recompute it.
-- 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 "Terms name",
  t.daysuntilnetdue AS "Days till net due",
  t.dayofmonthnetdue AS "Day of month net due",
  t.duenextmonthifwithindays AS "Roll to next month if raised within this many days",
  t.discountpercent AS "Early-payment discount percentage",
  t.discountpercentdatedriven AS "Date-driven discount percentage — the twin of discountpercent",
  t.daysuntilexpiry AS "Days till the discount expires",
  t.daydiscountexpires AS "Day of month the discount expires",
  t.installment AS "Terms pay in installments",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.splitevenly AS "Installments split evenly",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.recurrencecount AS "Number of installments",
  t.recurrencefrequency AS "Installment frequency (internal id)",
  t.repeatevery AS "Repeat every n frequency units",
  t.preferred AS "Preferred terms",  -- '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.externalid AS "External ID"
FROM <catalog>.<schema>.term 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;