manufacturingrouting

-- ============================================================
-- Table  : manufacturingrouting — The routing header: one row per routing for an item, tied to the bill of materials it is run against, with a default marker and the subsidiary that owns it.
-- Purpose: Column-selected read of manufacturingrouting — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: no lastmodifieddate — full refresh. `location` on this record is a MULTISELECT ("Locations") — a routing can be valid at several sites at once — so no location anchor is emitted; filtering it with `= <id>` would drop every multi-site routing.
-- 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 "Routing name",
  t.item AS "Item the routing produces (internal id)",
  t.billofmaterials AS "BOM the routing is run against (internal id)",
  t.subsidiary AS "Subsidiary (internal id) — a scalar select, unlike the BOM header's multiselect",
  t.location AS "Locations the routing is valid at — MULTISELECT, not a scalar foreign key",
  t.isdefault AS "Default routing for the item",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.autocalculatelag AS "Lag between steps is calculated rather than entered",  -- '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.memo AS "Memo",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.manufacturingrouting t
WHERE
  t.subsidiary = <subsidiary_id>  -- OneWorld partition — see quirks guide #oneworld
  -- 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;