CFACIL

-- ============================================================
-- Table  : CFACIL — The facility master — one row per facility (the costing/manufacturing level between division and warehouse), with its name and division; warehouses and orders reference it by FACI
-- Purpose: Column-selected read of CFACIL — auto-generated from field metadata
-- Grain  : One row per company (CONO) + CFFACI
-- 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
  c.CFCONO AS "Company",
  c.CFFACI AS "Facility — the code warehouses and orders carry",
  c.CFFACN AS "Facility name",
  c.CFDIVI AS "Division the facility belongs to"
FROM <catalog>.<schema>.CFACIL c
WHERE
  c.CFCONO = <company>
  -- AND c.CFDIVI = '<DIVI>'
  -- AND c.CFFACI = '<FACI>'
ORDER BY c.CFFACI;