MHDISH
Prefix: OQtransactionThe delivery header — one row per delivery (inbound or outbound, discriminated by INOU) identified by the delivery index DLIX, carrying the warehouse and the shipment it rides on; the unit picking and dispatch work against
Header & line
MHDISH is the header for its lines in MHDISL.
Fields
5 fields · 3 key
| Key | Field | Alias | Description | Type | Length | Flags |
|---|---|---|---|---|---|---|
| Key | OQCONO | CONO | Company | numeric | ||
| Key | OQINOU | INOU | Direction — inbound or outbound delivery | numeric | ||
| Key | OQDLIX | DLIX | Delivery index — the delivery's identity, carried by every line and document that rides on it | numeric | ||
| OQWHLO | WHLO | Warehouse the delivery ships from or arrives at | alphanumeric | |||
| OQCONN | CONN | Shipment the delivery is grouped onto | numeric |
Field provenance: hand-curated.
Boilerplate SQL
Starting point for reading MHDISHon 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.
-- ============================================================
-- Table : MHDISH — The delivery header — one row per delivery (inbound or outbound, discriminated by INOU) identified by the delivery index DLIX, carrying the warehouse and the shipment it rides on; the unit picking and dispatch work against
-- Purpose: Column-selected read of MHDISH — auto-generated from field metadata
-- Grain : One row per company (CONO) + OQINOU + OQDLIX
-- 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.OQCONO AS "Company",
m.OQINOU AS "Direction — inbound or outbound delivery",
m.OQDLIX AS "Delivery index — the delivery's identity, carried by every line and document that rides on it",
m.OQWHLO AS "Warehouse the delivery ships from or arrives at",
m.OQCONN AS "Shipment the delivery is grouped onto"
FROM <catalog>.<schema>.MHDISH m
WHERE
m.OQCONO = <company>
ORDER BY m.OQINOU;3 parameters not filled: <catalog>, <schema>, <company>
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
ON MHDISH.OQWHLO = MITWHL.MWWHLO AND MHDISH.OQCONO = MITWHL.MWCONOON MHDISH.OQDLIX = MHDISL.URDLIX AND MHDISH.OQINOU = MHDISL.URINOU AND MHDISH.OQCONO = MHDISL.URCONOON ODHEAD.UADLIX = MHDISH.OQDLIX AND ODHEAD.UACONO = MHDISH.OQCONO