View Post

How to access the JDE Data Dictionary in SQL

In Custom Development, Data Architecture, Enterprise Architecture, Enterprise Systems, JD Edwards by Bryant AveyLeave a Comment

The JD Edwards EnterpriseOne database layer has been abstracted, by design, from the business and application layers.  The impact of how JDE has chosen to implement this data abstraction is that the database does not contain any table or field name aliases with meaningful, English descriptions.  When applications developers and software developers are interfacing with the JD Edwards EnterpriseOne ERP system, there is often a need to have access to the Table File Definitions and Field Descriptions contained in the JDE Data Dictionary.  Without access to the table descriptions and the field descriptions, developers are not able to easily navigate …