MMS850MI
APIStock movement API — moves stock between locations programmatically, writing the MITLOC balances and their MITTRA transactions
This MI API 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 verified transaction is AddMove — moving a lot or balance between locations — named in Infor's published M3 documentation; the API exposes more than this one.
Boilerplate SQL
Databricks SQLStarting point for reading the tables behind MMS850MI from landed data — the backing tables joined on their keys and CONO. Set your Unity Catalog location, company, and filter values below.
-- ============================================================
-- Program: MMS850MI — Stock movement API — moves stock between locations programmatically, writing the MITLOC balances and their MITTRA transactions
-- Purpose: Read the tables behind API program MMS850MI — auto-generated from program-table-map
-- Grain : MITLOC × MILOMA — 1:N joins yield one row per line
-- Tables : MITLOC, MILOMA
-- 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; 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
LEFT JOIN <catalog>.<schema>.MILOMA m
ON m.LMBANO = il.MLBANO
AND m.LMITNO = il.MLITNO
AND m.LMCONO = il.MLCONO
WHERE
il.MLCONO = <company>
ORDER BY il.MLWHLO;3 parameters not filled: <catalog>, <schema>, <company>
Backing Tables
How these tables connect. Nodes are clickable.