Printing Table Definitions

[Jeremy M.]

Is there a way to print all tables and columns (table definitions)? Currently we are going into OMW and printing each table individually. Maybe there is a UBE that with some data selection would output a report that shows table definitions?

Any ideas would be helpful.

 

[lmujica]

Hello Jeremy,

You can see the list of all JDE tables in F98710. If you want to see the structure of a table, take a look at F98711 using the TDOBNM field to filter.
I don't know any UBE that works with those tables, but you can xref the tables and see what happens.

BR,



Luis.

 

[peterbruce]

Jeremy,

I created an Oracle SQL to extract the table structures and attached it to a post (number 129018) on JDEList 5 years ago at the beginning of 2008. It may be of use.

Download Attachment to Post 129018 (Post 129018)

 

[craig_welton]

Hi,

Our free JDE Object Browser tool lets you do that. There is a Batch Export option where you can select object types and dump the layout to text or HTML.

Craig

 

[peterbruce]

Jeremy,

Oops, I goofed!

In my last post I gave the links for the list of tables, not table structures.

Here are the correct links:

Download Attachment to Post 109002 (Post 109002)