MWOOPE
Prefix: VOtransactionManufacturing order operations — one row per operation step on an order with its work center; the grain for capacity and labor reporting, joined to its header by MFNO
Header & line
MWOOPE lines join back to their header MWOHED — and the CONO — so a line never fans out across companies.
Fields
5 fields · 4 key
| Key | Field | Alias | Description | Type | Length | Flags |
|---|---|---|---|---|---|---|
| Key | VOCONO | CONO | Company | numeric | ||
| Key | VOFACI | FACI | Facility | alphanumeric | ||
| Key | VOMFNO | MFNO | Manufacturing order number | alphanumeric | ||
| Key | VOOPNO | OPNO | Operation number within the order | numeric | ||
| VOPLGR | PLGR | Work center the operation runs at | alphanumeric |
Field provenance: hand-curated.
Boilerplate SQL
Starting point for reading MWOOPEon 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 : MWOOPE — Manufacturing order operations — one row per operation step on an order with its work center; the grain for capacity and labor reporting, joined to its header by MFNO
-- Purpose: Column-selected read of MWOOPE — auto-generated from field metadata
-- Grain : One row per company (CONO) + VOFACI + VOMFNO + VOOPNO
-- 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.VOCONO AS "Company",
m.VOFACI AS "Facility",
m.VOMFNO AS "Manufacturing order number",
m.VOOPNO AS "Operation number within the order",
m.VOPLGR AS "Work center the operation runs at"
FROM <catalog>.<schema>.MWOOPE m
WHERE
m.VOCONO = <company>
-- AND m.VOFACI = '<FACI>'
-- AND m.VOMFNO = '<MFNO>'
ORDER BY m.VOFACI;5 parameters not filled: <catalog>, <schema>, <company>, <FACI>, <MFNO>
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 MWOHED.VHMFNO = MWOOPE.VOMFNO AND MWOHED.VHFACI = MWOOPE.VOFACI AND MWOHED.VHCONO = MWOOPE.VOCONO