F46011

-- ============================================================
-- Table  : F46011 Item unit-of-measure definition for WMS: one row per branch, item or dimension group, and UOM carrying physical dimensions, weight, cube, container, and stacking rules the capacity engine uses.
-- Purpose: Column-selected read of F46011 — auto-generated from field metadata
-- Grain  : One row per IQMCU + IQPRP6 + IQITM + IQUOM
-- 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.IQMCU) AS "Branch/plant the definition applies to.",
  f.IQPRP6 AS "Item dimension group the row defines; blank when the row is for a specific item instead.",
  f.IQITM AS "Short item number the row defines; zero when the row is for a dimension group.",
  f.IQUOM AS "Unit of measure this definition row describes (e.g., EA, CA, PL).",
  f.IQGWID / POWER(10, 2) AS "Gross width of one unit in this UOM.",  -- implied decimals: 2 (verify in F9210)
  f.IQGDEP / POWER(10, 2) AS "Gross depth of one unit in this UOM.",  -- implied decimals: 2 (verify in F9210)
  f.IQGHET / POWER(10, 2) AS "Gross height of one unit in this UOM.",  -- implied decimals: 2 (verify in F9210)
  f.IQWIUM AS "UOM the width/depth/height are expressed in.",
  f.IQGCUB / POWER(10, 2) AS "Gross cube of one unit; what capacity checking charges against a location.",  -- implied decimals: 2 (verify in F9210)
  f.IQVUMD AS "UOM used to display volume.",
  f.IQGWEI / POWER(10, 2) AS "Gross weight of one unit.",  -- implied decimals: 2 (verify in F9210)
  f.IQUWUM AS "UOM used for weight.",
  f.IQDMTH AS "Capacity method for this UOM: check by volume, by dimensions, or by quantity.",
  f.IQCRMT AS "Carton recommendation method.",
  f.IQEQUS AS "How this UOM uses containers (in a container, on a container, none).",
  f.IQAROT AS "Allow rotating the unit to fit a location.",
  f.IQABKD AS "Allow breaking this UOM down into smaller units.",
  f.IQAROL AS "Allow rolling smaller units up into this UOM.",
  f.IQSLIM AS "How many of this unit can stack on each other.",
  f.IQEQTY AS "Default container code for this UOM.",
  f.IQRPCK AS "Repack allowed for this UOM.",
  f.IQPACK AS "Packing code.",
  f.IQLIPL AS "Track this UOM with license plates.",
  f.IQPPTG AS "Tag print method for putaway.",
  f.IQPKTG AS "Tag print method for picking.",
  f.IQPRTG AS "Tag print method for replenishment.",
  f.IQPTRA AS "Trip assignment method for putaway.",
  f.IQKTRA AS "Trip assignment method for picking.",
  f.IQRTRA AS "Trip assignment method for replenishment.",
  f.IQUCCU AS "Flag to update UCC-128 shipment information."
FROM <catalog>.<schema_data>.f46011 f
WHERE
  f.IQMCU = '<MCU>'
  -- AND f.IQITM = <ITM>
ORDER BY f.IQMCU;