Supported JDE Data Formats

As of 8.0.10, DAS supports all JDE data types. Here is a list of the common JDE data types.

String Data

All JDE String data is supported including variable string data and single characters.

Numeric data

All JDE Numeric data types are supported. DAS automatically applies all JDE formatting functions including such things as currency conversions.

JDEDATE

DAS supports JDE's date-only JDEDATE datatype. This will be displayed as a Date/Time column set at midnight. The 'E1 time to DateTime' calculation can be used to convert a JDEDATE and an associated JDE time formatted numeric time column to a Date/Time column.

JDEUTIME

Many modules of JDE (especially the grower module) support the JDEUTIME column. The JDEUTIME column is a date/time column where the date/time is stored in the database as UTC (Coordinated Universal Time). This universal date/time can be displayed in the user's time zone (with an optional associated daylight savings rule) or any other time zone.

Please see the Report Time Zone topic for more information.

Blob

JDE Supports binary large object columns for the storage of non-relational data. DAS supports interpreting such columns as text, images, or as a file download.