F41002

-- ============================================================
-- Table  : F41002 Item-level unit of measure conversions: the factor that translates one UOM into another for a given item and branch, used everywhere quantities change units.
-- Purpose: Column-selected read of F41002 — auto-generated from field metadata
-- Grain  : One row per UMMCU + UMITM + UMUM + UMRUM
-- 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.UMMCU) AS "Branch/plant (business unit); stored right-justified with leading blanks.",
  f.UMITM AS "Short internal item number (8-digit numeric key).",
  f.UMUM AS "From unit of measure of the conversion.",
  f.UMRUM AS "To (related) unit of measure of the conversion.",
  f.UMUSTR AS "Position of this UOM within the item's unit of measure structure.",
  f.UMCONV / POWER(10, 7) AS "Multiplier converting one from-UOM into the to-UOM.",  -- implied decimals: 7 (verify in F9210)
  f.UMCNV1 / POWER(10, 7) AS "Derived factor converting this UOM to the item's primary UOM.",  -- implied decimals: 7 (verify in F9210)
  f.UMEXPO AS "Flag: exclude this UOM from purchase order entry.",
  f.UMEXSO AS "Flag: exclude this UOM from sales order entry.",
  f.UMPUPC AS "Internal id linking to a purchase price rule for this UOM.",
  f.UMSEPC AS "Internal id linking to a sales price rule for this UOM."
FROM <catalog>.<schema_data>.f41002 f
WHERE
  f.UMMCU = '<MCU>'
  -- AND f.UMITM = <ITM>
ORDER BY f.UMMCU;