R31804

-- ============================================================
-- Program: R31804 Variance Journal Entries — the batch job that books manufacturing variances (engineering, planned, actual, other) to the G/L when work orders close.
-- Purpose: Variance Journal Entries — the batch job that books manufacturing variances (engineering, planned, actual, other) to the G/L when work orders close. — auto-generated boilerplate from program-table-map
-- Grain  : F3102 × F4801 — 1:N joins yield one row per detail line
-- Tables : F3102, 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: F0911 is cataloged for this program, but no verified join condition connects it to F3102, so it is left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.IGDOCO AS "Work order number the cost row belongs to.",
  h.IGITM AS "Short item number the costs apply to — the parent on parent rows, the component on child rows.",
  h.IGCOST AS "Cost component code (A1 material, B1 labor, C-range overheads, etc.) that this row's buckets belong to.",
  h.IGPART AS "Parent/child flag separating the ordered item's cost rows from its components' rows.",
  TRIM(h.IGMCU) AS "Work center (business unit) the cost row is attributed to; part of the unique key."
FROM <catalog>.<schema_data>.f3102 h
LEFT JOIN <catalog>.<schema_data>.f4801 f4
  ON f4.WADOCO = h.IGDOCO
WHERE
  h.IGDOCO = <DOCO>
  AND h.IGITM = <ITM>
  AND h.IGMCU = '<MCU>'
ORDER BY h.IGDOCO;