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, F4102, F0101 — 1:N joins yield one row per detail line
-- Tables : F4801, F4801T, F4102, F0101
-- 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",
  ib.IBITM AS "Short item number - the internal numeric item key",
  TRIM(ib.IBMCU) AS "Business unit / branch plant (right-justified, space-padded to 12)",
  ab.ABAN8 AS "Address book number - the master key for any entity"
FROM <catalog>.<schema_data>.f4801 h
LEFT JOIN <catalog>.<schema_data>.f4801t f
  ON f.WADOCO = h.WADOCO
LEFT JOIN <catalog>.<schema_data>.f4102 ib
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
LEFT JOIN <catalog>.<schema_data>.f0101 ab
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
WHERE
  h.WADOCO = <DOCO>
ORDER BY h.WADOCO;