F0015

-- ============================================================
-- Table  : F0015 Currency exchange rate table: dated conversion rates between currency pairs, including multiplier and divisor forms and triangulation settings.
-- Purpose: Column-selected read of F0015 — auto-generated from field metadata
-- Grain  : One row per CXCRCD + CXCRDC + CXAN8 + CXRTTYP + CXEFT
-- 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.CXCRCD AS "Currency being converted from.",
  f.CXCRDC AS "Currency being converted to.",
  f.CXAN8 AS "Address number for customer- or supplier-specific rates; zero for the default rate.",
  f.CXRTTYP AS "Rate type (spot, average, budget, etc.) distinguishing parallel rate sets.",
  CASE WHEN f.CXEFT IS NULL OR f.CXEFT = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.CXEFT AS INT) DIV 1000, 1, 1), CAST(f.CXEFT AS INT) % 1000 - 1) END AS "Date the rate takes effect; the latest row at or before the transaction date applies.",  -- CYYDDD Julian → DATE
  f.CXCLMETH AS "Whether conversion multiplies or divides by the stored rate.",
  f.CXCRCM AS "Multi-currency conversion mode flag.",
  f.CXTRCR AS "Intermediate currency used when the pair converts via triangulation.",
  f.CXCRR AS "Conversion rate in multiplier form. Implied decimals vary by setup, so no fixed scaling is applied.",
  f.CXCRRD AS "Conversion rate in divisor form. Implied decimals vary by setup, so no fixed scaling is applied.",
  f.CXCSR AS "Flag allowing spot rates entered directly on transactions."
FROM <catalog>.<schema_data>.f0015 f
WHERE
  f.CXAN8 = <AN8>
ORDER BY f.CXCRCD;