fulfillmentrequest

-- ============================================================
-- Table  : fulfillmentrequest — The fulfillment-request document: a store or site being asked to fulfill part of an order, with its own number, date, status, fulfillment type, assignee and pickup-hold state.
-- Purpose: Column-selected read of fulfillmentrequest — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: this record is FEATURE-GATED — it exists in the analytics catalog whether or not your account runs the fulfillment-request flow, so an empty table here is a configuration answer, not an extraction bug.
-- 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.tranid AS "Fulfillment number as printed",
  t.transactionnumber AS "Transaction number",
  t.trandate AS "Request date",
  t.status AS "Request status (internal id) — no public value list; see quirks #status-codes",
  t.fulfillmenttype AS "Fulfillment type (internal id) — ship-from-store, pickup in store, and their relatives",
  t.entity AS "Customer (internal id)",
  t.subsidiary AS "Subsidiary (internal id)",
  t.location AS "Fulfillment location (internal id) — the site being asked to fulfill",
  t.createdfrom AS "Order this request was created from (internal id)",
  t.assignee AS "Assigned employee (internal id)",
  t.pickuphold AS "Pickup hold state (internal id)",
  t.voided AS "Request voided",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.memo AS "Memo",
  t.createdby AS "Created by (internal id)",
  t.lastmodifiedby AS "Last modified by (internal id)",
  t.createddate AS "Date created",
  t.lastmodifieddate AS "Last modified — the incremental watermark",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.fulfillmentrequest t
WHERE
  t.subsidiary = <subsidiary_id>  -- OneWorld partition — see quirks guide #oneworld
  AND t.location = <location_id>  -- location scope — see quirks guide #oneworld
  -- AND t.id = <id>
  -- AND t.trandate >= DATE '<DATE_FROM>'
  -- AND t.trandate <= DATE '<DATE_TO>'
  -- AND t.lastmodifieddate >= TIMESTAMP '<watermark>'  -- inserts and updates only — deletes never appear here; diff deletedrecord, which is itself blind to line-level deletes (see quirks #deletes)
ORDER BY t.id;