F4092

-- ============================================================
-- Table  : F4092 One row per price group definition: names an item, customer, or order group and lists which category-code keys (up to 10) make up the group, ordered by the key columns.
-- Purpose: Column-selected read of F4092 — auto-generated from field metadata
-- Grain  : One row per GPGPTY + GPGPC
-- 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.GPGPTY AS "Group type: whether this definition is an item, customer, or order detail group.",
  f.GPGPC AS "Group code — the price group name referenced by F4071 adjustments and item/customer masters.",
  f.GPDL01 AS "Group description.",
  f.GPGPK1 AS "First category-code key making up the group definition.",
  f.GPGPK2 AS "Second category-code key in the group definition.",
  f.GPGPK3 AS "Third category-code key in the group definition.",
  f.GPGPK4 AS "Fourth category-code key in the group definition.",
  f.GPGPK5 AS "Fifth category-code key in the group definition.",
  f.GPGPK6 AS "Sixth category-code key in the group definition.",
  f.GPGPK7 AS "Seventh category-code key in the group definition.",
  f.GPGPK8 AS "Eighth category-code key in the group definition.",
  f.GPGPK9 AS "Ninth category-code key in the group definition.",
  f.GPGPK10 AS "Tenth category-code key in the group definition."
FROM <catalog>.<schema_data>.f4092 f
ORDER BY f.GPGPTY;