picktask

-- ============================================================
-- Table  : picktask — The warehouse pick task: one row per item, lot/serial and recommended bin a picker is asked to pull, with the picked and remaining quantities and the wave it belongs to.
-- Purpose: Column-selected read of picktask — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: totalpickedquantity and totalremainingquantity are STATE, not a flow — they are overwritten as the task progresses, so pick throughput over time needs a dated snapshot of this record, not a sum of its columns.
-- 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 "Pick task number",
  t.status AS "Task status (internal id) — no public value list; see quirks #status-codes",
  t.item AS "Item to pick (internal id)",
  t.location AS "Location (internal id)",
  t.units AS "Unit of measure (internal id)",
  t.inventorynumber AS "Lot or serial number to pick (internal id)",
  t.recommendedbin AS "Recommended bin (internal id)",
  t.picker AS "Assigned picker (internal id)",
  t.wave AS "Wave the task belongs to (internal id)",
  t.totalpickedquantity AS "Quantity picked so far — current state, overwritten as the task progresses",
  t.totalremainingquantity AS "Quantity still to pick — current state, not a flow",
  t.memo AS "Notes",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.picktask t
WHERE
  t.location = <location_id>  -- location scope — 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;