P31113

-- ============================================================
-- Program: P31113 Work Order Inventory Issues — the screen that issues component material to a work order, relieving on-hand inventory and writing IM transactions to the item ledger.
-- Purpose: Work Order Inventory Issues — the screen that issues component material to a work order, relieving on-hand inventory and writing IM transactions to the item ledger. — auto-generated boilerplate from program-table-map
-- Grain  : F3111 × F4111, F41021, F4801 — 1:N joins yield one row per detail line
-- Tables : F3111, F4111, F41021, F4801
-- 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.WMUKID AS "Internal unique key — the table's single-column primary key; carries no business meaning",
  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"
FROM <catalog>.<schema_data>.f3111 h
LEFT JOIN <catalog>.<schema_data>.f4111 il
  ON il.ILUKID = h.WMUKID
LEFT JOIN <catalog>.<schema_data>.f41021 loc
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
LEFT JOIN <catalog>.<schema_data>.f4801 f
  ON f.WADOCO = h.WMDOCO
ORDER BY h.WMUKID;