JDE Reference

F0005

controlAlso in JDE World

User defined code values — the lookup rows behind every UDC-validated field, keyed by system, type, and code

Module: 00 · FoundationColumn prefix: DR

Fields

8 fields · 3 key

KeyFieldAliasDescriptionTypeLengthFlags
Primary keyDRSYSYSystem code of the UDC tableString4
UDC
Primary keyDRRTRTUser defined code type within the systemString2
Primary keyDRKYKYThe code value itself; short/numeric codes are stored right-justified with leading blanks - TRIM before joiningString10
TRIM
DRDL01DL01Code descriptionString30
DRDL02DL02Second description lineString30
DRSPHDSPHDSpecial handling code - extra behavior many programs key offString10
DRUDCOUDCOOwnership flag distinguishing Oracle-delivered vs customer codesCharacter1
UDC
DRHRDCHRDCHard coded flag - Y means programs depend on this exact valueCharacter1

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading F0005on 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
-- ============================================================
-- Table  : F0005 User defined code values — the lookup rows behind every UDC-validated field, keyed by system, type, and code
-- Purpose: Column-selected read of F0005 — auto-generated from field metadata
-- Grain  : One row per DRSY + DRRT + DRKY
-- 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
  udc.DRSY AS "System code of the UDC table",
  udc.DRRT AS "User defined code type within the system",
  TRIM(udc.DRKY) AS "The code value itself; short/numeric codes are stored right-justified with leading blanks - TRIM before joining",
  udc.DRDL01 AS "Code description",
  udc.DRDL02 AS "Second description line",
  udc.DRSPHD AS "Special handling code - extra behavior many programs key off",
  udc.DRUDCO AS "Ownership flag distinguishing Oracle-delivered vs customer codes",
  udc.DRHRDC AS "Hard coded flag - Y means programs depend on this exact value"
FROM <catalog>.<schema_ctl>.f0005 udc
ORDER BY udc.DRSY;

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

Relationships

1-hop neighbors — click a table to navigate there. UDC decode edges point coded fields at their F0005 lookup.

Join details

  • F4211F0005UDC decode · N:1
    ON f4211.SDDCTO = f0005.DRKY
  • F4211F0005UDC decode · N:1
    ON f4211.SDLTTR = f0005.DRKY
  • F4211F0005UDC decode · N:1
    ON f4211.SDNXTR = f0005.DRKY
  • F4101F0005UDC decode · N:1
    ON f4101.IMGLPT = f0005.DRKY
  • F0911F0005UDC decode · N:1
    ON f0911.GLDCT = f0005.DRKY
  • F0911F0005UDC decode · N:1
    ON f0911.GLLT = f0005.DRKY
  • F4311F0005UDC decode · N:1
    ON f4311.PDDCTO = f0005.DRKY
  • F4311F0005UDC decode · N:1
    ON f4311.PDLTTR = f0005.DRKY
  • F42199F0005UDC decode · N:1
    ON f42199.SLDCTO = f0005.DRKY
  • F42199F0005UDC decode · N:1
    ON f42199.SLLTTR = f0005.DRKY
  • F4301F0005UDC decode · N:1
    ON f4301.PHDCTO = f0005.DRKY
  • F0901F0005UDC decode · N:1
    ON f0901.GMPEC = f0005.DRKY
  • F0401F0005UDC decode · N:1
    ON f0401.A6PYIN = f0005.DRKY
  • F4106F0005UDC decode · N:1
    ON f4106.BPUOM = f0005.DRKY

Programs That Use This Table