manufacturingoperationtask

-- ============================================================
-- Table  : manufacturingoperationtask — The operation task on a work order: one row per step being executed, with its work center, cost template, scheduled dates, input and completed quantities, and both the standard and the actual run and setup times.
-- Purpose: Column-selected read of manufacturingoperationtask — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: no lastmodifieddate — full refresh. The analytic hook is the PAIR of columns: runrate and setuptime are what the routing said, actualruntime and actualsetuptime are what happened. Compare them per step; do not average one across steps of different lengths.
-- 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.workorder AS "Work order this task belongs to (internal id) — a row on the transaction spine",
  t.operationsequence AS "Step sequence within the work order",
  t.title AS "Task name — the column is title, not name",
  t.status AS "Task status (internal id) — no public value list; see quirks #status-codes",
  t.manufacturingworkcenter AS "Work center the task runs at (internal id) — a group record, not a warehouse record",
  t.manufacturingcosttemplate AS "Cost template the task is costed with (internal id)",
  t.startdatetime AS "Scheduled start",
  t.enddate AS "Scheduled end",
  t.inputquantity AS "Quantity the task was given",
  t.completedquantity AS "Quantity completed",
  t.runrate AS "Standard run rate in minutes per unit — what the routing said",
  t.setuptime AS "Standard setup time in minutes — what the routing said",
  t.actualruntime AS "Actual run time in minutes — what happened",
  t.actualsetuptime AS "Actual setup time in minutes — what happened",
  t.estimatedwork AS "Estimated work for the task",
  t.actualwork AS "Work recorded against the task — a duration on the page, with no stated unit",
  t.remainingwork AS "Work still outstanding — a duration on the page, with no stated unit",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.manufacturingoperationtask t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.id = <id>
  -- AND t.startdatetime >= TIMESTAMP '<DATE_FROM>'
  -- AND t.startdatetime <= TIMESTAMP '<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;