AS/400 Table Relationship

Hi,
I am cognos Reporting developers. Now i need to develop lot of reports for JDE AS/400 for one of our new client. I am new to JDE.Is there any documentation to understand the relationships among the JDE AS/400 database. Please help

Thanks,
Tinn

Tinn,

First, welcome to the group.

Unfortunately, you are in for a nasty surprise: there's very little documentation about the tables and their relationships (i.e.: practically none) and there are no foreign keys in the DB to help you with reverse-engineering it.

You will have to work closely with a knowledgeable application consultant (or power user), who will need to tell you which fields of which tables they want on a report, what they are and how they relate to each other.

And as for the table structure, you can use standard JDE UTB tool, or Google for "OneAssist" to find a third-party tool. Either way, the table structures are relatively cryptic and without any previous exposure to such system, if working alone, you will be really struggling to figure out what is what...