itemsupplyplanorder

-- ============================================================
-- Table  : itemsupplyplanorder — The planned orders a supply plan generated: one row per proposed order, with its type, order and receipt dates, quantity, source location and whether it has been turned into a real document yet.
-- Purpose: Column-selected read of itemsupplyplanorder — auto-generated from field metadata
-- Grain  : One row per record — see the Fields section for the full key
-- Caution: no lastmodifieddate — full refresh. ordercreated is the line between a proposal and a document: rows where it is 'T' have already been raised as real documents on the spine, so counting those as supply on order double-counts them; rows where it is 'F' exist only in the plan.
-- 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.itemsupplyplan AS "Supply plan this order belongs to (internal id) — repeats once per planned order",
  t.ordertype AS "Proposed order type (internal id) — no public value list",
  t.ordernumber AS "Order number as displayed",
  t.orderdate AS "Date the order should be raised",
  t.receiptdate AS "Date the supply is needed",
  t.quantity AS "Proposed quantity",
  t.sourcelocation AS "Site a transfer would come from (internal id) — read as an id, no page-attested join",
  t.ordercreated AS "A real document has been raised for this proposal"  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
FROM <catalog>.<schema>.itemsupplyplanorder t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.orderdate >= DATE '<DATE_FROM>'
  -- AND t.orderdate <= DATE '<DATE_TO>'
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
;