MITFAC

-- ============================================================
-- Table  : MITFAC — The item/facility record — one row per item and facility, where costing lives; the approved cost the facility values the item at sits here, between the company-wide item master and the warehouse-level balances
-- Purpose: Column-selected read of MITFAC — auto-generated from field metadata
-- Grain  : One row per company (CONO) + M9FACI + M9ITNO
-- 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
  m.M9CONO AS "Company",
  m.M9FACI AS "Facility",
  m.M9ITNO AS "Item number",
  m.M9APPR AS "Approved cost — the price the facility values the item's inventory at"
FROM <catalog>.<schema>.MITFAC m
WHERE
  m.M9CONO = <company>
  -- AND m.M9FACI = '<FACI>'
  -- AND m.M9ITNO = '<ITNO>'
ORDER BY m.M9FACI;