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, F4801 — 1:N joins yield one row per detail line
-- Tables : F3111, F4111, 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.
-- Omitted: F41021 is cataloged for this program, but no verified join condition connects it to F3111, so it is left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.WMUKID AS "Internal unique key — the table's single-column primary key; carries no business meaning"
FROM <catalog>.<schema_data>.f3111 h
LEFT JOIN <catalog>.<schema_data>.f4111 il
  ON il.ILUKID = h.WMUKID
LEFT JOIN <catalog>.<schema_data>.f4801 f
  ON f.WADOCO = h.WMDOCO
ORDER BY h.WMUKID;