F46024

-- ============================================================
-- Table  : F46024 Location capacity by quantity: the maximum count of an item or item dimension group, per UOM and container, that a location dimension group can hold — used when capacity is checked by quantity instead of volume.
-- Purpose: Column-selected read of F46024 — auto-generated from field metadata
-- Grain  : One row per LCMCU + LCSTY1 + LCPRP6 + LCITM + LCUOM + LCEQTY
-- 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.LCMCU) AS "Branch/plant the capacity rule applies to.",
  f.LCSTY1 AS "Location dimension group being capped.",
  f.LCPRP6 AS "Item dimension group the cap applies to; blank when the row targets a specific item.",
  f.LCITM AS "Short item number the cap applies to; zero when the row targets a dimension group.",
  f.LCUOM AS "Unit of measure the maximum quantity is stated in.",
  f.LCEQTY AS "Container code the cap assumes.",
  f.LCMAXQ / POWER(10, 2) AS "Maximum quantity a location of this group can hold — the quantity-method override to volume-based capacity."  -- implied decimals: 2 (verify in F9210)
FROM <catalog>.<schema_data>.f46024 f
WHERE
  f.LCMCU = '<MCU>'
  -- AND f.LCITM = <ITM>
ORDER BY f.LCMCU;