P3111

-- ============================================================
-- Program: P3111 Work Order Parts List — the screen for reviewing and revising the components attached to a specific work order, including substitutions and commitment changes.
-- Purpose: Work Order Parts List — the screen for reviewing and revising the components attached to a specific work order, including substitutions and commitment changes. — auto-generated boilerplate from program-table-map
-- Grain  : One row per F3111
-- Tables : 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.
-- Omitted: F3002, F41021, F4102 are cataloged for this program, but no verified join condition connects them to F3111, so they are 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
ORDER BY h.WMUKID;