F30006

-- ============================================================
-- Table  : F30006 One row per work center within a branch/plant, holding the capacity, efficiency, crew, and shift-hour attributes used by scheduling, capacity planning, and cost rollups.
-- Purpose: Column-selected read of F30006 — auto-generated from field metadata
-- Grain  : One row per IWMCU + IWMMCU
-- 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
  TRIM(f.IWMCU) AS "Work center identifier — itself a business unit in the F0006 sense.",
  TRIM(f.IWMMCU) AS "Branch/plant the work center belongs to.",
  TRIM(f.IWMCUW) AS "Dispatch group used to bundle work centers for shop-floor dispatching.",
  f.IWLOCN AS "Default issue location associated with the work center.",
  f.IWCRTW AS "Flags the work center as critical for capacity planning purposes.",
  f.IWPILC AS "Prime load code — whether capacity load is measured in labor hours, machine hours, or both.",
  f.IWBFPF AS "Default pay point code for operations run at this work center.",
  f.IWDEMO AS "Whether rated capacity is demonstrated (historical) or calculated from shifts and efficiency.",
  f.IWAN8 AS "Address book number linked to the work center (e.g. responsible party or subcontractor).",
  f.IWWRHR / POWER(10, 2) AS "Standard work hours per day the work center is available.",  -- implied decimals: 2 (verify in F9210)
  f.IWWORE / POWER(10, 2) AS "Efficiency percent applied to standard hours when calculating capacity and cost.",  -- implied decimals: 2 (verify in F9210)
  f.IWWORU / POWER(10, 2) AS "Utilization percent — share of available time the work center is expected to be productive.",  -- implied decimals: 2 (verify in F9210)
  f.IWQMAD AS "Number of employees assigned to the work center.",
  f.IWNOMA AS "Number of machines at the work center.",
  f.IWSQD / POWER(10, 2) AS "Standard queue hours defaulted onto routing operations at this work center.",  -- implied decimals: 2 (verify in F9210)
  f.IWMOVD / POWER(10, 2) AS "Standard move hours defaulted onto routing operations.",  -- implied decimals: 2 (verify in F9210)
  f.IWQUED / POWER(10, 2) AS "Standard queue hours ahead of operations at this work center.",  -- implied decimals: 2 (verify in F9210)
  f.IWSETC / POWER(10, 1) AS "Default crew size for operations run here.",  -- implied decimals: 1 (verify in F9210)
  f.IWWDCT AS "Work day calendar type used to derive the work center's available days.",
  f.IWWDCK AS "Work day calendar key paired with the calendar type.",
  f.IWCAPU AS "Unit of measure the capacity figures are stated in.",
  f.IWCPSD AS "Standard rated capacity of the work center per period.",
  f.IWCPMI AS "Minimum capacity used by planning as a lower bound.",
  f.IWCPMA AS "Maximum capacity used by planning as an upper bound."
FROM <catalog>.<schema_data>.f30006 f
WHERE
  f.IWMCU = '<MCU>'
ORDER BY f.IWMCU;