JDE Reference

F0013

masterAlso in JDE World

Master list of currency codes with their display decimals; the lookup behind every CRCD column.

Module: 00 · FoundationColumn prefix: CV

What the badges mean

Superseded: Superseded — a newer table has replaced it, but older scripts still read this one.
Also in JDE World: Also present in JDE World A9.x on the same table name.
master: Data class: what the table holds — master data, transaction documents, control/setup values, history, or a workfile.
Read/write access: Access mode: how the paired program reads or writes this table — R (read), W (write), or R/W (both).

Fields

5 fields · 1 key

5 fields.

Table fields: key flag, field name, DD alias, description, data type, length, and quirk flags (Julian date, implied decimals, padded string, UDC decode). 5 fields.
Key	Field	Alias	Description	Type	Length	Flags
Primary key	CVCRCD	CRCD	Three-character currency code (e.g. USD, EUR).	String	3
	CVDL01	DL01	Currency name.	String	30
	CVEC	EC	Edit code governing how the currency is validated.	Character	1	UDC
	CVCDEC	CDEC	Number of decimal places shown for amounts in this currency; drives implied-decimal math on stored amounts.	Character	1
	CVCKR	CKR	Validation routine associated with the currency.	String	10

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading F0013 on Databricks — Julian dates, implied decimals, and padded strings are already converted. Set your Unity Catalog location and filter values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogData Schema (PRODDTA)

2 parameters not filled: <catalog>, <schema_data>

-- ============================================================
-- 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;

Verified September 2026

Relationships

Diagram of 1-hop neighbors — join details below. UDC decode edges point coded fields at their F0005 lookup.

Join details

F0015F0013foreign key · N:1
ON f0015.CXCRCD = f0013.CVCRCD

Programs That Use This Table

No program mappings populated for this table yet.

Browse more 00 tables