F40941

-- ============================================================
-- Table  : F40941 One row per item price group combination: an item group plus a specific set of item category-code values, assigned a numeric key ID (IGID) that F4072 rate rows point at.
-- Purpose: Column-selected read of F40941 — auto-generated from field metadata
-- Grain  : One row per IKPRGR + IKIGP1 + IKIGP2 + IKIGP3 + IKIGP4 + IKIGP5 + IKIGP6 + IKIGP7 + IKIGP8 + IKIGP9 + IKIGP10
-- 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.IKPRGR AS "Item price group this combination belongs to.",
  f.IKIGP1 AS "Value of the first item category code in the combination.",
  f.IKIGP2 AS "Value of the second item category code in the combination.",
  f.IKIGP3 AS "Value of the third item category code in the combination.",
  f.IKIGP4 AS "Value of the fourth item category code in the combination.",
  f.IKIGP5 AS "Value of the fifth item category code in the combination.",
  f.IKIGP6 AS "Value of the sixth item category code in the combination.",
  f.IKIGP7 AS "Value of the seventh item category code in the combination.",
  f.IKIGP8 AS "Value of the eighth item category code in the combination.",
  f.IKIGP9 AS "Value of the ninth item category code in the combination.",
  f.IKIGP10 AS "Value of the tenth item category code in the combination.",
  f.IKIGID AS "Item group key ID — the surrogate key F4072 stores in ADIGID; unique per combination."
FROM <catalog>.<schema_data>.f40941 f
ORDER BY f.IKPRGR;