unitstypeuom

-- ============================================================
-- Table  : unitstypeuom — The individual units inside a units-of-measure family: name, abbreviation, the base-unit marker and the conversion rate that turns this unit into the family's base unit.
-- Purpose: Column-selected read of unitstypeuom — auto-generated from field metadata
-- Grain  : One row per internalid
-- Caution: conversionrate is stated RELATIVE TO THE FAMILY'S BASE UNIT (the row where baseunit is 'T'), not to the unit on the line you are converting — converting between two non-base units means two hops, never one multiplication.
-- 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.internalid AS "Internal ID",
  t.unitstype AS "Units-of-measure family this unit belongs to (internal id)",
  t.unitname AS "Unit name",
  t.pluralname AS "Plural name",
  t.abbreviation AS "Abbreviation",
  t.pluralabbreviation AS "Plural abbreviation",
  t.baseunit AS "This unit is the family's base unit — the one every conversion rate is stated against",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.conversionrate AS "Rate converting this unit to the family's base unit"
FROM <catalog>.<schema>.unitstypeuom 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)
ORDER BY t.internalid;