MITTRA

-- ============================================================
-- Table  : MITTRA — The stock transaction ledger — one row per inventory movement (receipt, issue, transfer, adjustment) with its transaction type, quantity, date, and the order reference that caused it
-- Purpose: Column-selected read of MITTRA — auto-generated from field metadata
-- Grain  : Transaction-grain — finer than company (CONO) + MTWHLO + MTITNO; the full row key is not yet cataloged (see the table description)
-- Notes  : Auto-generated skeleton for a prefixed physical M3 schema or a landing schema normalized to the prefixed names in this catalog. Raw Data Lake property names vary with the published object: map them through Data Catalog before running this SQL. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); all curated status values are decoded inline. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
  t.MTCONO AS "Company",
  t.MTWHLO AS "Warehouse",
  t.MTITNO AS "Item number",
  CASE WHEN t.MTTRDT = 0 THEN NULL ELSE TO_DATE(CAST(CAST(t.MTTRDT AS BIGINT) AS STRING), 'yyyyMMdd') END AS "Transaction date",  -- YYYYMMDD, 0 → NULL
  t.MTTRTP AS "Transaction type — the code classifying the movement (receipt, issue, transfer, adjustment…)",
  t.MTTRQT AS "Transaction quantity in the basic unit, signed by direction",
  t.MTRIDN AS "Order number of the document that caused the movement (customer order, purchase order, manufacturing order…)",
  t.MTRIDL AS "Order line number within the referenced document",
  t.MTWHSL AS "Stock location the movement touched",
  t.MTBANO AS "Lot (batch) number the movement touched"
FROM <catalog>.<schema>.MITTRA t
WHERE
  t.MTCONO = <company>
  -- AND t.MTWHLO = '<WHLO>'
  -- AND t.MTITNO = '<ITNO>'
  -- AND t.MTTRDT >= <DATE_FROM>  -- yyyyMMdd numeric
  -- AND t.MTTRDT <= <DATE_TO>  -- yyyyMMdd numeric
ORDER BY t.MTWHLO;