F0013

-- ============================================================
-- Table  : F0013 Master list of currency codes with their display decimals; the lookup behind every CRCD column.
-- Purpose: Column-selected read of F0013 — auto-generated from field metadata
-- Grain  : One row per CVCRCD
-- 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.CVCRCD AS "Three-character currency code (e.g. USD, EUR).",
  f.CVDL01 AS "Currency name.",
  f.CVEC AS "Edit code governing how the currency is validated.",
  f.CVCDEC AS "Number of decimal places shown for amounts in this currency; drives implied-decimal math on stored amounts.",
  f.CVCKR AS "Validation routine associated with the currency."
FROM <catalog>.<schema_data>.f0013 f
ORDER BY f.CVCRCD;