E9.2 JDE Tables and definitions

[hgnis.]

Hello, I am new to JDE 9.2 and trying to learn about the system. Would someone be able to tell me where do I go to find the data dictionary? I am not sure how to find this.
Also, is there a way to see all the tables and fields for those tables in one window? I have visited a few websites (e.g. https://jde.erpref.com/?schema=920) and have not found anything which allows me to see all the fields in one screen. Thanks for your help!

 

[MFreitag]

The fact that you didn't get any answers in over two weeks should be an indicator that your question may have been poorly posed. Where are you looking for the data dictionary? On the web? On the database?
Web: 'dd' into fast path.
DB: DD920 schema, depending on your DBMS, but we didn't get that info.

"All tables and fies on one screen" - You probably won't find that anywhere and tbh - that would not be a pretty list or diagram to look at. We're talking A LOT of tables and relations and thus, fields.

What you can do, though: https://apexapps.oracle.com/pls/apex/f?p=50180:44:12115049462306
That's the ORACLE Technical Catalog. They have data models that you can look at per module and component, so you will at least know which tables are involved with the address book 01 e.g.

 

[ONYX]

try

JDE Tables - JDE Table Definitions

A JDE (JD Edwards) ERP (Enterprise Resource Planning) system table definition and reference

jde.erpref.com

JDE system 01 definitions

JD Edwards system table definitions for 01

jde.erpref.com

 

[ChrisPa]

Like ONYX said.

Only proviso is that this will give you standard tables only.

If you have any custom tables you are fresh out of luck. You will need Interrogator or ObjectBrowser.

My current version of JDE runs to 6000+ tables, so you won't see them all on one (A4) page.

 

[hgnis.]

Thanks for the feedback everyone. I think I have what I need to move forward .