F40942

-- ============================================================
-- Table  : F40942 One row per customer price group combination: a customer group plus a specific set of customer category-code values, assigned a numeric key ID (CGID) that F4072 rate rows point at.
-- Purpose: Column-selected read of F40942 — auto-generated from field metadata
-- Grain  : One row per CKCPGP + CKCGP1 + CKCGP2 + CKCGP3 + CKCGP4 + CKCGP5 + CKCGP6 + CKCGP7 + CKCGP8 + CKCGP9 + CKCGP10
-- 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.CKCPGP AS "Customer price group this combination belongs to.",
  f.CKCGP1 AS "Value of the first customer category code in the combination.",
  f.CKCGP2 AS "Value of the second customer category code in the combination.",
  f.CKCGP3 AS "Value of the third customer category code in the combination.",
  f.CKCGP4 AS "Value of the fourth customer category code in the combination.",
  f.CKCGP5 AS "Value of the fifth customer category code in the combination.",
  f.CKCGP6 AS "Value of the sixth customer category code in the combination.",
  f.CKCGP7 AS "Value of the seventh customer category code in the combination.",
  f.CKCGP8 AS "Value of the eighth customer category code in the combination.",
  f.CKCGP9 AS "Value of the ninth customer category code in the combination.",
  f.CKCGP10 AS "Value of the tenth customer category code in the combination.",
  f.CKCGID AS "Customer group key ID — the surrogate key F4072 stores in ADCGID; unique per combination."
FROM <catalog>.<schema_data>.f40942 f
ORDER BY f.CKCPGP;