F46010

-- ============================================================
-- Table  : F46010 Item warehouse profile: one row per branch/item holding WMS handling rules — mixing, one- vs two-phase movement, and the item's fixed special-purpose locations.
-- Purpose: Column-selected read of F46010 — auto-generated from field metadata
-- Grain  : One row per IPMCU + IPITM
-- 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.IPMCU) AS "Branch/plant the profile applies to.",
  f.IPITM AS "Short item number the profile applies to.",
  f.IPMLIT AS "Allow different items to share one location.",
  f.IPMLOT AS "Allow mixed lots or receipt dates in one location.",
  f.IPSPLP AS "Allow one putaway line to split across multiple locations.",
  f.IPPTPH AS "One- or two-phase putaway for this item.",
  f.IPPKPH AS "One- or two-phase picking for this item.",
  f.IPRPPH AS "One- or two-phase replenishment for this item.",
  f.IPLCOD AS "Location tax status the item requires.",
  f.IPDLTN AS "Overflow location used when no suggestion can be filled.",
  f.IPDEFI AS "Profile definition code.",
  f.IPVLOC AS "Variance location for confirmation shortfalls.",
  f.IPHLOC AS "Holding location used between phases of two-phase moves.",
  f.IPPPUT AS "Base putaway location that anchors proximity sequencing.",
  f.IPPPIK AS "Base picking location that anchors proximity sequencing.",
  f.IPPRLC AS "Pre-pick staging location.",
  f.IPMPTL AS "Merge partial quantities into existing stock during putaway.",
  f.IPMUMS AS "Merge unit-of-measure structures during putaway.",
  f.IPFIFR AS "Use the receipt date as the FIFO date for this item."
FROM <catalog>.<schema_data>.f46010 f
WHERE
  f.IPMCU = '<MCU>'
  -- AND f.IPITM = <ITM>
ORDER BY f.IPMCU;