F0004

-- ============================================================
-- Table  : F0004 User defined code types — defines each UDC table (system + type) and how its values behave
-- Purpose: Column-selected read of F0004 — auto-generated from field metadata
-- Grain  : One row per DTSY + DTRT
-- 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
  dt.DTSY AS "System code the UDC type belongs to",
  dt.DTRT AS "User defined code type (the two-character table id)",
  dt.DTDL01 AS "Description of the code type",
  dt.DTUSEQ / POWER(10, 1) AS "Display sequence",  -- implied decimals: 1 (verify in F9210)
  dt.DTUCD1 AS "Class code grouping for the code type",
  dt.DTCDL AS "Length of the code values in this type",
  dt.DTLN2 AS "Whether a second description line is used",
  dt.DTCNUM AS "Whether code values are numeric (drives right-justified storage)",
  dt.DTMRCT AS "Merge control flag used by environment merges",
  dt.DTMRTY AS "Merge type used by environment merges"
FROM <catalog>.<schema_ctl>.f0004 dt
ORDER BY dt.DTSY;