F4102

-- ============================================================
-- Table  : F4102 Item branch — branch/plant-level item attributes, planning parameters, and sourcing responsibility
-- Purpose: Column-selected read of F4102 — auto-generated from field metadata
-- Grain  : One row per IBITM + IBMCU
-- 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
  ib.IBITM AS "Short item number - the internal numeric item key",
  TRIM(ib.IBMCU) AS "Business unit / branch plant (right-justified, space-padded to 12)",
  ib.IBLITM AS "Second item number - the primary user-facing item code",
  ib.IBAITM AS "Third item number - catalog or cross-reference item code",
  ib.IBSTKT AS "Stocking type - how the item is stocked/made/purchased",
  ib.IBGLPT AS "G/L class code driving inventory account derivation through AAIs",
  ib.IBLNTY AS "Line type controlling inventory/GL/AR interfaces (S, N, F, ...)",
  ib.IBPDGR AS "Product group for pricing",
  ib.IBBUYR AS "Buyer address book number responsible for the item at this branch",
  ib.IBVEND AS "Primary (or most recent) supplier address book number",
  ib.IBANPL AS "Planner address book number",
  ib.IBSRP0 AS "Sales category code 10 (6-char)",
  ib.IBSRP1 AS "Sales category code 1 - catalog section",
  ib.IBSRP2 AS "Sales category code 2 - sub section",
  ib.IBSRP3 AS "Sales category code 3",
  ib.IBSRP4 AS "Sales category code 4",
  ib.IBSRP5 AS "Sales category code 5",
  ib.IBPRP0 AS "Purchasing category code - item pool (6-char)",
  ib.IBPRP1 AS "Purchasing category code 1 - commodity class",
  ib.IBPRP2 AS "Purchasing category code 2 - commodity sub class",
  ib.IBPRP3 AS "Purchasing category code 3 - supplier rebate code",
  ib.IBPRP4 AS "Purchasing category code 4 - master planning family",
  ib.IBPRP5 AS "Purchasing category code 5",
  ib.IBMPST AS "Planning code - how MRP/DRP plans the item",
  ib.IBLTLV AS "Level lead time in days",
  ib.IBLTCM AS "Cumulative lead time in days",
  ib.IBLTMF AS "Manufacturing lead time in days",
  ib.IBSAFE AS "Safety stock quantity",
  ib.IBROQI AS "Fixed reorder quantity entered for the branch",
  ib.IBROPI AS "Reorder point entered for the branch",
  ib.IBABCS AS "ABC ranking by sales",
  ib.IBABCM AS "ABC ranking by margin",
  ib.IBABCI AS "ABC ranking by investment",
  ib.IBBACK AS "Whether backorders are allowed for this item at this branch",
  ib.IBSLD AS "Shelf life in days",
  ib.IBLOTS AS "Default lot status code"
FROM <catalog>.<schema_data>.f4102 ib
WHERE
  ib.IBITM = <ITM>
  -- AND ib.IBMCU = '<MCU>'
ORDER BY ib.IBITM;