itemdemandplan

-- ============================================================
-- Table  : itemdemandplan — The demand plan header: one row per item and location being planned, with the projection method, interval, duration and start date that define the plan's time buckets.
-- Purpose: Column-selected read of itemdemandplan — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: no lastmodifieddate on this record — full-refresh the plans. The quantities are NOT here: they are the bucket rows on itemdemandplandemandplandetail, and projectioninterval is what tells you how wide each bucket is.
-- 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.item AS "Item being planned (internal id)",
  t.location AS "Location being planned (internal id)",
  t.subsidiary AS "Subsidiary (internal id)",
  t.units AS "Unit of measure (internal id) — resolves to unitstypeuom.internalid",
  t.demandplanid AS "Plan identifier as displayed",
  t.demandplantype AS "Plan type (internal id)",
  t.projectionmethod AS "Forecast method as text",
  t.projectioninterval AS "Bucket width as text — what the detail rows are stated in",
  t.projectionduration AS "Number of buckets projected",
  t.projectionstartdate AS "First day of the projection",
  t.analysisduration AS "Length of history the projection was fitted on",
  t.alternatesourceitem AS "Item whose history stands in for this one, as text",
  t.demandplancalendartype AS "Calendar the plan is viewed on, as text",
  t.memo AS "Memo",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.itemdemandplan 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.projectionstartdate >= DATE '<DATE_FROM>'
  -- AND t.projectionstartdate <= DATE '<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;