M3 Reference
PPS300
InteractivePurchase order goods receipt — reports receipts against MPLINE lines, driving the line status to 50 and writing the MITTRA stock transactions
Tables vs APIs
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 →
Boilerplate SQL
Databricks SQLStarting point for reading the tables behind PPS300 from landed data — the backing tables joined on their keys and CONO. Set your Unity Catalog location, company, and filter values below.
Query parameters
-- ============================================================
-- Program: PPS300 — Purchase order goods receipt — reports receipts against MPLINE lines, driving the line status to 50 and writing the MITTRA stock transactions
-- Purpose: Read the tables behind program PPS300 — auto-generated from program-table-map
-- Grain : MPLINE × MPHEAD — 1:N joins yield one row per line
-- Tables : MPLINE, MPHEAD
-- 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
pl.IBCONO AS "Company",
pl.IBPUNO AS "Purchase order number",
pl.IBPNLI AS "Purchase order line number",
pl.IBPNLS AS "Line subnumber — subdivides a line across deliveries",
pl.IBITNO AS "Item ordered",
pl.IBORQA AS "Ordered quantity in the purchase unit"
FROM <catalog>.<schema>.MPLINE pl
LEFT JOIN <catalog>.<schema>.MPHEAD ph
ON ph.IAPUNO = pl.IBPUNO
AND ph.IACONO = pl.IBCONO
WHERE
pl.IBCONO = <company>
ORDER BY pl.IBPUNO;3 parameters not filled: <catalog>, <schema>, <company>
Backing Tables
How these tables connect. Nodes are clickable.