F46022

-- ============================================================
-- Table  : F46022 Location dimension definitions: gross and usable width, depth, height, and cube per branch and location dimension group — the location side of putaway capacity math.
-- Purpose: Column-selected read of F46022 — auto-generated from field metadata
-- Grain  : One row per LTMCU + LTSTY1
-- 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.LTMCU) AS "Branch/plant the dimension group belongs to.",
  f.LTSTY1 AS "Location dimension group this row defines; locations point at it from the location master.",
  f.LTMAXW AS "Maximum weight a location of this group can hold.",
  f.LTGWID / POWER(10, 2) AS "Gross width of the location.",  -- implied decimals: 2 (verify in F9210)
  f.LTGDEP / POWER(10, 2) AS "Gross depth of the location.",  -- implied decimals: 2 (verify in F9210)
  f.LTGHET / POWER(10, 2) AS "Gross height of the location.",  -- implied decimals: 2 (verify in F9210)
  f.LTGCUB / POWER(10, 2) AS "Gross cube of the location.",  -- implied decimals: 2 (verify in F9210)
  f.LTUWID / POWER(10, 2) AS "Usable width after clearances.",  -- implied decimals: 2 (verify in F9210)
  f.LTUDEP / POWER(10, 2) AS "Usable depth after clearances.",  -- implied decimals: 2 (verify in F9210)
  f.LTUHET / POWER(10, 2) AS "Usable height after clearances.",  -- implied decimals: 2 (verify in F9210)
  f.LTUCUB / POWER(10, 2) AS "Usable cube — the number putaway capacity checks actually run against."  -- implied decimals: 2 (verify in F9210)
FROM <catalog>.<schema_data>.f46022 f
WHERE
  f.LTMCU = '<MCU>'
ORDER BY f.LTMCU;