F41001

-- ============================================================
-- Table  : F41001 Branch/plant inventory constants: the per-branch switchboard for item number symbols, location formatting, costing methods, commitment rules, and G/L interface options.
-- Purpose: Column-selected read of F41001 — auto-generated from field metadata
-- Grain  : One row per CISY + CIMCU
-- 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
  f.CISY AS "System/product code the constants row belongs to (typically 41).",
  TRIM(f.CIMCU) AS "Branch/plant (business unit); stored right-justified with leading blanks.",
  f.CIPRIM AS "Controls which description prints on G/L journal entries from inventory.",
  f.CISYM1 AS "Prefix symbol that identifies entry of a short item number.",
  f.CISYM2 AS "Prefix symbol that identifies entry of the long (2nd) item number.",
  f.CISYM3 AS "Prefix symbol that identifies entry of the 3rd item number.",
  f.CISYM5 AS "Prefix symbol that identifies entry of a customer/supplier item number.",
  f.CISECD AS "Delimiter character between configurator segments.",
  f.CISEPL AS "Separator character between location segments.",
  f.CISE01 AS "Characters allotted to the aisle segment of the location format.",
  f.CISE02 AS "Characters allotted to the bin segment of the location format.",
  f.CISE03 AS "Characters allotted to location segment 3.",
  f.CISE04 AS "Characters allotted to location segment 4.",
  f.CISE05 AS "Characters allotted to location segment 5.",
  f.CISE06 AS "Characters allotted to location segment 6.",
  f.CISE07 AS "Characters allotted to location segment 7.",
  f.CISE08 AS "Characters allotted to location segment 8.",
  f.CISE09 AS "Characters allotted to location segment 9.",
  f.CISE10 AS "Characters allotted to location segment 10.",
  f.CILR01 AS "Left/right justification rule for the aisle segment.",
  f.CILR02 AS "Left/right justification rule for the bin segment.",
  f.CILR03 AS "Justification rule for location segment 3.",
  f.CILR04 AS "Justification rule for location segment 4.",
  f.CILR05 AS "Justification rule for location segment 5.",
  f.CILR06 AS "Justification rule for location segment 6.",
  f.CILR07 AS "Justification rule for location segment 7.",
  f.CILR08 AS "Justification rule for location segment 8.",
  f.CILR09 AS "Justification rule for location segment 9.",
  f.CILR10 AS "Justification rule for location segment 10.",
  f.CIAN8 AS "Address book number tied to the branch/plant.",
  f.CIPOCS AS "Standing cost assumed for issuing one purchase order (used by EOQ).",
  f.CIINCS AS "Annual inventory carrying cost percentage (used by EOQ).",
  f.CIIALP AS "Weight factor applied when smoothing leadtime calculations.",
  f.CIBSDY AS "Days-in-year basis used by planning calculations.",
  f.CIIA1 AS "ABC class A cutoff: percent of sales.",
  f.CIIB1 AS "ABC class A cutoff: percent of gross margin.",
  f.CIIC1 AS "ABC class A cutoff: percent of average investment.",
  f.CIIA2 AS "ABC class B cutoff: percent of sales.",
  f.CIIB2 AS "ABC class B cutoff: percent of gross margin.",
  f.CIIC2 AS "ABC class B cutoff: percent of average investment."
  -- … plus 63 more columns — full list in the Fields section above
FROM <catalog>.<schema_data>.f41001 f
WHERE
  f.CIMCU = '<MCU>'
ORDER BY f.CISY;