InventTransOrigin

-- ============================================================
-- Table  : InventTransOrigin The origin record every inventory transaction points to — resolves an InventTrans row back to the sales line, purchase line, or journal that created it
-- Purpose: Column-selected read of InventTransOrigin — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + InventTransId
-- 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
  ito.inventtransid AS "The transaction reference string that groups all movements for one source document line",
  ito.referencecategory AS "What kind of document created the origin (sales, purchase, transfer, production…) — the discriminator for the polymorphic reference",  -- enum: decode ito.referencecategory via GlobalOptionsetMetadata join — see quirks guide #enums
  ito.itemid AS "Item the origin is for",
  ito.recid AS "The 64-bit surrogate key InventTrans.InventTransOrigin joins to",
  ito.referenceid AS "Document number of the originating reference — the sales order, purchase order, or journal id, typed by ReferenceCategory",
  ito.party AS "RecId of the counterparty's global-address-book party in DirPartyTable, where the origin has one",
  ito.iteminventdimid AS "Dimension combination carrying the origin's product dimensions (variant), before site/warehouse are decided",
  ito.isexcludedfrominventoryvalue AS "Whether transactions from this origin are excluded from inventory value reporting"  -- enum: decode ito.isexcludedfrominventoryvalue via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.inventtransorigin ito
WHERE
  ito.dataareaid = '<company>'
ORDER BY ito.inventtransid;