M3 Reference

MITFAC

Prefix: M9master

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

Module: Items & Product DataCompany-partitioned (CONO)Parent: MITMAS

Parent & satellites

MITFAC is a satellite of MITMAS — many rows here per MITMAS row; join on ITNO plus the CONO (exact ON clause under Join details below).

Fields

4 fields · 3 key

Key	Field	Alias	Description	Type
Key	M9CONO	CONO	Company	numeric
Key	M9FACI	FACI	Facility	alphanumeric
Key	M9ITNO	ITNO	Item number	alphanumeric
	M9APPR	APPR	Approved cost — the price the facility values the item's inventory at	numeric

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading MITFACon Databricks — numeric YYYYMMDD dates are wrapped to NULL, verified status ladders are decoded, and the CONO anchor is in place. Set your Unity Catalog location, company, and filter values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaCompany (CONO)Facility (FACI)Item number (ITNO)

Include optional filters (2)

-- ============================================================
-- 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 Infor Data Lake-landed M3 data. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); status ladders decoded inline where verified. 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;

5 parameters not filled: <catalog>, <schema>, <company>, <FACI>, <ITNO>

Relationships

1-hop neighbors — click a table to navigate there. CSYTAB decode edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

MITFACMITMASforeign key · N:1
ON MITFAC.M9ITNO = MITMAS.MMITNO AND MITFAC.M9CONO = MITMAS.MMCONO
MITFACCFACILforeign key · N:1
ON MITFAC.M9FACI = CFACIL.CFFACI AND MITFAC.M9CONO = CFACIL.CFCONO

Programs That Use This Table

No program mappings populated for this table yet.