P48013

-- ============================================================
-- Program: P48013 Enter/Change Order — the screen where manufacturing work orders are created and maintained: item, quantity, dates, status, and branch before shop floor processing begins.
-- Purpose: Enter/Change Order — the screen where manufacturing work orders are created and maintained: item, quantity, dates, status, and branch before shop floor processing begins. — auto-generated boilerplate from program-table-map
-- Grain  : F4801 × F4801T — 1:N joins yield one row per detail line
-- Tables : F4801, F4801T
-- 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: F4102, F0101 are cataloged for this program, but no verified join condition connects them to F4801, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
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"
FROM <catalog>.<schema_data>.f4801 h
LEFT JOIN <catalog>.<schema_data>.f4801t f
  ON f.WADOCO = h.WADOCO
WHERE
  h.WADOCO = <DOCO>
ORDER BY h.WADOCO;