itemmember

-- ============================================================
-- Table  : itemmember — The generic component record — analytics label "Members": one row per member line of a parent item, carrying the component, its parent, the quantity, the component yield and the effective/obsolete revision window. It is the shape the kit, item-group and assembly member records all repeat.
-- Purpose: Column-selected read of itemmember — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: both `item` and `parentitem` point at the item master, so a readable component list joins item TWICE under two aliases — one for the component, one for the parent.
-- 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.parentitem AS "The kit, group or assembly this line belongs to (internal id)",
  t.item AS "Component item (internal id)",
  t.linenumber AS "Line id within the parent",
  t.quantity AS "Member quantity",
  t.bomquantity AS "BOM quantity — the manufacturing quantity, not the member quantity",
  t.memberunit AS "Unit of measure as TEXT — not a unit id, so it cannot be joined",
  t.componentyield AS "Component yield percentage",
  t.itemsource AS "How the component is sourced (internal id)",
  t.effectivedate AS "Date this member line takes effect",
  t.obsoletedate AS "Date this member line goes obsolete",
  t.effectiverevision AS "Effective revision (internal id)",
  t.obsoleterevision AS "Obsolete revision (internal id)",
  t.vsoedelivered AS "Revenue-allocation flag: default as delivered",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.vsoedeferral AS "Revenue-allocation deferral rule (internal id)",
  t.vsoepermitdiscount AS "Revenue-allocation discount rule (internal id)"
FROM <catalog>.<schema>.itemmember t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.id = <id>
  -- AND t.effectivedate >= DATE '<DATE_FROM>'
  -- AND t.effectivedate <= DATE '<DATE_TO>'
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.id;