itemsupplyplanplanningmessage

-- ============================================================
-- Table  : itemsupplyplanplanningmessage — The planning engine's action messages: one row per recommendation — reschedule in, reschedule out, cancel — with the message text, the quantity, the dates involved and the order it refers to.
-- Purpose: Column-selected read of itemsupplyplanplanningmessage — auto-generated from field metadata
-- Grain  : One row per record — see the Fields section for the full key
-- Caution: no lastmodifieddate — full refresh. messagecode is an integer with no published enumeration: group and filter on it if you like, but read the label from `message` rather than asserting what a code means.
-- 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 message belongs to (internal id) — repeats once per message",
  t.messagecode AS "Action code — an integer with no published enumeration",
  t.message AS "Message text as the planner reads it",
  t.transactionid AS "Document the message is about (internal id) — read as an id, no page-attested join",
  t.quantity AS "Quantity the message concerns",
  t.receiptdate AS "Date on the message",
  t.rescheduledate AS "Date the message recommends moving to",
  t.creationdate AS "Date the message was generated"
FROM <catalog>.<schema>.itemsupplyplanplanningmessage t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.receiptdate >= DATE '<DATE_FROM>'
  -- AND t.receiptdate <= DATE '<DATE_TO>'
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
;