JDE UDC, Julian Date and Decimal Conversion
Avoid per-report repair logic by converting JDE UDCs, Julian dates, decimals and currency fields before they reach the reporting tool.
JDE data is not plain database data
A raw query can expose JDE values in technically correct but business-hostile forms: Julian dates, scaled integers, UDC codes without descriptions and columns named for developers rather than users.
A JDE-aware ODBC driver can perform these conversions centrally so each reporting tool does not need to reimplement them.
- CYYDDD Julian dates become usable dates.
- Implicit decimals become correct numeric values.
- UDC codes can be expanded with descriptions.
- Long or short column names can suit the audience.
Fewer silent reporting errors
Centralised conversion reduces the chance that two reports interpret the same field differently. That matters for finance, inventory and operational reporting.
See where this fits in the product.
This supporting page explains one search intent in detail. The main ESI JDE ODBC Driver page gives the full product overview, related use cases, licensing and enquiry path.
Back to ESI JDE ODBC Driver