F40943

-- ============================================================
-- Table  : F40943 One row per order detail group combination: an order detail group plus a specific set of sales-order line attribute values (up to 8), assigned a numeric key ID (OGID) that F4072 rate rows point at.
-- Purpose: Column-selected read of F40943 — auto-generated from field metadata
-- Grain  : One row per OKSDGR + OKSDV1 + OKSDV2 + OKSDV3 + OKSDV4 + OKSDV5 + OKSDV6 + OKSDV7 + OKSDV8
-- 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.OKSDGR AS "Order detail group this combination belongs to.",
  f.OKSDV1 AS "Value of the first order-detail attribute in the combination (positional, per group definition).",
  f.OKSDV2 AS "Value of the second order-detail attribute in the combination.",
  f.OKSDV3 AS "Value of the third order-detail attribute in the combination.",
  f.OKSDV4 AS "Value of the fourth order-detail attribute in the combination.",
  f.OKSDV5 AS "Value of the fifth order-detail attribute in the combination.",
  f.OKSDV6 AS "Value of the sixth order-detail attribute in the combination.",
  f.OKSDV7 AS "Value of the seventh order-detail attribute in the combination.",
  f.OKSDV8 AS "Value of the eighth order-detail attribute in the combination.",
  f.OKOGID AS "Order group key ID — the surrogate key F4072 stores in ADOGID; unique per combination."
FROM <catalog>.<schema_data>.f40943 f
ORDER BY f.OKSDGR;