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  : F3111 × F3002, F41021, F4102 — 1:N joins yield one row per detail line
-- Tables : F3111, F3002, F41021, F4102
-- 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",
  f.IXTBM AS "Bill type — M is the standard manufacturing bill; other UDC values cover rework, spare parts, and planning bills.",
  f.IXKIT AS "Short item number of the parent being built — the top of this BOM line.",
  TRIM(f.IXMMCU) AS "Branch/plant that owns this bill — BOMs are branch-specific in JDE.",
  f.IXSBNT / POWER(10, 2) AS "Sequence that orders substitute items for a component; 0 for the primary component line.",  -- implied decimals: 2 (verify in F9210)
  f.IXBQTY AS "Batch quantity of the parent that the quantity-per is stated against; part of the key, so one item can carry separate bills per batch size — implied decimals vary by setup.",
  f.IXCOBY AS "Classifies the line as a component, co-product, by-product, or intermediate.",
  f.IXCPNB / POWER(10, 2) AS "System-assigned BOM component line number that uniquifies lines within a parent/branch/type/batch key.",  -- implied decimals: 2 (verify in F9210)
  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",
  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)"
FROM <catalog>.<schema_data>.f3111 h
LEFT JOIN <catalog>.<schema_data>.f3002 f
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
LEFT JOIN <catalog>.<schema_data>.f41021 loc
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
LEFT JOIN <catalog>.<schema_data>.f4102 ib
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
ORDER BY h.WMUKID;