P31114

-- ============================================================
-- Program: P31114 Work Order Completions — the screen that records finished goods coming off a work order, moving completed quantity into on-hand inventory and updating order status.
-- Purpose: Work Order Completions — the screen that records finished goods coming off a work order, moving completed quantity into on-hand inventory and updating order status. — auto-generated boilerplate from program-table-map
-- Grain  : F4801 × F41021, F4111, F3111 — 1:N joins yield one row per detail line
-- Tables : F4801, F41021, F4111, F3111
-- Notes  : Auto-generated skeleton. Julian dates are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210). Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  h.WADOCO AS "Work order number — the single primary key; join target for F3111 parts list, F3112 routing, and F4801T tag rows",
  h.WADL01 AS "Work order description — free text, handy as a label in dashboards",
  loc.LIITM AS "Short item number - the internal numeric item key",
  TRIM(loc.LIMCU) AS "Business unit / branch plant (right-justified, space-padded to 12)",
  loc.LILOCN AS "Storage location within the branch plant",
  loc.LILOTN AS "Lot or serial number",
  il.ILUKID AS "Unique key ID - the system-assigned surrogate key",
  f.WMUKID AS "Internal unique key — the table's single-column primary key; carries no business meaning"
FROM <catalog>.<schema_data>.f4801 h
LEFT JOIN <catalog>.<schema_data>.f41021 loc
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
LEFT JOIN <catalog>.<schema_data>.f4111 il
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
LEFT JOIN <catalog>.<schema_data>.f3111 f
  ON f.WMDOCO = h.WADOCO
WHERE
  h.WADOCO = <DOCO>
ORDER BY h.WADOCO;