InventJournalTable

-- ============================================================
-- Table  : InventJournalTable Inventory journal header — one row per movement, adjustment, transfer, BOM, or counting journal, with its type, posting status, and line count
-- Purpose: Column-selected read of InventJournalTable — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + JournalId
-- Notes  : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  i.journalid AS "The journal number — the key its lines join back on",
  i.journalnameid AS "Journal name (setup record) the journal was created from, carrying its defaults",
  i.journaltype AS "Kind of inventory journal — movement, adjustment, transfer, BOM, or counting",  -- enum: decode i.journaltype via GlobalOptionsetMetadata join — see quirks guide #enums
  i.description AS "Free-text description of the journal",
  i.posted AS "Whether the journal has been posted — unposted journals have no inventory impact yet",  -- enum: decode i.posted via GlobalOptionsetMetadata join — see quirks guide #enums
  i.posteddatetime AS "When the journal was posted, stored in UTC",  -- stored in UTC
  i.posteduserid AS "User who posted the journal",
  i.numoflines AS "Number of lines in the journal",
  i.inventsiteid AS "Default site for the journal's lines",
  i.inventlocationid AS "Default warehouse for the journal's lines",
  i.ledgerdimension AS "RecId of the offset ledger account (dimension combination) the journal posts against",
  i.voucherdraw AS "Whether vouchers are drawn at journal entry or at posting",  -- enum: decode i.voucherdraw via GlobalOptionsetMetadata join — see quirks guide #enums
  i.deletepostedlines AS "Whether lines are deleted after posting",  -- enum: decode i.deletepostedlines via GlobalOptionsetMetadata join — see quirks guide #enums
  i.systemblocked AS "Whether the system has locked the journal (for example while posting)",  -- enum: decode i.systemblocked via GlobalOptionsetMetadata join — see quirks guide #enums
  i.journalidorignal AS "Journal this one was created from, when split or copied (the misspelling is the genuine column name)",
  i.worker AS "RecId of the worker responsible for the journal"
FROM <catalog>.<schema>.inventjournaltable i
WHERE
  i.dataareaid = '<company>'
ORDER BY i.journalid;