F3102

-- ============================================================
-- Table  : F3102 One row per cost bucket on a work order — keyed by order, item, cost component, parent/child flag, and work center — holding standard, current, planned, actual, completed, and scrapped units and amounts used for manufacturing variance analysis.
-- Purpose: Column-selected read of F3102 — auto-generated from field metadata
-- Grain  : One row per IGDOCO + IGITM + IGCOST + IGPART + IGMCU
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. 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
  f.IGDOCO AS "Work order number the cost row belongs to.",
  f.IGITM AS "Short item number the costs apply to — the parent on parent rows, the component on child rows.",
  f.IGCOST AS "Cost component code (A1 material, B1 labor, C-range overheads, etc.) that this row's buckets belong to.",
  f.IGPART AS "Parent/child flag separating the ordered item's cost rows from its components' rows.",
  TRIM(f.IGMCU) AS "Work center (business unit) the cost row is attributed to; part of the unique key.",
  f.IGDCTO AS "Order type of the work order (typically WO).",
  f.IGOPSQ / POWER(10, 2) AS "Routing operation sequence associated with the cost row; informational here — not part of the unique key.",  -- implied decimals: 2 (verify in F9210)
  f.IGLITM AS "25-character second item number for the same item.",
  f.IGAITM AS "Third item number for the same item.",
  f.IGOPUN / POWER(10, 4) AS "Standard (frozen) units for the cost component at order creation.",  -- implied decimals: 4 (verify in F9210)
  f.IGOPAT / POWER(10, 4) AS "Standard (frozen) amount for the cost component at order creation.",  -- implied decimals: 4 (verify in F9210)
  f.IGCLUN / POWER(10, 4) AS "Actual units charged to the order so far.",  -- implied decimals: 4 (verify in F9210)
  f.IGCLAT / POWER(10, 4) AS "Actual amount charged to the order so far.",  -- implied decimals: 4 (verify in F9210)
  f.IGCCCU / POWER(10, 4) AS "Current units — standards re-extended against the current bill/routing.",  -- implied decimals: 4 (verify in F9210)
  f.IGCCCA / POWER(10, 4) AS "Current amount — standards re-extended against the current bill/routing.",  -- implied decimals: 4 (verify in F9210)
  f.IGPLUN / POWER(10, 4) AS "Planned units from the work order's attached parts list and routing.",  -- implied decimals: 4 (verify in F9210)
  f.IGPLAT / POWER(10, 4) AS "Planned amount from the work order's attached parts list and routing.",  -- implied decimals: 4 (verify in F9210)
  f.IGCPUN / POWER(10, 4) AS "Units relieved as completed against the order.",  -- implied decimals: 4 (verify in F9210)
  f.IGCPAT / POWER(10, 4) AS "Amount relieved as completed against the order.",  -- implied decimals: 4 (verify in F9210)
  f.IGSLUN / POWER(10, 4) AS "Units written off as scrap on the order.",  -- implied decimals: 4 (verify in F9210)
  f.IGSLAT / POWER(10, 4) AS "Amount written off as scrap on the order.",  -- implied decimals: 4 (verify in F9210)
  f.IGCCUU / POWER(10, 4) AS "Units transacted but not yet run through manufacturing accounting (unaccounted).",  -- implied decimals: 4 (verify in F9210)
  f.IGCCUA / POWER(10, 4) AS "Amount transacted but not yet run through manufacturing accounting (unaccounted).",  -- implied decimals: 4 (verify in F9210)
  f.IGUNPU / POWER(10, 4) AS "Units that failed posting to the general ledger.",  -- implied decimals: 4 (verify in F9210)
  f.IGUNPA / POWER(10, 4) AS "Amount that failed posting to the general ledger.",  -- implied decimals: 4 (verify in F9210)
  f.IGUOM AS "Unit of measure the unit buckets are stated in.",
  TRIM(f.IGWMCU) AS "Branch of the work center when it differs from the order branch.",
  TRIM(f.IGMMCU) AS "Branch/plant of the work order itself.",
  f.IGFORQ AS "Fixed-or-variable quantity flag carried from the BOM line.",
  f.IGENGV / POWER(10, 4) AS "Engineering variance amount — standard vs. current bill/routing.",  -- implied decimals: 4 (verify in F9210)
  f.IGPLNV / POWER(10, 4) AS "Planned variance amount — current vs. the order's attached plan.",  -- implied decimals: 4 (verify in F9210)
  f.IGVACT / POWER(10, 4) AS "Actual variance amount — planned vs. actual charges.",  -- implied decimals: 4 (verify in F9210)
  f.IGOTHV / POWER(10, 4) AS "Other variance amount — residual differences such as completion rounding.",  -- implied decimals: 4 (verify in F9210)
  f.IGNETV / POWER(10, 4) AS "Net variance amount across all variance buckets.",  -- implied decimals: 4 (verify in F9210)
  f.IGSCRP / POWER(10, 2) AS "Scrap percent carried from the BOM line."  -- implied decimals: 2 (verify in F9210)
FROM <catalog>.<schema_data>.f3102 f
WHERE
  f.IGDOCO = <DOCO>
  -- AND f.IGITM = <ITM>
  -- AND f.IGMCU = '<MCU>'
ORDER BY f.IGDOCO;