MWS068
InteractiveBalance identity toolbox — the working view over the MITLOC balance identities (item, location, lot, receipt)
This program works over the tables below. For analytics at scale, land the raw tables — the SQL further down reads them directly, joined on their keys and CONO. When to land tables vs call MI APIs
The MITLOC pairing is published: Infor's 'Stock and Inventory Information' states that items per location are stored in the MITLOC table and that all locations where an item is stored are displayed in 'Balance Identity. Open Toolbox' (MWS068).
Boilerplate SQL
Databricks SQLStarting point for reading the tables behind MWS068 from landed data — the backing tables joined on their keys and CONO. Set your Unity Catalog location, company, and filter values below.
3 parameters not filled: <catalog>, <schema>, <company>
-- ============================================================
-- Program: MWS068 — Balance identity toolbox — the working view over the MITLOC balance identities (item, location, lot, receipt)
-- Purpose: Read the tables behind program MWS068 — auto-generated from program-table-map
-- Grain : One row per MITLOC record
-- Tables : MITLOC
-- 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; company-partitioned tables are joined on CONO to prevent cross-company fan-out. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
il.MLCONO AS "Company",
il.MLWHLO AS "Warehouse",
il.MLITNO AS "Item number",
il.MLWHSL AS "Stock location within the warehouse",
il.MLBANO AS "Lot (batch) number — blank for non-lot-controlled items",
il.MLREPN AS "Receiving number distinguishing receipts of the same item and lot in the same location",
il.MLSTQT AS "On-hand balance at this location/lot grain, in the basic unit",
il.MLALQT AS "Allocated quantity at this location/lot grain"
FROM <catalog>.<schema>.MITLOC il
WHERE
il.MLCONO = <company>
ORDER BY il.MLWHLO;